November 30, 2015 at 3:16 pm
Hi I'm stuck and hoping you guys can help me out.
We have an SSIS package that moves data from one SQL 2005 application db on a remote server to DM database pm SQL 2005 on the local server.
The application is being upgraded so we've moved the database to SQL 2014, so I need to point the ETL package to the new SQL 2014 database. So I've loaded the package in VS 2008 and tried to point it to the new database but VS tells me "This server version is not supported. Only servers up to SQL 2005 are supported" (This is in test not production)
So I installed VS 2015 on another server and tried to open the project. But its not supported in VS 2015 🙁
Can someone tell me what to install or do so that I can get my ETL to talk to SQL2015 and SQL 2005.
PS: I can use Visual Studio a bit but my knowledge is just from building SQL Server maintenance plans, ie pretty basic.
November 30, 2015 at 3:42 pm
What is the version of the server you are trying to run the package on? Is this the same server as before the upgrade?
If the package is a SQL 2005 package and you're trying to run it on a newer version server, you must first upgrade the package.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 30, 2015 at 4:53 pm
I'm trying to run the package from the DM server with SQL 2005 and Windows Server 2003 on it.
So I'm not trying to move the package, I just need it to be able to read data from a SQL 2014 server. Is that possible without upgrading it?
I've done some research and haven't been able to find a clear upgrade path.
If I need to upgrade the package, I can put it on a Windows 20012 server. What would I need to install and look out for?
December 1, 2015 at 2:05 am
It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new server properly configured and verified.
That also assumes that you are not using any now-obsolete SQL in your package.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
December 1, 2015 at 7:44 am
Phil Parkin (12/1/2015)
It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new server properly configured and verified.That also assumes that you are not using any now-obsolete SQL in your package.
Agree.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 1, 2015 at 5:41 pm
Well its nice that you expect it to run, but it doesn't 🙁
So what am I doing wrong, and what should I do?
December 1, 2015 at 5:54 pm
martin 22999 (12/1/2015)
Well its nice that you expect it to run, but it doesn't 🙁So what am I doing wrong, and what should I do?
Leave the package exactly as is, changing only the connection string (via a config change only, I hope) to point at the 2014 db. Then run it and tell us the error.
Tell us the connection string too (obfuscate passwords and server names).
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
December 2, 2015 at 9:22 pm
Phil Parkin (12/1/2015)
martin 22999 (12/1/2015)
Well its nice that you expect it to run, but it doesn't 🙁So what am I doing wrong, and what should I do?
Leave the package exactly as is, changing only the connection string (via a config change only, I hope) to point at the 2014 db. Then run it and tell us the error.
Tell us the connection string too (obfuscate passwords and server names).
I've got the package loaded into SS Data Tools 2010.
Every time I change the connection strings by editing the connection managers, I leave the dialog and they revert back to what they were.
How do I change the strings as a config change?
TIA and thanks for your patience
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply