how to create copy job for ssis packages from production to test server in SQL Server 2008

Do you want to transfer packages from one server to another or only SQL jobs.?

for moving SSIS packages from dev to production  , you can use the DTUtil from command prompt
refer the below links,

http://go4answers.webhost4life.com/Example/deploy-ssis-production-server-44662.aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f8df1872-1c26-43e8-95ca-bf70bf8e2eea/

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e6d530ba-5c91-4b11-940f-4791121f9f1f/

Thank you.

hi,

Here Production server SQL Version is MS SQL Server 2008R2 and Test server version is MS SQL Server 2005.

Is it possible copy/transfer SSIS Jobs and Packages from SQL Server 2008 to SQL Server 2005?

Please help me.

Thanks & Regards,
Chandra

Hi,


   if the packages are created with R2 , then it wont support / downgrade to 2005 . for getting 2005 version you have to re-work the package and you need to upgrade your sqlserver from 2005 to 2008 R2

check the below link


social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/50dd9bc4-d95c-4435-8438-554075575a83/

 For some third party downgrade application please refer the below link


http://www.sqlservercentral.com/Forums/Topic1046316-148-1.aspx

So

You can use Job Transfer task in SSIS

The SSIS packages copied from Production (MS SQL Server 2008 R2) to DR Server (MS SQL Server 2008 R2) by using Import utility.