Category Archives: SSIS

SSIS: Use Dates in Dynamic SQL Statements

Posted on March 1, 2012 by Kevin Carter

I have seen lots of posts on how to build a date string for expressions that set the SQL Statement that will be executed in Data Pumps for example. You might need to do that if you are working with a data source that does not like date manipulation functions in the SQL statement. The solutions I have seen seem a bit complicated, but I figured out a way to do it simply. This might not be new, but I have not seen it, so here goes. First, I create a variable that is a string to hold the date.  
Read more...

Posted in Business Intelligence, SQL, SSIS | Leave a comment

SSIS Attunity Connectors

Posted on October 18, 2011 by Everett Comstock

Recently I had to create an SSIS package that transferred a huge amount of data between an Oracle database and a MS SQL Server database. I began creating an SSIS package that used an existing linked server connection that the client had already been using to perform similar data transfers. To my dismay, the performance of the linked server was dismal. Instead of using the linked server I decided to go with the OOTB OLE DB data source available in SSIS. This increased my performance dramatically. However, when I spoke to a colleague at TCSC, he recommended that I try the Microsoft Connectors for Oracle by Attunity. I had never heard of these connectors, but I was intrigued, so I downloaded them and ran some performance test. The following tests results we recorded while debugging through Visual Studio, so real numbers will be better than what I have recorded, but the results do represent without a doubt the performance differences between the different connections.  
Read more...

Posted in Business Intelligence, SSIS | Tagged , , | Leave a comment