February 10, 2004 at 11:05 am
Hey All,
I've imported Excel files into Sql Server with DTS several times before and never had this problem.
The sheet has about 6000 row of data.
It always fails right after the last row with the message: "The task reported failure on execution. The statement has been terminated. Cannot insert the value NULL into column BLAH, table dbo.BLAH; column does not allow nulls. INSERT fails."
Even if I have hard coded a value to avoid the null, or set the last row to 5999, or rigged the transformation step to do nothing and not even try and insert I still get this error not matter what.
Why am I getting this null value insert error when I'm not even inserting? How can I get DTS to behave and just stop at the last row like it usually does?
Thanks in advance, much appreciated -
Skål - jh
February 11, 2004 at 1:38 am
I've had the same problem previously. The following worked for me - open the excel file and delete all the rows below your data. Hope this helps.
February 11, 2004 at 4:42 am
Also, delete a bunch of the columns to the right of your data. Someone may have used a column to the right temporarily and then cleared the data, but Excel still lists those cells, and therefore that column, as in use.
If you look at the Transformations tab does it list a column that you weren't expecting? This is one indicator that it's a Column problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply