Solved

SSiS integration Package  - Execute the SQL Task

Posted on 2011-03-24
1
736 Views
Last Modified: 2012-05-11
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
Comment
Question by:Amanda Walshaw
1 Comment
 
LVL 11

Accepted Solution

by:
Larissa T earned 500 total points
ID: 35206596
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question