How to fetch database in lookup?

Question

How to fetch database in lookup?

Sarvesh Pandey 71

Hi,
Is it possible to fetch all the database name just like table name we fetch using Lookup activity?
If yes how it is done, request you to please share the steps.
if no, can you please explain the reason and any workaround of it.

Can we pull database name from azure SQL server?

1 answer

Your answer

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Hey,
Assuming you are using SQL server, you can use
Select name from sys.databases and filter out the ones like temp, master etc.

The same can work on Azure SQL DB wherein you would need to exclude the Master database name

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-10-10T23:29:09.67+00:00

Thank you @Nandan Hegde ,

Hello @Sarvesh Pandey ,

If this answers your question, please consider accepting the answer by hitting the Accept answer button, as it helps the community.

Share via

How to fetch database in lookup?

1 answer

Your answer