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.
Free Windows Admin Tool Kit Click here and download it now
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\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll P.S. You don't need it if you access properties using TaskHost.Properties[]
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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