Skip to Content
0
Former Member
Jul 24, 2008 at 05:03 AM

SQL Server, bcp, binaries/timestamps - not supported in DI?

34 Views

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?