"Do nothing" Task

[shade3]

Hello

I want to make a first step preexecution event handle.
But later perhaps the first task will not to be the first task.
So I thought I do a "Do nothing" Dummy task and link to this the event handler.
But how can I do this "Do nothing" step? I didn't found like this task.

thnx
shade3

 

[fredericofonseca]

few options

create a sequence container - don't put anything on it
create a script task - don't need to have anything on it.
create a sql task - put "set nocount on" on it -- not the best one as it does require a sql connection

but better yet set up proper flow logging on your package and add a task to log start/end and intermediary steps to a logging database so you can see easily what/where/when was going on on your package. you could inclusive log the supplied parameters/variables supplied to the package and those that change within the execution of the package (and SSISDB catalog although would do part of this it also has its limitations)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886