January 11, 2012 at 2:10 pm
I used the Data Import Wizard to create the most basic package. It truncates tables in DatabaseB, then repopulates from the tables in DatabaseA.
When I export the package and open it in BIDS, I cannot see where the individual tables are specified to truncate and copy. The package works when I run it, but I may want to edit to add more tables in the future.
Under "Control Flow" I see: Start Transaction; Transaction Scoping Sequence; and inside is a "Foreach Loop container"; Transfer task and Execute Inner Package.
Under "Data Flow" it says "No data flow tasks have been added to the package".
I've searched around, but can't see where the 30 tables are specified.
What am I missing ?
EDIT: I think I found the problem. Since I was exporting a lot of tables, the "Optimize for Many Tables" box got checked automatically.
Help text for this options states:
"If you intend to save the package created by the wizard and customize the import or export of data by adding transformations, you must leave this option unselected.
So I guess they are not stored in a user identifiable method.
When I created a similar package and unselected the option, all the tables were there where I expected them.
January 11, 2012 at 2:17 pm
Check out the various properties of the Transfer task - that is where the tables will be specified. It might not be doing a truncate - rather a delete/recreate (I don't use transfer objects much).
--edit, fix typo.
January 11, 2012 at 2:37 pm
Transfer Task is where I would expect it, but I don't see much understandable info in there.
January 11, 2012 at 2:40 pm
Somewhere in there (I don't have SSIS in front of me), there is a list of objects to transfer - you just have to expand a few properties. Keep looking!
March 2, 2012 at 1:25 pm
Bump for solution added to original post.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply