I tried this in both ways...
First: I created all the steps till before creation of FOREACH Loop...
I get an error of following kind...
"[OLE DB Destination [102]] Error: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.
Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "The statement has been terminated.".
An OLE DB record is available.
Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "Cannot insert the value NULL into column 'AuthorID', table 'MySampleDB.dbo.Author'; column does not allow nulls. INSERT fails.". "
The reason being... The Author table have IDENTITY PRIMARY Column "AuthorId" and the "author1.txt" have data mapped to other 2 columns. (i.e. lastname and firstname)
Does anyone who followed the steps of this article expericed this?? And did anyone got any work around, solution?
I will appreciate if someone can share it to me as I am curious.
My email is deepak.kolapkar@gmail.com
Thanks in advance
Deepak
I tried this in both ways...
First: I created all the steps till before creation of FOREACH Loop...
I get an error of following kind...
"[OLE DB Destination [102]] Error: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.
Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "The statement has been terminated.".
An OLE DB record is available.
Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "Cannot insert the value NULL into column 'AuthorID', table 'MySampleDB.dbo.Author'; column does not allow nulls. INSERT fails.". "
The reason being... The Author table have IDENTITY PRIMARY Column "AuthorId" and the "author1.txt" have data mapped to other 2 columns. (i.e. lastname and firstname)
Does anyone who followed the steps of this article expericed this?? And did anyone got any work around, solution?
I will appreciate if someone can share it to me as I am curious.
My email is deepak.kolapkar@gmail.com
Thanks in advance
Deepak
read more | 1 comment
Reply