SQL Server Performance

Load file

Discussion in 'SQL Server DTS-Related Questions' started by Reddy, Jul 12, 2006.

  1. Reddy New Member

    Hi
    How can I load a text file into staging table in sql. Here am not sure what the file name is, user will be passing file name as a parameter and my DTS task has to load that file.
    How can I accomplish this, pls help.

    Thanks!
    "He laughs best who laughs last"

  2. satya Moderator

    You can use Global variables to pass the filename within the DTS taks, refer to books online andhttp://www.sqldts.com for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. Reddy New Member

    How can I dynamically select a file to load in my DTS package?
    How to work with global variable so that I can pass a file name to the BulkInsert task through a parameter from a SP.

    Thanks!
    "He laughs best who laughs last"

  4. Reddy New Member

    I have really no idea how to select a file for my bulk load task where file name will be given through a parameter of SP. Pls help its urgent.

    Thanks!
    "He laughs best who laughs last"

Share This Page