Home > SSIS > Pause the package execution

Pause the package execution


We may need to pause the package execution for some reason. Pausing is just making the current thread to sleep mode for N milliseconds.

Package Design

1. Create a new SSIS package and add a Script Task

2. Add this code in the script task to block the thread

System.Threading.Thread.Sleep(1000) ‘1000 milliseconds

If you execute the package with this code you will see a second delay in the script task execution.

Thanks for reading.

Advertisements
  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: