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