>I have a VB.NET application that needs to execute a DTS package.
>
>This package includes an 'Execute Package Task' as one of its steps. I
>cannot get the 'Execute Package Task' step to run.
>
>My package runs fine if I take out this package.
>Both packages run fine if run separately.
>The packages run fine if I move the functionality from the included
>package into the main package.
>
>The error the log reports is that the user has canceled the execution
>of the sub package.
>
>My code is very simple:
>(serverName and dtsPackageName are variable passed to this function)
>
> Dim p As New DTS.Package2Class
> p.LoadFromSQLServer(serverName, , ,
>DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
>dtsPackageName)
> p.Execute()
>
>Thanks for any help,
> Don
>

<chambersdon@hotmail.com> wrote in message
news:1109371606.808932.200290@l41g2000cwc.googlegroups.com...
>I have a VB.NET application that needs to execute a DTS package.
>
> This package includes an 'Execute Package Task' as one of its steps. I
> cannot get the 'Execute Package Task' step to run.
>
> My package runs fine if I take out this package.
> Both packages run fine if run separately.
> The packages run fine if I move the functionality from the included
> package into the main package.
>
> The error the log reports is that the user has canceled the execution
> of the sub package.
>
> My code is very simple:
> (serverName and dtsPackageName are variable passed to this function)
>
> Dim p As New DTS.Package2Class
> p.LoadFromSQLServer(serverName, , ,
> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
> dtsPackageName)
> p.Execute()
>
> Thanks for any help,
> Don
>