OK, so ... what is your question?

A couple of lines of sample data will probably help people picture what you are trying to do.

OK what is the nature of the PK on the orders table - is it sequential/ascending?

(If it would help this problem) can you add any fields to either of the...

Can order rows be inserted/modified after creation? Or does this problem merely boil down to taking across order headers/details for those orders which do not already exist in the target...

I suspect that the error message is telling you the truth - setting IDENTITY INSERT does not mean that you can put NULLs into a PK field.

You need to double...

Of course I don't mind mate - spread the word!

What a bizarre thread. I will watch with interest for the next informative post 🙂

Sabyasm, have you ever been accused of plagiarism? :hehe:

Please provide more information of what you are trying to achieve, with examples, and ask a question or two, obviating the need for readers to try and guess what it...

The elaboration is that you need to provide a few more details about your data before anyone can help you in any detail. By 'delta', I'm guessing that you mean...

If you want to use a dataflow component and you want it to be dynamic in terms of field names / types, you'll not find a way using the standard...

So ... is it a text file? If it is, what is the problem? If not, you need to find out what sort of file it is and use the...

Can you have another go at writing out your question - be a bit more verbose...

Yuk, nasty. Easiest solution: change the field delimiter character to something else in the source data.

Otherwise (and this may not work perfectly), you could consider running a replace routine on...

Use a UNC path to get round the unmapped drive issue.

Ensure that the SQL Agent service user is a domain user which has at least read access to the folder...

I guess I'm just not understanding what you're trying to do.

What is the scope of your variable? It needs to be package level, not task level.

What is written to the...

I suggest that you change your approach slightly.

To get the variable evaluated as you want, you need to put the SQL into an expression (and the expression can use your...