Yes, that's my idea but my only concern.

Is there any better way to do this ?

Hi All,

Thanks for your replies.

My idea is to have a table with the list of holidays (dates)

A sql job which is to be scheduled everyday at 00:01 with a SP

stored...

Hi Phil,

Can we automate this one. I mean changing the start date.

Thnx buddy:-)

Hi,

Place a Execute SQL Task and get the email id's

Assign the result set to a object variable.

Next place a Script Task and write code for sending mails.

use the object variable...

Hi,

The workgroup edition only has primitive import and export capabilities. As far as I can confirm, if you want to create SSIS packages using any data transformations you need to...

Hi Pals,

Finally done it by creating Script Task.

Hi Pals,

Thanks for your replies. Finally I have created a SP with a out parameter which holds the output template and values from the table. Generated a txt file(with out...

Hi buddy,

Thanks for your reply,

I need two OleDB source in a Data Flow Task has to be executed simultaneously.

Thanks Buddy,

So from my understanding you are trying to say that we need to generate all the contents of the template in the OleDB source and moving it to a...

Hello,

Thanks for your reply

I need to generate a txt file with a output returned from OleDB source. Now the problem is Im using a template, so I can't just generate...

Thanks for your information.

Thanks for your prompt response....

Yes, how to map the SSIS variable to the header property? and I have another one too.

How do I use the same SSIS package for different...

Hi John,

Your post was very helpful, but I have a query,

"You can create a SSIS variable to store your dynamically built header information, then assign it to the Header property...