Home > SSIS > Delay package task validation – SSIS

Delay package task validation – SSIS


DelayValidation is an important property if you develop a package with dynamic connection string or custom expressions.

In this article, I will be giving an example to show you teh use of DelayValidation property in the package design.

Plot:

A package has File System Task to delete a file from the disk. But, user like to make the functionality dynamic. So, user uses a package variable to refer file name to the task. Let design a package.

Implementation:

Step 1: Create a package, Add File system task and a package variable.

Step 2: Change the File System task property value as given in the below picture.

 

 

 

 

 

 

 

Step 3: Click ok. You will see the error mark on the task saying variable is empty.

Step 4: Go to File System Task property and change DelayValidation property value to True.

 

 

 

 

Step 5: Now, error should be disappeared from the design. If you run the package with empty package variable then you will get the error during runtime.

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: