Importing SP from SQL Server 2000

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Importing SP from SQL Server 2000

Post by admin »

Hi All

Im trying to import a SQL Server 2000 stored procedure definition but keep
getting:

Parameter @RETURN_VALUE in stored procedure dev.dbo.usp_Reports_DataStage_Quality_Summary;1 is defined as type 5, which is not supported in DataStage.

Definition not imported!

What does the above mean? This sp does not have any parameters, in or out. I dont know where DS is getting the @RETURN_VLAUE from.

TIA
Hong
Locked