hello,
i am trying to figure out how to check for failure or success AFTER the script task has ran.
its a piece of cake to write script logic that runs before the task but how do i check things and decide to retry AFTER a script task has ran?
i want to check for an error after a large table replication and if it detects that there was an error i want to RETRY.
dts does not seem to have this one specific piece of functionality. am i overlooking something?alright... i am closer to figuring this out although the solution seems a bit complex.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6196&pg=2
the WROX book that i bought on DTS "DOES NOT EVEN COVER THIS TOPIC" . it covers reactive error handling but doesn't say a word about proactive error handling.
i have a java programming background. can anyone see this from my point of view and give me a hint?
this reminds me of using the "onStart" and "onLoad" methods of ASP programming but it doesn't seem to be quite as simple to use...
Showing posts with label figure. Show all posts
Showing posts with label figure. Show all posts
Monday, March 19, 2012
Sunday, February 19, 2012
How to build AS model in report builder?
Is anyone can figure out that how many ways to use AS cube as the datasouce
of report builder?
One of the way that I knew is use SQL Server Management Studio to create AS
Model for report builder.
So, can I use report designer to create?
I'm so confused on report designer for create data source views when using
Cubes.
Data source view wizard just can see relational data source and can't select
AS cube?
Thanks for any advice!
AngiAS-based models can only be generated from Management Studio or Report
Manager
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:O3B4yA9AGHA.608@.TK2MSFTNGP12.phx.gbl...
> Is anyone can figure out that how many ways to use AS cube as the
> datasouce of report builder?
> One of the way that I knew is use SQL Server Management Studio to create
> AS Model for report builder.
> So, can I use report designer to create?
> I'm so confused on report designer for create data source views when using
> Cubes.
> Data source view wizard just can see relational data source and can't
> select AS cube?
> Thanks for any advice!
> Angi
>
of report builder?
One of the way that I knew is use SQL Server Management Studio to create AS
Model for report builder.
So, can I use report designer to create?
I'm so confused on report designer for create data source views when using
Cubes.
Data source view wizard just can see relational data source and can't select
AS cube?
Thanks for any advice!
AngiAS-based models can only be generated from Management Studio or Report
Manager
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:O3B4yA9AGHA.608@.TK2MSFTNGP12.phx.gbl...
> Is anyone can figure out that how many ways to use AS cube as the
> datasouce of report builder?
> One of the way that I knew is use SQL Server Management Studio to create
> AS Model for report builder.
> So, can I use report designer to create?
> I'm so confused on report designer for create data source views when using
> Cubes.
> Data source view wizard just can see relational data source and can't
> select AS cube?
> Thanks for any advice!
> Angi
>
Subscribe to:
Posts (Atom)