Stack Overflow
Stack Overflow

Questions tagged [ssis-connection-manager]

40 questions
1
vote
1 answer

Use an already created connection in "Connection Managers" into Biml script

I have an already source connection in SSIS "Connection Managers". It is a custom connection (not a oledb or any other standard connection types). Is it possible to reuse it (i.e call it) in the Biml script without writing the connetion string…
Ziad Salem
  • 496
  • 13
  • 34
0
votes
0 answers

SSIS - Cannot connect to excel source and load any views or tables. Visual studio version 2022

I have a problem when importing data in SSIS from an excel source. I have the Visual Studio Professional 2022 installed and excel’s version is Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20214) 32-bit. My system type is…
Bich Le The
  • 27
  • 8
0
votes
0 answers

I have an SSIS package with a SQL Task and a Data Flow Task and both are throwing connection errors

I have a SSIS package that I am running in VS2015 for testing. I connect to 3 different databases on 2 different SQL instances (default and a named instance). Running SQL2019 Standard. Any connection to the default instance run just fine. Any…
mikegrove
  • 1
  • 1
0
votes
1 answer

Can't save the password in connection manager in SSIS package, it's replaced with *** (stars) after publishing

I have a SSIS package shifted to ADF, it's connected to Azure SQL Server, but every time I publish, the password in connection manager is being replaced with ********** star symbols. - obviously its impossible to connect to DB after that and I…
Ewa
  • 53
  • 1
  • 6
0
votes
0 answers

SSIS Error: ADO NET Source failed to acquire connection - Could not create a managed connection manager

I am unable to execute my SSIS package in Visual Studio. I am guessing that it might be some kind of a compatibility issue as things were running fine before my software upgrades. I have used a ADO.NET connection manager to connect to Azure SQL…
Ankit Das
  • 11
  • 4
0
votes
1 answer

No Tables or Views when Connecting to Excel file in SSIS

Visual Studio 2019 Excel 365 64-bit Excel file has a single worksheet named raw_products I added a Data Flow Task to my Control Flow Added Excel Source to the Data Flow Opened the Excel Source and clicked "New" to create a new connection…
Dizzy49
  • 1,360
  • 24
  • 35
0
votes
0 answers

Can connection abort in J1939 for any request be destination specific?

When any one requests to vehicle with PGN 0xEA00 in J1939 what are the possible reason for connection abort 0x255 in connection manager? And will this connection manager be destination specific? -> Detailed reason for COnnection abort -> If…
Saajan sahu
  • 13
  • 3
0
votes
0 answers

SSIS Read File With No Column Names

Alright so I am not sure how to go about this, I have files that will be coming in a format like this that I need to read into a SQL Server database: As you can see, it is "~" delimited and it contains no columns names at all. I will have multiple…
Coda759
  • 107
  • 14
0
votes
1 answer

SSIS 2019 Package which imports Excel file creates an empty file if it isn't in the expected folder

I have a SSIS 2019 Package which imports an Excel as soon as the file is placed to a folder and then moves the Excel file to another folder (agent will run it every 30 minutes). At the beginning I have a Script Task which tests if the file is in…
Mike Myers
  • 33
  • 1
  • 7
0
votes
1 answer

Empty error while executing SSIS package in Azure Data Factory

I have created a simple SSIS project and in this project, I have a package that will delete a particular file in Downloads folder. I deployed this project to Azure. And when I am trying to execute this package using Azure Data Factory then the…
Robin
  • 85
  • 2
  • 12
0
votes
1 answer

SSIS Exit Sequence Container Following Error Is Not Releasing Excel File

I have an SSIS package that has been working without issue for some time, but due to changes in our company infrastructure, we have had to make some changes. In simple terms, the SSIS package reads a table containing a list of files that will…
MartinS
  • 111
  • 1
  • 14
0
votes
1 answer

How to Remove All Database Connection Dependencies in an SSIS package

I have an SSIS package that contains a connection manager used for logging. The logging service has been deprecated and I have been tasked with removing references to it from the package. Before I delete the connection manager, I need to remove all…
Riggster
  • 107
  • 3
  • 15
0
votes
1 answer

How can i pass database name dynamically in ssis execute sql task

In my server there are multiple databases. Hence having multiple connection manager for each db on server. Would like to pass database name as parameter in executesql task, so that I can reduce the no of connection managers. Something like below…
vignesh
  • 1,414
  • 5
  • 19
  • 38
0
votes
0 answers

2016 SSIS Package- Duplicate connections

We have noticed the SSIS packages has created duplicate connections in the package , not sure when we open the solution the package was trying to connect to the server credentials and unavailable due to the passwords and had created a duplicate…
user15014142
  • 1
0
votes
1 answer

finding network connection type using the library connman (connection manager) and function connman_service_get_type

I want to write a c code to display the network connection type in ubuntu.I found a library called connman (connection manager) and also i got a function connman_service_get_type for getting the connection type. But i don't get how to use that…
Athira GS
  • 9
  • 2
1
2
3