We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and ...
We have a SQL Server 2012 instance that is our main ETL/DW server. The daily jobs consist of about 40+ ETL processes querying other data sources, updating the DataMart, standard ETL and BI processes. ...
I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...