Professional Web Applications Themes

DTS import csv - dynamic file name - Microsoft SQL / MS SQL Server

I have an asp application where a user can upload a .csv file. The file name will be different each time. I need to know how to change the source file name the package ps into a specified table. Right now the package looks for a specific file, but it will be different each time. Thanks in advance....

  1. #1

    Default DTS import csv - dynamic file name

    I have an asp application where a user can upload a .csv file. The file
    name will be different each time.

    I need to know how to change the source file name the package ps
    into a specified table. Right now the package looks for a specific
    file, but it will be different each time.

    Thanks in advance.
    Jennifer Guest

  2. #2

    Default Re: DTS import csv - dynamic file name

    Assuming you have SQL Server 2000, you can use a Dynamic Properties task to set the file name. The file name can be passed in through a global variable.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Jennifer Smith" <com> wrote in message news:com...
    I have an asp application where a user can upload a .csv file. The file
    name will be different each time.

    I need to know how to change the source file name the package ps
    into a specified table. Right now the package looks for a specific
    file, but it will be different each time.

    Thanks in advance.

    Tom Guest

  3. #3

    Default Re: DTS import csv - dynamic file name

    Sorry - I should have mentioned I have sql 7.
     
    Jennifer Guest

  4. #4

    Default Re: DTS import csv - dynamic file name

    In that case, you can replace the Dynamic Properties Task with an equivalent ActiveX Script task to set the file name based on the global variable.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Jennifer Smith" <com> wrote in message news:com...
    Sorry - I should have mentioned I have sql 7.
     

    Tom Guest

Similar Threads

  1. CIB file will not import.
    By Tim_Fink@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: November 10th, 08:26 PM
  2. File - Import (.dxf)
    By bert68 in forum Macromedia Freehand
    Replies: 2
    Last Post: November 29th, 08:14 PM
  3. FileIO for dynamic Runtime import?
    By Jeff in forum Macromedia Director Basics
    Replies: 7
    Last Post: November 13th, 04:45 PM
  4. Import .MDF file
    By Ad Bec in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 1st, 10:13 PM
  5. Import a .dmp file
    By Linda in forum Oracle Server
    Replies: 3
    Last Post: December 7th, 08:10 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139