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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-08 : 08:16:54
|
| ats writes "i want to design a dts package as follows;1) run TSQl using a connection2) upon successful completion of TSQL, i then want to produce results to an XL sheet or on failure write a message to Event Application log using RAISERROR.i can do task 1 above with SQL connection defined. i know how to define workflows but when i try to define a workflow between TSQL task to an XL connection, i get an error that i cannot do it.please assist to let me know how i can get the whole of the above working. thanks a bunch" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-08-08 : 08:30:52
|
| Seems you need only two connections:the 1st - SQL Server connectionthe 2nd - Excel workbook connectionandMenu >> Workflow >> Add Transform TaskIn the properties sheet of this task you mayassign your query as the datasource for this task.- Vit |
 |
|
|
|
|
|
DTS