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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2011-02-28 : 02:45:54
|
| Hi, I want to Extract(Export) 4 tables from SQL SERVER 2008 to a Flat File.All the four tables are related to each other (through PK & FK relationships).Tables are1. Type2. COA4. VoucherMaster5. VoucherDetailHow can i do that ? any help regarding this will be highly appreciated.Regards, |
|
|
latch
Yak Posting Veteran
62 Posts |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2011-03-01 : 07:02:50
|
| I wants to do it using SSIS |
 |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-03-01 : 09:25:49
|
| Hi,In a SSIS package: 1.Add a Data Flow Task, a.Take OLEDB source,make sure you select DATA Access mode as SQL Command then specify the Query using Joins or UNION ALL. b.Take flat file as destination.Map the columns respectively.For refer how to specify the query using Join or Union All have a look at: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115061Thanks,latch |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-03-01 : 09:33:22
|
| Why don't you go to the database in question right click and select export data, this will allow you to select the four tables and their destinationJust a quicker solution than creating an actual ssis package.If your wanting all the data together you can do the same as above poster has said using union or inner joins to link the tables together, and then use the export data option but use a query as the source instead of selecting the tables individually |
|
|
|
|
|
|
How to Extract Multiple tables using SSIS