Category Archives: SQL Server Integration Services

Installing SQL Server 2014 Data Tools

I noticed that SQL Server Data Tools (a.k.a. BIDS) was not listed under Shared Features on the SQL Server 2014 Developer DVD. So where did it go?  With SQL Server 2014, there is a link on the Installation Center window … Continue reading

Posted in Database Administration, Development, SQL Server Integration Services, SQL Server Reporting Services | Tagged , , | Leave a comment

Converting from Teradata Timestamp to SQL Server Datetime ‏

Teradata has a timestamp data type that appears to be equivalent to a SQL Server datetime.  It is not. Attempting to use the SSIS Data Conversion task will likely fail with a truncation error.  While the solution below is extremely … Continue reading

Posted in SQL Server Integration Services, Teradata | Tagged , , , , | Leave a comment

SSIS Tuning–Packet Size

Tuning the packet size property in connection managers can often yield significant performance improvement.  By default the packet size is 0 for OLE DB connections which defaults to the instance packet size.  In most cases the default value is 4096.  … Continue reading

Posted in Performance, SQL Server Integration Services | Leave a comment

SSIS Fuzzy Lookup Hangs

I ran into a problem where the Fuzzy Lookup transformation would hang when run from within BIDS. A command prompt window would open and close. It happened too fast to be able to read it. The lookup involved two relatively … Continue reading

Posted in SQL Server Integration Services | Tagged | 3 Comments

Loading XML data from a URL in SSIS

Loading XML data from a web endpoint in SSIS is easier than it seems.  Create a Data Flow Task and add a XML Source Task.  While it appears the task is looking for an XML file path, a URL can … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 3 Comments

Free SQL Server 2012 Training

I am always on the lookout for some free training.  Registration and a Windows Live ID are are required but there is no cost for the training. http://www.microsoftvirtualacademy.com/colleges/sqlserver

Posted in Database Administration, SQL Server Integration Services, SQL Server Reporting Services | Tagged | Leave a comment

Good post on waiting for a file in SSIS

A commonly encountered problem in SSIS is determining when a file that is being written has completed.  Here is a great post on how to deal with that situation: http://microsoft-ssis.blogspot.com/2011/05/wait-until-file-is-unlocked.html

Posted in SQL Server Integration Services | Tagged | Leave a comment