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

First thing, you're going to need more than 2 disks.

Take a look at the HP Solution Sizers for SQL Server. You can enter the requirements info there and it'll suggest...