Home > ETL Best Practices > ETL Best Practices (2) – “Work Offline” in development

ETL Best Practices (2) – “Work Offline” in development

When developing SSIS packages in BIDS, you would want to turn on the “Work Offline” option. This will allow BIDS to load packages without validating every connection or the schema for every query.

Step 1: Open your SSIS project from BIDS, but do not open any package yet.

Step 2: From the SSIS menu, turn on “Work Offline”

image

Step 3: Once you have the package opened in BIDS, you need to turn off the “Work Offline” option in order to create/modify your queries against the sources.

Potential problems with validation in development:

1) When you have a large volume of data, opening your package from BIDS can take a long time.

2) If your login credential has expired, the connection will fail. Worse yet, the multiple login failures from BIDS will count towards your allowable tries, and your source server might lock up your account.

Another way to stop the validation during development, is to set the delay validation to True for every connection and component. But remember this is a runtime setting that will just delay the validation of a component until just before it executes.

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: