July 6, 2005 at 6:52 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:19 am
See here
http://support.microsoft.com/default.aspx?scid=kb;en-us;236605
Far away is close at hand in the images of elsewhere.
Anon.
July 7, 2005 at 7:43 am
http://support.microsoft.com/kb/194124/EN-US/
If the package is pure DTS then right-click the package menu item - select Disconnected Edit...
expand the Connections
Expand the Excel Connection and view the Extended Properties entry
In the Value Property add ;IMEX=1 to the end of the connection string
This is an IMport EXport mode setting to allow mixed values.
Hope this helps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply