SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions.
I have a .dtsx file (an SSIS package) that downloads files from an FTP server and imports data. It runs …
ssis permissions sql-server-agentIve spent hours trying to fix this issue. For the column that's giving me the problem i am using a …
sql-server ssis dynamics-crm-2011I need to set the Folder in my Foreach loop to a variable location. I tried just adding the location …
sql-server-2008 ssis foreach-loop-containerI need to escape quotation marks in SQL Server Integration Services' Expression Builder. I cannot escape it with double or …
sql-server ssis expressionbuilderI am running SQL Server 2014 on my machine. I have installed SSDT for Visual Studio 2017, which I also have. Now …
sql-server visual-studio ssis etl sql-server-data-toolsThe error: There was an exception while loading Script Task from XML: System.Exception: The Script Task uses version 14.0 script …
ssis visual-studio-2015 sql-server-2014 vstaI have a CSV file - It has many values having comma as a part of value.The commas within …
csv ssis commaI'm building an ssis package and I wish to use an existing OleDbConnection inside the Script Component. Here is my …
ssis script-componentI have a very simple component which trims all leading and trailing spaces from (read/write) strings in a pipeline. …
sql-server ssis custom-pipeline-componentI'm passing a column of Json data to the script component to process. It went fine until I had a …
sql json ssis buffer script-component