RE: DTS Package Fails to find import file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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.
.



Relevant Pages

  • Re: DTS Security
    ... the package due to the guest account being enabled in msdb ... where SQL Server is installed. ... >the DTS package. ... >> Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • BUG: Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... the DTS package. ... We are using SQL Server 2000 Enterprise Edition with SP2. ... For information about the Microsoft Strategic Technology ... > Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: BUG: Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... Don't think it's a bug. ... >the DTS package. ... >We are using SQL Server 2000 Enterprise Edition with SP2. ... >> Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • RE: Importing a DTS from Sql 2000 to Sql 2005
    ... Did you try checking the "Execute on main package thread DTS Package" in the ... Also, if your servers' security is configured for SQL Server, can you try ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS job updating IBM DB2
    ... DTS package manually, it executes from your PC and under your security ... security vs. SQL Agent. ...
    (microsoft.public.sqlserver.dts)