Copying Table - Empty Rows

Discussion created by shaun_weston-eagle-co-nz-esridist on Apr 19, 2012
Latest reply on Apr 21, 2012 by shaun_weston-eagle-co-nz-esridist
I'm having a very annoying issue when I try and copy a table from SQL Server to a file geodatabase. I'm using an ODBC connection to connect to a database in SQL Server, then using any of the table copy GP tools does not work properly and I get an empty table! However if I click Export from the table menu it does work and I get the table in a file geodatabase:


So I've tried Table to Table, Table Select, Copy Table and all of which return empty! I need to automate this, so doing it manually in ArcCatalog won't work.