Downgrading an ETL project from SSIS 2014 to SSIS 2012

Recently I came into the situation that I had a SSIS package built with Visual Studio 2013 and SQL Server Data Tools (SSDT) 2014 which should be deployed to SQL Server 2012. Running the packages from Visual Studio 2013 and inserting data in a database on SQL Server 2012 worked, it also worked to deploy … Continue reading Downgrading an ETL project from SSIS 2014 to SSIS 2012

[SSIS Errors] The process cannot access the file because it is being used by another process

This is an error message that took me a few hours because I could not find that particular solution on the internet and … I did not look properly at the SSIS output So I’d like to share it with you. Information: 0x402090DC at Load Observations, Flat File Destination [268]: The processing of file “D:\test\Log.txt” … Continue reading [SSIS Errors] The process cannot access the file because it is being used by another process