SSIS Row Count error

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.

Yitzhak Khabinsky 25,026 Reputation points

2022-12-01T20:43:09.987+00:00
@Максим Ибрянов ,

It is not clear what you are asking.

The Row Count Transformation in SSIS is used to count the rows as they pass through a data flow and store the final count in a variable. How is this related to the Execute SQL Task?

The T-SQL statement is cut off: INSERT INTO stage.LoadingLog
ZoeHui-MSFT 33,126 Reputation points

2022-12-02T01:43:08.797+00:00

Hi @Максим Ибрянов ,

Please give more information about your package. What do you want to do with the Execute SQL Task and where are you using RowCount transformation.
Максим Ибрянов 6 Reputation points

2022-12-02T04:16:51.257+00:00

I want load data from source DB in target DB.

Using RowCount transformation in DataFLow

2 answers

Максим Ибрянов 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 DB

Control FLOW
Please sign in to rate this answer.
Yitzhak Khabinsky 25,026 Reputation points

2022-12-02T13:55:43.56+00:00

@Максим Ибрянов ,

Please copy content of this "Answer", which is not an answer, to the original question and delete it after that.

We need your SSIS Execute SQL Task screen shots, especially Parameter Mapping tab.

Максим Ибрянов 6 Reputation points

2022-12-03T07:05:34.333+00:00

Here
Sign in to comment
Максим Ибрянов 6 Reputation points

2022-12-04T15:05:25.1+00:00

Any can help me?
Please sign in to rate this answer.
ZoeHui-MSFT 33,126 Reputation points

2022-12-05T01:16:28.967+00:00

Hi @Максим Ибрянов ,

There are three parameters in the execute sql task, but in the code, you are only using one parameter, please have a double check.

INSERT INTO stage.LoadingLog (mf_source_system_code, mf_target_system_code, mf_count_rows_income) VALUES (N'a', N'a',?)

Максим Ибрянов 6 Reputation points

2022-12-05T11:47:34.197+00:00

OK..set up 3 parameters

INSERT INTO stage.LoadingLog
(mf_source_system_code, mf_target_system_code, mf_count_rows_income)
VALUES (?,?,?)

And error

ZoeHui-MSFT 33,126 Reputation points

2022-12-07T02:24:36.31+00:00

Hi @Максим Ибрянов ,
From my local test, it works well. Please make sure the result set is none and the variables datatype map with the column datatype in table.
Sign in to comment