Skip to main content
46 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-1 votes
1 answer
77 views

I have following problem: I use a variable: Server=DESKTOP-156DAO6\FILEWATCHERSER;Database=testDb;User ID=florian;Password=test123321;TrustServerCertificate=true;Trusted_Connection=False for ...
Florian Berwald's user avatar
  • 1
0 votes
1 answer
47 views

I am trying to set up a Variable Called ServerName in my SSIS package. I need the variable to render the name of the server used in the connection string from the connection manger named "...
Working_at_It's user avatar
  • 19
0 votes
0 answers
13 views

I've been copying a dtsx package that contains nearly all Execute T-Sql statement tasks. The engineer who built this sadly died in December, I'm just trying to do what needs to be done for my team's ...
Phteven's user avatar
  • 139
1 vote
1 answer
1k views

I have upgraded from VS2019 to VS2022 and none of my ADO.NET connection mangers no longer work. My previous connections in VS2019 were SQLClient Data Provider. When I try and use those same connection ...
C Layne's user avatar
  • 43
0 votes
0 answers
164 views

I am new to SSIS and I have to add a connection for SQL destination server. But, I cant see any names or databases to add there. The server name was correct. When I click on test connection, it says ...
Eshwar Yashwanth's user avatar
  • 1
0 votes
1 answer
132 views

I am struggling on this error for a long time now. Here is the configuration of my project : a server SERV_SSIS_CATALOG where SSIS packages are deployed a server SERV_FILE (another) with files ...
Bekkk's user avatar
  • 1
0 votes
1 answer
176 views

I had trying my hands on creating a SSIS custom component to retrieve data from Salesforce. I having the custom connection manager project working and verified, and the custom source works and ...
Shaggy's user avatar
  • 259
0 votes
1 answer
297 views

I need to update a connection in SSIS to a Gupta SQLBase OLE DB provider but it does not show as an option in the dropdown. I have registered the Gupta SQLBase OLE DB provider on my local machine for ...
jeremiahgarrett's user avatar
  • 1
3 votes
5 answers
9k views

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 ...
Bich Le The's user avatar
  • 57
0 votes
1 answer
309 views

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 ...
Ewa's user avatar
  • 53
2 votes
0 answers
2k views

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....
Ankit Das's user avatar
  • 31
0 votes
1 answer
1k views

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 ...
Dizzy49's user avatar
  • 1,550
3 votes
3 answers
2k views

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: ...
Equator's user avatar
  • 87
1 vote
1 answer
994 views

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 ...
AndreA's user avatar
  • 789
0 votes
0 answers
237 views

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 ...
Coda759's user avatar
  • 107
0 votes
1 answer
541 views

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 ...
Mike Myers's user avatar
  • 39
0 votes
1 answer
443 views

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 ...
Robin's user avatar
  • 125
0 votes
1 answer
279 views

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 ...
MartinS's user avatar
  • 165
0 votes
1 answer
744 views

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 ...
Riggster's user avatar
  • 107
0 votes
2 answers
850 views

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 ...
vignesh's user avatar
  • 1,496
-1 votes
1 answer
946 views

SSIS Excel Connection manager validation is taking forever. The same package works when running Visual Studio in administrator mode. The Excel file I am reading is from a local folder. I set the ...
Biruk Belihu's user avatar
  • 49
0 votes
0 answers
84 views

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 ...
user15014142's user avatar
  • 1
0 votes
1 answer
436 views

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 ...
Athira GS's user avatar
  • 9
1 vote
0 answers
1k views

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 ...
Cristina's user avatar
  • 159
0 votes
1 answer
110 views

How to execute SSIS package from local machine, where there are different source files are on VM machine which are source file for this packages, how SSIS packages can connect to the VM Machine for ...
sarfaraz shaikh's user avatar
  • 55
1 vote
0 answers
1k views

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 ...
Brandon Meyer's user avatar
  • 131
0 votes
0 answers
438 views

I am trying to configure the connection manager in SSIS using .Net Providers\MySQL Data Provider to connect to a MySQL database on a remote server. I am basically following this tutorial https://...
Ning's user avatar
  • 595
1 vote
1 answer
1k views

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....
Tarta's user avatar
  • 2,117
0 votes
0 answers
695 views

I need to load a .xlsx source to do some things. I've made an Excel Connection Manager and it works but I need to parameterize it to use a dynamic path. How can I do that? I've read a lot of guides ...
marko's user avatar
  • 547
3 votes
3 answers
23k views

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: ...
dorian harley's user avatar
  • 51
0 votes
0 answers
711 views

I am setting up an SSIS project for testing. This project has a package where I manage some connections to SQL Server data bases, for doing this I use Package Configurations. Here I have a ...
Rafael's user avatar
  • 117
0 votes
0 answers
2k views

I've recently created an SSIS Project and deployed that project to a folder in SSISDB. I've tested this project and I am able to run it end-to-end in Visual Studio successfully. However, when I run ...
Shaye's user avatar
  • 543
0 votes
2 answers
284 views

Do SSIS ConnectionManagers attempt to make their connections on package start, or when the connection is first used? If it's the latter, I can use failure transitions to handle connection failures ...
FireSBurnsmuP's user avatar
  • 953
0 votes
1 answer
3k views

I am using Visual Studio 2017 and trying to connect to an Excel file source for a data flow. I have tried all of the following solutions found on StackOverflow and none of them work: Installed 32-bit ...
DesertCoder's user avatar
  • 23
1 vote
2 answers
3k views

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 ...
Jennifer Fuss's user avatar
  • 43
3 votes
1 answer
3k views

I have made a custom SSIS Connection Manager (.NET 4.6.2): namespace HelloWorldCm { using Microsoft.SqlServer.Dts.Runtime; [DtsConnection( ConnectionType = "HELLOWORLD", ...
Charlotte Skardon's user avatar
  • 6,280
0 votes
0 answers
44 views

I have a ssis pacakage which was in designed in 2008 and i have upgraded it to 2017 having flat file source. I want to execute via ssis catalog (SSMS). How to add file name in ssis catalog?
Sneha Yadav's user avatar
  • 21
2 votes
1 answer
2k views

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 ...
Dina Kleper's user avatar
  • 2,101
2 votes
1 answer
4k views

In our normal c# this is the way to get connection string from app.config SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DPTConnectionString"].ConnectionString); But ...
NAGARAJA H I's user avatar
  • 149
3 votes
0 answers
300 views

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 ...
Boštjan Arzenšek's user avatar
  • 31
2 votes
2 answers
2k views

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 ...
Caleb Fortner's user avatar
  • 57
2 votes
1 answer
1k views

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 ...
user2431858's user avatar
  • 73
0 votes
1 answer
1k views

We've been working to get some SSIS packages deployed to our SSISDB catalog in the sql server. After fixing umpteen issues with permission in proxy accounts the latest issue is this; After deploying ...
Phteven's user avatar
  • 139
1 vote
1 answer
2k views

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 ...
Ziad Salem's user avatar
  • 525
2 votes
2 answers
867 views

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 ...
sql2015's user avatar
  • 621
2 votes
0 answers
1k views

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 ...
default_noob_network's user avatar
  • 1,315