I tried once myself but could not get it to run.

See: http://www.sqldts.com/default.aspx?210

Sorry cannot help any further.

This script checks for failed jobs:

========================================

use master

SET NOCOUNT ON  --- speed up operation

GO

/* Failed jobs report. This query lists the name of all jobs that failed in their last attempt:...

I have a query that runs against system tables to list all failed packages last time run. I will post it to you tomorrow as it is at home.

You can...

Why do you not just add a task at the end of the job that:

1. Selects all records from table a where aid not in table b.id.

2. Then export the...

Apologies. I don't really get your meaning.

Chris.

Let me know if you still want to do this. I have found a way and have it working on my server for my own purposes.

It is a bit copmplicated...

Why not use the 'execute package task'. You get to specify the server and the package name so should suit your purposes.

There are a few ways to achive this. This probably the simplest.

Set up two data connections in dts. Click on source and destination and right click to get the task...

See this article for how to get a loop in a dts package:

http://www.sqljunkies.com/How%20To/A8CB0AFE-D143-4B49-B865-4FBBFEDFCCD7.scuk

You need to find a way of bringing each id from the table into a variable to...

The maximum allowed for any data type is 8000.

If you want more than this, you will have to strip the first 8000 chars into one parameter, the next 8000 in...

Use:

isnull(dbColumn,0)

If it is null, it will use 0.

Believe it or not, the query:

CONVERT(numeric(10,2),round(34.2365,2,1))

... is the most efficient out of all the examples. Looking at statistics it takes 0ms to run, whereas all the others take at least...

Cedric and Razvan - I am afraid your examples do not work. They still round up the value when I try them in QA. Try your examples out with 34.2399...

Try this:

--- DECLARE VARIABLES

DECLARE @MYVAL DECIMAL (8,4) ---ORIGINAL VALUE

DECLARE @MYVAL_CONVERTED NVARCHAR(50) ---CONVERT VAL TO STRING

DECLARE @STARTPOINT AS INTEGER ---POSITION...

Thanks. I'll have a playabout and see if I can find it.