Executing a DTS pkg from .NET

[jkb17]

hello.

i'm trying to load an execute a sql server dts package via .net. I have found the following code from microsoft:

http://support.microsoft.com/default.aspx?scid=kb;en-us;321525

I've implemented as is (adjusting console.writeline to a different output for asp.net application). The package loads and i can view the properties; however, it will not execute.

Has anyone dealt with this before? Am I missing a step? Any advice would be greatly appreciated.

thanks

Jim

 

[jkb17]

I figured out what my problem was. I had to grant ASPNET application access to my sql server. It was a permissions issue.