September 28, 2010 at 3:28 am
Hi All
We have an application that creates databases when they reach a certain size, then it creates a new DB to continue from but we have SSIS package that needs to access & read data from the new DB. How do I automate this process as currently do a manual admin.
Thanks
It's better to fail while trying, rather than fail without trying!!!
September 28, 2010 at 4:43 am
the steps which is creating the new db, you can mention additional steps to grant required permission to the account which is running package.
----------
Ashish
September 28, 2010 at 5:09 am
Unfortunately the application has been hard coded to create certain accounts for it's own use but a sql connection account is used by SSIS that needs access to all those new DB's
Tx
It's better to fail while trying, rather than fail without trying!!!
September 28, 2010 at 5:13 am
if you create the account in model and give required permission, then i think whenever then new database created, it will inherit the defaults from model.
----------
Ashish
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply