Phani,

Write Disable expression on DFT and Archival tasks to disable/enable tasks, so that DFT and Archival will not work when those are disabled, for next iteration, i guess its diffcult...

Dear AJ,

Remove global variables from Child package, child will use the parent variables if you refer inside if Child which are declared in Parent and assigned values either in parent...

Dear AVB,

Based on the first sql task value, you can enable and disable the next task, to do that use a activex script task in between and write VBA code...

Hi Burak30,

you cant do that in the way as you are trying..

I guess you are writing the SQL query in Execute SQL task, this task works on Single connection, where...

Hi burak30,

Pls follow the steps

1. Create source connection (SQL Server)

2. Create Destination (Access DB)

you can achieve in two ways

i. Create 6 DataFlow tasks and enable/disable required tasks, each DFTask must...

yes,

you can mail using OSQL command and Vmailer exe file

Cheers

RB

Hi Guys,

Its pretty simple...

I was decided to use 5 DFT tasks in side to create multiple sheets in single excel file. I started working on it, mean while I...