Convert decimal to string in derived column in ssis

ISNULL(ContractItemNumber) ? "NOT_PRESENT" : (DT_WSTR,50)ContractItemNumber


You can use the above expression to convert a column namely "ContractItemNumber" from decimal to string

Run the SSIS package again and again even after failure.

Hi Guys,

There was a requirement to run the SSIS package again and again even after failure. ( SAP connection should wait for infinite time). I was able to achieve this by setting the "For loop" task and "Data Flow Task" Event handler's "Propagate" variable to False. This I could achieve by following the steps in the below link.

http://gqbi.wordpress.com/2013/06/27/ssis-stopping-an-error-from-propagating-to-its-parent-enabling-an-ssis-package-to-continue-when-an-error-happens/



This could be achieved in another way (but I don't know if this is advisable)
Set the "ForceExecutonResukt" property of the SSIS package, For loop and Data Flow task to "Success" This also produces the same result.  

SSIS Package Execution Stops with SQLDUMPER.EXE Popup

Hi Guys,
I have set my package to run again and again by setting the "Propagate variable" value to "False" in eventhandler . But after this my package still failed due to Merger Join task. My package will show the SQLDUMPER.EXE Popup and then stop the execution. This does not serve my purpose of changing the Propagate variable.

This is how I resolved the issue,

My Merge Join inputs were sorted. But 1 of them had "Sort" from the data flow task while the other was sorted manually i,e its sorting property was set to True and the key was set to 1.
I removed this and added the "Sort" task in Data flow task. Bingo! This fixed the issue.

unable to load librfc32.dll ssis 2012 - SAP BW Connector

Hi,
I was getting the below error while I was first time trying to configure SAP BW connector in my SSIS 2012. To resolve this issue, I downloaded linrfc.32dll and place it in "C:\Windows\syswow64" folder.