thanks for the reply,

here is the thing

step 1 create a execute sql task and pass the date column from tablea as a variable (variablea)

step2 create another execute sql task with...

CAST STATEMENT? which transformation do i have to use for this

thanks

i donno if this is what u need

but the below steps will check if a file exists and then proceed to execute a package

first u will need to define three...