I don't think SSIS 2005 supports xslx. Is this an Excel 2007 file? Have you tried saving it as a .xls file and importing it?

Yeah, they essentially map the columns in the file to output columns. That editor enables you to set column widths, specify filure or ignore on truncation, etc. BOL...

SSIS uses the ID to refer to the column.

Right-click on your flat file source and show the advanced editor. Go to Input and Output properties and select one of...

42 isn't the row number; it represents the column ID. Check the data in the file and make sure it agrees with what the package is expecting...

We'll walk around the building a couple of times, provided it isn't 20 below in winter. When it is nice, there is a golf course about a mile from...

This is exactly what I was looking for, thanks!!

Impulsiveness. Drives my wife crazy. I would think nothing of going out and dropping several hundred dollars on something. I'll walk by something at the store and...

Great topic!

The importance of maintaining good health really hit home after the birth of our daughter.

Myself, I bike 2 or 3 times a week. I usually don't go farther...

I would probably struggle with some of the quizzes described in this thread. On overall SQL Server knowledge, I would rate myself at 2/5, because there is so much...

I used to work in a different country and with a manager that kept telling me, he only needs 10% of a DBA. So who should we be scared of?...

My boss stuck her head up over her cube wall and looked around after I laughed out loud at this post....very well done! I'm sending this to the team....

Thanks all, turns out one of the DBA's who left was doing some replication tests. Problem resolved.

SAS; one physical controller w/ 2 ports.

There is an expansion cage taking up the spot wehre an extra CD/DVD drive would go, which gives us two more drives. Backplane is 2x4

Thanks much everyone, I certainly have a lot to think about. Appreciate the responses. Now I have to pass the hat for more disks....:D