steveb. (12/8/2009)

---

You should be able to do this in SSIS,

however your description is not clear.

Here in example first column stars with '8' and fifth column '3' and...

Script task will do it in about 5 lines of code ...

If I understand correctly, you want the user to fire off a package which reads an Excel file from their PC?

Assuming that SSIS is installed on a network server and...

I would guess that those 'numbers' you are referring to are the number of days since 1/1/1900 (or 1899, or whatever the base date is) - which is how Excel...

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...