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… Read More »
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… Read More »
In SSIS, for fixed width flat file, new line character (CRLF) is NOT added at the end of the row. So when you run the package, all the rows are stored in one single line in the flat file. Prerequisite You need to add additional column to the fixed width flat file and name it… Read More »
Use the following expression in order to create a derived column By default Data Type of string “\r\n” is DT_WSTR so here I am casting the data type to DT_STR
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… Read More »
We have parent and child SSIS packages. Both the packages are using environment variable configuration to get the confuguration database and sql configuration to get the further configuration property. Both the packages have sql authentication and package protection level is “EncryptSensitiveWithUserKey”. Both the packages run as expected in development environment but when moved to QA,… Read More »
If you happen to get an error “The value violated the integrity constraints for the column”, it means that it tried to insert null value into the non nullable column in the database. If the source is table or in any other easily verifiable format, you can visually look at it. If the source is… Read More »
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… Read More »
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… Read More »
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… Read More »