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

5,186 reads

Blogs

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Default Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Default Credentials

Re-OPENing a Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Re-OPENing a Cursor

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers