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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-10 : 12:30:53
|
| Sheila writes "I have not worked in SQL server for several years. have been in a refresh mode. My experience prior was nothing in depth when I did work with it. I have built a db and need to import data from a text file. The data for many dates in the text field are coming over as 72803, 112633, - there are no slashes. The file is a csv, delimiters "" and these so called dates are numbers, there are no delimiters around them. There are several date fields in each of 8 files that are being imported. The data will need to be deleted and reloaded each month. I have the dts package setup and am now trying to decide whether to transform the data on import, or run updates to fields once it is in, or load and then move to new tables with the date. Can someone help me with the transformation. Getting the text file changed from the legacy system is not an option at this point. I'm assuming I need a global so that it can be used in multiple places. Obviously the len makes a difference as well as dates =< 49 thinks it is 1949 instead of 2049. I'm struggling in the transformation. I'd appreciate any help/advice. Thanks." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-10 : 15:46:10
|
| I suggest you load the data in to a stage table and the use sql to store your transformationsjust bcp the data inDTS will be much slower and less flexibleMy Own OpinionMOOBrett8-) |
 |
|
|
|
|
|
DTS - import from text file, number field to date field