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 |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2010-03-12 : 14:18:57
|
| Hi,I am trying to access a SSIS package that I converted from a SQL 2000 DTS. Unfortunately after successfully importing, I can't find it (I need to modify the connection string). I think the problem is due to having multiple instances on the server. On this server I have both 2005 and 2008 installed. The default instance is 2005 (SERVERNAME). I have a named instance for 2008 (SERVERNAME\2008). When I initially ran the DTS wizard, I set the export location to be the "local" server. I got this error:Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.So I changed the export path to be the 2008 named instance (SERVERNAME\2008). The wizard was successful. I then go Integration Services\Execute Package Utility and can successfully load the package. But when I run it, it fails due to incorrect connection strings. I have tried to change the connection string values but this Utility, but although it looks like it changes, when I run it, it uses the original (now incorrect) values. So how can I find and change the package?In management Studio, I connect to Integration Services (I can only provide the server name and can't connect to the named instance). When I connect, I can see packages but they aren't the ones I'm looking for. I know this is probably a simple solution, but I just don't know where to look.This may helpSERVERNAME database engine is version 9.0.2047SERVERNAME\2008 database engine is version 10.0.2531The SERVERNANE integration Service is version 10.0.1600.Nic |
|
|
nic
Posting Yak Master
209 Posts |
Posted - 2010-03-12 : 14:32:24
|
| Nevermind. I exported to dtsx, modified the connection string in the file and then imported into the SSIS package store. Usually I figure this stuff out right after posting for help :PThanks,NicNic |
 |
|
|
|
|
|
|
|
Multiple DB Instances - can't find package