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.
…
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.…