Can you write a query which executes against the Oracle database and brings back the data in the format you want?

If you can, job done - use that as your...

I have some questions about your post wolfkillj.

What do you mean by 'logically' in the above?

*However*, clustered...

Elliott - your workaround idea worked a treat, thanks again.

Elliott Whitlow (7/21/2013)

---

Phil,

I don't think you can prevent it once its been started. I think you have to do all the work to make sure that the values will...

Use Windows authentication in your connection.

No problem. Well done on getting it working.

J0shu@ (7/17/2013)

---

Yes the columns are the exact same, the only change is the file name and sheet name.

I want to also make sure that I'm configuring the data flow...

There is an example here that might be relevant to you.

Are the column names exactly the same in all of the files?

Is there exactly the same number of columns in all of the files?

Are the columns in exactly the same...

Koen Verbeeck (7/16/2013)

---

Never really payed attention to it, but you're right. I just ran a package with every possible log event enabled, but the columns are still the same.

So you...

ssurekha2000 (7/16/2013)

---

i need to insert records from table1 to table 2

out of 15 columns from table1 i need to insert 6 columns to table 2

but

if i use

insert...

Yep, I confirm that your method works for me - I would say that you have a scope issue.

Megistal (7/15/2013)

---

Sure,

The next component, in the control flow, I've added a breakpoint on the "PreExecute" event and check the locals variables in the debugger.

I've also do the samething a few...

Tara-1044200 (7/12/2013)

---

If its a permissions issue how could that loop make half way through hitting the same tables and database/server?

just so you know my loop iterates almote 50k times, do...

May I ask what technique you are using to check the variable's value?