Is the PK an IDENTITY field? If so, you'll have to enable IDENTITY insert.

bitbucket-25253 (10/21/2009)

---

Phil did...

I just expanded my testing to include cells populated via drop-down and these worked fine too. So there must be something more to this ...

bitbucket-25253 (10/21/2009)

---

1. Check those cells to see if they contain a formula

If they do then

2. Check Excel help for "Replace a formula with its result"

Unfortunately the only...

That's too complex for anything but the Script Component - I suggest you concentrate your efforts there.

Except for your post, the word 'wizard' appears nowhere in this thread.

Siddharth Mehta (10/21/2009)

---

Not just Union All, there are other components that would have the same issue in case of duplicate column names. Its a better practice to keep column names...

Siddharth Mehta (10/21/2009)

---

Step 1: copy the entire data from your spreadsheet

Step 2: Use the option of Edit Top 200 rows by right-clicking the table in SSMS

Step 3: Paste the data,...

I suspect that you need to use SQL syntax which is supported on DB2.

Check here and search for INSERT as a possible resource to get you through this.

You have left the reader to face unnecessary challenge number one: "What's the question?" It would appear to be: "How do I get the data to transfer too?" But as...

I just (yet again) ran into this Excel 'feature' and it managed to irritate me just as much as it always has.

This time, however, I tried a different solution: I...

So you are adding data to an existing table using SSIS and it is in this table that you would like to auto-increment department?

Why not use an IDENTITY field on...

Try specifying a UNC path rather than a drive letter in the path to the exe.

Great - thanks for the feedback.

Use an Expression to set the Filespec (from memory) property, rather than typing the variable stuff directly in to the property ...