There was a requirement in one of my recent projects to export data from table in SQLServer database to an Excel file. Though it sounds a straightforward one, there was a tricky part in it. The data has to go…
Connecting to Azure Instance using SSIS
This blog post discusses two methods in SSIS which can be used for connecting to Azure instances.The attempt is to copy an on premise table along with the data to an Azure instance.We can use ADO.NET connection manager to connect…
Implementing Transaction over File System Objects
Its a common scenario in ETL processes to transfer files from remote location to landing folder and do some processing with them. Recently we had a requirement wherein we were asked to implement transaction processing for the file transfer package.…
DTExec issues in multi instance SQL Server box
The purpose of this blog is to highlight a problem which I faced while automating an ETL process recently and to suggest a solution for it.The scenario was as follows.There were a set of packages which were developed in SSIS…