April 16, 2014 at 8:01 am
I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.
But looking at the debug it never states that the componet "Update Records" was run and it never states that rows were updated. (also the data does not change)
So what could be wrong?
April 16, 2014 at 8:36 am
dwilliscp (4/16/2014)
I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.But looking at the debug it never states that the componet "Update Records" was run and it never states that rows were updated. (also the data does not change)
So what could be wrong?
Are you calling a stored procedure or an update statement with try/catch? That could suppress the error so it never reaches the package.
😎
April 16, 2014 at 11:25 am
Eirikur Eiriksson (4/16/2014)
dwilliscp (4/16/2014)
I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.But looking at the debug it never states that the componet "Update Records" was run and it never states that rows were updated. (also the data does not change)
So what could be wrong?
Are you calling a stored procedure or an update statement with try/catch? That could suppress the error so it never reaches the package.
😎
I am using a OLE DB Command, with SQL command. Valicate External Metadata = true. Default Code Page = 1252.
The command:
update zt_bor
set plant = ?
, Customer = ?
, Material = ?
, [SL No] = ?
,[Old RDD] = ?
,[New RDD] = ?
,[Order Qty] = ?
,[Prev Qty Confirmed] = ?
,[New Qty Confirmed] = ?
,[SU] = ?
,[DlBl] = ?
,[Created On] = ?
,[Old Load Date] = ?
,[New Load Date] = ?
,[MRP] = ?
,[Source Plant] = ?
,[CSR] = ?
,[TP Date] = ?
,[Stocking_Strategy] = ?
where Document = ? and Item = ?
April 16, 2014 at 11:39 am
I even created a new package.. with just one control in the "Control Flow", and that was the data flow task. I just put the New BOR Records (OLE DB Source) with the SQL Select command. Linked to the (OLE DB Command) Update BOR Records.
Still the same result. (so all the other work.. like splitting out the new rows.. were not created, and the other Contorl Flow events, like backing up the table... and deleting old rows.. were not added.)
I then decided to have it dump the data into a brand new table.. that it creates.. so I added a OLE DB Destination at the bottom. When it created the table, the data it placed in was the old zt_bor data NOT the data from the (OLE DB Source). What the heck?? How would the data from the table I am trying to update end up in the SSIS data?
April 16, 2014 at 11:54 am
What about the values passed in the where clause, a typical mistake would be mixing up the two parameters.
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply