Sounds like a good plan of action, although I wouldn't do it all in one go. I've been caught like that before.

One day: "Yes,...

Roger

You wouldn't be a developer rather than a DBA would you

If you tried to put a trigger with a cursor into production at...

Test the different methods of obtaining data in Approach 1 & 2 and go with the one that provides the best speed. This will depend on the physical location of...

"...I'm not in the habit of questioning the wisdom of savants..."

Question, question it's highly unlikely that one person knows everything.

http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=634f7f84-6c10-4163-9890-faf1ab55f66a

"...only adds a leading comma instead of a trailing one..."

Oh well, trim off the trailing or trim off the leading ... which way is better ??

Maybe you could throw a...

Yes do use a function, wouldn't do to give the "CursorsAreEVIL" police more ammunition

Also, correct me if I'm wrong, but if you use...

Run the query in Query Analyzer with "Show Execution Plan" selected and you see

Jacob

In the wizard, you can change the destination table in the step where you select source tables and views. If you select an existing table as the destination you can...

Using a staging table is probably the better method and is more in line with standard practice.

You could also set the Exception file properties on the Options tab of the Datapump. Then...

Unfortunately SQL 2000 does not have a row number function, you'll have to wait for SQL 2005 for that

In the meantime, take a...

In the stored procedure, are you using the sp_OA* procedures to execute the packages, or xp_cmdshell?

The sp_OA* procedures a know to cause memory leaks. So if you are using them...

Otto, I think 32bit SQL Server database engine is limited to 4GB of ram unless you're running Windows 2003 Enterprise or Datacenter. If you run 64 bit SQL Server you...

"The error is occuring only when the job calls the stored procedure

If i executed stored procedure from query analyzer then there is no problem. "

Hmmm ... conflicting executions of...

Unless you're talking about a different post, which is quite likely the way you post thing all over the place, you do not mention anywhere that you get null for...

Just because I wasn't contributing anything to the discussion, it's wrong to presume that I wasn't following the discussion.

I actually considered helping when you posted your first message, but due...