Jim

Can you please help by explaining what is the purpose of the stored proc and what are the possible test cases and test scripts for it.

Thanks,

Jim

Can you please help by explaining what is the purpose of the stored proc and what are the possible test cases and test scripts for it.

Thanks,

Jim

Can you please help by explaining what is the purpose of the stored proc and what are the possible testcases and test scripts for it.

Thanks,

Vinit,

Did you get an output for the stored proc?

If so can you please explain.

Hi Jacob and Toby,

Its the same server that the databases resides in.

The table that i mentined would be used as a base table for reporting.

Do we set up transactional...

Hi Tom,

I know to create a basic SSIS package.

I am not sure though without using some script how would i would get the required Result.

Please let me know the steps...

Thanks Adam and SQLKing.

I want to apply configurations to the package for same excel source and OLEDB destination specified earlier.

Suppose i am using variable and i am making...

Thanks Tommy!!!

Thank You So much.... Adam, for providing a simple solution .

Hi Adam,

Thanks a ton for the code.

The code works fantastic. I have used the same for monthly

reports as well.

Regards,

Hi Adam,

Thanks for the great script.

I did not think about breaking down the whole poblem and solving in different steps:)

The code works fine, except when i have multiple years in...

Thanks Marek for the detailed steps.

I have tried out the same steps, except I had specified query as source.

And for destination I have selected these options in Flat File connection...

I need to post files to another organization and they have to send back a set of excel files.

One option is data exchange through FTP site.

It would be great if...

Hi John,

Thanks a lot for the script.

That onez pretty simple and fast too.:)

Works great!!!!

Hi Jeff,

Thanks a lot for the reply.

I am in a similar situation again.

I have a table that has columns 1)ProductName and 2)qualification.

The reporting scenario is like i...