Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Exclamation Unanswered: DTS Package Manipulations

    Hi,

    How do I delete out 4 statements contained within a text file, each followed by a newline which requires to be deleted also. I have already performed a number of transformations to structure the txt file and insert it into columns in a table but noticed the following text randomly appearing throughout the txt file; there are 3 other statements simular to this also:

    res1 = 0, res2 = 0, res3 = 0, res4 = 0

    Server Host = irea3nbu002 <------ delete
    <------ delete
    media_id = IAP004, partner_id = *NULL*, version = 1
    Last edited by achillesUNIT; 04-26-07 at 12:06.

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    either use a staging (temp) table to import and delete from that table before copying to final table. or use a Activex step to open that text file with filesystemobject, read every line and correct it.

Posting Permissions

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