I have source systems that have timestamps (not datetime fields) and binaries. I created views that convert the timestamps and binaries to integers to enable DI to "see" the columns and load them. that's fine.
I am trying to use bulk loader now for a half a dozen tables out of 60+ tables to speed along updates. But the error message I get with these binary/timestamp fields is that bcp does not support them . HOWEVER, using SSIS and bcp directly via SQL Server 2005 rather than through DI works fine. Any suggestions?