Integration Services

• Topics

  Started by

  Posts

  Last post

• Moving an SSIS .dtsx from one server to another

  I have a ,dtsx package stored in a folder and trying to move it from one to server to another. The …

  juniorDBA13

  29 replies

  1 year, 10 months ago

  By: MarkP

• Import data from REST API using SSIS

  Dear, Our company uses third party application for company expenses. For example, Webexpenses. We h…

  a2zwd

  2 replies

  1 year, 10 months ago

  By: kaj

• Powershell task completes successfully but doesn't actually work.

  Hi I hope someone can help me. I've been running an SSIS script inVs 2015 for several months and it…

  steve.alston

  3 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Changing Connection Managers with the Configuration Manager

  OK, this actually not a question, this is in response to a question I got in DM from Phil Parkin, a…

  Thom A

  6 replies

  1 year, 10 months ago

  By: SP

• Package runs in Debug mode but fails otherwise

  Hi We have a SSIS package that uploads data to Blob storage. The package is used by multiple agent …

  Alexp012

  1 replies

  1 year, 12 months ago

  By: Jo Pattyn

• Parameter error message

  Has anyone experienced this error message: There is no appropriate variable in the current environm…

  Pete Bishop

  1 replies

  1 year, 12 months ago

  By: Pete Bishop

• SSIS Package started failing for no obvious reason

  I've been troubleshooting this for hours now and have run out of ideas. I have a package which has …

  Phil Parkin

  8 replies

  2 years ago

  By: Roland Whitley

• Retrieving Active Directory information

  I have a requirement to process AD information through an SSIS package and have hit a problem with …

  Pete Bishop

  1 replies

  2 years ago

  By: Ant-Green

• SSIS Package runs on VS but not with SQL Server Agent after deployment

  Hello there! I am trying to run a .dtsx package that fills excel sheets using c# and then format th…

  Khattab19

  1 replies

  2 years ago

  By: Phil Parkin

• Incremental package deployment from project not working

  Based on the Help About in Visual Studio this is my VS configuration: Microsoft Visual Studio Enter…

  latkinson

  6 replies

  2 years ago

  By: sgmunson

• SQL 2019 SSIS Package - Flat File Destination Custom Property - Header

  Is there any easy way to programmatically set the value of the Header "Custom Property" of a Flat F…

  sgmunson

  1 replies

  2 years ago

  By: sgmunson

• script language different depending on user

  I've installed visual studio community 2019 on local machine and I can see 2019 language in the set…

  Bhagat

  1 replies

  2 years ago

  By: Bhagat

• Stored Procedure & API Calls

  Quick question about architecture design ethics. How good / bad would it be to call scripts on the …

  plalonde

  4 replies

  2 years ago

  By: Grant Fritchey

• How to keep For Loop Container continue on error?

  Hi all, So I found a solution of a problem I was having with For Each Loop Container in my SSIS pac…

  Jobs90312

  1 replies

  2 years, 1 month ago

  By: Jobs90312

• Oracle connection failing with "Microsoft OLE DB Service Components", "Access is Denied"

  Hello I'm using SSIS 2012, oracle 12 client on Windows 2012. We created a simple package that only …

  Ken Jr.

  3 replies

  2 years, 1 month ago

  By: kay.doggett