Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: DTS package with parameters


    I want to create DTS package which can accept a parameter and export / import data which match the parameter value. is it possible? if yes , can you please tell me the steps.

    thanks in advance.

    Satya - do not refer me to , not much help there .


  2. #2
    Join Date
    Aug 2003
    Boston, MA
    I am not clear on what you are trying to do....

    What are the source and destination connections in both the import and export scenario.

    Are you trying to conditionally import or export data based on some Parameter? How are you executing the package?

    DTS packages can take input parameters and return paramters via Package Variables (inner and outer). You can use an Execute package task to pass parameters to a nested DTS package which contains your logic for import or export. Depending on the complexity of your process you could create one master package (to manage the process) and two "child" packages: one for Import and one for export.

    See books online for more info on the Execute Package Task...


Posting Permissions

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