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 |
|
keropotter
Starting Member
4 Posts |
 Posted - 2010-05-28 : 11:00:22
|
| Hi!!I have a DTS package exporting a SQL Server table to an Excel file.The excel file is created in a temporary directory. After the Data Transformation Task is completed, i need to copy it to a different folder on the same machine.The problem is, the ActiveX task that copies the file executes successfully, but the excel file i get on the destination folder is empty, except for the table heading (that is, the names of the columns are on the first row).It looks as thought there is a "commit" missing... but I'm not sure what's going on... has anyone experienced this problem before? How did you solve it? |
|
|
keropotter
Starting Member
4 Posts |
Posted - 2010-05-28 : 11:43:34
|
| I found a solution here: http://www.tek-tips.com/viewthread.cfm?qid=1247679&page=25It involves creating a higher level package that invokes the package that exports the data. Given that the inner package releases the file, I can copy it.Anyway, if you know of a different method or if it's even possible to have it all done in a single package, i would really appreciate it. |
 |
|
|
|
|
|
File copy problem