You don't have the Excel file open, so it is locked?

dg227 (4/19/2011)

---

Another easy way to pull just header data is to do a conditional split off of the flat file source based on some sort of identifier in the header...

There is a query builder that you can use. That way you don't have to worry about syntax.

I would advise you however not to use SELECT *, but to specify...

Thanks, this will be stuck in my head for the rest of...

Please don't crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1095345-148-1.aspx

The space in the name is possibly the issue.

Try writing a SQL query to your Excel file instead of just selecting the sheet name in the dropdown list.

There you can...

Check out this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ca1225ff-fe3d-4c97-9ebe-5febda95741b

😉

If you place different Flat File Sources into one dataflow, you can read out the necessary columns for each table.

So if you have 5 destination tables, use 5 different Flat...

Well, there is your problem. It is not a business key, as it does not uniquely identify a record. So...

Nice question, thanks.

WayneS (4/18/2011)

---

Well, yes. I'm overly sensitive to them (normal mosquito bites look like a welt), but I think that was a spider bite. I'm actually able to close my hand...

WinRar is free as opposed to WinZip?

Is it possible to split a .zip file in multiple compressed files, as is possible with .rar?

Since you are using excel 2007, did you modify the properties of the JET provider or of the ACE provider in the registry?

I think one should not put too much faith in the SSIS GUI 😀

To really test your package, run it from the command line with DTEXEC. If it finishes OK...

Duplicate post. Please refer to the following original thread with the solution:

http://www.sqlservercentral.com/Forums/Topic1094033-364-1.aspx