Ok I'm no developer but I'm guessing that you can't run VB code in VB Script. You would need to use VB.

Why wouldn't you have the DTS package stored on the server,...

Jeff, thanks its nice to know I'm right sometimes

As for the example with the leading/trailing spaces, this would generally be dealt with using...

Hmmm ....

Bowtie ?!?

Two people bowing

Check the log files in

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

I went here

http://www.sqlservercentral.com/search/turbo.asp

Typed in Constraint, selected 'Script Library', and clicked 'Find It!'

Guess what was returned,

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=246

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=213

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=899

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=202

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1202

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=246

Now with the wealth of information that was returned in...

Can you paste your script? That way we might be able to spot whats causing the error

Joe

"Professional best practice" is to review the documentation. If there is something in Books Online that you don't understand then explain what you don't understand and we may be able...

Another suggestion is http://www.sqlservercentral.com/scripts

I would recommend DTSBACKUP 2000. Nice and easy to use and you can run it seperate from SQL Server.

Brad

Firstly, its not good forum etiquette to hijack someone else's post. Yes your question does relate to SQL Mail, but it has nothing to do with the original posters question.

As for...

For your SQL 2K environment, you should have the users assigned to a database role that has execute permissions on all stored procedures.

Then when users create procedures they can include...

What edition of SQL Server are you trying to install?

You can use the web services to return a byte stream for the rendered report. You'd then have tohave appropriate print logic in your application to turn this byte stream...

You can use an activexscript, or a dynamic properties task to change the source filename.

The following link shows how to do it in script.

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

sp_changedbowner changes the owner of the current database, nothing to do with orphaned users.

Read the documentation in Books Online.