Click here to Skip to main content
15,560,987 members
Home / Discussions / Database
   

Database

 
GeneralRe: Assist to solve this problem? Pin
Peter_in_278026-Jun-11 15:50
professionalPeter_in_278026-Jun-11 15:50 
GeneralRe: Assist to solve this problem? Pin
Mycroft Holmes26-Jun-11 15:56
professionalMycroft Holmes26-Jun-11 15:56 
GeneralRe: Assist to solve this problem? Pin
David Skelly26-Jun-11 23:29
David Skelly26-Jun-11 23:29 
AnswerRe: Assist to solve this problem? Pin
Blue_Boy25-Jun-11 22:42
Blue_Boy25-Jun-11 22:42 
GeneralRe: Assist to solve this problem? [modified] Pin
current199917-Jul-11 22:48
current199917-Jul-11 22:48 
AnswerRe: Assist to solve this problem? Pin
Niladri_Biswas4-Jul-11 1:44
Niladri_Biswas4-Jul-11 1:44 
GeneralRe: Assist to solve this problem? Pin
current199918-Jul-11 1:00
current199918-Jul-11 1:00 
QuestionStored procedure from SSIS Pin
Groulien24-Jun-11 1:11
Groulien24-Jun-11 1:11 
Hello CP,

I'm messing around with SSIS and have run into a problem when trying to get the DataReader Source to work.
The problem is simple;
I'm trying to set the SqlCommand property to point to a stored procedure:
EXECUTE [dbo].[spMyProc] '20110101', '20110131'

The problem does not lie in calling the SP but rather with something in the SP.
My SP makes use of Temp table and it seems it cannot find it:

Error at Data Flow Taks[DataReader Source[1]]: System.Data.SqlClient.SqlException: Invalid object name '#tmpCalcTable'.
 at System.Data.SqlConnection.OnError(SqlException exception, Boolean breakConnection)


The Stored Procedure creates a temporary table and later deletes it, but it seems it's either not doing that or can't access the it.
I've tried making the temp table global by using a double hash (##) instead of one but without luck.

Does anyone have an idea how I can fix this?
AnswerRe: Stored procedure from SSIS Pin
R. Giskard Reventlov24-Jun-11 2:57
R. Giskard Reventlov24-Jun-11 2:57 
AnswerRe: Stored procedure from SSIS [modified] Pin
UNCRushFan24-Jun-11 3:03
UNCRushFan24-Jun-11 3:03 
GeneralRe: Stored procedure from SSIS Pin
Groulien27-Jun-11 4:28
Groulien27-Jun-11 4:28 
GeneralRe: Stored procedure from SSIS Pin
UNCRushFan27-Jun-11 6:06
UNCRushFan27-Jun-11 6:06 
QuestionShow Statement Pin
programmervb.netc++23-Jun-11 7:30
programmervb.netc++23-Jun-11 7:30 
AnswerRe: Show Statement Pin
Blue_Boy23-Jun-11 7:50
Blue_Boy23-Jun-11 7:50 
GeneralRe: Show Statement Pin
programmervb.netc++23-Jun-11 8:11
programmervb.netc++23-Jun-11 8:11 
AnswerRe: Show Statement Pin
Pete O'Hanlon23-Jun-11 8:26
mvaPete O'Hanlon23-Jun-11 8:26 
GeneralRe: Show Statement Pin
programmervb.netc++23-Jun-11 8:31
programmervb.netc++23-Jun-11 8:31 
GeneralRe: Show Statement Pin
jschell23-Jun-11 9:35
jschell23-Jun-11 9:35 
QuestionRe: Show Statement Pin
Eddy Vluggen23-Jun-11 10:14
professionalEddy Vluggen23-Jun-11 10:14 
QuestionSQL Jobs Output Pin
Groulien23-Jun-11 5:05
Groulien23-Jun-11 5:05 
AnswerRe: SQL Jobs Output [modified] Pin
UNCRushFan23-Jun-11 8:30
UNCRushFan23-Jun-11 8:30 
GeneralRe: SQL Jobs Output Pin
Groulien23-Jun-11 23:56
Groulien23-Jun-11 23:56 
Questionis these two queries same? Pin
Dhyanga23-Jun-11 4:08
Dhyanga23-Jun-11 4:08 
AnswerRe: is these two queries same? Pin
JV999923-Jun-11 4:44
professionalJV999923-Jun-11 4:44 
GeneralRe: is these two queries same? Pin
Dhyanga23-Jun-11 4:53
Dhyanga23-Jun-11 4:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.