How to handle Insert & select Query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

How to handle Insert & select Query

Author

Topic

yaman
Posting Yak Master

213 Posts

Posted - 2008-12-01 : 14:55:20

Sir I have Procedure

CREATE proc Temp11
as
BEGIN
INSERT INTO TEMP
VALUES
('yam','India')
SELECT * FROM TEMP
END

Now i am making the SSIS Package for these procedure .
Store data in New Text File
I am succesfully Crated SSIS Package
When i am run these Package I got a ERROR ?

" [OLE DB Source [1]] Error: A rowset based on the SQL command was not returned by the OLE DB provider. "

"[DTS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC02092B4. "

Sir When i am Remove Insert Statement from Procedure Then
My Package RUN Sucessfully .

What is the Solution Of these Problm Pls Help me Out Sir ...........

Yaman

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-01 : 17:28:34

You need to create temp table before you can insert values.

yaman
Posting Yak Master

213 Posts

Posted - 2008-12-01 : 18:15:47

quote:
Originally posted by sodeep

You need to create temp table before you can insert values.

i have already used temp table but

when i am creating temp table in SSIS package then it will give
error when i am mapping table column

Yaman

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources