DeveloperBarn

hi
i m not sure where is actual place to post question abt SQL Server Integration Services(SSIS Package)?.so far i have created SSIS Package in 2005 is working.basically what my package do is execute procedure and send email to user with all records as attachment.but for all this stuff i m using desinger only.

but what i m looking for is do all this stuff(making connection,executing procedure,checking & creating folder ,saving all returns data from procedure into csv file,and atlast sending email with attachment.) programmtically.

any body has an idea about SSIS Package?

Hope it make some sense.

__________________
Love is physical attraction and mental destruction

Hi,

How about making an standard report with the same using SSRS and get that executed on daily basis or as per your needs and attach the report in email to the users.

This will save a lot of efforts from you and would also give the good data presentation for the user.

Just a thought.

Regards,
~Harish