Hi Raathesh,

You may begin in the following order...which I am comfortable with:

1. Package execution in BIDS.

2. Package execution in SQL Server environment.(Running/Stored packages)

Storage options(MSDB and File...

Hi Malavika,

It seems your issue is resolved.

You must understand that Type conversions though seems easy add a lot of overload to underlying engine...considering that you have a large database to...

Hey Mike,

What are you really interested about....is it BI or SQL Server certification?

Hi Malvika,

As a better practice it is always suggested that one should always handle date-time manipulation at database level and not on SSRS interface.

Hi Abhit,

Could you please re-phrase your question and provide some brief snapshots about your requirements?

Thank you.

It has been a month already of preparing for 70-448.

Can you please advice on key areas from Exam point of view?

:-P:-P:-P

Again Microsoft monoploy....

:-D:-D:-D

that was easy...

kudos to Sachin

This is interesting...SSIS yes possible SSRS never tried Excel export paging with respective names applied to sheets.

Please let me know if you come across any feasible solution.

Suresh,

have you tried the Package migration wizard,

why not use the exceute DTS 2000 Package Task editor

Hi,

There are basically two ways to achieve the same.

1. Use parameters

...

Thant is even better and also one can toggle the visibility options using the appropriate crietria that suits one's requirement

Before employing the solution be sure that you enable the appropiate options from Surface Area Configuration to use OpenRowSet

Hi,

I do not understand.I can refer office assemblies but not data extensions,Presenataion Frameworks and many others....

Hi Mithun,

This is unusual.Try building the solution file again.