SSIS Flat File Destination Setting Connection String to variable + string

I'm using SSDT 2016 and Sql Server 2014.

I am outputting a bunch of Flat Files with debug information during my import. For these I use Flat File Connection Managers. I have a project variable DebugOutputFolder.

I can't figure out how to set the Flat File Connection String to: @[Package::DebugOutputFolder] + "file1.csv".

Does anyone know how to specify that?

Answers


Find the Connection String property of the Flat File's connection manager, and click the ellipsis (...) button and create an expression.


Need Your Help

Selenium waitForElementPresent hangs in IE11

selenium selenium-webdriver internet-explorer-11

I'm trying to test a site with Selenium Grid via recordings from Selenium Builder. Everything seems to work for Firefox and Chrome on Windows and Mac, but I'm getting error messages when testing in

Socket.IO with Cordova not working on Device

angularjs cordova socket.io ionic-framework

I'm currently developing an Apache Cordova app with Ionic Framework that should communicate through a WebSocket and I use the Socket.Io library for it. Now when I run it on my desktop browser every...