I'm trying to find the following reference for a VS2005 C# project but can't see to locate it on two of my machines which uses Sept CTP install (Ent & Dev) both with SQL2K already installed:Namespace: Microsoft.SqlServer.Dts.Tasks.ExecutePackageTaskAssembly: Microsoft.SqlServer.ExecPackageTaskWrap (in microsoft.sqlserver.execpackagetaskwrap.dll)The only thing that I can find is ..\Program Files\Microsoft SQL Server\90\DTS\Binn\ExecPackageTask.dllIs that the same thing or am I missing something???? Thanks.

It's in the GAC.

Thanks but I still can't reference it in my C# project. Is it referenceable or use within another namespace?

Try this: Right click References --> Add Reference in your C# project In Add Reference dialog select Browse page. In File Name type:%windir%\assembly\GAC_MSIL\Microsoft.SqlServer.ExecPackageTaskWrap\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll P.S. You don't need it if you access properties using TaskHost.Properties[]

I am having the same problem ,even when I try and add the Microsoft.SqlServer.ExecPackageTaskWrap.dll from the GAC as mentioned,VS 2008 does add it to my project as a reference.

Hi CedricLab, Add reference in you C# Project, in text box, copy %windir%\assembly\GAC_MSIL\Microsoft.SqlServer.ExecPackageTaskWrap\10.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll You can add Microsoft.SqlServer.ExecPackageTaskWrap.dll SQL 2008 in you project. Then some code can run through. for example, ExecutePackageTask pkgExecute = thTask.InnerObject as ExecutePackageTask; Carey

Hi Ryan I have a problem I've being working on for the past week to no avail. I figure it out. I've searched online, at Microsoft sites, and nothing. Hope you can point me in the right direction. I created a file SSIS Package A and SSIS Package B. Package A calls Package B using "Execute Package Task". When in package development mode, everything works perfect. I created a VB.net project that uses the Package and Application objects to run packages programmatically. Package A, when called from my code, runs without a glitch. But when the task in Package A that is supposed to run Package B is executed, the task fails with no error, making the whole of Package A fail. Any ideas why that might be?