In case you missed it.

The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 “The partner transaction manager has disabled its support...

The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 “The partner transaction manager has disabled its support for remote/network transactions.”.

Solution: Click...

That is a great way to handle it.

Although I must say that I recently was able to test with the client network admin and indeed it was a permissions issue...

I will have to give that a try.

Unfortunately I am just contracting my services here and I do not have that level of permissions on the systems and network. So...

By the way.

I have no problem using File System tasks in the same package to move the file and rename the file using the UNC in variables.

It is...

Nope.

Any other thoughts folks?

Why can I not use a UNC in a Flat File Connection Manager?

The

UNC I am using is --> \\hal\QlikViewDocs$\Analytix\Circulation\SubscriberWriteOffs\SubscriberWriteOffs.txt

I've used an expression to set the connection...

Did you try setting the destination column to nvarchar?

Agreed to a point.

Often times there is not enough time to completely study and re-write someone elses work in set based logic and a fix is needed immediately.

You must agree...

In the while loop, looping through the memory table with the row count can be problematic at times.

For example; Make the table a real table not a memory table and...