April 3, 2007 at 4:08 am
Hi everybody!
may be you can help me: I've done a dts package that load an excel file into a table on my workstation (for a local server). the problem is that i've moved this package on server, changed all the linked connection but, when i check it in the transform data task to see the preview of the source file i don't see anything of a column of datetime data. the excel file is complex and there about ten lines of header so the datetime column begin after a few lines.
thank you in advance and sorry for my english..
April 3, 2007 at 8:28 am
Are there not headers in your test files on your workstation?
Headers cause problems in DTS. If there's a way to remove them, I'd do that.
Or load the entire file into a staging table with one wide column. Then delete those rows and transform them with T-SQL into another table.
April 3, 2007 at 9:00 am
there are header also on my test file on workstation.... i've solved changing the modifying the extend properties of excel connection and setting IMEX=1
the problem is that on my pc the field is loaded as a datetime, on server i've to do an extra operation, but now (and i don't know for how long.....) it works
ciao!
Luciano
mater semper certa est, pater numquam!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply