>>I have only tried to use SSIS twice now, and both times it has errored out.
>>
>>I'm trying to import an Excel file into SQL. This should be a no-brainer. MS has again made what used to be a really simple task into something overly complex.
>>
>>I followed this well clear, written example: http://blogs.techrepublic.com.com/datacenter/?p=205
>>
>>When I run my project, the SQL Server Destiantion object turns red and the output is
>>
>>

>>SSIS package "Package.dtsx" starting.
>>Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
>>Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
>>Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
>>Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
>>Error: 0xC0202009 at Data Flow Task, SQL Server Destination [14]: An OLE DB error has occurred. Error code: 0x80040E14.
>>An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E14  Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT              ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.".
>>Error: 0xC0202071 at Data Flow Task, SQL Server Destination [14]: Unable to prepare the SSIS bulk insert for data insertion.
>>Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "SQL Server Destination" (14) failed the pre-execute phase and returned error code 0xC0202071.
>>Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
>>Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
>>Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "SQL Server Destination" (14)" wrote 0 rows.
>>Task failed: Data Flow Task
>>SSIS package "Package.dtsx" finished: Success.
>>

>>
>>This Excel file has nothing but text in it. 6 columns, no datetimes or int's. All Text.
>>
>>This shoud have been Click - Done. Instead I get this.
>>
>>WTF???
>
>I've given up trying to use SSIS for excel imports. SSIS makes assumptions based on sampling the spreadsheet as to what type of data is in a column, and it doesn't care what you tell it.
>
>I've switched to using Access to upsize an Excel spreadsheet into a SQL table. That is the only real use I have ever had for Access.

I just did it using Access & Upsozing Wiz - Worked like a charm

Thanks Bill.