Viewing 15 posts - 9,736 through 9,750 (of 13,874 total)
Did you generate new IDs for the child packages, or are they exact copies?
(I'm not sure whether it matters, but worth checking.)
July 15, 2013 at 11:53 am
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...
July 15, 2013 at 11:50 am
ssurekha2000 (7/15/2013)
[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...
July 15, 2013 at 3:25 am
ssurekha2000 (7/15/2013)
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...
July 15, 2013 at 3:11 am
HanShi (7/15/2013)
INSERT INTO table2SELECT FDT1 TODT1 FROM table1
UNION ALL
SELECT FDT2 TODT2 FROM table1
I think you might need to add a comma between the column names ...
July 15, 2013 at 2:59 am
Right - sounds like you have limited rights on that PC. Can you find someone with local admin rights who can do it for you?
July 10, 2013 at 12:55 am
mister.magoo (7/10/2013)
Thanks for taking the time to explain.
NP - I feel like the subject matter expert on this topic after the last few days!
July 10, 2013 at 12:53 am
To fix the problem (for SS2012 only), use the following T-SQL instead:
exec dbo.testProcWithTempTables
with result sets((id int));
July 10, 2013 at 12:52 am
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...
July 10, 2013 at 12:44 am
Comment removed - it was wrong!
July 10, 2013 at 12:31 am
girl_bj0619 (7/9/2013)
Cannot import. Error accessing the registry.
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...
July 10, 2013 at 12:27 am
Munabhai (7/9/2013)
July 10, 2013 at 12:23 am
girl_bj0619 (7/8/2013)
i hit error accessing the registry during importing.
The package failed with a registry-access error while you were performing an import?
What was the error message?
July 9, 2013 at 6:52 am
mister.magoo (7/9/2013)
Ah right, sorry - I hadn't realised that didn't work any more in 2012, and you hadn't mentioned trying that technique...:-)I don't have any other suggestions, sorry.
Sorry about that...
July 9, 2013 at 6:21 am
Viewing 15 posts - 9,736 through 9,750 (of 13,874 total)