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 |
|
TokyoBrit
Starting Member
1 Post |
 Posted - 2009-09-24 : 05:49:28
|
| Not sure if this is the right forum, but it is an import problem so maybe...Trying to import a fixed-length text file into a temporary table, and am using BCP to do it so I can run it as a batch job via Windows Scheduled Tasks.However, I've not been able to find out where I can specify how to handle the source data formats.Basically, the date is stored in the text file as YYYYMMDD, but if the destination table is set to datetime, the BCP utility generates an error.Is there a way to specify in the XML format file to change YYYYMMDD into YYYY/MM/DD prior to importing?If the answers no, is there a way to do this without having to write a seperate import program or reams of T-SQL?Thanks for taking the time. |
|
|
|
|
|
BCP Solution?