SSIS Maintenance Script


Trackbacks

steel construction builder on : steel construction builder

https://public.tableau.com/profile/metal.building.contractors2928#!/california general contractor

construction consultants on : construction consultants

https://splice.com/steelbuildingbuildersmetal building construction

steel building suppliers on : steel building suppliers

https://visual.ly/users/designbuildingcontractors/portfoliodesign steel buildings

TI construction on : TI construction

https://myopportunity.com/profile/metal-building-contractors-3/nwgeneral contractors

metal building fabricator on : metal building fabricator

https://stackoverflow.com/story/facilitybuildingcontractorgeneral contractors

Comments
Display comments as (Linear | Threaded)

Ben on :

Thanks for putting this together. It worked great for me.

Ben on :

Mark, I am thinking about writing a sqlservercentral article on my ssisdb problems. I would like to include a link to your blog as I have found it very help. Please let me know if I have permission to include a link.
Thanks,
Ben

Mark Tassin on :

Go for it. I'm a big fan of SSC

pavi on :

how do i add the below code to the

declare @retention_window_length int

select @retention_window_length = cast(property_value as int) from [catalog].[catalog_properties] where property_name = 'RETENTION_WINDOW'

exec [internal].[cleanup_server_retention_window_bottomup] @retention_window_length = @retention_window_length


to the main script..i mean in which location should i add this script..can i run this script seperately in the database?

Mark Tassin on :

What you could do is add

IF @retention_window_length IS NULL SELECT @retention_window_length = cast(property_value as int) from [catalog].[catalog_properties] where property_name='RETENTION_WINDOW'

right after the variable declares in the stored proc.

Also modify the @retention_window_legnth parameter to have = NULL as part of its definition.

Add Comment
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.