SSIS in the Real World - Parsing Unstructured Data
For those of you that were at the first UK BI usergroup meeting you will have been my whirl wind example of processing an unstructured data file using ssis. The packages are now available.
The presentation is here http://sqlblogcasts.com/files/7/ssispresentations/entry902.aspx
and the package is here http://sqlblogcasts.com/files/8/ssisdemos/entry901.aspx
The Packages cover,
- Parsing unstructured data
- De-normalising
- Multiple source files
- Managing lookups
- Incremental processing
- Restartability
The sample file is http://sqlblogcasts.com/files/8/ssisdemos/entry903.aspx and will need to be put in a folder
C:\UserGroup\SSIS - Parsing Unstructured Data\ErrorLogs
Enjoy and any questions please feel free to ping me.
-