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

The problem you are having is that the table needs to exist before you can create the required mapping meta data.

But there is a way round this:

Allow the build task...

OK, now we're really getting somewhere 🙂

I will tell you what I would do - others would certainly have their own ideas.

1) Build the destination table now, including all of...

You have not answered all of my questions, so it's difficult for me to answer.

Does your destination table already exist? If so, what's the problem? Just go ahead and import....

Yeah, the meta data issue is going to make this a tough job for you, because you need a dynamic data flow and SSIS isn't good at that.

Cozyroc has an...

This is an unusual requirement - let's make sure I understand.

Say your input file has 10 columns and, out of those, 8 columns contain only nulls.

You want to load...

ar-727381 (9/23/2009)

---

i cannot untick them because there are around 40 columns with 100's of rows in the csv file. so checking if a column is null or not is not...