Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello Guys ,
I am new to SSIS , i have got the task
where i have to get the xml response from the below URL and process the data to the SQL tables .
http://134.15.215.228:8080/xdsrouter?docName=GS_Client_010101 .


i am using XML source(kingwayssoft) as source and getting the xml response using HTTP connection manager and SQLdb as destination

i am getting the xml response correctly and able to process the the data to the SQL table .

but the next requirement is : i have to use "docName" as a parameter , because the document name will keep changing in future
http://134.15.215.228:8080/xdsrouter?docName={docName}
need your valuable help here ,

Thank you in advance .

What I have tried:

I tried to search some articles but no luck
Posted
Updated 26-Jun-18 23:37pm
v2

1 solution

Create a user variable that is set from the command line.

If you're running the ssis package from a SQL agent, you have to modify the command line to include the value to set to the package variable.

If you're running the ssis package from the DOS command line, you have to use the appropriate command line values.

If you're running the package from visual studio, just set the variable manually, and execute the package.

To pass the variable to the url, you have to use an expression that will append the variable's value to the URL.

When I get to work, I'll modify this response to include an example of the appropriate command line parameter.

In the mean time, google is your friend if you want to finger all of this out on your own. That's how I did it.

PROMISED UPDATE
=============================================
The following command line is valid for both running the package using DTEXEC on the DOS command line, or running the package from a SQL agent:

/FILE "\\fullpath\ssispackage.dtsx"  /X86  /CHECKPOINTING OFF /REPORTING E /SET "\Package.Variables[User::pkgMyVariable].Value";0117


The /SET parameter is what you'll be specifying for your file name.

If you're not running this package from an agent or with DTEXEC, this information does not apply to you.
 
Share this answer
 
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900