Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2011-05-30 : 18:08:17
|
| 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. |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-05-31 : 10:24:05
|
| Check these links:Migrating from SSIS 2005 to 2008:If you are already running on SQL Server 2005’s Integration Services platform and you wish to get the new benefits of Integration Services 2008 you will still need to perform a migration (or upgrade), however it’s a relatively simple one. As of the time of this writing (SQL Server 2008 CTP5), SSIS 2008 does support being installed side-by-side with SSIS 2005. SSIS 2008 is for the most part a pure enhancement of the platform. I say for the most part because there are a few ‘gotchas’ (breaking changes) between the two builds:· SSIS 2008 uses Visual Studio 2005 Tools for Applications (VSTA) for its scripting environment· SSIS 2008 uses a newer build of the SQL Server Native Client· SSIS 2008 contains an updated OLEDB Provider for Analysis Services (10.0)· SSIS 2005 custom developed components will need to be altered to work in SSIS 2008The script environment differences are the biggest change between the two builds of SSIS. When you open/add a SSIS 2005 package which contains a Script Task in SQL Server 2008 BIDS it will automatically attempt to convert the script for you. You can also attempt to execute the older SSIS 2005 package with the 2008 dtexec utility, this operation will also convert the script; however the script conversion is only temporary for the currently running instance of the package.source:http://blog.scalabilityexperts.com/2008/02/19/the-key-sql-server-2008-bi-migration-dts-to-ssis-2008-part-2-of-2/The SQL 2005 is not going to change, SSIS 2005 is hosted in VS 2005, and you can't open SSIS projects in VS 2008 until you install SSIS 2008.source:http://blogs.msdn.com/b/michen/archive/2007/12/04/sql-2008-and-vs-2008.aspx |
 |
|
|
|
|
|
access methods for ssis