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 - 2001-10-18 : 13:20:47
|
| David writes "Using SQL Server 7.0 on a Win2K server, I have created a DTS package which exports the results of a query into an excel file. Then I would like to email the file to the user, and preferably all in one package...no need for an additional job, etc. The first part of the package flows like this: execute sql task (create table)->on completion->connection 1 (sql db)->DTS (copy rows)->connection 2 (excel file)Then I added to connection 2:->on success->execute sql task (send sql mail statement)Also a free floating connection to MASTER db to access sendmail stored procedure.Problem: The file is is mailed incomplete. Watching the explorer window, file does not seem to be complete until package is finished. (emailed file is 9k should be 1.2mb).Solution attempted: Adding a waitfor statement (15 seconds) before sending file to make sure file is complete...no luck.Please help! Thanks. David" |
|
|
|
|
|
DTS, Excel, and SQL Mail