$SqlConnection = New-Object System.Data.SqlClient.SqlConnection "Server=tc201\mssql;Database=master;Integrated Security=True" #"server=atthomas-pc\mssql2017,1434;database=mdb;user=XXXXX;Password=XXXXXXXX"
$SqlConnection.Open()


$sqlCmd=New-Object System.Data.SqlClient.SqlCommand
$sqlCmd.COmmandType = [System.Data.CommandType]::StoredProcedure
$sqlCmd.CommandText="DY2025.dbo.spGTS_Export "
$sqlCmd.CommandTimeout = 300
$sqlCmd.Connection = $SqlConnection

$sqlCmd.ExecuteNonQuery() | out-null 

$SqlConnection.Close()

#we specify the directory where all files that we want to upload  
$Dir="f:/tco/gatcs/exports/GTS/"    

#ftp server 
    $ftp = "ftp://ftp.govtechtaxpro.com" 
    $user = "effinghamga" 
    $pass = "bf4DyFfw!"  
    $folder = ''

$webclient = New-Object System.Net.WebClient 

$webclient.Credentials = New-Object System.Net.NetworkCredential($user,$pass)  

#list every sql server trace file 
foreach($item in (dir $Dir "gts_main.txt")){ 
    "Uploading $item..." 
    $uri = New-Object System.Uri($ftp+"/" +$folder +"/"+$item.Name) 
    $webclient.UploadFile($uri, $item.FullName) 
 }