July 6, 2005 at 7:05 am
iam using dts for fileuploads,
an excel file is used for uploads
all the columns in xcel are set to property as text
each and every column in excel is mapped to a particular table columns, and this way data is transfered from excel to a table in sql-server
date format in xcel is ->"04072005 "
04 being the day
07 being the month
2005 being the year
and in map script it is written
DTSDestination("book_dt") = mid(DTSSource("pkup_dt"),5,4)+"-"+mid(DTSSource("pkup_dt"),3,2)+"-"+mid(DTSSource("pkup_dt"),1,2)
but when i import an excel file, some columns get inserted as null in the table, even when they have date values
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
July 6, 2005 at 7:15 am
Please do not triple-cross-post, we monitor all boards.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=197371
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply