DW.dbo.orders out \\SQLD003\Mart\Backup\NewChanges\orders.bcp -c -m1 -S SQLD003 -T
here the table orders data is stored through BCP in the shared folder
\\SQLD003\Mart\Backup\NewChanges\orders.bcp sqlD003 is the drive and the same server is passed as the parameter for the bcp as -S SQLD003
So my question is how to change the server names dynamically in the QA and PROD, I am using this in the execute process task.
In the execute process task-> parameters I have written this code
DW.dbo.orders out \\SQLD003\Mart\Backup\NewChanges\orders.bcp -c -m1 -S SQLD003 -T
so the server on which this backup takes place has to be taken dynamically at runtime.
It is very urgent.