SSIS

SQL Server Integration Services How To - Create a data flow source that provides a list of files in a folder

simonsabin — Mon, 05 Mar 2007 22:27:20 GMT

I use a script component a lot to provide me a list of files in a data flow. I use it to record the log files from my servers and identify which ones need processing.

This demo show how to add a script component to a data flow as a source component and configure the script component to output the details of the files in a folder passed to the component.

You must be registered to download this demo. Registration is free.

SSIS in the real world - Parsing Unstructured Data : Sample File

simonsabin — Mon, 17 Jul 2006 23:06:28 GMT

Sample file for the SSIS in the real world - Parsing Unstructured Data package

SSIS in the real world - Parsing Unstructured Data

simonsabin — Mon, 17 Jul 2006 22:54:20 GMT

Parsing unstructured data
De-normalising
Multiple source files
Managing lookups
Incremental processing
Restartability