I have a strange issue while I am deploying a package to one of the environment server.
I have 2 XML Source, in the DataFlow, and one will extracted based on a value of variable that is passed from run time (package is executed from a Job) and other will be extracted all time.
The next Step I have is a Execute SQL Task in ControlFlow wihich will execute after DataFlow. This has 2 input parameters and some SQL query that uses the param. Now this one fail on the target environment with below error:
failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I got the error when I did a SSIS Text File Log.
If I run the package in BIDS with the same XML files it work.
Also when I deploy the package to my Dev Server it works.
When I compare the Dev DB with the target environment DB - Both are same.
The Service Acount has permission - as I can see the DataFlow task completed.
Another Point: The XML Load Data Flow that executes based on the Variable Value does not execute on target environment, even if the value is passed as "True" (It is Boolean Type) But this variable is NOT an input for the Execute SQL task that fails.
I am not sure w
View Complete Post