Execute SQL task fails

Question

Execute SQL task fails

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

gtschech Ten Centuries Points: 1351 More actions · Answer 1

Can you give us the exact error message?

Does SSIS complain or SQL Server?

If the latter is true, you may want to start SQL Profiler on your target database and see if a query comes in and how it looks like. Then just pick the query and try it in SQL Management Studio.

WM_JUSTMY2CENTS

Guenter

anuya_pitake Old Hand Points: 315 More actions · Answer 2

I am getting the error as follows:

"Either the input parameters or Resultset is not set correctly".

I am not able to understand where the error is.

-Anuya

gtschech Ten Centuries Points: 1351 More actions · Answer 3

Have you tried running the package with the SQL Profilter active? This often gives you a hint where the problem lies (e.g. misspelling of a SQL keyword).

vineet_ SSC-Addicted Points: 475 More actions · Answer 4

The best way to use Execute SQL task is to have the SQL statement as an expression.

Whatever parameters you want to pass should be declared as user variables.

In the execute sql task editor, open the Property Expressions Editor.

Chose the property of "SQLStatementSource" to be configured.

Open the expression builder and enter the query in the expression--

Example:

"SELECT * FROM EMP where ENAME = '"+ @[User::EmpName]+"'"

Here EmpName is a user variable of String Type.

Using Property Expressions work with any type of connection.

------------------
Why not ?