467,915 Members | 1,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

ssis - Where is the sql?

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
Nov 13 '08 #1
  • viewed: 1157

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Eric | last post: by
1 post views Thread by oregondba | last post: by
9 posts views Thread by gelangov | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.