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

So the SQL command text is in a variable. How are you executing the command?

--edit

Are you executing the command through the use of an Expression?

A single package will do the job for you. An EXECUTE SQL task can be used to run the sp's. Followed by one or more dataflow tasks to export the...

Where are you entering the text of the SQL query containing the variable?