February 2007

Monthly Archive

Thu 22 Feb 2007

FTP within an SSIS Script Task

Posted by Phil Brammer under SSIS Connectivity
[2] Comments 

A fellow user on the SSIS forums has posted his code to FTP from within a script task. I just want to increase visibility to this as the stock FTP Task is somewhat limited.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1258083&SiteID=1

 

Tue 20 Feb 2007

Generating Surrogate Keys

Posted by Phil Brammer under SSIS Data flow
[8] Comments 

Generating surrogate keys is no sweat in SSIS. Though it does require a custom script to be written. (You might be able to use the Row Number Transformation)

(more…)

 

Tue 20 Feb 2007

SQL Server Service Pack 2 (SP2) is out

Posted by Phil Brammer under SSIS Announcements
No Comments 

Take a look at the released SP2 for your installation.

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

 

Tue 20 Feb 2007

New Blog

Posted by Phil Brammer under General
1 Comment 

So, I’ve decided to move into the realm of having my own blog space for SSIS along with a nifty domain name. Please note that from time to time the site look and feel may change. I’m bound and determined to try to find something I really like in terms of presenting this content… This site will replace http://ssistalk.blogspot.com.