October 14, 2008 at 2:34 pm
Is it possible to create 2005 SSIS Packages on a SQL 2000 Database?
We have recently developed a SQL 2000 Database ... that will be upgraded to a SQL 2005 Database in the next couple of months. (Because we will be getting another server). We are in the process of creating DTS Packages for our nightly imports. Instead of creating them in the DTS 2000 version ... could we use our SQL 2005 SSIS that is on another computer to create SSIS 2005 packages for this new SQL 2000 Database ... instead of worrying over the migration in the future. Would the SSIS packages run properly now (backward compatible question)?
Thank You,
Donna
October 14, 2008 at 2:47 pm
If you have SSIS 2005 then you can develop your packages in it with SQL Server 2000 as either a source or a destination and as long as you do not change table definitions you should be okay with migrating it to 2005. I assume the server name will change when you bring in the new server so your SSIS package(s) will have to have the connection settings changed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 14, 2008 at 2:50 pm
Donna, the answer to that would be no.
When you install your 2005 instance however you can install the 200 dts designer components at the same time and you will be able to continue using the DTS packages in 2005 until you are ready to convert them to SSIS packages at your leisure.
see
---------------------------------------------------------------------
October 14, 2008 at 9:00 pm
Jack is correct - there is no problems with a SSIS package being developed on your SQL 2005 server and run from that server but accessing (for reading or writing) SQL Server 2000 databases on another server.
October 15, 2008 at 3:16 am
yes sorry the others are correct, I am guilty of not thinking this through or reading the question properly.
However it does give you another option of sticking with your DTS packages, it just depends which you think will be best way forward for you.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply