September 4, 2008 at 1:23 pm
I used SSIS Import and Export Wizard to import 30 tables from one database to another database. It created a very nice package for me but I could not see any code. How can I see the codes so I know if I get all the tables?
September 4, 2008 at 1:40 pm
I am not sure how you are viewing the package...My suggestion would be to , go to BIDS and create a new package, this will create a new solution file and created default package named package.dtsx. I would go there and right click and select ->add existing package, add your package. If you really want to see the code, menu - > view -> code.
You can query sys.tables to compare the table count.
VG
September 4, 2008 at 2:42 pm
After I used the wizard to create the import, it gave me a nice picture of a lot of execute SQL tasks. But when I clicked on those tasks, I could see the file connection with a name but no query behind them. When I executed the package, all those tasks pointing to different temp files.
September 4, 2008 at 3:04 pm
HI Loner,
what I understood is data is copied to different tables.
Here you can test:
1. In import- export wizard, in one of the step wizard you can select destination (try for one table) and edit mappting and see the destination table name, and it has some more options like you want to append or delete and insert, enable identity insert etc..
2. After opening package in BIDS, you click one of the data flow task, check source and destination and check the mapping between source and destination (Including destination table).
to make sure, source is mapping to destinatiopn table you wanted.
There are no SQL commands, since it is one to one transfomration.Connection string is to connect to server and database , it uses same connection for all of your tables.
VG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply