DTS trying to import empty Excel rows.

[PNC]

Hi,

I'm trying to do an import from an excel file, but I get an error message saying that the destination field cannot be null at row 29, but row 29 is empty in my Excel file.

Why is DTS trying to import the empty rows from the file?

 

[TheJon]

Is there any data after row 29 in your excel file, (check rows and columns outside your expected range as well)?



[tt]|_ |_ _ | _ _
|, | )(/, |(_)| )
'[/tt]

 

[PNC]

No absolutely nothing!?!

I did the import using a query instead of the copy function, but I'm still curious as to why it didn't work.

 

[mercwrought]

As a test open your excel file and select the first blank row and all the rows after and delete them using the delete in the edit menu(do not just use the delete key). Then try to import them.

 

[JayKusch]

As another test ... cut and paste the needed 29 rows into another worksheet. The save the worksheet to another name and have your DTS package source connection point to this new test file. Try to execute the package and lets see if the import works.

Thanks

J. Kusch

 

[PNC]

1) I tried the Edit --> Delete, it did not work.

2) I created a new file, and copied the rows, that worked.

Thanks,
PNC.

 

[JayKusch]

Not sure what to tell you. Sounds like DTS found something in the rest of the 32,000+ rows below your good data. Can you work with the newly created file and forego using the bunk one?

Thanks

J. Kusch

 

[PNC]

From now on I will always create a new file, I think that's the best solution.

Thanks everyone.