Tag Archives: Script

Presentations at Atlanta’s BI Edition SQL Saturday

Posted on January 11, 2016 by jwelch

I presented this weekend at SQL Saturday #477 in Atlanta. It was a great event, very well organized. I appreciate all the attendees at my sessions – there were some great questions and comments. I promised that I’d publish my … Continue reading →

Posted in Presentations, SQL Saturday | Tagged , , | Comments Off on Presentations at Atlanta’s BI Edition SQL Saturday

Advanced Scripting in SSIS

Posted on August 17, 2015 by jwelch

Last week I presented a session on Advanced Scripting for SSIS for Pragmatic Works. Thanks to everyone who attended, and all the great questions. I’ve had a few requests for the samples I used, so I wanted to make those … Continue reading →

Posted in Presentations, SSIS | Tagged , , | Comments Off on Advanced Scripting in SSIS

Naming Columns for the Script Component

Posted on August 18, 2011 by jwelch

Naming columns is important for the Script component Continue reading →

Posted in SSIS | Tagged , | Comments Off on Naming Columns for the Script Component

Using OLE DB Connections from Script Tasks

Posted on August 17, 2011 by jwelch

Use OLE DB Connections from Script Tasks in SSIS Continue reading →

Posted in SSIS | Tagged , | Comments Off on Using OLE DB Connections from Script Tasks

Importing Files Using SSIS

Posted on February 2, 2008 by jwelch

A topic that has come up a few times recently is the idea of loading a set of files into a database using SSIS. One of the data flow components in SSIS is the Import Column transform, which allows you … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Importing Files Using SSIS