Something Strange happend in SSIS....

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  November 29, 2009 at 2:48 am

  #1085125

  Hi I tried this,

  It was working when I gave the below lines to SQL command data accessing mode.

  SET NOCOUNT ON

  Exec sp_name 1

  here 1 the the value. But when I tried

  SET NOCOUNT ON

  Exec sp_name ?

  and tried to map the parameter with variable I'm getting error.

  Can I get some help for this ....

  Regards,

  MC

  Thanks & Regards,
  MC

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  November 29, 2009 at 5:18 am

  #1085129

  Hi friends,

  I just got it , if we give the below two lines at the beginning of the sp it works!!!!

  SET FMTONLY OFF

  SET NOCOUNT ON

  ie

  CREATE PROCEDURE SP_NAME

  AS

  BEGIN

  (@P1 INT, @P2 VARCHAR(30)

  )

  AS

  BEIGN

  SET FMTONLY OFF

  SET NOCOUNT ON

  -----

  ---

  --

  END

  in this case , in the data access mode is selected as 'SQL Command' , no need to give SET NOCOUNT ON . Also we can give the parameter using ? , and can map it with variable . ie

  exec sp_name ?,?

  Regards,

  MC

  Thanks & Regards,
  MC