Thread: SQL Server Integration Services

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.