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

4,812 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

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

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

Unique value constraint among active records

By CanuckBuck

I have a lookup table that implements a system-generated Id for DRI purposes.  The...

Textfield comparator.

By ben.brugman

A client would like to be able to recognize similar free-texts in a text...

Are there any free resources/ebooks to develop database design and modeling ?

By vijay41

  I want to develop my skills in database design and modeling. I found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers