I am new to ssis. My company has the sql server 2005 standard edition for a couple of more months. Later this year my company will be converting to sql server 2008 r2 standard edition. Can you tell me how to access the ssis 2005 packages using sql server managment studio 2008 r2 standard edition since this is what I have access to (This includes using bids if I need it) If I do get access to sql server managment studio 2005 andor bids (business intelligense studipo 2005), can you tell me how to access the ssis 2005 packages.

Have a read of this thread http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/a4c788cb-8461-4066-96a4-894dcb8de332Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

If the SSIS 2005 packages reside on file system they can be upgraded in SQL Server 2008 R2 BIDS by adding them in the solution explorer. It is done automatically.Happy to help! Thanks. Regards and good Wishes, Deepak.