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 |
|
evanburen
Posting Yak Master
167 Posts |
 Posted - 2008-10-22 : 13:49:01
|
| I have to import a lot of flat text and .xls files into SQL Server. Since moving to version 2005, I've found this to be much more difficult because every anamoly with the data causes the import to fail often with little or reason why it failed. I never had this problem with version 2000 and often find myself importing my text files into version 2000 and then from there into 2005. Is there anything I can do to turn off this stricter import behavior under 2005 and make my life a lot easier? Thanks. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-22 : 14:22:48
|
| How are you importing in 2000? 2005 is real handy once you get a hang of it. |
 |
|
|
evanburen
Posting Yak Master
167 Posts |
Posted - 2008-10-22 : 14:48:23
|
| I usually just use the import data wizard with 2005. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-22 : 18:06:19
|
| Just give it a shot and you'll like it. This forum has lots of tips, tricks, and help when you get stuck. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-10-24 : 01:33:30
|
| One thing to always watch for, is the line delimiter on your txt files, make sure you set that correctly, specially if you import files from legacy or linux/unix systems.---http://www.ssisdude.blogspot.com/ |
|
|
|
|
|
|
Importing Data was easier with SQL Server 2000