Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dev1978
Starting Member
2 Posts |
 Posted - 2011-09-20 : 04:57:28
|
| I am using the import export wizard to transfer the data between databases, but my requirement is that i want to use the query option to define the data to transfer.I write the following query.SELECT * fROM TABLE1 WHERE TABLE1.COL1=1;SELECT * fROM TABLE2 WHERE TABLE2.COL2=1;After writing this when i click the next it only shows query 1 to map with table what about the other query how to map it to table2 do i have to export separately first to TABLE1 then TABLE2 or i can use the same.How to do this please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 05:52:51
|
| you need to add seperate export/import packages for that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dev1978
Starting Member
2 Posts |
Posted - 2011-09-20 : 10:06:34
|
| Thanks for the reply.You mean to say that i need to create 1 package for each select if i have to transfer 4 tables then i will create 4 packages each with the selection of records.But i have 3 locations so 3 * 4 = 12 packages i will create.Please need your help in this.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 10:54:12
|
| why not create a SSIS package itself rather than going for export/import wizard. you will just need a data flow task with four OLEDB sources and four OLEDB destinations connected in parallel. i dont know how you're planning to iterate for locations though. perhaps a for each loop might be of help------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL Server 2008 Import / Export