You could build a small VB app to execute the DTS package and distribute the app to the required stations.

I am not sure about just installing dtsrun.exe as there could...

I never did this but I guess if you have an OLEDB Provider to access Lotus 123, it shouldn't be a problem using DTS to import the workbook.

ALTER DATABASE SET SINGLE_USER WITH [ROLLBACK IMMEDIATE | ROLLBACK AFTER integer [SECONDS]]

Why don't you use the Microsoft OLE DB Provider for Oracle for your connection, instead of the Oracle driver? I found this solved a lot of headaches in the past.

...

The easy way....ActiveX Scripting.

The easy way?...sp_OA... stored procedures.

Is your domain a native Windows 2000 domain with some Windows NT server?? If yes, take a look at this:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/6/43.asp&NoWebContent=1&NoWebContent=1

Is your account local to the SQL Server machine...

You could put your query into a transaction but for the situation you describe where you write a wrong condition, you may be out of luck once your transaction is...

You could BCP into a staging table as varchar, do some substringing to remove the (-) sign and import into the final table.

If DTS is an option, you could use...

Try using the three part naming for your table (databasename.owner.tablename).

Yes, the desktop engine could participate in merger and snapshot replication as a subscriber/publisher but could only be a subscriber in transactional replication.

In your scenario, you could set up merge...

More than one way to skin a cat..

You could use sp_OA.... stored procedures to instantiate and execute your DTS package. You could also execute dtsrun by using xp_cmdshell from...

One way I could think of is to wrap your API calls into a COM and instantiate and execute the COM using the sp_OA.... stored procedures.

Two things: use the three part naming scheme database.owner.table in your FROM clause; specify the complete path to your attachment PestErrors.csv

Hope this helps.

Joseph

What parameter are you passing to the stored procedure in @ui_category? Is this a column name in your table? You may also want to put your select statement into a...

I would also suggest you check your network hardware for bottleneccks, especially the network interface cards. I had a similar problem where a 562GB database backup was failing(with same error...