RE: DTS Package Fails to find import file
- From: "Jason Smirnow" <JasonSmirnow@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Jun 2005 09:52:04 -0700
Still stumped by this one. Any other ideas?
"Jason Smirnow" wrote:
> I have a DTS package I am kickig off from a C#.Net applcation that imports a
> tab delimited text file created by the C# app. I can successfully kick off
> the DTS package from my development machine, run the package, and everything
> works great.
>
> When I install the app on another machine, it successfully kicks off the DTS
> package, but the package fails to find the text file to import. I am pretty
> sure this is some kind of permissions issue. I am using SQL Server security
> rather than widows security on the login to the SQL Server. The file name is
> referenced using the UNC filename (although I have also tried the direct path
> to the filename on the server with the same result). Any ideas why this
> would perform differently on two different machines? What security account
> does a DTS package kicked off from a client machine run under?
>
> Thanks in advance for any help.
.
- References:
- DTS Package Fails to find import file
- From: Jason Smirnow
- DTS Package Fails to find import file
- Prev by Date: Re: HTML text file as source
- Next by Date: Re: DTS/Excel choosing incorrect data type on import
- Previous by thread: RE: DTS Package Fails to find import file
- Next by thread: Help ! Out of Memory when using Lookups
- Index(es):
Relevant Pages
|