Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 781
  • Last Modified:

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
0
Amanda Walshaw
Asked:
Amanda Walshaw
1 Solution
 
Larissa TCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now