SSIS sql 2008 - Microsoft.SqlServer.DtsRuntimeWrap .dll
I'm having quite the issue with an SSIS package script task there I am trying to modify another package via the vb script code. I've been searching for hours and cannot find anything more on this topic. I have an error in my code that is showing
that I am missing a reference to "Microsoft.SqlServer.DtsRunTimeWrap.dll"...so I add it. I save it and then reopen the script file and the error is back.
I have the dll loaded in the Microsoft SQL Server\100\SDK\Assemblies folder. I sometimes get an error that the templates are missing or out of date. I tried running the devenv /installvstempates script that was posted somewhere...and that
did not work.
Does anyone have any ideas? I'm don't know much about the installations and i'm just starting to learn SSIS. This is just a head scratcher for me.
Thanks for any help!
November 8th, 2010 8:37pm
Hi jtseltmann,
By default, SQL Server Integration Services(SSIS) saves the references in a package definition. When we view code of a package that includes a script task, we will get the following section:
<ItemGroup>
<Reference Include="Microsoft.SQLServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=x86" />
<Reference Include="System" />
<Reference Include="System.AddIn, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL" />
<Reference Include="System.Data" />
<Reference Include="System.Windows.Forms" />
<Reference Include="System.Xml" />
<Reference Include="Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.ScriptTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</ItemGroup>
In this case, please build the script task(in code design mode, right-click the code project, and then click build), close the code designer, save the package, and then reopen the package to check if the reference is still there.
Or, please view the code of the package, and add to following line to the ItemGroup element manually to fix the issue:
<Reference Include="Microsoft.SQLServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=x86" />
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 5:09am