Brandie Tarvin (6/10/2011)

---

That is an...

DV

I think if you look in the Variables window, you'll see the value for the variable the last time the package was loaded. If you know a bit of...

Brandie Tarvin (6/10/2011)

---

Eh-hem. I think you need to go back and look at your variable scope. The picture you posted does not jive with the comment "I have a package...

DV

Please will you post DDL and a sample of data for the CurrPeriod table.

Thanks

John

WITH NewOrders AS ( -- change prices here as required

SELECT 10 AS orderTotalPrice UNION ALL

SELECT 20 UNION ALL

SELECT 30 UNION ALL

SELECT 40

)

INSERT INTO [Order] (

orderId

,orderCustomerId

,orderTotalPrice

)

SELECT

NEWID()

,c.customerId

,n.orderTotalPrice

FROM

Customer c

CROSS JOIN

NewOrders n

-- Check...

OK, we're getting closer. Now will you please send some DDL that will actually create the tables when I run it on my SQL server.

Thanks

John

Table DDL, please, including foreign key constraint.

John

The same four orders for each customer? If not, what? Also, please provide table DDL in the form of CREATE TABLE statements.

John

DV

Just search for execute sql task parameter mapping - you should find loads of articles. Also, try searching for your original problem - somebody might already have solved it....

It should work with just a SELECT statement. How do you know the variable isn't being updated?

I would recommend that you use a stored procedure in any case, if...

Simon

Since Gail and I have taken the time to help you, and in case anyone else is reading this in the future with a similar problem, please will you post...

Not so fast! Two alternatives here:

(1) Something like (simplified):

WHERE (@datatype = 'B' AND tablenameid IN (30,28))

OR (@datatype = 'C' AND tablenameid IN (11,48,132))

OR etc

(2) My preferred solution...

If you only have changes to your database that often, then you don't...

You will need to do some string manipulation or some arithmetic on your date in order to get it into a format that can be converted. '20110607 11:11:11.111' is a...

Gus is right.

I think sp_delete_backuphistory is date specific, not database specific, so you may end up throwing the baby out with the bathwater if you use it.

John