Post reply

The same DTS package doesn''t work outside SQL Server

  • April 25, 2006 at 4:59 am

    #67362

    I have a DTS package that gets information from an Oracle database and put it in a SQLServer database. I have tested the package and it runs ok.

    Later I have done a program in C# that includes a call to the package. I open the package (that is saved in a file) and the information (connections, etc...) is there, but when I execute the package, I doesn't obtain any record from the Oracle database.

    Any idea?

  • April 25, 2006 at 10:15 am

    #634100

    Have you tried turning on package logging?  That could show you what's happening when the package executes.  Turn on logging on the 'Logging' table of Package properties.

    I don't know much about c# but, if you're able to debug it, you'll see if the package is actually being executed.

    Greg

    Greg

  • April 25, 2006 at 10:38 am

    #634113

    Thank you very, very, very much.

    Thanks to the log I have been able to see that the problem was that the ASPNET user had no access to the SQL Server. When I tried to launch the package inside SQL Server, it uses the user that initiates the SQL Server. When the package was launched from c#, it uses the user ASPNET.

  • April 25, 2006 at 10:53 am

    #634117

    Glad I could help, Oscar.  Good luck!

    Greg

    Greg

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply