Using Script Component Transformation as SQL Server Function derived column

Posted on November 5, 2009 by Reza Rad

Did you tried to create a derived column in SSIS with a written sql server function before? This is impossible with Derived Column Transformation because you can not use sql server functions in this transformation. Solution: Use Script Component Transformation. this is a simple example : 1-create a sql server table with 2 fields named Read more about Using Script Component Transformation as SQL Server Function derived column[…]

Dynamic connection string in SSIS

Posted on October 25, 2009 by Reza Rad

This is a common problem: Use a dtsx package with dynamic database connection. In fact there are times that you need to set connection string of database from outside of package. solution: Suppose that you have an OLE DB connection and set it to same database which you want to work with and named it Read more about Dynamic connection string in SSIS[…]

How to create NOT IN on different database servers with SSIS package?

Posted on October 24, 2009 by Reza Rad

Problem: There is a source table and destination table with same structure, but in different databases and different servers . Suppose some of data from source table transferred to destination table in past, and the ID field is not IDENTITY, so all data in destination table has equivalent in source table. Now we want to Read more about How to create NOT IN on different database servers with SSIS package?[…]

Working with flat files dynamically in SSIS package

Posted on October 23, 2009 by Reza Rad

Problem: Create a directory based on each year in a specified path, and then create a flat file named with compound of year and month based on a template file. You need to transfer some data into this flat file from a source. The above scenario is a usual scenario when you work with flat Read more about Working with flat files dynamically in SSIS package[…]