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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-04-22 : 21:45:30
|
| Please give me your valuable suggestions for the below sceniaro.We will get a flatfiles every day which i need to export the data into sqlserver 2000.The flat files which may contains more than 350 columns some of columns data may be nulls.What is the best way to address the above scenario.1.DTS2.BCP3.Stored Procedure. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-22 : 22:14:58
|
For simple text file either one of the below will be able to do the job- DTS- BCP- Bulk Insert
KH |
 |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-23 : 10:53:26
|
| Few questions. Are the files all the same structure? Are they going to be the same name? Is the process going to be a manual one? |
|
|
|
|
|
|
Dataimport sqlserver 2000