Transfer Multiple Files from or to FTP remote path to local path – SSIS

This is a common mistake which SSIS developer’s thinks that they need Foreach Loop for transfer multiple files from ftp to local or from local to ftp.I had a post about using masks in FTP task for transfer multiple files, but it seems that I should clarify this more than before. Note that you don’t Read more about Transfer Multiple Files from or to FTP remote path to local path – SSIS[…]

Export Data Starting From Special Cell in Excell File – SSIS

Sometimes you have a formated Excel file, which you want to use this file as Destination, so you may need to import data start from special Cell inside the excel file.By default SSIS import data from Column1 and Row1 in excel file. But you can change it. Solution: Suppose this excel format: in this sample Read more about Export Data Starting From Special Cell in Excell File – SSIS[…]

SSIS – Sql Server to XML – Save to file

As you know there is no XML destination in SSIS. so how you can save result of a query from sql server to XML file? Solution is: First Of all you can use FOR XML to get result of query in XML , look at our sample query : SELECT EmployeeID,NationalIDNumber,ContactIDFROM HumanResources.Employee FOR XML RAW(‘Facility’),Root(‘Extract’),Elements  Read more about SSIS – Sql Server to XML – Save to file[…]