| Author |
Topic |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-04-27 : 12:40:22
|
| I am trying to run this pakage and it stops but does not show any error message. But when I parse the query it gives me the message:The query failed to parse. Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command. This is what we have been using for every month and now its not working |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 15:04:53
|
| did something changed in source recently?Which is task where this is happening? Is it execute sql or oledb source? Also is query direct input or from a variable?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-27 : 16:14:34
|
| No actually I did not have access to the Prod so I created a separate connection on the environment where I had access to. Then this error takes place I don't know where. The first two SQL Task run correctly and then it says package execution completed. But then when I change anything on the variable, it moves on to the next SQL task and has an error on that. MeaningThis is the expression first @var_cnt_RO_Sc>0but when I change it to @var_cnt_RO_Sc==0 then it moves on to my other variable and it fails there with this error[Execute SQL Task] Error: Executing the query "SELECT COUNT([*]) AS Cnt_ROFROM db..." failed with the following error: "Invalid column name '*'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.If that helps!!Let me know what other info is necessary coz you have helped me previously as well:) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:17:39
|
| the statement itself is not correct . it should be SELECT COUNT(*) AS Cnt_ROFROM db...no need of [] around *also where are you using expression @var_cnt_RO_Sc>0?is it in precedence constraints?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-27 : 16:21:40
|
| Yes in the precedence constraint |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-27 : 16:25:48
|
| Yes and I made that change on the SQL task component but it still does not go to the next one and with green colors on the task it displays the message of package completed but when I check the table there are no rows affected with this package |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:26:17
|
| check before that step whether the variable is correctly getting populated with expected value as per your logic------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-27 : 16:28:18
|
| No it is not |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:31:17
|
| then thats the issue. Check the step which populates it and see why its not getting correct value. You can add breakpoints to check intermediate steps and include variables in watch window to see how value changes during execution.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-27 : 16:42:18
|
| ok when I am doing that the the breakpoint there is a message that displays preexecute breakpoints. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-28 : 19:05:13
|
| hmm...didnt get thatwhat message you're getting?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Package stops and no error message