SSIS Debug: The SSIS package dynamically created by script

I had a script task which creates a package dynamically and load data. While I was debugging, I wanted to see the dynamicapackage and open and check everything is working as it should be.

In order to see the package, follow the steps:

  1. On the package open the Variables
  2. On the Variables click on the Grid Options
    1. Check Show system variables
  3. Then find the DebugMode and set to True.

Advertisements

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