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,969 reads

Blogs

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Daily Coping 23 Nov 2020

By

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

Read the latest Blogs

Forums

Query performance with ROW_NUMBER function

By vijayd

Hello All, Could any of you please let me know why the row_number paging...

multisubnet configuration

By abdalah.mehdoini

Good morning all , I am in an alwayson multisubnet configuration, the listen and...

Simple Recovery Model - Active VLFs cannot be truncated

By jdlayton83

Hi everyone, I am facing a strange situation. I've got 99% of VLFs active...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The ADF Case

See possible answers