Windows 10: Boolean Value Change in OLEDB Source of SSIS Data Flow in SSIS

Before and after the last deployment of our SSIS packages into Integration Services Catalog, Boolean values coming from an OLEDB Source SQL Query changed. Earlier we were getting True & False but post-deployment we have noticed we are getting 0 & 1, which we had to cast again to fix it. Is this a known behavior? What are general recommendations to avoid this?

:)

 

OLEDB DB2 Version 6.0

Hello. Does anyone know if SSIS Projects need to be re-compiled after installing OLEDB DB2 Version 6 if they are currently compiled using OLEDB DB2 Version 5? Our newest SSIS Projects are developed on a machine using 6, but will be deployed on a machine
using 5. Is that a problem?

Thanks.

 

SSIS Migration

Hi,

I am a newbie in SSIS development. In my project SSIS packages are developed in 2008 edition but now they want to move forward. But, for all our packages we are using ORACLEBULKLOADER connecter. Can some one please tell me how to move to newer version of setup
without disturbing all packages and how to include this third party connection manager in configuration file?

 

SSIS Job Fails with unexpected termination on Execute of Data Flow Task

Hi,



Thank you for writing to Microsoft Community Forums.



I appreciate the efforts taken by you in resolving the issue. I understand that SSIS Job fails with unexpected termination.



We do have a dedicated forum for developers, where you can directly get in touch with the developers around the world who will be able to assist you with the appropriate troubleshooting steps, let me point you in the right direction. I would suggest
you to post your query in MSDN forums.



I hope your query gets resolved at the earliest.



Regards,

Nikhar Khare

Microsoft Community - Moderator