G_M_J


How to remove quote marks using SSIS and a little C#

Introduction If you import flat files and use double quotes as your Flat File Text Qualifiers, then it’s likely that you’ve encountered problems when importing data where speech marks have been entered manually. This is a common occurrence in free text fields, such as Name. e.g. Smith, James “Jim” Attempting to import a file with a […]

4.83 (6)

2020-01-16

6,140 reads

Blogs

Daily Coping 5 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

cheap hennessy

By bion

Are you looking for quality Wine, Champagn,Hennessy or Heineken for your birth day party,wedding,events...

is Forced Parameterization usually more beneficial than less?

By VoldemarG

On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with...

Celebrating Lives

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Lives

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers