SQL Server Performance

Writing SSIS with BIDS 2008 to run on SQL Server 2005

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Zirco, Oct 27, 2008.

  1. Zirco New Member

    Hi,
    Is it possible to use Business Intelligence Designer Studio from SQL Server 2008 to design a SSIS package that will be executed on a SQL Server 2005?
    I have done the opposite (SSIS from BIDS 2005 to run on SQL Server 2008), the only trouble was the version of SQL Native Client Connectivity (SNAC) which must be updated from version 9 to version 10. Since then I have updated my dev environment to SQL Server 2008.
    Now I have an old SQL Server 2005 SSIS package to update. I am going to open it and update the code using BIDS 2008. If there is anything I shoild be aware of in terms of compatibility or deployment issues, I would appreciate any advice.
    Thanks very much in advance.
  2. Saurabh Srivastava New Member

    Yes- Its is possbile to use BIDS 2008 to design a SSIS to execute on 2005 machine.
    Run SQL server 2008 upgrade advisor to find out any incompatble items in SSIS package

Share This Page