Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Daft DTS Data Driven task question

    Hi, I'm trying to get a Data Driven DTS task to update a table based on a .csv source file. I've got a numeric ID Identity column (unique) to give me a record number, and I'm using the following code on the update query to try and update the relevant record:

    UPDATE [DR-TestDB].dbo.[Test - CustAddress]
    SET
    County = ?
    WHERE (ID = ?)

    The problem I'm getting is a conversion error from VarChar to Numeric when I run the task. I've tried using a type conversion in the transformation, but that doesn't appear to help.

    Anyone know the answer - I'll bet it's simple

    Cheers,

    Menthos

  2. #2
    Join Date
    Mar 2004
    Posts
    3
    Hmmm... ok, I seem to have resolved this - just rebuilt the task from scratch and it appears to have worked fine.

    Very strange.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •