Hi all, I saw this post a while back and thought I would post for others what I found to help... I was having the same problem (blank char/varchar fields) - unfortunately using a linked server wasn't an option for me as you can't use 32bit drivers (like the old ODBC driver) for linked servers on 64bit SQL Server.
I found a work around at the link below, basically to summarise - on your data source, set the error output for each problem column to be 'redirect row'. Then add a multicast to your dataflow and connect your error output (red arrow) to the multicast (you will get a warning if you don't handle the errors). http://www.sqlservercentral.com/Forums/Topic1254262-364-2.aspx http://www.sqlservercentral.com/Forums/Topic1254262-364-2.aspx A bit strange why this works, but it does. I didn't actually have any errors to be handled. Also I note text fields (as opposed to char/varchar) seem to migrate fine without needing the redirection option. -- View this message in context: http://firebird.1100200.n4.nabble.com/SSIS-ODBC-ISSUE-tp3497997p4524946.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
