What does the fx sign in the connection manager mean

BVK 0 Reputation points
2023-02-14T14:10:13.51+00:00

Hi All,

I am new to SSIS, what does the "fx" sign next to the connection in the connection manager mean?

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2023-02-14T14:14:12.8266667+00:00

    It means the connection string isn't fix, there is an expression behind, e.g. to change dynamically a file name.

    See Icon Markers for Expressions

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2023-02-15T03:20:06.42+00:00

    Hi @BVK

    The fx means that you are using expression in the connection manager.

    User's image

    User's image

    Check: Use Property Expressions in Packages

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.