Post reply

How to check for special character in CSV file?

  • January 11, 2010 at 4:15 pm

    #1102094

    This does not sound like a case of a special character. It sounds like the package is hung up on a step.

    Can you describe the control flow tasks prior to the data flow in question and also detail the tasks inside of the data flow? What are you trying to do with the data? Are you using precedence constraints that contain expressions, or script tasks?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • January 12, 2010 at 9:32 am

    #1102527

    John,

    Thanks for the help.

    SSIS move files from 5 application to SQL servers, check file name, header, load into staging and start processing rows (creating rows few different base table). You were right the package hung due to INSERT NULL error. There is a row:

    SELECT @RoleGenerateID = SCOPE_IDENTITY()

    right after INSERT. That might be the reason identity column jump from 5 to 6 digits in one table. But what surprised me was that I added a DELETE way before the processing:

    DELETE dbo.stg_RolePlayer

    WHERE ISNUMERIC(RoleID) <> 1

    right after staging was populated. The DELETE resolve the issue.

    In any case, thanks again/

    Chris

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply