Well the sample I provided didn't check the return value from the sp_OA* procedures. The variable @hr will be zero if there were no errors. If you find an error,...

Firstly, if the memory is configured as default then you'll have dynamic memory management enabled. This means that SQL Server will grab and release memory as needed. The default setting...

Ramesh

Firstly, why you can't do this in VBScript is a mystery. If you have SQL Server installed then you have both VBScript and JScript installed as part of the default...

See my response to your duplicate post.

Reporting Services is licensed with SQL Server the same as Analysis Services. If you want to run either service on another server, you need to license that server.

As to the...

If you're runing SQL 2000, you can use the /A parameter. Check out the Books Online topic for the syntax.

Is this the same query syntax used when querying the Foxpro database?

Are you able to determine which records are excluded find out what is different about them.

It depends on your data requirements. Do you ALWAYS load ALL six files? If one file fails to load properly should the remaining files still be loaded. Would there ever...

Check out this article,

http://www.sqldts.com/default.aspx?218

If all you have is this one task, why are you using DTS?

How about breaking up the stored procedure execution into a few steps. Then use workflow and looping to...

Firstly, every package has at least one version. However, there may be package log records for versions that don't exist. If you don't get any records when executing that query...

Using Visual SourceSafe to Version control tables and views requires a lot of manual intervention and as such can be very problematic.

I don't understand what you mean by "The subtotal or total is actually the same textbox", are you using the in-built subtotal option in the matrix layout? This shows a...

Personal preference, but I'd put the application name first. Quite often I'm faced with tracking down problems with XYZ application. If you run the same application in multiple divisions you...

Never tried this before but you might try

http://www.crystalsoftware.com.au/textpipe/ebcdic_ascii.html?google6

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;216399