How to change "DestinationName" property of UNION ALL Transformation in SSIS
I want to make friendly names of Union All inputs; however, the Destination Name is dimmed.
I have 10+ inputs and it is really annoying finding the destination "Union All Input 10"
The best solution I could find so far is add Path Annotation as displayed in the picture below:
I want to rename Union All Input 1 to somthing meaningful.
Solution
Looks like Microsoft has stated that they Won't Fix This. Bummer. Everyone please upvote the Microsoft Connect link and maybe they will assign a developer.
- 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
- 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?
- SSIS dynamically Execute Package Task: Package Name is missing
- SSIS is executing successfully, but it doesn't seem to be running the script task portion
- How to download attachment using SO_DOCUMENT_READ_API1?
- SSIS How to get part of a string by separator
- Executing procedure in SSIS Visual Studio with result sets