The $Z line will always be the last line in the file and need to get the value from $X into my output before cleanup of that line.

Thanks.

Each file has what I'll call a total line(Last line to me).

$M00000000,$F000000,$J08,$V1000,$f000000,$m0000000,$n0000000

$M00000000,$F000000,$J08,$V1000,$f000000,$m0000000,$n0000000

$M00000000,$F000000,$J08,$V1000,$f000000,$m0000000,$n0000000

$M00000000,$F000000,$J08,$V1000,$f000000,$m0001274,$n0001274

$Z,$I RW6 ,$N 1 ,$G201120,$H141340,$M00000000,$F000000,$X0000001240,$U0000

I want the value from the $X(lastline of file) only, appended to my output file...

Thanks for suggestion.

"DECIMAL(18,10) means 8 digits to the left of the decimal point and 10 to the right.  That seems like a very strange datatype for an "order quantity' column.  It would...

update tbl

set exportfilename = REPLACE(exportfilename , 'devserver', 'prodserver')

where exportfilename like (%devserver%)

not sure why I thought it was diffcult

update tblset exportfilename = REPLACE(exportfilename , 'devserver', 'prodserver')

where exportfilename like (%devserver%)

Thanks sorry..

That works perfect.

Many Thanks.

any way to trap errors in SP's so if one fails the process stops?

Thanks.

Any to trap if errors before running next SP.

$ServerInstance = "MyServer"
$Database = "MyDB"
$ConnectionTimeout = 30

$Query = "selectrow","truncateid","selectrow"

$QueryTimeout = 120

foreach ($Q in $Query){

    $conn=new-object System.Data.SqlClient.SQLConnection
...

Any examples or ideas to make this requirement?

Thanks.

Instead of reading .sql could it read a .txt where multiple sp's are defined and stop if anyone of the procedures has an error?

spload.txt  --> PS script reads

content:

usp_sp_import_ac_conv  -- if...

Nice..

I want to have a common module that from a command file have be able to supply

RunSP  -Instancename localhost -Database stagingdatabase -Sp 'usp_sp_import_csv' -SpOutput 'C:\importcsv.log'

Then from command file be able...

I have been running the Batch Deletes using the MailID, and deleting 10,000 at a pass. It deleted 3/4 million records

in 8 minutes, and 1.5 million in 10 minutes on...

I got delayed on this, but wanted to give an update:

I'm trying to put together my test environment to begin the deletions.

Thanks.

This is what I'm doing "If you want to simply guarantee such operation, use the sent date to find the PKs and store them in a separate table and then...