SQL Server Performance

Parameters in DTS Importing from Xcel Sheet

Discussion in 'SQL Server DTS-Related Questions' started by cnu77, Jan 6, 2004.

  1. cnu77 New Member

    I'm using Data Driven Query Task in DTS to import an Xcel Sheet into the SQL Server Database. I tried to use both Insert and Update in the Package. I also pass parameters to the Insert and Update Query. But I can't assign my own name to the Parameters. It takes default name as 'Parameter 1', Parameter 2',...,'Parameter N' when I click the "Parse/Show Parameters" Button. I used the "Look Up" Tab to specify the Query for the Parameters. But when I tried to use the Parameters for both Insertion and Updation from Xcel, I use different set of Parameters. But the Parameters built are in the same names.
    The possible solution will be to give name to the Parameters.
    Can any one help in this regard...
    Seenu.
  2. satya Moderator

    Can you define examples used to run DTS package.
    Is this a one-off requirement or continuous process?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. cnu77 New Member

    Thanx for ur Reply.
    I want to Import Data from Excel to SQL Server using DTS. The changes made in the Excel Sheet should affect the DB. I use Data Driven Query Task to accomplish the Task.

    Que 1: Can I use same Data Driven Query Task (DDQT) for Insertion, Updation and deletion?

    When I define the Params it gives its own name like 'Parameter 1', 'Parameter 2',...,'Parameter N'. I need to assign the new name for the params, bcos the Look Ups are same either for Insert Query or Update Query or Delete Query (that too same name).

    Que 2: While deletion I shall use seperate DDQT. I delete using ActiveX Scripting. Whatz the Script?

    Thanx
    Seenu.
  4. satya Moderator

Share This Page