Isn't there a Text Qualifier in the connection manager where you value " when all your imported columns are quoted, or when you want you exported columns quoted?

Was the package built using drive letters for your login? Does the account running the SQL Server Agent have permissions to the files and folders involved?

I opened the script in Notepad++ and said show all characters and there's no special character there. Only when I click Open in the Agent Job Step and browse...

The special character didn't translate in my last post. It was black and diamond shaped with a white question mark inside it.

Found the problem and fixed, but I don't know hows or whys. When I added the code to the Job Step by selecting Open and browsing to the .ps1...

Yes the script runs successfully on the sql server when run from windows explorer: right click>Run with Powershell and from CMD.

Those script weren't finding any Excel processes.

But I tried this and it works:

For Each p As Process In Process.GetProcesses

If p.ProcessName = "EXCEL" Then

...

This must be all about me having a 64-bit client and running 64-bit Office 2010. I only leave Excel running in the background when I execute the package from...

That's possible that DBS 1,2,3... run successfully and the failure on db10 failing fails the job. A job scheduled from a maintenance plan only has one job step. But I...

Funny. I didn't think db1, db2, db10 were the real database names.

Is the path and file name too long for whatever data type Maintenance Plans is using?

Try backing up to d:sql_backup\dbname\

tx_id is not the same when the curser is run. Each record get's its own sequential tx_id for a CLOS transaction type:

tx_date ...

The cursor works. The max(tx_id)+1 does not get incremented when you comment out the insert and just display the results.

So I'm not crazy or lazy using a cursor in...

I read elsewhere that since a flat file is a text file, if you use a Text Qualifier it will be applied to every column.

So here's what works... remove...

Yea, they are empty string before the derived column transformation

and NULL after the derived column transformation.

And the result is all columns quoted.

Screen shots are attached.

In the attached gifs you can...