Pass Parameter to DTS from Stored Procedure

[scottsanpedro]

Hi,

Can anyone point me in the right direction.

I have been trying pass a parameter from a stored procedure in a DTS package

I have used DTSRun with master..xp_cmdshell and have had no luck.

Many thanks

Scott

 

[JohnDTampaBay]

DTS packages use global variables not parameters. You can set a global variable for a package then execute the package using the sp_OA system stored procedures. What are you trying to set within the package?

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[yksvaan]

The command line string as outputted should look something like this

DTSRun /N "v3_dim" /F "c:\dw\prog\DTS\v3_dim.dts" /A "EBO_INI:8=PRODUCTION"

-name of variable is EBO_INI
- :8 tells variable is of variable data type String
-PRODUCTION is the value to pass

But be precise how you build up this execution string in your sp, so that all quotes are perfectly.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[scottsanpedro]

The idea is that i'm about to install a new credit card authorisation system on an Access 2000 frontend/SQL Backend system.
It works by the user entering in the specific details from the Credit Card, a text file is then created and placed onto a server, where the CC software will shoot it off for authorisation followed by another text file being created with authorisation results.
I want SQL Server to export a query from a table and create the specific text file and place on the server.
The text file should read one line only, no headers and comma delimiter.
Hope that makes sense.
I will try the above tomorrow.
Really appreciate your imput
Scott