Menu
Cutty
  • Chryslers
  • Lutherie
  • YLSNED
  • About
Cutty

Tag: SQL

SSIS Text File Data Source Quote Delimiter

Posted on June 16, 2012February 19, 2015 by Iain 'Cutty' Carlin

I have an SSIS package that imports data from various comma-delimited text files that use quotes as the text delimiter.

The package works fine on my local machine, however when I deploy it to the server, the quote delimiter is ignored and all my data contains the quotes around the text. Worse, integer fields fail to convert as to SSIS it looks like the field is a string (“1”) rather than an integer (1).

Turns out that because the filenames of the text files are specified at runtime (they come from a variable in the database), the text delimiter field in the text file connection is also ignored.…

+

Recent Posts

  • Instrument Making Course
  • Jigging, plating and sanding
  • A building block….
  • Fridays are lutherie days!
  • Music is your art…

Categories

  • Chryslers (1)
  • Cutty's Blog (7)
  • Lutherie (38)
  • You Learn Something New Every Day (39)
©2021 Cutty | Powered by WordPress & Superb Themes