Recently, while working on SSIS package, we encountered the error after few minutes of execution of package. To get rid of this issue, we implemented one workaround: Go to Data Flow --> Properties Decrease the default buffer size to 1MB i.e. 1048576 Bytes Decrease the default Max Buffer rows to 1000 as shown below: After … Continue reading SSIS: The component returned a failure code when the pipeline engine called PrimeOutput()

Recently, while working on one of the existing SSIS package, we found that there were number of sort blocks in SSIS where as it could have been sorted at the source itself and informing the SSIS package that the data is already sorted at the source and can be processed further. Another disadvantage of using … Continue reading SSIS: The column with the sortkeyposition value of 1 is not valid. It should be 0

Yes, SQL is not case sensitive but SSIS is. Recently we came across an issue which was very difficult to trace and find the root cause. The requirement was to update the sales data for each product. The logic was working fine for all the records and data was getting updated properly except for couple of … Continue reading SSIS is Case Sensitive