Stack Overflow
Stack Overflow

Questions tagged [ssis-2016]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2016 is a part of SQL Server 2016 Data Tools

96 questions
10
votes
4 answers

Is it possible to delete a package within SSIS Catalog?

Seems it could not be done in SSMS. Does Microsoft actually provide this option for users to delete single package within SSIS catalog? Thanks. Best Regards, Mike
OysterSing
  • 165
  • 1
  • 1
  • 12
7
votes
3 answers

Delete statement fails when called from SSIS

I'm trying to orchestrate Snowflake from SSIS. I'm using an ODBC connection and the execute SQL Task. A truncate table statement works fine and the task completes successfully. Changing this to a delete, the task fails with the below error: failed…
Neil P
  • 2,920
  • 5
  • 33
  • 64
7
votes
2 answers

querying ssisdb to find the name of packages

i was querying the ssis catlog to find out the name of all the packages in the catalog. There are only 6 packages in the Folder1 project,but the query gives 9 records 1. SELECT P.NAME FROM SSISDB.internal.projects PRJ INNER JOIN …
user1254579
  • 3,901
  • 21
  • 65
  • 104
5
votes
3 answers

Execute Stored Procedure with multiple result sets

I am using SSIS 2016. I need to execute a stored procedure that returns 4 result sets. I only need to keep the first result set and write this to a table. I can not modify the stored procedure. I do not care about any of the data returned in the…
Chris
  • 53
  • 1
  • 4
4
votes
3 answers

Accessing a Configurable Value in an SSIS Script Task Static Constructor

I have an SSIS package with a script task that needs a 3rd party assembly. Since I am not allowed to place this assembly in the GAC on the SSIS server, I am binding the assembly at run time in the static constructor of the script task. This article…
mallan1121
  • 489
  • 7
  • 14
4
votes
2 answers

SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the SSIS Catalog, I receive the below error: Execute SQL Task: Error: Failed to acquire connection.…
Michael
  • 2,507
  • 8
  • 35
  • 71
4
votes
4 answers

SSIS Script Component not working when deployed. Complains about ComponentVersionMismatchError

A package with a Script Component that runs fine on SSDT (Visual Studio 2017) does not run when deployed to SQL Server 2016. It throws a ComponentVersionMismatchException. So, other packages work fine. This one has a data flow with a Script…
user2712166
  • 81
  • 1
  • 5
4
votes
1 answer

How to update activeX Script task

We are migrating some packages from sql server 2008 to 2016. But the ActiveX script task isn't loading correctly. I am very new with this tools. I would like to know how to update this kind of task. Thanks in advance
Hugo Gonzalez
  • 189
  • 1
  • 11
4
votes
3 answers

SSIS - package works in VS, fails with "Failed to compiled scripts contained in the package". There are no script objects in the package

VS2017, Deploy to SS2016. Package runs without any errors from VS. Project deployment to a server that previously had package deployments only - we're moving to project deployment, and DBAs said to use that. Getting many errors like: Get Error…
RBerman
  • 374
  • 4
  • 9
4
votes
2 answers

Run SSIS Package Without SQL Server Integration Services

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement. The problem statement is as follow: I am using SQL Azure database to store the data. I also have Azure VM from which I…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
4
votes
1 answer

Dynamic connection in Package Part Control Flow

I use SSIS 2016. I have created a Package Part Control Flow as you can see in this image : The perpose of this Package Part Control Flow is to have a loop on the all files in one folder and transfer all files to another folder. I have a Foreach…
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
4
votes
1 answer

In Integration Services Catalogs getting "Cannot access a disposed object." error

In Integration Services Catalogs I configured parameters of the project and pressed OK and then again when I am going to change the parameter configurations by right clicking on project and clicking on configure it gives me below error. TITLE:…
Naim Halai
  • 355
  • 1
  • 8
  • 27
3
votes
2 answers

Query SSIS Configuration In 2016 SSISDB

I need to query the SSISDB to view the configuration information of each package. I can easily view the package names and their folders but am unable to query the XML behind it and more importantly the Config information. Has anyone queried this…
PseudoToad
  • 1,504
  • 1
  • 16
  • 34
3
votes
1 answer

SSIS Expression Builder - How to find last occurrence of a character

I have values that look like this: D:\DM-250\Insert_Jobs-QA-UAT\14-FILE_A_UpdateInsert.dts D:\DM-250\Insert_Jobs-QA-UAT\Something_DaisyChain\14-stuff_and_things_UpdateInsert.dts D:\DM-250\14-another_file.dts I want the very ends of these 3…
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
3
votes
1 answer

Special character in Sensitive SSIS Package Parameter String renders package invalid

I have a Sensitive String Parameter on an SSIS Package that is used to store a password for a remote server. However, the Job Agent throws an error whilst configuring the Package Parameters of that step when the string value contains a curly…
wp78de
  • 18,207
  • 7
  • 43
  • 71
1
2 3 4 5 6 7