Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
picatshou
Starting Member
12 Posts |
 Posted - 2014-04-24 : 12:08:14
|
| hi alla i want to join a word file in a message how can i do tha thnx ? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-25 : 08:02:08
|
| no idea what you're talking about. Please send some sample data and desired output. |
 |
|
|
picatshou
Starting Member
12 Posts |
Posted - 2014-04-25 : 09:00:05
|
| in fact i would attach a word file containing captures of the message erros shown by SSIS and i ak how can i do that thing ?thnx |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-25 : 13:02:32
|
| OK -- I get it now. Have you set up logging in your package? That's step 1. Just set it up for a text file and choose the logging options you want.Then, add a control flow task that executes conditionally on failure. If you really want MS-Word format, you'll need to also write a script component to talk to MS Word to write the file. Note that you can do Excel as a SSIS destination directly but not Word. The task can then email the results, using the file you specified in the logging options. |
|
|
|
|
|
|
how to join word file here ?