Are you and the developer running the package against the same database, with the same data being inserted?

If you're worried about picking up the same file two days in a row. Best/easiest option would be to move the file to an archive location once it has been...

"As I stated in the original post it is a script that executes a simple backup command. "

Ahh ... no ... you didn't mention that.

Yes, many of the custom scripts...

Maintenance plans are ok for system databases and small sized user databases that have a maintenance window. Try running a maintenance plan on a 24/7 database that's over a few...

Susan

There is no relationship between the saved VBScript file and the DTS package. The save/load functionality in the ActiveXScript window just allows you to save/load the text. Quite handy if...

Now why would you be running an Insert statement within an ActiveXScript task in DTS?

You could try capturing the concatenated SQL string and seeing if there is a syntax error....

Brian, Happy to help.

BTW, I prefer the Aussie Cricket team to the Wallabies

What OS are you running on? For Windows 2003 you might have better success using CDO.Message instead.

Report Manager isn't terribly customisable. Best to just leave the "billy boy gates" look alone and create your own front-end for entering parameters and rendering reports. It's almost a drag...

You can just change the table design using Enterprise Manager. Look up the decimal datatype in Books Online.

If you don't want to change the table design, then you'll need to...

oh .. and also the hardware specs including data file locations.

To get subjective answer, you would really need to post a heap of DDL & DML (table and index definitions, query syntax, etc...) and provide more detail about your datatypes...

You could also run script to check the services list using WMI.

Haven't had much of a look at this, but try this on for size. Copy and paste the entire code into Query Analyzer.

SET NOCOUNT ON

CREATE TABLE #BETS (
 [BetID]...

If the SQL table has an Identity field then you can import the autonumber field into it by selecting the 'Enable Identity Insert' on the Options tab of the datapump.