Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, December 7, 2010 1:16 AM
I am using vb.net in vs2010.
I can't find the Microsoft.SQLServer.ManagedDTS.dll. How do I add that dll to the reference?
Imports Microsoft.SqlServer.Dts.Runtime
All replies (3)
Tuesday, December 7, 2010 6:21 PM âś…Answered
See the below link. You may need to install the SDK if it isn't on your machine:
Paul ~~~~ Microsoft MVP (Visual Basic)
Wednesday, December 15, 2010 7:37 AM
Hello Anonymous9758,
I am writing to check the status of the issue on your side. Would you mind letting us know the result of the suggestions?
If you need further assistance, please feel free to follow up.
Best regards
Liliane Teng [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Thursday, January 27, 2011 7:34 AM
Location of Microsoft.SqlServer.Dts.Runtime when Programmatically Running an SSIS 2008 Package
If you are having problems finding the DLL to reference to programmatically run an SSIS Package, you should find it in the following location:
** %Program files%\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll**
Take note that you may have several directories under %Program files%\Microsoft SQL Server\ if you have upgraded through different versions of SQL Server.
Try looking through each of these to find the correct version of Microsoft.SQLServer.ManagedDTS.dll So assuming you installed it on C:\ you should find it in:
For SQL 2005: C:\Program files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll
For SQL 2008: C:\Program files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll
If you still can't find the Assembly, make sure you've installed the Client Tools SDK