Error using CSTR on field in Excel Import

• dave-0

  Mr or Mrs. 500

  Points: 550

  More actions

  April 20, 2009 at 10:24 am

  #384398

  When I execute the package locally it is successful.

  However, If I run the query via the SQL Job Agent. I get:

  Executing the query "Select top 1 CSTR(F2) AS [F2] from [Front Page$]" failed with the following error: "Unknown". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  I need to use the CSTR to convert the field to a string.

  Anyone have any ideas?

• vishal.gamji

  SSCertifiable

  Points: 6126

  More actions

  April 20, 2009 at 11:00 am

  #980888

  Read this article. I think u have a typical case from the article.

  http://sqlscape.blogspot.com