SSIS: Is It possible to have modularity and avoid replication inside a single Data Flow?

43 Views Asked by At

How I can do something like programming language functions/methods inside a Data Flow? I have data flows that have many steps sequence replication and I don't want that.

Using programming language as example, what I want:

task1;
task2;
insert();
....
task13;
task14;
insert();
....
task60;
task61;
insert();

//insert implementation
insert()
{
   logtask;
   insertInDatabaseAtask;
   insertInDatabaseBtask;
   audittask;
}

I know that break my package flow in more data flows is a possibility, but in certain cases, I prefer to do some modularity like methods/functions of programming language inside the same data flow.

Is it possible? How I can do that?

Best Regards, Luis

0

There are 0 best solutions below