Menu
Cutty
  • Chryslers
  • Lutherie
  • YLSNED
  • About
Cutty

Tag: SSIS

SSIS Toolbox missing in Visual Studio 2017

Posted on November 2, 2017 by Iain 'Cutty' Carlin

I have installed the Data-Tier Application Framework and SQL Server Data Tools for VS 2017 . I created a solution then returned to it a week later and the SSIS toolbox had disappeared.

I opened the toolbox window using View -> Toolbox but it was empty.

To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox – hey presto! it reappears.

 …

+

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

  • Lawson – A life in words and music
  • Instrument Making Course
  • Jigging, plating and sanding
  • A building block….
  • Fridays are lutherie days!

Categories

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