Post reply

I need to do a DTS for traspassing

  • April 12, 2005 at 1:54 pm

    #67388

    I need to do a DTS for traspassing datas from a txt to a table,

    but in the txt exists a registers with problems, the txt file is very large and for repairing that register is very difficult, then how i can do for traspasing the datas so the register can be skiped or how to do the load in another way?

     

     

     

  • April 12, 2005 at 1:57 pm

    #552232

    Increase the maximum number of errors allowed in the properties of the datapump

     


    * Noel

  • April 12, 2005 at 2:04 pm

    #552234

    where is the datapumb???

     

  • April 12, 2005 at 2:33 pm

    #552242

    do you see this


    * Noel

  • April 12, 2005 at 2:36 pm

    #552244

    sorry master, i cant see it

  • April 12, 2005 at 2:51 pm

    #552249

    Ok, This "image Feature" does not works  (as I assumed )

    so lets try describing it:

    once you have stablished the data transformation task between the Text File and the SQL Server DB

    - right click the transform arrow and select the Options tab

    - On Data movement change Max Error Count ( 0 by default)  to a higher value!

    hth


    * Noel

  • April 12, 2005 at 3:38 pm

    #552259

    thanks i did that but it continues with the same problem,

    my transformation uses  ';' like delimiter between fields but some register

    has a ';' of lack.

     

    i have increased the max count but my dts continues failing,

    mmm i put the max count in 100,   will exist above of 100 registers with problems?

    mmmmm but i think, is possible to manages the txt like a table?

    can i do a select to txt file? if that is posible i could to do the load with a cursor....

    thanks for your helping

     

Viewing 7 posts - 1 through 6 (of 6 total)

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