Unable to call a stored Procedure via link server in SSIS 2005
===

i had created a test stored procedure in data-warehouse.map server. i had created a OLE DB source. this source is connected with mas.est server and i am calling the stored
procedure via link server EXEC [data-warehouse].MAP.dbo.test

 procedure via TITLE: Microsoft Visual Studio
------------------------------

The component reported the following warnings:

Error at Data Flow Task [OLE DB Source [1]]: No column information was returned by the SQL command.


Choose OK if you want to continue with the operation.
Choose Cancel if you want to stop the operation.

------------------------------
BUTTONS:

OK
Cancel
------------------------------

please suggest me how to do this?

