August 30, 2010 at 2:17 pm
Hi,
This is an ssis package
my issue is with excel
1) excelsheet.1 (output1.xsl) has a table (result of one of the data flow task)
ex: (single row data is generated )
column1 column2 column3 column4
value1 value2 value3 value4
2) template.xsl is a template
ex:
company name
duration : value1 to value2
rules : abcdedfghdfgdflkhdlfhdfhfdkghlfdghdf
table (single row)
column3 column4
value3 value4
3) send email to some members with updated data looks like the template as an excel attachment
Please help me with this
thanks in advance
praveen
September 1, 2010 at 1:33 am
Do you have a specific problem with this process or are you just looking for a "How to"?
If the latter is the case then i would have a look on Google and apply a general guide to your specific situation.
Something like this (http://cavemansblog.wordpress.com/2009/04/17/ssis-export-data-from-sql-server-2005-to-excel/)
I would store the file name and path in a variable that you can use later to email it out. For this you could either use the send mail task in SSIS or Database Mail.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply