Tag Archives: Script

Presentations at Atlanta’s BI Edition SQL Saturday

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

Advanced Scripting in SSIS

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

Naming Columns for the Script Component

Naming columns is important for the Script component Continue reading

Posted in SSIS | Tagged , | Comments Off

Using OLE DB Connections from Script Tasks

Use OLE DB Connections from Script Tasks in SSIS Continue reading

Posted in SSIS | Tagged , | Comments Off

Importing Files Using SSIS

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