How to import text files using a wildcard in the filename

From: Art VanDelay (art_at_xyz.com)
Date: 11/22/04

  • Next message: David Gugick: "Re: Run Multiple Stored Procedures in order with a script??" 
    Date: Mon, 22 Nov 2004 01:36:59 GMT

    I am trying to import IIS logs using a DTS package. I have everything
    working, except I cannot figure out how to tell it to do al the logs in a
    directory, instead of a specific filename.

    Also what would be the best way to make sure it doesnt import duplicate into
    the database? I dont see a good way to make a primary key.

    I selected the Date, Time, C-IP, and Stem and tried to make them a key, but
    it warns me: Total size of an index or primary key cannot exceed 900 bytes.

  • Next message: David Gugick: "Re: Run Multiple Stored Procedures in order with a script??"

    Relevant Pages

    • Manual replication through DTS
      ... We are using a dynamically created DTS package to do a complete push ... Error Help Context ID:0 ... Error Description:Violation of PRIMARY KEY constraint 'PK_Policy'. ... The DataPump task properties have not been changed, ...
      (microsoft.public.sqlserver.dts)
    • DTS Package Duplicate Checking
      ... occasionally the text file has duplicate records in it. ... the DTS package will fail and due to primary key ... I was thinking about removing the primary key constraints from the temporary ...
      (microsoft.public.sqlserver.dts)
    • DUP Primary Key
      ... I work in DTS Package and this DTS insert fileds from TXT file into any ... I need control with ON ERROR RESUME NEXT the error "Violation of PRIMARY KEY ...
      (microsoft.public.sqlserver.dts)
    • Re: IIS Logs Max Per Hour
      ... > Using a dts package to transfer IIS logs into a SQL ...
      (microsoft.public.sqlserver.mseq)