Are you saying that...

That's more like it, thanks for taking the time to clarify Jason.

I understand that you were trying not to get too technical with your first answer & just wanted to...

Create a query which runs against your Oracle data.

The query should return the data in the format you want to insert to SQL Server.

Use the query within a data flow...

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.