Post reply

loads empty rows

  • February 28, 2009 at 2:55 am

    #131474

    Hi,

    I suffer a strange issue, sometimes a package load empty rows.

    The number of rows returned by the OLEDB connection is correct but the

    content is empty.

    If I execute the package a second time I see the correct result!!!!

    my source database is in SQL 2005 and the query is really simple: select

    name, description from customers

    what is the problem????:hehe::hehe:

    Thanks.

    Diego.

  • March 2, 2009 at 2:06 am

    #951706

    What tools did you use for load data, Destination database tool/ script task ?

    Plz check

  • March 2, 2009 at 2:15 am

    #951709

    I used SQL SERVER Destination as destination

    and OLE DB Source with SQL Command as source

    what is the problem????

    Thanks.

    Diego.

  • March 2, 2009 at 2:38 am

    #951717

    Uhmmm,

    Try to use OLE DB destination as the destination,

    and donot check keep nulls

    😉

  • March 2, 2009 at 3:22 am

    #951728

    Thanks

    however, you are sure that this is the problem??

    is related to the destination?

    you give me an explanation

    Thanks

    Diego

  • March 4, 2009 at 4:49 am

    #953001

    :alien: :alien: :alien:

    Have you some other idea??

    Thank

    Diego

  • March 4, 2009 at 8:03 pm

    #953736

    well Diego,

    I have no idea about the reasonable of da empty rows problem, i just guide you another way to work.....

  • March 17, 2009 at 7:56 am

    #961036

    The error occurs in debug mode and in the sql server agent...

    I have not yet solved the problem.

    Have you any advice?? :crying:

    Thanks

    Diego

  • March 19, 2009 at 7:54 am

    #962707

    Moreover, the error occurs with ole db destination and sql server destination

    Thanks

    Diego

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

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