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"
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.
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"
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"
