Can SQL Server Data Tools work with SQL Server 2008 SSIS?

sql-server-2008 ssis sql-server-2012 sql-server-data-tools
Mark Arnott picture Mark Arnott · May 4, 2012 · Viewed 14.2k times · Source

Can I use the new SQL Server Data Tools that come with SQL Server 2012 to create SSIS packages for SQL Server 2008?

I work with both SQL Server 2008 and SQL Server 2012 and I am wondering if I can use SSDT to create and maintain SSIS on both.

Answer

Sentinel picture Sentinel · Jun 5, 2012

No. See problem with deploying ssis 2010 package

It seems that the backward compatibility offered by SSDT does not apply to SSIS.

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Update Rows in SSIS OLEDB Destination

I have a data flow process where I have an OLEDB Source and an OLEDB Destination like below: Source merges data from two staging tables and returns a result set (say, 50K rows). These 50K rows are present in the …

Read More
How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages?

I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that's not what I'm after). I receive the following error by …

Read More