Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to transfer data on a regular automated basis from a database running on a SQL Server 2005 instance to a remote database running on a SQL Server 2008 instance. I'm new to database administration and using SSIS.

Is it possible to configure an SSIS package to transfer data between two SQL databases of different versions? The package would need to be configured and installed on the SQL 2005 instance.

share|improve this question
up vote 2 down vote accepted

Yes, you can transfer data between 2005 and 2008.

The big gotcha you need to look out for is that the SSIS packages themselves can't be moved between the two. If you create the package in 2005, it needs to run in 2005. You can convert the package to 2008, but then it needs to run in 2008.

share|improve this answer

You could forget about SSIS and create a linked server and use stored procedures in a job step instead. SSIS can be overkill and time consuming for most SQL to SQL transfers.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.