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?

NP - I feel like the subject matter expert on this topic after the last few days!

To fix the problem (for SS2012 only), use the following T-SQL instead:

exec dbo.testProcWithTempTables

with result sets((id int));