Bob,

Thanks alot, it worked, appreciate it.

thanks Bob, i changed it to $filename = "$instanceName_Configuration_$Date.csv"

and started the sql job with the same error i had before syntax error, i can run the script inside ISE without...

the error message i got from sql agent history is:

step Name1

Duration00:00:00

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Unable to start execution of step 1 (reason: line(14): Syntax error). ...