Home > SSIS > Confirm to delete an item from SSIS package

Confirm to delete an item from SSIS package


While designing SSIS package, we may delete some tasks which are used temporarily or intend to remove some task for other purpose. Altering the design (Add/Delete) is very normal in development scenario. But, removing item should not be a pain for the developers. Instead, it should ease the development process.

The pain killer is that we can remove confirm to delete option from SSIS design interface.

In this example I will show you the default setting of confirm delete option.

Now, I am going to delete a task from the control flow design interface. It will ask me to confirm whether yes/no.

In this example, I am going to remove check for the task confirm to delete option.

Now, I can delete task from the package easily with single delete key press.

Additional tips, SSIS Denali has Undo/Redo feature. So, don;t worry for deleting an item in the package.

Thanks for reading.

Advertisements
Categories: SSIS Tags:
  1. September 2, 2011 at 6:09 pm

    I got a very nice response from a reader “I liked your article is an interesting technology
    thanks to google I found you”. This response motivate me to do more. thanks for your support forever.

  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: