execute sql task issue

• scuby.me

  Mr or Mrs. 500

  Points: 587

  More actions

  October 22, 2013 at 8:02 am

  #278351

  i have a ssis package where i need to import data from excel to sql table which does it job perfectly. and also i have execute sql task which executes stored procedure.

  when i exec the job the table is getting null values in some columns(which comes from stored procedure)

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 22, 2013 at 11:32 am

  #1660623

  scuby.me (10/22/2013)

  ---

  i have a ssis package where i need to import data from excel to sql table which does it job perfectly. and also i have execute sql task which executes stored procedure.

  when i exec the job the table is getting null values in some columns(which comes from stored procedure)

  OK.

  ---