Any can help me?
SSIS Row Count error
Максим Ибрянов
6
Reputation points
Hi everybody.
Can you pls help me?
I have error when using RowCount transformation
[Execute SQL Task] Error: Executing the query "INSERT INTO stage.LoadingLog
..." failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
2 answers
Sort by: Newest
-
-
Максим Ибрянов 6 Reputation points
2022-12-02T04:15:35.387+00:00 SQL task
INSERT INTO stage.LoadingLog
(mf_source_system_code, mf_target_system_code, mf_count_rows_income)
VALUES (N'a', N'a',?)All picture
DATAFLOW
1.Load data from another DB
2.Block of Row Count
3.Load into target DBControl FLOW