SSIS Project Destination Assistant "unable to use" Existing Connection Managers
Visual Studio 2019, SSIS project.
Whenever I drop a new Destination Assistant into a Data Flow I am required to create a new Connection Manager to our SQL Server instance.
Presently, there are 4 identical Data Connections (except the index appended on the name) and none of them show up in the list of "Select connection managers." TBH this is driving me nuts. It is the same behavior for both Package and Project scoped Connection Managers.
Any ideas? Everything I see everywhere just shows the Database connection managers listed as expected - but they don't show up for me.
Don't use the assistants. Not to be flippant but I don't find that they add any value. I know whether I'm pushing/pulling from a flat file vs OLE DB so why do I want to make clicks here versus just dragging the thing I want onto my palette?
Whenever I start SSIS work on a new machine, I remove the suggested favorites of source/destination assistants and add in what I use day-in and day-out.
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- unpivot with different destination columns in SSIS Dataflow
- SSIS package shows blank screen in design mode
- Add SSIS to existing SQL Server instance
- Appending Header Record in Flat file SSIS
- Project consistency check failed. has a different ProtectionLevel than the project
- How to debug SSIS package in SQL Server Management Studio 2017?
- ORA-01422 error thrown when executing a stored procedure from SSIS script task, however it executes successfully when run from SQL Developer
- SSIS - The process cannot access the file because it is being used by another process
- What are the possibilities to call APIs in SSIS (Microsoft SQL Server Integration Services)?
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- Specified provider is not supported IBMDA400
- SSIS Excel Connection Manager using Expression fail : "Cannot update. Database or object is read only"
- Connection failure running SSIS package from web service
- no leading zero in hours h:mm:ss time format to convert to seconds in a derived column in SSIS
- How do I avoid the SSIS error "Unable to determine if the owner (MyOwner) of job MyJob has server access"
- How to parameterize a custom SSIS component
- SSIS Execute SQL Task SQL Command Issue
- Why is my SSIS toolbox empty in Visual Studio 2019 community?
- SSIS job step fail : Not using SSL certificate but getting error
- Why won't Windows 11 allow an Administrator to run gacutil.exe?
- Where are SSIS Packages Saved?
- How to change "DestinationName" property of UNION ALL Transformation in SSIS
- Difference between .NET, OLEDB, and Native Providers in SSIS
- How do I work around the "The process cannot access the file .ISPAC because it is being used by another process" error?
- Sql Server SSIS package Flat File Destination file name pattern (date, time or similar)?
- Yesterday's date in SSIS package setting in variable through expression
- Wrong error in SSIS - [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset"
- Why do I get the error: "cannot communicate with the debug host process" when attempting to execute an SSIS package?