I am guessing P1 and P2 are really solutions(and not packages), because the statement :

P1 has one DTSX and P2 has three DTSX files.

doesn't sound right. One SSIS package always...

Hi am new to this forum but found the question intersting....so trying.... 🙂

From your latest response, it seemd like you want to create some kind of a stg/tmp table where...

As the other user suggested, this can be achieved easily through Configurations (inside your package).

So basically :

1)Create a variable (say FILE_LOC of datatype string)

Put the path in that variable...

Hi

I am new to this forum and would like to take a stab at this question.

With whatever info you have provided....

Please see first what SSIS is sending to your table....

Well

even you knew you the structure of your pkg xml well enough, it will be a big deal to modify / create your package from xml directly as the XML...

Hi friends

just figured out the answer.....if it helps anybody at all. the below is what i did to make it work :

//You can first check for p.Executables.count > 0

foreach...