$tables = @("ProductType","CurrencyMaster", "Cards", "Transaction", "Transaction_Int", "Payment_Token") for ($i=0; $i -lt $tables.length; $i++) { $table = $tables[$i] $fmtOut = "AlexisManualQA.dbo.[${table}] format nul -f ${table}.fmt -n -S PTSMAIN -U gpspl -P yW2S6KXdY8" $bcpOut = "AlexisManualQA.dbo.[${table}] out ${table}.bcp -n -S PTSMAIN -U gpspl -P yW2S6KXdY8" Start-Process bcp -ArgumentList $fmtOut -Wait Start-Process bcp -ArgumentList $bcpOut -Wait }