Stack Overflow
Stack Overflow

Questions tagged [ssis-connection-manager]

40 questions
3
votes
3 answers

Azure storage connection to Datalake G2 in SSIS using Access Key

Test connection Connection manger in SSIS to the azure storage using access key succeeded. While copying data using Flexible file task in SSIS throwing an error "[Flexible File Task] Error: Could not load file or assembly…
Equator
  • 77
  • 8
3
votes
3 answers

SSIS OLEDB Connection Manager - Unable to connect to a database (No database names appear)

I am trying to create a connection manager in Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT) for an integration services project. In the Connection Manager: The Provider is set to: Native OLE DB\SQL Server Naive Client 11.0 The…
dorian harley
  • 51
  • 1
  • 1
  • 4
3
votes
1 answer

Deploying custom SSIS connection manager failing with '...is not recognized as a valid connection manager type'

I have made a custom SSIS Connection Manager (.NET 4.6.2): namespace HelloWorldCm { using Microsoft.SqlServer.Dts.Runtime; [DtsConnection( ConnectionType = "HELLOWORLD", DisplayName = "Hello World Connection Manager", …
Charlotte Skardon
  • 6,220
  • 2
  • 31
  • 42
3
votes
0 answers

How to get SSIS connection which is defined using a custom connection manager

I am trying to edit a SSIS package from code using ManagedDTS dlls (and others) and I need to access one of the connections defined in the package in order to re-map the columns in one of the source components. The problem is that this connection is…
Boštjan Arzenšek
  • 31
  • 2
2
votes
1 answer

SSIS - Change between to ConnectionManagers without going through all the components to change its reference

I've used DataSource named HSV then decided to switch to an OLE DB connection with the same name. I've switched between the two in the ConnectionManagers section. But now all the components which once referred to the HSV connection have an error…
Dina Kleper
  • 1,949
  • 4
  • 17
  • 23
2
votes
1 answer

How to get the sql connection from dts config file in ssis package scripts

In our normal c# this is the way to get connection string from app.config SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DPTConnectionString"].ConnectionString); But how will achieve the same in vsts scripts using…
NAGARAJA H I
  • 149
  • 3
  • 11
2
votes
2 answers

Use SQL Server database table as to configure SSIS project parameters and variables

We would like to use a SQL Server table as a source for all connection manager values within SSIS. We would prefer to do this at the project level since many of our connections are already at the project level. We would like to be able to easily…
Caleb Fortner
  • 57
  • 9
2
votes
1 answer

change run 64 bit run time property to false on run time executing ssis package through sql server job

I have parent package and associated child package to be executed from sql server agent job but I am getting following error : * Source: xxxxx Connection manager "RedshiftODBC" Description: An ODBC error -1 has occurred. End Error Code:…
user2431858
  • 63
  • 12
2
votes
2 answers

SSIS Connection manager issue

I created a Project within SSIS it would take data from a table within a db, do a data conversion and then insert into a Excel spreadsheet. it was working fine with no issues for about a week but now I'm having issues with th e connection manager.…
sql2015
  • 591
  • 3
  • 13
  • 34
2
votes
0 answers

Can't read flat file in SSIS (but the live job still works!)

I have inherited a bunch of SSIS packages. In some of these packages there is a connection manager being used to grab a flat file. These flat files are downloaded daily from FTP and unzipped - then used in these packages. The packages are executed…
default_noob_network
  • 1,204
  • 3
  • 19
  • 39
1
vote
1 answer

Copying parameters and connection managers from one SSIS Package to another

I have an SSIS package with some parameters and connection managers that are parametrized using environment variables What I need to do is to come that ssis package, change the name and few other things and deploy it as a different package. After…
AndreA
  • 779
  • 9
  • 22
1
vote
0 answers

SSIS Connection Manager - retry connection after failed attempt

I am wondering if there is a property from the connection manager or a straight forward way to retry the connection in case of timeout. I am experiencing a random connection error when trying to connect to a webservice. I've checked that if I…
Cristina
  • 159
  • 3
  • 16
1
vote
0 answers

SSIS DataFlow Script Component Oracle and SQL Server Connection Managers Get Confused

So... I've got an SSIS Package that creates and runs SSIS Packages in memory. The "meta" package creation happens inside of a DataFlow Script Component that is set up as a Destination. The basic gist is to pull data from one or more Oracle…
Brandon Meyer
  • 121
  • 1
  • 6
1
vote
1 answer

SSIS connection manager cannot find my SQL Server database

This is my very first step in SSIS and I am trying to migrate data from an excel sheet into my database. I am following different tutorials and I am at the point where I need to set up my destination. Therefore through Connection Manager I try to…
Tarta
  • 1,729
  • 1
  • 29
  • 63
1
vote
2 answers

Performance issues of a data transfer between Oracle and SQL Server using SSIS

I am trying to design a process that transfers data from Oracle to SQL Server 2016 by using SSIS. It is done with the aim of removing productive processes from an SQL Server 2000 instance, where the transfer had been realized with a Linked…
Jennifer Fuss
  • 43
  • 10
1
2 3