Using variable in Execute Process task

• MuraliKrishnan1980

  SSCrazy

  Points: 2497

  More actions

  April 15, 2011 at 5:21 am

  #389290

  Hello Friends,

  I am trying to implement BCP functionality using Execute Process Task.

  This is the scenario.

  I am reading the name of the table which has to be exported to a text file from a table and storing it in a variable.

  I have configured the Execute process task as follows.

  Executable: BCP.exe

  Arguments: @Source_Table out D:\Department.txt -c -T [@Source_Table variable has the name of the table which has to be exported]

  Success value: 1

  I am not really sure if i would have to select StandardInpurVariable or StandardOutputVariable.

  Please help me on this.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  April 18, 2011 at 12:12 am

  #1312605

  Duplicate post. Please refer to the following original thread with the solution:

  http://www.sqlservercentral.com/Forums/Topic1094033-364-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP