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 |
|
kimmie
Starting Member
7 Posts |
 Posted - 2004-08-25 : 13:12:29
|
| I'm copying an XLS file to a table, it's not a straight copy as fields from XLS will go to different fields in my table. However the table's date format needs to be mm/dd/yyyy and the date field in my XLS file is yyyy/mm/dd. I tried using the DateTimeString Transformation properties to convert the date but it failed. Is there a way I could put that in a VBScript with the rest of my copies? and if so ..how?tnx |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-25 : 15:37:59
|
| I would dts it to a staging table that looks exactly like the file and then use tsql to get it to it's final destinationIt's more expensive (because of the log) but I think it'll be faster because it doesn't have to transform every row on the way in...Brett8-) |
 |
|
|
kimmie
Starting Member
7 Posts |
Posted - 2004-08-26 : 08:32:19
|
| Thank you ..that's basically what I ended up doing. I found some scripts on sqldts.com that helped me with the date issue. I have 3 other files I need to bring over to a staging area now (1 of which also has date issues mm/dd/yy that need to be changed too), then I need to build a final table out of those 4 files with a 1 to many relationship. |
|
|
|
|
|
|
DateTime question