Tag: ssis

  • SSIS – How to Find If Attunity 32 Bits or 64 Bits Drivers Are Used

    Here is a simple flowchart to find out if the Attunity 32-bit or 64-bit drivers are going to be used when executing SSIS package. Please note that the answer does not depend on the if the database engine is 32-bit or 64-bit. Are you running SSIS from Visual Studio? If yes, then check if SSIS…


  • How to Fix: “MSORA” is not recognized as a valid connection manager type

    Error The connection type “MSORA” specified for connection manager “” is not recognized as a valid connection manager type. This is the most dreaded error while working with Oracle and Attunity and could not find why it would not work even after installing everything that is needed. Edit: Updated for Attunity 4.0 and 5.0 based…


  • The Value Violated the Integrity Constraints for the Column

    SSIS Package Error You are using SSIS package to load data into SQL table and suddenly you get the error “The value violated the integrity constraints for the column”. It does not give enough information of why the error occurred. Root Cause for Error SQL Server has following integrity constraints Primary Key Foreign Key Not…


  • Improve Attunity Driver Performance When Extracting Millions of Rows From Oracle

    If you are extracting data from Oracle, Attunity driver helps you extract it faster. But if you are extracting millions of rows from Oracle and you think it is slower than anticipated, here are few tips. These advanced tips will help you drastically improve the performance. Advanced Tips to Improve Performance Right click on Oracle…


  • How Cancelling the DTEXEC (or Any Other Executable) From Command Prompt/Automic UC4 Works

    When we start executing the SSIS package using DTEXEC from command prompt/Automic UC4, it creates an individual process DTEXEC which runs on its own. You can see that process in Task Manager. When you cancel the job from command prompt using Ctrl+C or cancel it  from Automic UC4, it sends the SIGINT (interruption) signal to…


  • Get DATETIME Value From msdb.dbo.sysjobhistory

    If you ever had to work with SQL Job Agent and find out the details about run time for the job/step, you would find it difficult to convert the INT into DATETIME. Here is the quick solution. To get the start date time, use msdb.dbo.agent_datetime function available in SQL Server 2005 onwards. If you are…