Scheduling an SSIS 2008 Package on a SQL 2005 server?

Question

Post reply

Scheduling an SSIS 2008 Package on a SQL 2005 server?

Steve-443559

SSCrazy

Points: 2307
More actions
August 26, 2011 at 8:02 am

#247081

Will an SSIS Package developed in SQL 2008 BIDS work, if scheduled on a SQL 2005 server? I'm guessing it won't, but wanted to confirm.

Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Robert Klimes SSCoach Points: 17865 More actions · Answer 1

Robert Klimes

SSCoach

Points: 17865

August 26, 2011 at 8:28 am

#1373799

Unfortunately it wont work.

http://qa.sqlservercentral.com/Forums/Topic1079134-391-1.aspx

Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

MysteryJimbo

SSC-Insane

Points: 24203

August 26, 2011 at 9:23 am

#1373856

You can start a SSIS job on another server using sql 2005, but you wont be able to call a 2008 SSIS package directly from 2005. So you will need another instance or to redevelop the package in 2005