Dynamic Row Delimiter and Column Delimiter in SSIS

Posted by on Dec 10, 2010 in SSIS | No Comments

There are times that you want to make Row Delimiter and Column Delimiter dynamic in Flat File source, and you want to change these values dynamically with package variables. usually you can use EXPRESSION properties for making things dynamic in SSIS, such as ConnectionString and bind it to a package variable. As you may know ...

Read More

Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS

Posted by on Nov 11, 2010 in ETL, SQL Server, SSIS | No Comments

There are lots of links which described how to UPSERT( Update / Insert ) between two SQL Server tables. which mostly used Lookup Transform with OLEDB Command, like this:http://www.insideit.fr/post/2010/06/17/Lookup-simple-sur-SSIS But when you work with MySQL there is a limitation, you can not use OLEDB Connections, you can use ODBC or ADO.NET Connectors from .NET to ...

Read More

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