SQL Server Integration Services How To - Add a rownumber to a data flow using a script component

simonsabin — Mon, 05 Mar 2007 21:03:41 GMT

This demo shows how simple it is to add a script component into a data flow to generate a row/line number for your data flow.

This demo currently has no sound, I hope the content is self explanatory. I will be publishing a version iwth sound over the next week (when I get a microphone)

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

Raw File Reader

simonsabin — Sat, 06 Jan 2007 03:22:33 GMT

A tool for reading raw files produced by SQL Server 2005 Integration Services. This is currently freeware, if you wish to make a contribution via paypal feel free (paypal@onarc.com)

The current feature set is

Read any SSIS Raw file
Results displayed in a grid
Columns automatically resized
Order of columns can be changed
The results can be ordered by clicking on the column headings
You can choose which columns to display (will improve performance for large files)
Data can be copied from the results grid using CTRL+C
Any set of cells can be copied from the results grid by using the CTRL key
Column headers can be included or excluded from the copied data
Will remember the last 10 files used
Reading of data can be automatic when the columns are read or the data can be read manually once you have selected the columns you want
Column selection mechanism is similiar to that in SSIS components
Notification when the currently loaded raw file has changed i.e. package is rerun
Opton to automatically reload file when file changes
Sizeable window to maximise viewing of data in the grid.
Column headers can be included if more than one column is selected.
Context menu to copy data from the grid
Can read a package for raw files and will load each one of them
Will remember the last 10 packages read used
Option to change the file extensions associated with raw files (thanks Julian)
Fixed some spelling mistakes
Application is now an MDI application allowing for multiple raw files to be opened at once
Rawfile detail windows can be cacaded, tiled as with all MDI windows
Enable application for ClickOnce deployment

17th Janurary 2007 1.1.1.0

Column headers can be included if more than one column is selected.

Context menu to copy data from the grid

Can read a package for raw files and will load each one of them

Will remember the last 10 packages read used

Option to change the file extensions associated with raw files (thanks Julian)

Fixed some spelling mistakes

Application is now an MDI application allowing for multiple raw files to be opened at once

Rawfile detail windows can be cacaded, tiled as with all MDI windows

Enable application for ClickOnce deployment

First version 1.0.0.0

Read any SSIS Raw file

Results displayed in a grid

Columns automatically resized

Order of columns can be changed

The results can be ordered by clicking on the column headings

You can choose which columns to display (will improve performance for large files)

Data can be copied from the results grid using CTRL+C

Any set of cells can be copied from the results grid by using the CTRL key

Column headers can be included or excluded from the copied data

Will remember the last 10 files used

Reading of data can be automatic when the columns are read or the data can be read manually once you have selected the columns you want

Column selection mechanism is similiar to that in SSIS components

Notification when the currently loaded raw file has changed i.e. package is rerun

Opton to automatically reload file when file changes

Sizeable window to maximise viewing of data in the grid.

Integration Services Tools

SQL Server Integration Services How To - Add a rownumber to a data flow using a script component

Raw File Reader