SQL Server Performance Forum – Threads Archive

Parameters in DTS Importing from Xcel Sheet

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.

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.

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.

For all your queries I suggest to review information available onhttp://www.sqldts.com which is a good resource of DTS especially. 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.

]]>