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 |
|
daviddeldave
Starting Member
28 Posts |
 Posted - 2003-06-02 : 07:52:26
|
| Importing a text field in Paradox. The data looks something like 20030502 which is to be imported into a sql server table field whose data type is datetime. The problem is I have lots of fields in this format I want to import.I am doing this using the DTS Designer and when I right click on the line mapping the two fields and go to the transformations tab, specify the source and destination details for datetime mapping I want this format saved so that I do not have to specify the details for each field.Hope this makes senseDavidDavid Mercer |
|
|
|
|
|
Saving in a format in "Create New Transformation"