Stack Overflow
Stack Overflow

Questions tagged [ssis-connection-manager]

40 questions
0
votes
1 answer

How to Execute SSIS package from local,but files like (.csv, .xls...) are on VM

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 the source files and can execute the packages.
sarfaraz shaikh
  • 55
  • 5
0
votes
0 answers

How to configure the connection manager in SSIS to connect to a MySQL database on a remote server?

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://smallbusiness.chron.com/connect-mysql-ssis-60851.html…
Ning
  • 499
  • 1
  • 4
  • 16
0
votes
0 answers

ssis - how to parameterize excel connection

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 but I couldn't get it to work. How do I define the…
marko
  • 487
  • 1
  • 6
  • 15
0
votes
0 answers

SSIS OLEDB connection not saving password when setting connection string from package configurations

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 configuration that takes four connection strings from a…
Rafael
  • 117
  • 1
  • 9
0
votes
0 answers

SSIS File System Task - Create Folder - "The network path was not found"

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 the deployed version I get an error: "The network…
Shaye
  • 179
  • 13
0
votes
2 answers

When do SSIS Connections occur?

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 within the package, but if it's the former then I…
FireSBurnsmuP
  • 923
  • 10
  • 28
0
votes
1 answer

SSIS Excel Connection "No tables or views could be loaded"

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 Microsoft Access Database Engine for 2010 (I am…
DesertCoder
  • 23
  • 1
  • 5
0
votes
0 answers

How to Execute flat file source by ssis catalog

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
  • 21
  • 3
0
votes
1 answer

SQL Agent detects a connection manager in SSIS package that has been deleted

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 the project to the SSISDB (SQL Server 2012) then…
Phteven
  • 139
  • 1
  • 13
-1
votes
1 answer

SSIS Excel Connection manager validation is taking forever

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 Security of both Package and project to…
Biruk Belihu
  • 49
  • 1
  • 3
1 2
3