Friday, November 30, 2012 1:47 PM
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 .
Friday, November 30, 2012 8:16 PMModerator
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?
- Edited by SSISJoostMicrosoft Community Contributor, Moderator Friday, November 30, 2012 8:16 PM
Saturday, December 01, 2012 4:43 AM
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 ?
Saturday, December 01, 2012 7:10 AMModeratorThe dll' for 2005 and 2008 are different. So if it was made for 2005 (90 folder) then you need to install ssis 2005.
- Proposed As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, December 04, 2012 8:35 AM
Sunday, December 02, 2012 6:32 AMThanks SSISloost.