Hi

Firstly, Merge joins use sorted data sets, so take those out.

Secondly, Converting on the join is never recommended, and since you're converting to the same data type, it is very...

Hi AdrSHL

When you paste the data into Excel, select all the data and go to Data->Text To Column. Select Delimited, click Next. Select the correct delimiter, if it is a...

Hi Koen

I found the underlying problem.

I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user doesn't...

Hi Koen

I used a Flat File source component.

Thank you for your reply