I got GUID coming from Text file which I need to load in to Extract Layer. While doing so I am getting an error as I am unable to convert it to DT_GUID. I tried using Derived column and also Data conversion both failed. Is there a way to load the column to the table? Anand

Can you send an example? I just need a couple examples of the GUID column. I have had trouble with GUIDs in the past.Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers

What is the text format of the GUID? If you use an Derived Column expression (e.g. "(DT_GUID)MyGuid"), the expect string format includes both the enclosing braces and embedded dashes (i.e. "{00000000-0000-0000-0000-000000000000}"). You might need to reformat the string into this format so that it can be parsed. Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

Found the solution We need to use a derived column not a data conversion and add as a new column and in the expression type mention as (DT_GUID)("{" + ColumnName + "}") Worked for meAnand