Is there a way of converting a SSIS package created in Visual Studio 2013 to work on SSIS 2012?
The start of my package looks like this:
DTS:CreationDate="12/18/2014 8:53:33 AM"
Best How To :
The short and long answer, unfortunately, is no. If you want to develop SSIS/SSDT for SQL Server 2012, you must use the Visual Studio environment that came with 2012.
Here's the long version of the background info. To build SSDT packages for SQL Server 2012, you actually use Visual Studio 2010. VS2010 is the BIDS environment that came with SQL Server 2012. People very colloquially call it SSIS 2012, but that's a misnomer, and with the very weird backwards compatibility issues surrounding SSIS across these versions, it's important to get the terminology about development environments right. Additionally, you are developing packages in Visual Studio 2013, but that technically is only for SQL Server 2014.
The interesting thing is you can use VS2013 (the developer tools included with 2014) to build SSRS and SSAS solutions for SQL Server 2008 through present, but that flexibility does not extend to SSIS/SSDT. You must use SSDT for VS2010 if you want to deploy packages on SQL Server 2012, and you must use SSDT for VS2013 if you want to deploy packages for SQL Server 2014.
Anyway to deploy a SSIS 2012 project built in VS 2013?