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.
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