Post reply

DTS Problem

  • July 6, 2005 at 6:50 am

    #69297

    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 6:56 am

    #571202

    Please do not cross-post, we monitor all boards.

    Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=197371

  • July 6, 2005 at 7:19 am

    #571215

    that is necessary as a person who knows answer to my question may not login the proper forum

    he may not see my question, to increase the chance of getting the answer i need to post in some more groups

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2005 at 7:21 am

    #571219

    No you don't this is a dts question and it's gonna be posted in the dts section in tomorrow's newsletter.

  • July 6, 2005 at 7:23 am

    #571221

    Still, that is not reason enough to cross-post. Please post questions in one forum only, else all forums would soon be full of duplicates of the same question. Worse is that answers also would be spread over several different threads, making it very difficult for others to benefit from the discussions.

    /Kenneth

  • July 6, 2005 at 7:24 am

    #571222

    Anyways his question has already been answered .

  • July 6, 2005 at 7:33 am

    #571225

    Are you sure it's a 'him'?

    Only kidding ladies

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 6, 2005 at 7:38 am

    #571228

    I'm sure untill he corrects me .

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply