How to compare strings based on ASCII code in SSIS

Posted by on Oct 14, 2010 in SSIS | No Comments

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

SSIS – Sql Server to XML – Save to file

Posted by on Oct 5, 2010 in SSIS | No Comments

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

How to handle Failed Rows in a Data Flow

Posted by on Jul 16, 2010 in ETL, SSIS | No Comments

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

Looping through specific files – SSIS

Posted by on Jul 6, 2010 in SSIS | No Comments

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

XML Task – Changing Style of Data – XSLT

Posted by on Jun 4, 2010 in SSIS, XML | No Comments

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

XML Task – Validating Data

Posted by on May 29, 2010 in SSIS, XML | No Comments

I decided to explain XML Task for a while. This task has many abilities to work with XML. to use this Task, create a SSIS package , add a XML task ,double click on it, Xml Task Editor window will open.the most important property of XML task is : OperationType .there are 6 OperationTypes in ...

Read More

How to use Script Component as Asynchronous Transformation

Posted by on Apr 16, 2010 in Scripting, SSIS | No Comments

Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read,  This is an example of data file: date                     : 04/14/2010customer name        : John doeaddress                  : 2014 apple st. Chicago, IT 30000sale order        ...

Read More