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 |
|
iphonelover
Starting Member
2 Posts |
 Posted - 2012-02-29 : 22:44:13
|
| Our company has made a new acquisition. You will be helping with the data conversion. They will be pulling out original owner data and convert into our system.How do you proceed?I have never worked on such project before. All the data I worked on are right there in front of me...quite simple. Now I am afraid to make mistakes. Could someone explain? your help is much appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
iphonelover
Starting Member
2 Posts |
Posted - 2012-02-29 : 23:07:07
|
| Thanks for your reply tkizer. Yes, bulk insert into staging table then conversion in T-SQL make sense. I know it looks like a homework but its actually a possible interview question. Which is more efficient at workplace? SSIS or Bulk insert? Would that be related to stored procedures? Thanks a lot! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Data conversion question