Microsoft.SqlServer.Dts and related assemblies to develop custom ssis task are missing in GAC for 64 bit machine
Why are you writing a program to start SSIS package?? You have choosen the long road i guess. If your aim is to start the package, use SQL Job and trigger it by using EXEC sp_startJob as standart SQL Command in whereever,whenever you want... For GAC things: start+Run: C:\windows\assembly; locate Microsoft.SqlServer.ManagedDTS to find the public token key. Senior BI Consultant & PM @ Bicentrix If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.
May 26th, 2012 8:45am

The easy way would be to just go to your references - add reference and then browse for the Dll. But if you are targeting SQL 2008 why are you trying to use a 2012 assembly (110\SDK\Assemblies ) It sounds like you need to install the SQL 2008 client utilities and SDK on your dev machine.Chuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2012 9:02am

Hi all, I'm trying to develop small c# program to start a dtsx package on a Windows Server 2008 R2 64 bit machine. Looking at C:\Windows\assembly I can't find a reference for Microsoft.SQLServer.ManagedDTS.dll, I've found this dll in C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies but I'm wondering if is possible to register this dll (and all related dependencies) in GAC. In addition I've a ASPX page that calls a dtsx package using Microsoft.SQLServer.ManagedDTS.dll, I need to migrate this page from a Windows server 2003 machine with SSIS 2005 installed to this new machine in my web config I have the following line <add assembly="Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91" /> I suppose I have to change this line using Version 11.0.2100.60 but I don't know PublicKeyToken= Can someone help me? Best regards Fabrizio
May 27th, 2012 6:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics