Conditional Split Transformation: Populate data from SQL Server, divide and save in MySQL and Oracle databases

In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That process is based on the condition defined in SSIS as "conditional split transformation". Conditional Split transformation is like case statement of any programming language. Using conditional, we can redirect the output of a component in multiple destinations that is based on a condition defined in the conditional split component. Demo Setup We can retrieve data from various database platforms by using ODBC connection while using SQL Server data tools. Most of the database platforms provide their connectivity drivers that can be used to configure the connection between application and database. I am going to export data of customer table of the "AdventureWorks2014" database to Oracle and MySQL based on the condition defined in condition split. Data will be divided on the base of the "StateProvinceName" column of "Customers" table. Records that have the value named "California" in "StateProvinceName" column will be exported to Oracle database and records that have the value named "Washington" will be exported to MySQL database.

✔ Read More...

I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

SQL Server,database administration,mysql,oracle,sql server