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. 

nullreferenceexception was unhandled in ASP.Net or C#

Hi Folks,
I got the below error

nullreferenceexception was unhandled

And I browsed so much for the solution....finally i understood that all I had to do was check the connectionstring name

i,e i had
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CCDBRegistrationString"].ConnectionString);

while the correct connection string name was

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CCDBConnectionString"].ConnectionString);

Cannot insert the value NULL into column 'id'? ASP.Net

Hi Folks,
If you get the below error while being a fresher in ASP.net ...

Cannot insert the value NULL into column 'id'?

Then please add identity property to your primary key

[ID] [int] Not NULL IDENTITY(1,1),

check the below link for more clarification

http://stackoverflow.com/questions/10013313/why-is-sql-server-throwing-this-error-cannot-insert-the-value-null-into-column

Add 2 labels to a bar chart or stacked chart in SSRS or add a label at the middle in the Bar chart

Hi Folks!

As soon as I came to office, I got a call from my collegue to make some changes to the allready existing report. 1 such change was to add a data label at the center of the bar chart. I performed the below steps to make it work. Enjoy charting !!!


https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be

https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be

Connect to SAP source and Destination from SSIS

To connect to SAP Source and destination you will first need to download Microsoft SQL server 2008 Service Pack 2 Feature Pack from the below link

http://www.microsoft.com/en-in/download/details.aspx?id=6375

Click on Download and try to download SAP related file only (to avoid time consumption). Later run this file. After installing, open SSIS project in BIDS. Click on Tools> Choose Toolbar options and then under SSIS data flow objects you will find SAP BI destination and SAP BI Source. You can now proceed to connect to. You will also fine the SAP BI connection manager in the Connection manager window in SSIS.