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 |
|
carthik_s
Starting Member
34 Posts |
 Posted - 2006-10-31 : 12:20:05
|
| I am trying to import data from a txt file onto a table via DTS transformation.For a particular field, I am doing a DateType string(MM/dd/yyyy) transformation. The corresponding column on the table is of smalldatetime type. The transformation job runs fine until it encounters spaces for this field. When it tries to load spaces to that column, it is giving an error message as below:-Invalid Date FormatThe column can contain nulls. Any pointers to the issue?Thanks in advance,Karthik |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-31 : 13:50:26
|
| before importing, writeSET DATEFORMAT MDYPeter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
DateTimestamp --> Null