By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,612 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

ssis - Where is the sql?

P: n/a
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
Nov 13 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.