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 |
|
chrissmith75
Starting Member
1 Post |
 Posted - 2009-02-24 : 10:47:27
|
| I have created a package and need the data to be written to an Excel file. The issue is that I have no Excel file at the start, therefore the package is complaining that Excel file does not exist (which I know!) Is there a way of forcing the package to create a new spreadsheet if it cannot locate the existing one? My location and name of Excel file is stored in a local user variable.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 12:39:56
|
| http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-_116683388696570741.html |
 |
|
|
|
|
|
SSIS into new Excel file