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 |
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-10-03 : 11:09:19
|
[code]Hi all,I have a spread Excel Sheet with Three (3) Sheets. 1st: has all Customers2nd: rows refers to customers on 1st sheet3rd: rows refers to customers on 1st sheet===> One-to-many One-to-Many |Sheet2| --------------> |Sheet1| <------------- |Sheet3|===>I need to Export all data to SQL Server 2008. I'm willing to create tables with respect to referential integrity.I'm thinking to export one by one but I thought maybe a better way to do it.What are some suggestions please for this process?[/code]--------------------------Joins are what RDBMS's do for a living |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-03 : 12:04:14
|
you've to thos one by onefirst one to start is sheet1then do others which can be done in parallel after adding lookup to first table created------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-10-03 : 13:40:04
|
OK, sounds good. Visakh! thanks man a lot.I'm planning on using just an export/import wizard to do.would this be better done using an SSIS package. IF so, please, list the possible tasks to be used.Thanks.--------------------------Joins are what RDBMS's do for a living |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-03 : 14:06:25
|
yep..you can add ssis taskfirst task would be a data flow task for exporting data from sheet1 with excel source and oledb destinationit has to then followed by another data flow task which has two parallel data flows one from each of other sheets to destination tables. the first data flow is connected to second by means of an onsuccess precedence constraint------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-10-03 : 14:29:53
|
thank you visakh a lot. Appreicated.--------------------------Joins are what RDBMS's do for a living |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-03 : 14:40:54
|
welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|