G_M_J


SQLServerCentral Article

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 […]

(6)

You rated this post out of 5. Change rating

2020-01-16

11,928 reads

Blogs

Chatting with Power BI: Who Benefits from This Conversation?

By

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

A Quick Look at Redgate Data Modeler

By

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...

Prepping for Certification, Part 2 of ?

By

The advantage of understanding the make-up of the exam: I can tailor my efforts...

Read the latest Blogs

Forums

SQL Server 2022 order by bug?

By hugo-939487

Hi, I was using order by on a column with characters and saw something...

SQL Server 2025 Build List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Build List

Filtered Indexes: The Developer’s Secret Weapon in SQL Server

By Chandan Shukla

Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...

Visit the forum

Question of the Day

Getting The Database Name

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E
At the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME()
GO
What is returned?

See possible answers