I suppose I could have done this just as easily to your original, but sometimes a simple example shows the technique better. Just as long as you understand what...

Is the service account running your SSRS instance set up as a user in your database?

You need to reference the named instance in the connection like this: host\instance.

Please do not double post......

continue this thread here

DECLARE @ParmDefinition nvarchar(500);

SET @ParmDefinition = N'@Date datetime'

DECLARE @DBNameVar NVARCHAR(128)

DECLARE @Statement NVARCHAR(600)

DECLARE @ADATE DATETIME

SET @ADATE =(DATEADD(d,-60,getdate()))

SET @Statement=N'SELECT @DATE'

EXEC sp_executesql @Statement, @ParmDefinition, @Date = @ADate

Just make sure the SELECT portion of this statement gives you the correct results, then combine with the INSERT and let it roll.

INSERT INTO ClientAlias(ClientAlias,ClientID,defaultalias,enrolled)

SELECT Clients.Name & ' (' &...

Can you write the SQL statement that SELECTs the data that you want deleted?

Agreed.

Ice Cream.....treat it from the inside too.

These are some of the things I had to learn too moving from DTS to SSIS. The visual studios environment gives you much better troubleshooting and debugging features. ...

You have to include the variable as a ReadOnlyVariable in the script properties page.

There is an easier way to do this. Set a breakpoint and use the Watch window....

Tom.Thomson (7/28/2010)

John Rowan (7/28/2010)

Now your challenge will be to get both since most income equations involve trading one...

Now your challenge will be to get both since most income equations involve trading one for the other.

Nope, just count 'em.

blessing