HomeSQLServerPedia SyndicationSSIS: Execute SQL task vs Execute T-SQL Statement task

Comments

SSIS: Execute SQL task vs Execute T-SQL Statement task — 15 Comments

  1. I love your blog. I am trying Execute ssis package(32 bit) using t-sql or sql job on 64 bit.i am getting error on that.could you help me out in this…

  2. Yesterday, I had started with SSIS 2012, was thinking what’s the difference between these two tasks.. Thanks for bringing this post.

  3. The error is
    ” Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:43:57 AM Error: 2012-11-09 08:43:57.89 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in specified state.”. You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-11-09 08:43:57.90 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in specified state.”. You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-11-09 08:44:00.01 Code: 0xC0202009 Source: iNovahTestQARefresh Connection manager “SourceConnectionOLEDB” Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80040E4D Description: “Login failed for user ‘saqa’.”. End Error Error: 2012-11-09 08:44:00.02 Code: 0xC020801C Source: Data Flow Task 1 Source – Account [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “SourceConnectionOLEDB” failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-11-09 08:44:00.02 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component “Source – Account” (1) failed validation and returned error code 0xC020801C. End Error Error: 2012-11-09 08:44:00.02 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-11-09 08:44:00.03 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:43:57 AM Finished: 8:44:00 AM Elapsed: 2.687 seconds. The package execution failed. The step failed.

    I manually i change the user name and pwd in sql server job pro…

  4. Pingback:How To Fix Dts:password With Error 0x8009000b Errors - Windows Vista, Windows 7 & 8

  5. I am trying to input query through program for execute SQL task, so that i can keep the block diagram same and change only query through txt file input. But I afraid, how to make this happen? Can you please help me related to same?

    Best Regards,
    Vaibhav

  6. Pingback:Fix T-sql Execute Error Windows XP, Vista, 7, 8 [Solved]

  7. Is this “Execute T-SQL Statement task supports only ADO.NET.” correct?
    I have used OLEDB for T-sql statemnet task

  8. I have the following issue when using execute sql task in SQL 2012 on Windows Server 2012. Anyone has seen this before and how to fix it?

    Mixed mode assembly is built against version ‘v2.0.50727’ of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

  9. Pingback:SSIS: Execute T-SQL Statement Task vs Execute SQL Task – My Blog

  10. Pingback:▷【 SSIS: ejecutar la tarea de instrucción T-SQL frente a ejecutar la tarea SQL 】

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>