From what I read (http://msdn.microsoft.com/en-us/library/bb522577.aspx) if I only have SQL Server 2012 Developer edition installed it will not be possible to create SSIS packages to run under SQL Server 2008 (or 2008 R2). In order to do this one needs to have side-by-side installation of SQL Server 2008 and 2012 on development PC. Is that correct?

Yes, that is correct. And they operate just fine on the same machine. I've got 2005 BIDs, 2008R2 Bids and SSDT running on the same machine, along with an instance of SQL 2008R2 and SQL 2012 Chuck

Yes, that is correct Chuck If I already have SQL Server 2008 Dev. Ed. installed - can it target 2008 R2?

Yes, that is correct Chuck If I already have SQL Server 2008 Dev. Ed. installed - can it target 2008 R2? You can target 2008r2 with the 2008 version, but I'd recommend upgrading to 2008R2 dev tools since they added a lot of features on the BI side in R2 Chuck

Here's the doc listing the differences so you can see if you care http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspxChuck

Yes, that is correct Chuck If I already have SQL Server 2008 Dev. Ed. installed - can it target 2008 R2? You can target 2008r2 with the 2008 version, but I'd recommend upgrading to 2008R2 dev tools since they added a lot of features on the BI side in R2 Chuck If I upgrade to 2008 R2 - will I still be able to target 2008? Or 2008 would need to be installed side-by-side with 2008 R2 for this?

Not sure - I don't have any clients who run both 2008 and 2008R2. Most folks went to R2 as soon as it came out. If you have mixed 2008 and 2008r2 you would probabally want to stick with the 2008 BIDS.Chuck

Here's the doc listing the differences so you can see if you care http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx Chuck So it looks nothing was changed in SSIS.

Here's the doc listing the differences so you can see if you care http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx Chuck So it looks nothing was changed in SSIS. Only this: The following list outlines the new features for Integration Services: ADO NET Destination Editor (Connection Manager Page) This release includes a new option, Use bulk insert when available, in the ADO NET Destination Editor. This option enables you to use the System.Data.SqlClient.SqlBulkCopy interface to improve the performance of bulk insert operations. http://msdn.microsoft.com/en-us/library/bb522534(v=sql.105).aspx Chuck