Please find answer below if anyone is looking for it - 

foreach ($f in Get-ChildItem -path $PSScriptRoot -Filter *.sql | sort-object -desc) {   Start-Job -ScriptBlock { invoke-sqlcmd...

For reference, if anyone lands on this page, I have resolved this using C#. Script task - 

#region Help: Introduction to the script task
/* The Script Task...

Thanks Steve.. This helps. I could store data by triggering it to another table in same database.

Joe,

Thank you for your response, but if you please see the screenshot attached, i am already using remote login with property "Be made using this security context". Further...

Hi sorry guys,

I got the solution in the above script i have declared cursor as Static and local.

Be4 doing this i was getting error, 1s i declared it as static...