February 17, 2014 at 11:15 am
This (SSIS?) package works great, but is there a way I can script out its use? Every month when we refresh our dev boxes I need to capture the database .. in case a change was not moved into production and not scripted out to file. We have a lot of databases, so it would be great not to have to do this by hand every month.
February 17, 2014 at 1:15 pm
You can use SQL Server Management Objects (SMO) to programmatically script out database objects. An intro to SMO scripting you can find here: http://technet.microsoft.com/en-us/library/ms162153.aspx
___________________________
Do Not Optimize for Exceptions!
February 17, 2014 at 10:28 pm
Also when designing SSIS package you can define action if step fails take this action if step successful take this action to control the steps.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply