Oh.. i didnt know i needed the error output for each component. I tried just for the text file source previously...this time i did it with the DB destination and...

That seems to be alright.

A self join does do the trick.

Thanks

The results are output in an excel report.

When it is output in that format, it is not ridiculous anymore. The clarity of data is what is achieved, and what I...

Yes, absolutely. Everything is done with an SA login

Yeah, I did mate. It ran fine.

Ok, the 2 profiler statements are EXACTLY the same, but essentially are the same, since the params are the same.

The 2 statements are:

1. when hard code:

EXEC USP_DTS_BatchFile_FraudCheck 'D:\FTP\RPIBatch\Output\'

2. when...

Yes, that is correct

I checked via Profiler, and the parameters plus the query itself is correct. I ran what was in Profiler in Query Analyser and that is working fine, taking its sweet...

I checked everything.

What I think may be causing the problem, is that in certain places, there are NULL characters instead of SPACES which may be causing the unnecessary truncation.

This program would then be something like a service then, isn't it?

I had a look and found a File Watcher Task on SQLIS.COM, which sort of does what I want,...

I didn't need to use the FOR EACH block, but for the moment, it picked up the text file.

But what I noticed was that it wasn't copying all the data...

Coolies...thanks for the responses guys; I reckon as Steve said that double cursor approach would be pretty performance hungry. I will try the method suggested by CK as I have...

I hadn't thought about using a function to loop n times. But that is a good thought actually.

And it may be faster as well. Actually, I think it will definitely...

Yeah, I was just thinking about the speed of the query. With so many joins, it would definitely affect the performance. But yeah, indexing should limit the damage.

When the value...

Hmm...looks interesting. Join the table with itself.

Yeah, seems viable for this instance. Will check it out and see how it goes.

Thanks for your help mate.

Cheers.