Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HoopsBhoy
Starting Member
4 Posts |
 Posted - 2009-06-05 : 04:39:19
|
| I have an application which was designed to work with SSIS on SQL Server 2005. The application moves data from one database to another (in bulk). The code references the following DLL's which ship with SQL Server 2005.Microsoft.SqlServer.DTSPipelineWrap – (v9.0.242.0)Microsoft.SQLServer.DTSRuntimeWrap – (v9.0.242.0) Microsoft.SQLServer.ManagedDTS – (v9.0.242.0)I now have to make my application compatible with SQL Server 2008. I have recently tried it out on an instance of 2008 and it works fine if SQL Server 2005 also resides on the same machine. However, if the machine has just SQL Server 2008 installed then it cannot find the above versions of the DLLs (v10.0 exists) and falls over.I have tried to reference both assembly versions in my code but that doesn't work when I try to add the reference via VS2008. The assemblies have the same name.I think if I distribute the above DLL's with my application this should work, however I am not sure if this is allowed under the licensing agreement.Does anyone know if you are allowed to distribute these with your software or can anyone propose another solution or point me in the right direction? Any help would be appreciated.Cheers |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-06-11 : 23:41:13
|
or, you could recompile your app against the v10 versions of the DLLs above.
elsasoft.org |
 |
|
|
HoopsBhoy
Starting Member
4 Posts |
Posted - 2009-06-15 : 11:28:11
|
quote:
Originally posted by jezemine
or, you could recompile your app against the v10 versions of the DLLs above.
elsasoft.org
That's not going to work as my app needs to be compatible with SQL Server 2005 and 2008.Sorry if I didn't make that clear. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-06-16 : 00:58:33
|
I am in this same situation actually, and what I ended up doing is having two different builds of my app - one built against 2005 binaries and one built against 2008.It's not ideal but it works.
elsasoft.org |
|
|
|
HoopsBhoy
Starting Member
4 Posts |
Posted - 2009-06-16 : 04:37:50
|
quote:
Originally posted by jezemine
I am in this same situation actually, and what I ended up doing is having two different builds of my app - one built against 2005 binaries and one built against 2008.It's not ideal but it works.
elsasoft.org
It's looking like I may have to go down that route myself! I'll let you know if I come up with any bright ideas. |
|
|
|
|
|
|
SSIS 2005/2008 Compatibility