Marc

I've never used a Lookup transformation, but if you look at the editor, you'll see at the top that it "enables simple equi-joins". My guess is that this means...

2. I'm still not sure what you mean. If my original reply didn't answer your question, please say what you don't understand or what further information you need.

4....

Marc

It's very difficult to visualise this. Please will you show us what the structure of your databases table(s) and text file(s) looks like?

Thanks

John

I think you need to use the PIVOT statement (or you can achieve the same with a series of CASE expressions). Have a read about that and post back...

From the sparse information you've given, a linked server or a dataflow task in SSIS seem to be what you need. Please provide more details of what you're trying...

1. I don't know. You could find out for yourself by creating a user and making it a member of both roles.

2. Not sure what you mean here....

I'm sorry, but I don't understand what you're trying to do. The statement you have posted will return just one column, but you appear to want to return at...

Well, yes - but only if such a group exists. By default, all members of the local Administrators group have full access to SQL Server (at least they did...

Speak to whoever is sysadmin on SQL server and ask them to grant it to you.

John

DV

I haven't tried this myself, but you could try casting as the various date data types and see if one of those gives the date portion only. Failing that,...

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...