Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: Modifying the DTS package.

    I have a DTS package package1 which imports an excel sheet into my DataBase.ANd its saved and scheduled and running fine.Actually the excel sheet will be located daily @ c:\bruce\exceldata.But now we wanted to change the location of the file to c:\bruce1\new\exceldata

    So how and where can I change my package.

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

    how:

    Open the package (in EM) Double click on the Destination Icon. You should be able to set the file name there.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Using DTS designer as mentioned, from EM --> DTS --> Local Packages and double-click on the package which will open the designer.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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