The command line seems to be fine.

You installed the Oracle client, but did you also install the 32-bit provider?

Why not try to run the package in 64-bit by the way?

Unpivot the data and use the Aggregate transform to find the max.

wanox (7/26/2013)

---

I cannot pivot in excel (source data).

I have tried to pivot as part of my data flow and have not been successful. Can you help me out...

I'll have a look later. I have to go to work now 🙂

Please do not crosspost. It wastes peoples time and fragments replies. Original post can be found here:

Not sure if it is the same for DB2, but for SQL Server queries I use @myParameter for parameters. The question mark is used in SSIS, but not sure this...

Can you show us the command line?

TDE isn't my strong suit. Ah well, it's almost weekend 🙂

Can you give some sample data so we can see what we're dealing with?

You can use the Excel Source in the data flow to read the Excel file (not with a stored procedure). Then you can use a Lookup component to find the...

jk_in_San_Diego (7/25/2013)

---

File this under "you learn something new every day" - my coworker (Linda Knott - The Magnificent!) reminded me that the Save button during the file name prompt has...

Luis Cazares (7/25/2013)

---

Eric M Russell (7/25/2013)

---

We also can't assume that DateOfBirth isn't nullable.

SELECT TOP 1 *

FROM MyTable

WHERE DateOfBirth is...

jk_in_San_Diego (7/25/2013)

---

Yeah, I know and love Notepad++ myself, but it is limited on the maximum file size that it can handle. Unfortunately, some of my text output files get up...

jk_in_San_Diego (7/25/2013)

---

Thanks for the reply. I used an SSIS package to output the file as ASCII text to meet my immediate need.

I would like to know if it's possible...

SELECT * FROM myTable

WHERE BirthDate = (SELECT MIN(BirthDate) AS EarliestDate FROM myTable)