Create a Shortcut to Reference a SQL Server Table in Dataflow Gen 2

[tan_thiamhuat]

Every time we need to get the tables in SQL Server, we need to import them inside Dataflow Gen 2, which is both time consuming and does not make sense.

We want to do this, without importing the data, that is, a shortcut or references to SQL Server tables inside Dataflow Gen 2.

[miguel]

Could you further explain your scenario and what you're trying to accomplish?

A Dataflow Gen2 is not effectively a storage item, but rather a data processing one. It connects to data, processes it and enables you to load it to a destination, but by itself Dataflow Gen2 doesn't truly store.

If perhaps this is more about adding multiple queries from the same source (being SQL Serve), you can do so today in many forms, but it also depends on what your needs are.

Looking forward to hearing from you! 

[tan_thiamhuat]

I think I am clear now, we can close this case, thanks.

[tan_thiamhuat]

I think I am clear now, we can close this case, thanks.