There is a line in the VB code that executes the package. Just above that is a line that is commented out which saves the package back to SQL.

Look up...

Ah yes you could use encryption, forgot about that one. I generally keep away from it because it can cause more problems than it's worth

Yelena

Yes the direct url is http://www.sqldev.net/xp/xpsmtp.htm

We use it on all our SQL Servers for all emails that originate from SQL Server. Since setting it up we haven't had any...

Try using the undocumented extended stored procedure xp_dirtree.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=128000

Use xp_smtp_sendmail from http://www.sqldev.net

No need for VBScript writing.

First of all you shouldn't be putting non-Microsoft supplied items in the system databases.

Given an appropriate tool, such as Query Analyzer, users in the public role can view the stored...

You could install IIS on your machine and then try the Web Data Administrator from Microsoft,

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

You could also try myLittleAdmin

http://www.mylittletools.net/scripts/en/mla_sql/default.asp

Mathew

In order to provide a useful answer instead of a stab in the dark, can you give use more information about your problem?

How are you calling the package? What does...

Thanks Grigory

Will a new version of SQLH@ be getting released before the SQL Server 2005 release?

The problem you're encountering is due to the way DTS works. It's basically a client application and all resources that are referenced in the package need to be local to...

Server Compare looks like an interesting start. At the moment it's a bit limited in it's functionality.

I tried a few DTS compares that failed miserably and trying to filter out...

The configuration in SQL Server Integration Services (DTS 2005) is handled much differently. You have a package configurations collection that you can play with instead of global variables.

As I was saying, if the global variable has <not displayable> for the value, you can't change it. You have to delete it and create it again.

For something that runs in Query Analyzer to synchronise data, or even better as stored procedures. You'll be wanting to run a series of DELETE, UPDATE and INSERT statements across...

Where are you looking to use this IIF EMPTY command? In the report itself, or in an SQL statement?

You can use IIF in expressions within the report. For the SQL...