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 |
|
chilluk
Starting Member
24 Posts |
 Posted - 2002-08-16 : 08:50:37
|
| I want to convert from DTS import to Bulk Insert to pull in some raw text data - because I'm told it's faster and much more efficient? When I try it, I get errors concerning date fields (type mismatch) - I presume that this is because the date format in the data is d/mm/yy and SQL server Bulk Insert doesn't like that? Is there a way to tell it which date format to use (I tried creating a DTS Bulk Insert package with a format file). The existing DTS package copes fine with the raw data.Am I assuming the problem correctly? Please help...Chris Hillchris@softwarefirst.com |
|
|
|
|
|
BULK INSERT and Dates