There are lots of time which you want to get latest created file in a directory and do something with it, for example do a data transfer or do a file system task like delete or move. As you may know the Foreach Loop Container in SSIS can loops through files of a directory, But Read more about Find Last Created File in Special Directory – SSIS[…]
Few days ago, I encounter a request which asks for delete files on remote ftp folder which are older than 10 days with SSIS tasks. Suppose date of each file is embeded in the file name like this: zzz_2010-10-25 03-00-22.txt As you may know , using Foreach loop with configuring enumerator as file enumerator will Read more about Loop through FTP Files On Remote Folder and Delete OLD Files – SSIS – .NET Code[…]
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[…]
there were two thread in this week which has issue when compare two strings in SSIS Expressions, for example request was "9:9" < "99" . if you try the above expression in SSIS, you will get True as result. this may seems OK, but requests was to compare them by ASCII character, if you look Read more about How to compare strings based on ASCII code in 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[…]
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[…]
I encounter a question today which was about using a Stored procedure inside a Data flow task, and use result of stored procedure which returned by output parameter beside other columns in Data Stream. Solution with sample: Suppose your stored procedure has an input parameter and output parameter. I show you a simple stored procedure Read more about Output Parameter of Stored Procedure In OLE DB Command – SSIS[…]
suppose this scenario: you have a source table and a destination table, you want to transfer rows from source table to destination table, so you can use simple data flow with OLE DB source and OLE DB Destination. but problem hits when destination table has few rows inside, and there is Unique Constraint in ID Read more about How to handle Failed Rows in a Data Flow[…]
As you may know, there is an enuerator in Foreach Loop Container which help you to loop through files, named File Foreach Enumerator. you can specify a location for searching through files and get files as enuerator in loop.But, there are some times which you need to loop through specific files not all of files Read more about Looping through specific files – SSIS[…]
I wrote about Validation with XML Task in SSIS here before, now I want to write about XSLT in this post. XSLT is an acronym of eXtensible Stylesheet Language Transformation. XSLT can transform given XML document to new style. this is very good way for reading complex XML documents where XML source has week ability Read more about XML Task – Changing Style of Data – XSLT[…]