Hi all We are creating and saving the packages in server by using the c# code , The package has a source connection, it has textqualifier, I am setting the textqualifier as " (double quotes) When i pull or get the package from server to locally, the textqualifier as hexadecimal like _X0022_ instead of " Is there any settings in source connection to set the double quots as textqualifier.. Thanks Rama

Rama, The hex value for a double quote is x0022, so it sounds like this is just a presentation issue. The value is correct, and when you query it get a double quote value, but it is displayed in HEX just to confuse you. Just to prove the point evaluate the SSIS expression "\x0022". (As a minor aside, if you want a simple tool to play with expressions see SSIS Expression Editor & Tester)http://www.sqlis.com | http://www.konesans.com

An additional note to what Darren said. Prior to SQL Server 2008 SP1 Cumulative Update 6 the qualifier was stored as is (i.e. as " as opposed to _x0022_). See the details of this particular change in CU6 at http://support.microsoft.com/kb/977889/ Note that this affects column delimiters too. What this means is that you should not develop packages on a machine with CU6 (or later) applied unless the machine that you are ultimately going to be running the package on also has CU6 applied because the SSIS installation on that machine will not understand _x0022_ (take this from someone who, earlier this week, spent the better part of a day debugging this issue :) ). It sounds as though you are hitting this same issue so make sure that you are developing on the same build of SQL Server as you are running the packages on. To see what version of SQL Server (and hence SSIS) you have installed please consult SQL Server 2008 Build List. Hope that helps @JamieT http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Thanks Darren, Jamie When i Pull the package in my system it shows with ", when i pull the package from some other system then only it shows as hexadecimal values. May be some sp updates are missing in other systems.

Can anyone confirm whether this bug is fixed in SP2? It is not listed in the SP2 list of bug fixes, although the list of bug fixes seems to be missing a lot. http://support.microsoft.com/kb/2285068/

Can anyone confirm whether this bug is fixed in SP2? It is not listed in the SP2 list of bug fixes, although the list of bug fixes seems to be missing a lot. http://support.microsoft.com/kb/2285068/ Yes. Service Packs are cumulative - meaning that everything in a SP1 Cumulative Update (CU) will be included in SP2. Consult the SQL Server 2008 Build List for more infohttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me