Hi,
I am new to ssis, but not to ye olde dts. I just used the wizard to
create a package that imports a bunch of tables. I will be using it
to sync the tables. This package imports 10 tables. My issues is
that I cannot find the sql the runs this thing. Since the wizard ran
it the first time there should be some CREATE TABLE sql strings (that
I need to change to deletes), but I see a query string for one table
in the preparation sql task. I see one statement in the control flow,
but I have 10 tables being updated in the data flow. DTS used to have
execute sql tasks that you could add, but I see these only in the
control flow. I must be overlooking the obvious.
Thanks for your hlep
P
I am new to ssis, but not to ye olde dts. I just used the wizard to
create a package that imports a bunch of tables. I will be using it
to sync the tables. This package imports 10 tables. My issues is
that I cannot find the sql the runs this thing. Since the wizard ran
it the first time there should be some CREATE TABLE sql strings (that
I need to change to deletes), but I see a query string for one table
in the preparation sql task. I see one statement in the control flow,
but I have 10 tables being updated in the data flow. DTS used to have
execute sql tasks that you could add, but I see these only in the
control flow. I must be overlooking the obvious.
Thanks for your hlep
P