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?

Did you generate new IDs for the child packages, or are they exact copies?

(I'm not sure whether it matters, but worth checking.)

It's been a while, but I seem to remember that you do not need to have the variable listed in ReadWriteVariables if you are using the VariableDispenser methods to read...

ssurekha2000 (7/15/2013)

---

CREATE TABLE [dbo].[DETAILS](

[ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[CLENO] [int] NOT NULL CONSTRAINT [DF_DETAILS_CLENO] DEFAULT ((0)),

[Custid] [int] NOT NULL CONSTRAINT [DF_DETAILS_Custid] DEFAULT ((0)),

CONSTRAINT [PK_DETAILS] PRIMARY KEY CLUSTERED...

ssurekha2000 (7/15/2013)

---

i have a int column as Custid

initally value is balnk.

but i have set the default value when creating the field as 0

i need to increment the max Custid value

but...

I think you might need to add a comma between the column names ...

What's your question?

Right - sounds like you have limited rights on that PC. Can you find someone with local admin rights who can do it for you?