Category Archives: SSIS

SSIS – how to find if Attunity 32 bit 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 […]

SSIS

SSIS Oracle Error Solution: ORA-01406: fetched column value was truncated

I was modifying an SSIS package in which I was fetching data from Oracle source using Attunity. The query was complex and using multiple CTEs to fetch data. As soon as I added new query in Oracle Source and remapped the columns in the destination object, everything looked good at design time but when I […]

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 […]

SSIS

Execute Package Task fails even though the package executed successfully

We have parent and child SSIS packages. Both the packages were using environment variable configuration and sql configuration to get the further configuration property. Sql authentication and package protection level is set to “EncryptSensitiveWithUserKey” for parent and child packages. Both the packages run as expected in development environment. When we moved packages to QA, even […]


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

Attunity driver for extracting data from Oracle is faster but if you are extracting millions of rows from Oracle and you think it is slower than anticipated, make sure you change the following advanced settings Right click on Oracle Data Source and click on “Show Advanced Editor…”. Go to “Component Properties” tab and under “Custom […]



Stop DTS Package Execution Conditionally Without Failure

There is no straight way in DTS to stop the package on a certain condition without having it fail. Suppose in DTS package is suppose to be executed everyday at 8:00AM. This package is looking for a file c:\abc.txt. If the file has not arrived, it should gracefully stop without reporting any error. If the […]

SSIS