Please note that this approach can be expanded upon to have the entire ConnectionString be dynamic and dictated by the calling SQL Agent job step if necessary. Set the Expression property as follows: Data Source="+ +" Provider=MSOLAP.4 Integrated Security=SSPI Set the EvaluateAsExpression property to true. This variable will be used to build the ConnectionString.ĬonnectionString | Package level | String Intended for use in the Set Values tab of the SQL Agent job if more than one instance will be backed up.InstanceForDatasource | Package level | String An Execute Script Task that uses the Analysis Management Objects (AMO).īackupDir | Package level or Foreach level | StringĭatabaseId | Package level or Foreach level | StringĭatabaseName | Package level or Foreach level | String.One dynamic SSIS package that is called in each step of the job.A step for the development server, the qa server, and for production). A SQL Agent job with a step for each instance that needs backed up (i.e.For this solution, you will use a combination of: There are probably a few ways to do it, and here is a fairly straightforward example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |