Does the Postgres Destination Support User Variables?

[sxwalsh55]

I'm using the SSIS Postgres flow components, and I don't see anywhere that a user variable can be used in the source table field. This is useful to me because I'd like to be able to use a variable to control the target schema of the flow components of my package.

So far it looks like I need to open up every data flow and make all schema changes manually when switching back and forth between environments, which we control with schemas.

Thanks

[Shalex]

Sorry for the delay.

Please define your parameter (for example, with name=TODAY and expression=GETDATE() ) via SSIS > Variables menu of Visual Studio.

Devart PostgreSql Source: you can use newly created parameter in the query in the following way

Code: Select all

select * from MyTable where LastModifiedDate='<@User::TODAY>'

Devart PostgreSql Destination: create an additional component Derived Column (the Common tab in SSIS Toolbox)
some source -> Derived Column -> Devart PostgreSql Destination
Now you can drag&drop User::TODAY to the bottom surface within Derived Column Transformation Editor to create a new Input Column for Devart PostgreSql Destination (map it via the Column Mappings tab).

Does this help?

[Shalex]

The possibility to set object name via user variable in destination components is implemented: viewtopic.php?f=60&t=39336.

After you created the variable named tableName, set ObjectName=User::tableName in the destination component.