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

As this is all happening within the domain of SQL Server, I would be considering other means of achieving the same result if I were you. I'm thinking that all...

RBarryYoung (9/30/2009)

---

No, you should get...

If you are asking for help writing SQL in Access, why are you posting in a forum for SSIS?

Does your spreadsheet have a header row? If so, but you have defined the connection to the spreadsheet without specifying a header row, I think that this error can appear.

Yes, that should work. If you decide to do that, I would suggest putting a uniqueness constraint on that combination in SQL Server, to avoid any possibility that duplicates can...