Thanks a millions Elliot....!

Thanks Elliott! that worked but still the job failed with this message

Message

Executed as user: . Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 32-bit Copyright (C)...

I came up with a solution

DECLARE @cmd VARCHAR(4000)

DECLARE @ID INT

SET @ID = 1

SELECT @cmd = '/FILE "C:\Packages\Test Folder\Package.dtsx" /CONFIGFILE "C:\Packages\Test Folder\Package.dtsConfig" /SET "\Package.Variables[User::ID].Properties[value]";'

SELECT @cmd = @cmd+ CONVERT(VARCHAR(100), @ID) + '/CHECKPOINTING...

Hi Jeff,

That worked for me......But in order to do that I have to write a stored proc for all the databases which they dont want to do.....

Thanks! lewis..... that helped me

Thanks! for your reply.

I have a sql task which executes a query and stores the result set in a xml result set. i have to send an email of this...

I'll Explain it again.

I have a variable which holds all the sql commands to be executed. So in the sql task the sql source type is variable. So the...

Thanks! Leju. But i dont understand the xml task path

XML Task properties:

OperationType: XPATH

SourceType: Variable

Source: User::varResults

SaveOperationResult: True

Destination: User::varRowCount

SecondOperand: count(//table1)

so in the second operand do we have to type count(//table1)

in the xml...

Thank you allen...

@GSquared:

Thank you soo much....i finally got it

Thank you....but im working on sql server 2000...sorry should've told you first...

the max orderdate is the maximum date for each order id for example

if u look at the table for orderid efgh there are three records and the maximum orderdate for...

Thank you....that helped me....

thanks got it......is there any other way instead of a single select statement.....which is beter than the queries posted in the challenge.

they haven't yet....i need that solution....cause im dealing with the same scenario right now....