Yeah I did know we can do that but was hoping to understand more about why it is happening because some records are null and some are the blank space...

yeah select cast(col as varchar(128)) as column_name in this case.

The target is also SQL Server. This occurs when preview the source as well.

Hi Jeff,

Thank you for your comment. While this gave us an alternative, it didn't solve the problem we had. We know how to do that but the main reason we...

This is exactly what I realized yesterday just before I left work for the day. I was thinking it was looking for the environment id not for the package but...