locked
Sql Task Execute Error RRS feed

  • Question

  • Hi:All
        Recently I come with the error of the SSIS likes that :
       Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
       The sql likes that : select  ? as run_time,job_name from job_history. "?" stand for a virable which not belongs to the job_history table,but the job_name comes from it . The task can execute on my colleague's computer with the Operation System of win2000,but can not run at my computer with winxp . All configuration on my computer is correct or the same with my colleague's ,anyone knows why? waiting for your help .
       Thanks . 
     
    Monday, March 2, 2009 2:57 PM

Answers