Execute a Stored proc in SSIS execute SQL task with variable as parametres.

• ajit_padhan

  SSC Enthusiast

  Points: 129

  More actions

  June 2, 2011 at 3:00 am

  #252074

  Dear Friends,

  I want to execute a SP in Execute sql task like 'EXEC SP_CID_Push_DeleteTable ?' . here i want to pass the parameter from the variable User::common_extract_costcenter. I have set the properties of task as below :

  Variable NAme - User::common_extract_costcenter

  Direction - INPUT

  DataType - Varchar

  paramater NAme - TableName

  Parameter Size - 0

  while i execute the task i am getting the below error : [Execute SQL Task] Error: Executing the query "EXEC SP_CID_Push_DeleteTable ?" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. [/size]

  Your hlp is highly appreciated.

  Thanks,

  Kumar

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  June 2, 2011 at 10:40 am

  #1333233

  Try changing the parameter name to the number zero (0) and perhaps paramter size to -1, can't remember about the size one..

  CEWII