Even better - a combo of the 2 suggestions:

Run this in Query Analyzer:

select 'exec master..xp_cmdshell ''bcp your_db_name..'+name+' out '+name+'.txt -Sserver_name -c -E''' from sysobjects where type = 'u'

Cut and paste...

From Query Analyzer you could:

select 'bcp your_db_name..'+name+' out '+name+'.txt -Sserver_name -c -E' from sysobjects where type = 'u'

Grab the results of that query and run them from the command line...

Thanks for your comments. I'll try SQSH.

I didn't really need to mention TomCat. I'm just researching my options in copying data from an Oracle/PeopleSoft installation on Linux to...

HH - I have sent you an email with an explanantion of my fix. Here's a summary:

In EM,select YOUR_SERVER-->Management-->Right click SQL Server Agent-->Properties

In the 'Job System' tab, uncheck...

Thank you all for your suggestions!

I believe I will have to give Andy's suggestion (writing to a table) a try as my DTS knowledge is very limited.

apf

Wow! You guys are fast. Thank you very much for the quick response and the info.

A follow-up:

Is there a way to pass info from one step to the...

Thanks for your response. I see that I forgot to state my question, but you did guess it correctly!

I guess basically you're saying that when calling UDF's,...

Prakash -

Thank you very much for pointing out that 3rd party product. I'll give it a try!

apf

OK, thanks Andy. I appreciate your time.

apf

OK! Thank you for your quick response!