Pages

Sunday, March 6, 2011

Excel Connection Manager: Access file from another folder


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