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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-07-22 : 16:37:01
|
| Is it possible to close a file using ssis? |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-23 : 07:14:22
|
| What kind of file and what would be the state of the file while closing? It could be locked while in use. |
 |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2009-07-24 : 10:14:16
|
| It's an excel file and since it will be on my computer the file won't be locked. The excel file opens, runs a macro and then saves. Then I want it to close. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-24 : 10:49:16
|
Here's one solution:Create a batch file "c:\closeExcel.bat" for example and insert this line:taskkill /FI "WindowTitle eq Microsoft Excel - file.xls" That command will kill the Excel task labeled "Microsoft Excel - file.xls"Then on SSIS package use Execute Process Task > Process > Executable and point to the batch file. Run it and see what happens. I'm sure there's other ways of doing this as well. |
|
|
|
|
|
|
Close a file?