<div>
<div class="content wysiwyg-content">
SSIS package &quot;Package.dtsx&quot; starting.<br />
Error: 0xC002F210 at exec mydatabse parepare starschema, Execute SQL Task: Executing the query &quot;EXEC dbo.procube_prepare_starsc<wbr />hema&quot; failed with the following error: &quot;Login failed for user 'mylogin.&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly.<br />
Task failed: exec procube parepare starschema<br />
SSIS package &quot;Package.dtsx&quot; finished: Success<br />
<br />
<br />
umm where do you set the logon for execute sql task in control flow on ssis for 2008.<br />
<br />
my mind has gone blank
</div>
</div>


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

SSiS integration Package  - Execute the SQL Task

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.