This is how excel can access file from another folder.
Ex:
Package location: "D:\BIServerDB\SSIS2012\First_SSIS\ExcelPackage\ExcelData.dtsx"
Excel File location: "D:\BIServerDB\SSIS2012\First_SSIS\Files\ExportToExcel.xlsx"
Or also can use "..\Files\ExportToExcel.xlsx" as path in Excel Connection Manager.

No comments:
Post a Comment