Post reply

How to get the Error row number from Data convertion Transformation in SSIS 2005

  • March 28, 2011 at 5:52 am

    #389152

    I am using data flow task to load data from .csv file to SQL data base. In this, I am using data conversion transform and redirecting the rows having conversion errors. I want to get the row number in which error exists.

    Can any body help in this regard

    Thanks

  • March 28, 2011 at 12:30 pm

    #1304513

    To my knowledge SSIS does not implicitly add a row number to your data set that you can reference. I think you will first need to manually add a row number to your data set. This may help:

    http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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