Hi Karan,

Use the execute SQL task to run your stored procedures in the sequence required.

Regards,

Barkha.

Try searching for the SQLDBA::ParseSQL module in the Perl Package Manager

Regards,

Barkha.

Hi,

The tablix or matrix or similar object in the SSRS report can be bound to a dataset. Use a stored procedure with a parameter as the dataset. This will allow...

The function below returns the week ending date for the specified week day.

-- =============================================

-- Author: Barkha Javed

-- Create date: 10 Jul 2009

-- Description: Date of week ending, per given weekday

--...