-
DTS: problem with converting into DATETIME
Using the import facility of the DTS I need to convert
a character field representing a date of format yyyymmdd
into DATETIME. Within the DTS package I`ve tried to add
a SQL step (SET DATEFORMAT YMD) before the transformation
step but this doesn`t help. Do you know a general solution
without converting each DATETIME field of the VBA script?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|