Viewing 15 posts - 16 through 30 (of 38 total)
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?
July 29, 2010 at 11:54 am
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...
July 29, 2010 at 11:50 am
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...
July 29, 2010 at 10:56 am
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...
July 29, 2010 at 10:45 am
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...
March 12, 2010 at 8:23 am
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...
December 5, 2008 at 8:09 am
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...
August 8, 2008 at 11:39 am
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...
July 1, 2008 at 7:39 am
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?...
June 25, 2008 at 8:46 am
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....
May 14, 2008 at 3:01 pm
Thanks all, turns out one of the DBA's who left was doing some replication tests. Problem resolved.
April 10, 2008 at 9:45 am
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
March 21, 2008 at 7:16 am
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
March 20, 2008 at 10:17 am
Viewing 15 posts - 16 through 30 (of 38 total)