FeatureClassToGeodatabase_conversion ArcGIS 10.1 Problem

[SimonWoodman]

I've just upgrade from ArcGIS 10 to 10.1 and I've run into a problem with some of my scripts. I'm using FeatureClassToGeodatabase_conversion to extract data from a non-spatial SQL Server table. The input I am using is a layer file using a "Definition Query" to limit the features that I create. This worked fine in 10.0, but in 10.1 it seems to be ignoring the definition query so I get the entire table. I've tried switching to FeatureClassToFeatureClass_conversion and that does the same, and when I try to use the where_class on that call I get the error "000339 : Input <value> does not have OIDs". Does anybody have any suggestions?

[StacyRendall1]

Have you tried running the tool within ArcMap or ArcCatalog with the definition query already loaded on the feature class? Maybe they changed it at 10.1 such that definition queries are not carried through for this kind of conversion.

Perhaps you can use MakeTableView_management with a selection query then CopyRows_management to circumvent your issue?