I know this may be considered as blasphemy and I can barely believe I am suggesting this on here, but you could use a lightweight ORM like Dapper for CRUD...

This is a good article for how to use a compenent that is very badly documented in Books Online and everywhere else. I used the Script Component transformation to "condense"...

You are exactly right - i want to compare a field in the current row to a calculated value from the previous row.

I had actually tried something similar in a...

I've actually found my problem and it wasn't the instr function at all. That worked fine.

It was a second condition in the IIF statement that was comparing an integer to...

Actually it is #Error i am getting not a blank.

I'm thinking i may need to do some data type conversion in the expression.

I'm struggling with the same issue. You mention you have a solution and a blog? Any chance of letting me know where I can see this info?

Thanks in advance,

Matt

Thanks for letting me know.

Thanks for the links. It's always useful to build up examples and best practices. I have actually merged using the first technique - pre sorting as the data is taken...

day,

i'm trying to do an update after doing a merge join. Surely the method you have described updates one row at a time? I've got millions of rows so this...

SSIS and utilising how to load and export dynamically isn't the most intuitive tool. I would suggest the two things you should start looking into are using variables (in the...

Thanks for all comments. I know what you mean about it not being a reference - it isn't. But then again i've been using SSIS for a while and know...

Just to let people know I have bought the Expert SQL Server 2005 Integration Services from Wrox. The review on Amazon for Professional SQL Server 2005 Integration Services didn't seem...

Has no one bought a specialist book on SSIS? I find it hard to believe. Help is needed urgently.

To be totally honest i'm not thinking of packing in the certification just because i won't use it on a day to day basis, but it will be harder than...

I am a developer so from a point of view of how the servers are set up i haven't really been factoring it into my consideration. Apart from the fact...