BIDS is not acceptable - to "heavy"

Hello everybody!

I have a question - is it possible to visualize an execution of the SSIS package when it is being run from SQL Agent? "Visualize" means to show a data-flow "live" - similair to the visualization provided by BI Dev.Studio when you run a package there, with coloured boxes, blinking etc.

I searched the Web but found nothing - neither MS-related nor utilities from third parties. Is it possible in any way?

Thanks in advance,

Andrey.

P.S. Parsing log-files is an option, but we would like to try first something less "painfull" and more universal...

To the best of my knowledge, no such tool exists.

Why not simply run the package from BIDS when you require the visualization?

|||

Just because we do not want to install BIDS in order to run a couple of SSIS packages. We thought of some utility ot "light-weight" version of it invoked when package is run.

And thanks for the information.

Regards,

A.G.

|||Yep, no tool exists, other than BIDS. Is the real-time log/output of the package not enough?|||

Thanks a lot! We will think about other solution - perhaps, log-based.

Regards,

A.G.

|||Sorry I couldn't help - good luck!|||

Hi:

I have had requests for such a UI too. Once you show users a package running in BIDS, they just love it, and want to see it running that way.

It is also a useful aid in Requirements and Design reviews.

Is there some place we can request Microsoft for a feature like this?

TIA

Kar

|||connect.microsoft.com|||Hello.

To be honest, I'm not sure that MS will implement your request ever. This tool is not interesting for marketing. It has no real sales potential.

Regards,
Andrey

best way to delete the reporting services jobs in sqlserver

I have six thousand reporting services jobs in sqlserver, which were
scheduled to run only once and their execution date is older than a month.
how do I know which of the jobs are useful out of these 6000.
Can I write a job, to purge the reporting services jobs older than a month
and schedule it to run every week, basically how do I manage these ever
growing jobs ?
Thanks in advance..GAis it okay to delete the subscriptions like below '
delete from reportserver..subscriptions
WHERE ModifiedDate < dateadd(day, -7, getdate()) AND Description LIKE 'SRS%'
TIA
"DallasBlue" wrote:
> I have six thousand reporting services jobs in sqlserver, which were
> scheduled to run only once and their execution date is older than a month.
> how do I know which of the jobs are useful out of these 6000.
> Can I write a job, to purge the reporting services jobs older than a month
> and schedule it to run every week, basically how do I manage these ever
> growing jobs ?
>
> Thanks in advance..GA
>|||I have deleted subscriptions using this method. There are cascading deletes
when to remove the related records in ReportSchedule and Schedule tables.
Though, bulk deleting a lot of subscriptions at the same time might not work
with that statement. I know for me I've gotten timeouts when trying a direct
delete. So instead, I create a memory table (DECLARE @.x TABLE...) and put in
all the SubscriptionID for the ones I want to delete. Then I delete from the
Subscription table using a join to the memory table. I know it might seem
strange to do it that way, but because of the way the tables are indexed, it
works.
Once you the records are deleted from the tables, the Reporting Service will
automatically delete the actual SQL Agent jobs when it does its maintenance,
I'm not sure of the frequency that it does that, but at minimum its once a
day.
Carmine
"DallasBlue" wrote:
> is it okay to delete the subscriptions like below '
> delete from reportserver..subscriptions
> WHERE ModifiedDate < dateadd(day, -7, getdate()) AND Description LIKE 'SRS%'
> TIA
> "DallasBlue" wrote:
> > I have six thousand reporting services jobs in sqlserver, which were
> > scheduled to run only once and their execution date is older than a month.
> > how do I know which of the jobs are useful out of these 6000.
> > Can I write a job, to purge the reporting services jobs older than a month
> > and schedule it to run every week, basically how do I manage these ever
> > growing jobs ?
> >
> >
> > Thanks in advance..GA
> >
> >