Hi,
I have a reqirement where in i need to create a Database dynamically in SSIS, Database name is given in table.


Regards,
Miranda

Hi ,

Kindly post your query in Sql Server integration services tab.

thanks

Hi mirandaroopa,

According to your description, you want to dynamically create tables based on a metadata table. Right?

In this scenario, you only need SQL query to achieve your requirement. You can create a Execute SQL Task, and put your query into the SQL statement. For how to write the query, please refer to the query in the link below:

Dynamic table creation using SSIS Package

Regards,

Hi,

for SSAS use AMO (Analysis Management Objects).