Using a filtered query that returns one record and you know works in fox, such as "select field1 from package where packageid = 123", work with it manually in Query Analyzer...

Ah such a simple thing.  Thanks!  At first I wasn't sure, but I can custom-write the datatable build and leave it outside the utility sp.  For that, this will work...

Hrm.  the _agg version is not something I was familiar with.  Thanks

/hijack off

BCP is the fastest way to get the data from a file into SQL.  Although DTS can be pretty fast also, it is bad about giving inspecific errors and failing...

After testing, BCP is fast (no suprise there), and it does give the error log nicely.  I'll likely use it over DTS (it has it's uses but oof I can't...

Won't BCP only record single constraint violations?  I've only used it once, and just did a simple dump OUT.  I should read up on it.

Thanks

Neato

Ah ok i understand now.  Yeah the article unique id would be the only way i'd know to do it.  Not that there isnt another one... i constantly see things...

Sorry I don't know a good answer (all i would know to do is turn it into something that could be grouped/distinct by), but i do have a curiosity question.

Why...

Don't mean to mislead. there is no 'exec into' specifically, just the

insert into x

Exec Into requires that a table structure be there.  It can't create it on its own.

The execute(string) statement cannot see any variable declarations except those declared inside the exec string itself. try using SP_ExecuteSQL.  As long as you don't have enormously long string executes it...

By 'was populated' dont you mean that it was originally loaded with data from that source?  the TextData field in a profiler trace result I think would apply to the...

Considering the environment, I would think it is something else other than what I am about to suggest-  but I thought i'd throw it out there anyway.

In ISQL when selecting...

Depending on how often you need it ran, you can also just schedule it as a job to run every minute. Since jobs won't start if they are already...