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...

Have a look through this Powerpoint presentation from a meeting we had last night.

http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=33

Take a look at this lively thread

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

When the variables show <not displayable> for the value, you cant change them.

You'll have to delete the global variables and start again. When you...

It's one of my favourite tools. It even comes in a command-line version

This is all down to the initial package design.

What I have is a single table that stores all the global variables for my packages. These are global variables for various...

If the BUILTIN\Administrators group hasn't been removed, when you connect with a windows account that has admin privelages you should be granted sysadmin privelages. Once connected you can change the...

Is "SQL-1-SRV" the name of your server? Could be part of the problem, I've heard of people having problems with different tools when they have "-" in the server name.

Other...

Have you tried using the FTP task in DTS? A what point doesn't it cater for your needs?

How about using the FTP task that comes with DTS, or even this handy replacement by the guys at SQLDTS??

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

How about creating a DTS package and saving it as a VB file?

I think the magical potion you're looking for is something like

    CONVERT(datetime, STUFF(STUFF(sjh.run_date,7,0,'-'),5,0,'-') 
        + ' ' + STUFF(STUFF(REPLACE(STR(sjh.run_time,6),' ','0'),5,0,':'),3,0,':'), 120)

You might need to add "SET DATEFORMAT ymd" at the...

No problem. It's always a pleasure to help with the simple problems

Hmmm ... must be something else here. Just ran a little test myself,

CREATE Table tt_basetable (
 field1 int
 , field2 int
 , field3 char(3)
 , field4 int
 , field5 int
)

CREATE Table tt_arctable (
 field1 int
 , field2...

The error you're getting is a MAPI Login failure. Do you specifically have to use SQL Mail functioanlity? eg: xp_sendmail, xp_readmail

If not I'd suggest you save yourself some headaches and...