Official CozyRoc Blog

November 5, 2007

Even Easier SSIS Package Configuration

Filed under: SSIS — COZYROC @ 3:42 am

We all know the standard hard-coded SSIS package configuration types like XML, registry, INI file, SQL Server. Our opinion is that the SSIS package configuration implementation in the SQL 2005 incarnation is half baked, with no way to extend it with other configuration types. We have used for a long time in DTS a different configuration setup based on Excel worksheets. It gives you better maintenability and flexibility because you can use the Excel engine as a powerful initialization model. We have created a small Script Task to demonstrate the concept. You can use it as a sample to create your own configuration mechanisms. Please install SSIS+ 1.2 to use it. Enjoy.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: