SSiS integration Package - Execute the SQL Task

SSIS package "Package.dtsx" starting.
Error: 0xC002F210 at exec mydatabse parepare starschema, Execute SQL Task: Executing the query "EXEC dbo.procube_prepare_starschema" failed with the following error: "Login failed for user 'mylogin.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: exec procube parepare starschema
SSIS package "Package.dtsx" finished: Success


umm where do you set the logon for execute sql task in control flow on ssis for 2008.

my mind has gone blank
Amanda WalshawBusiness Solutions AnalsystAsked:
Who is Participating?
 
Lara FEACommented:
Your execute SQL task has connection property. When you add execute sql task - you must defile on what connection it will be executed. In connection object you can edit login etc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.