Sql Server Import and export

I am trying to import from an excel spreadsheet into a sql server table. However, It fails because of one of the columns in the excel spreadsheet is a value that needs to be converted to a uniqueidentifier. The values in the spreadsheet look like this 0EC16729-5097-41CD-9556-0003BAE5954A

Wrap the string in braces { } or switch to a .net provider for the sql load.
see:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ca4fd844-431f-4fa5-9762-443c994162f9/convert-from-unicodestring-to-uniqueidentifier?forum=sqlintegrationservices

I don't think the dialog you have quoted is relevant to the problem - you are getting a failure when the key is being loaded and the error message implies the table definition does not match the content of the excel column.

first I would try removing the dashes from the excel data, the example looks as though it should be a hex number and the dashes will make it appear as a string.

Instead of using a excel spreadsheet , I tried importing a table with one column of varchar to a table with the column as UniqueIdentifier and it still didn't work. I just don't understand why the conversion does not work in Sql Server Import and Export. it certainly works when I just T-SQL in a new query window and by simply just doing a regular insert of a string into a uniqueIdentifier and it converts right away.

Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "PID_NO" (45)" failed because error code 0xC020907F occurred, and the error row disposition on "output column "PID_NO" (45)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Data Conversion 0 - 0" (37) failed with error code 0xC0209029 while processing input "Data Conversion Input" (38). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps.
It is …

The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …