//
archives

SSIS

This category contains 8 posts

SSIS 2016: Empty toolbox?

I recently upgraded several SSIS packages from VS2010 (SSIS 2008R2) to VS2015 (SSIS 2016). After the initial upgrade\conversion when I opened the package(s) I noticed that the Toolbox pane was empty, displaying a “There are no usable controls in this group.  Drag an item onto this text to add it to the toolbox.”.  What???  Where … Continue reading

SSIS – Display Variable Value in a Script Task

Sooner or later, you will need to debug the variable values in your SSIS package when something is not working as expected. With SSIS you have many choices when it comes to debugging your variables, breakpoints, stepping over, stepping in, the local or watch windows, etc. However sometimes you just want a quick and simple … Continue reading

SSIS: OleDB Data source: cannot retrieve the column code page info from the OLE DB provider

  When i tried to set an Informix data source in a SSIS package, the following warning was shown when the clicked preview button. Warning at {Local Component ID} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the “DefaultCodePage” property, the code page … Continue reading

SSIS with Informix\Oracle Oledb connection not working when a config file is included

I am running a SSIS package which has an Informix OLEDB Connection(32 bit). When I run from the Debug mode without the configuration file, the task completes successfully. But when I include the Informix OLEDB Connection in the config file and try to run the package, it fails with the following error. An OLE DB … Continue reading