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));

Hi MM

The error occurs when you use the proc in an OLEDB Source, within a data flow. ExecuteSQL tasks are not affected, as far as I know.

I did this, using...

Comment removed - it was wrong!

You did not answer my first question and your error message was not the exact error message which you received.

If you provide only snippets...

Munabhai (7/9/2013)

---

I have 1000 text files in one folder, text files have 2 or 3 or 4 column. Now I need to load those text file in sql server tables,...

The package failed with a registry-access error while you were performing an import?

What was the error message?

Sorry about that...