Can't find microsoft.sqlserver.execpackagetas kwrap.dll in Sept CTP
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.
October 26th, 2005 1:29am
It's in the GAC.
November 1st, 2005 5:57am
Thanks but I still can't reference it in my C# project. Is it referenceable or use within another namespace?
November 2nd, 2005 8:20pm
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\22.214.171.124__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll P.S. You don't need it if you access properties using TaskHost.Properties
November 5th, 2005 4:37am
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.
July 1st, 2009 6:31pm
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
December 22nd, 2010 5:38pm
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?
April 28th, 2011 7:08pm