Right-click on the maintenance plan and select "Maintenance Plan History". This is where you'll find much more descriptive error messages.

Take a look at creating something in DTS using VBScript to reference CDO objects.

EG:

Set objSession = CreateObject("CDONTS.Session")

objSession.LogonSMTP ("Joe Friday", "joe@here.com")

Set objInbox = objSession.Inbox

Set colMessages = objInbox.Messages

MsgBox objInbox.Name & " –...

In the report definition, the "Can grow..." and "Can Shrink..." properties will adjust the height of the field. I don't think you can dynamically adjust the width though.

Have you posted...

What connectivity does the PDA have? Modem/Network/USB Sync?

You might need to set/change the ip addressing or proxy.

Can you paste the full query?

Easiest way to check out what's happening is to paste the full statement into Query Analyzer and execute with "Show Execution Plan" selected, or use "SET SHOWPLAN_ALL ON" at the...

Take a look at sp_help_job. This proc calls xp_sqlagent_enum_jobs which determines the jobs current status.

Make sure you check out the ReportViewer sample application.

I know a lot of people are using this to render reports when they have parameters that aren't handled by the Report...

I always pass dates using the three character month. eg: 20 Apr 2004

This way SQL will always convert it to the correct datetime regardless of the regional settings.

This format is...

Just to add another twist in the story.

We have a regular process that archives records on an hourly basis from a table that has 10mil+ rows. Each hour approx. 1000...

Have you specifically set the default database in the System DSN?

For the VBScripts, you should be able to modify a connection string.

Julie

Thanks for your reply, however I don't think this is the case. The ExecuteSQL task that sets the variable is the first step in the package and the variable isn't...

Ooops ... sorry ... SQL 2K sp3a, W2k Server sp4

The ExecuteSQL task is just "SELECT COUNT(field) FROM Table". If you are thinking about discrepancies in the record count, that won't...

Take a look at http://www.querytool.com/index.html

Take a look at this example,

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