loads empty rows

Question

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

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

PeterHmoodang SSC Enthusiast Points: 175 More actions · Answer 1

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

Plz check

diego.piccolboni Mr or Mrs. 500 Points: 508 More actions · Answer 2

I used SQL SERVER Destination as destination

and OLE DB Source with SQL Command as source

what is the problem????

Thanks.

Diego.

PeterHmoodang SSC Enthusiast Points: 175 More actions · Answer 3

Uhmmm,

Try to use OLE DB destination as the destination,

and donot check keep nulls

diego.piccolboni Mr or Mrs. 500 Points: 508 More actions · Answer 4

Thanks

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

is related to the destination?

you give me an explanation

Thanks

Diego

diego.piccolboni Mr or Mrs. 500 Points: 508 More actions · Answer 5

:alien: :alien: :alien:

Have you some other idea??

Thank

Diego

PeterHmoodang SSC Enthusiast Points: 175 More actions · Answer 6

well Diego,

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

diego.piccolboni Mr or Mrs. 500 Points: 508 More actions · Answer 7

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

diego.piccolboni Mr or Mrs. 500 Points: 508 More actions · Answer 8

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

Thanks

Diego

Cookies on SQLServerCentral