SQL 2008 SSIS Question - How to insert a double quote. - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Lockhouse replied

3 March 2011, 13:48
Originally posted by Weltchy View Post

[Field A] + "\"" + [Field B]

Or for your example

"\"\"" + [Field with 345 as value] + "\"\""

Thank you that man.
Leave a comment:
Weltchy replied

3 March 2011, 13:42
[Field A] + "\"" + [Field B]

Or for your example

"\"\"" + [Field with 345 as value] + "\"\""
Leave a comment:
Lockhouse started a topic SQL 2008 SSIS Question - How to insert a double quote.

3 March 2011, 13:31
SQL 2008 SSIS Question - How to insert a double quote.

I don't usually post in this forum but I've got a quick SSIS question that I can't figure out.

I'm doing an SSIS data transform from an ADO.Net connection to a flat file and I'm using the Derived Column Transformation Editor to reformat a field. How do I insert a " (double quote) into the reformatted field? I can't seem to find any protection characters (""" or / etc) and there is no CHR function available so I can't use CHR(034). So how's it done?

For example - I want the field to look like ""345"" when transformed including the quotes.

Cheers
Tags: None

Working...

X