Microsoft.SqlServer.Dts.Runtime refrence error

Question

Hi all , 

I have a console application which uses SSIS component implemented in v 2.0 . I am opening it using VS 2010 keeping version same.  SQL 2008 is installed on this box. 

Application has reference to Microsoft.SqlServer.DtsRunTimeWrap from location 

C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies.

When application is opened first time Package class is used in one of code files without any refrence issues. 

But once i start compiling , package class starts giving reference issue saying that  "Package Does not exist in given namespace". 

It is bit strange . Also one of my team member has SQL 2005  installed . When application is opened on that machine , it is referenced from 

C:\Program Files (x86)\Microsoft SQL Server\90\SDK\Assemblies. And application compiles. 

Does it make any difference with DLL refrenced from 90 or 100 folder ? 

Any help will be really appreciated . 

Thanks 

Siddhesh 

---

Siddhesh Sawant

Answer 1

Each version of SSIS have its own folder and dll's.
  90 => 2005
100 => 2008
110 => 2012

Not sure about the error... are you referencing the right dll? What are you doing in the code?

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Thanks SSISLoost . 

Code uses  SSIS libraries to create a dtsx at runtime based on input parameters. Console application does this . 

Application is written in .net V 2.0 , I think it uses SSIS version 2005. DTS  DLL are referred from 90/SDK/Assembles folder. 

My machine has SQL server 2008 installed . There are no assemblies under Program Files (x86)\Microsoft SQL Server\90\SDK\Assemblies.

To get rid of this error , I explicitly added a refrence from 100\SDK\Assemblies folder , but still it does not work. 

In that case do i need to install SQL 2005  to get it compiled and running ? 

Thanks 

Siddhesh 

---

Siddhesh Sawant

Answer 3

The dll' for 2005 and 2008 are different. So if it was made for 2005 (90 folder) then you need to install ssis 2005.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 4

Thanks SSISloost. 

---

Siddhesh Sawant