paultran00
asked on
SSIS package fails when CONNECTION MANAGER Excel tries to find the Excel destination but can't find it.
Hi,
I'm using SSIS 2017, SQL SERVER 2016, Azure cloud:
My ssis package gets data from a table and exports it to an existing Excel file successfully.
Problem I'm having with is that in PROD, I can't have the existing Excel file out there, so the SSIS package fails when CONNECTION MANAGER Excel tries to find the destination Excel but can't find it.
Options?
I'm thinking:
1) Create an Excel template in another folder and copy it over to PROD every time the ssis package runs. But in SSIS TOOLBOX, I don't see any objects for copying a file.
2) Create an Excel template in another folder and copy it over to PROD every time the ssis package runs. I could create a Powershell vbscript (that copies the Excel template to the PROD folder) but I don't know if Azure can run the Powershell.
3) any other ideas? Pleaes provide example code.
4) Can ssis create a new Excel file?
I'm using SSIS 2017, SQL SERVER 2016, Azure cloud:
My ssis package gets data from a table and exports it to an existing Excel file successfully.
Problem I'm having with is that in PROD, I can't have the existing Excel file out there, so the SSIS package fails when CONNECTION MANAGER Excel tries to find the destination Excel but can't find it.
Options?
I'm thinking:
1) Create an Excel template in another folder and copy it over to PROD every time the ssis package runs. But in SSIS TOOLBOX, I don't see any objects for copying a file.
2) Create an Excel template in another folder and copy it over to PROD every time the ssis package runs. I could create a Powershell vbscript (that copies the Excel template to the PROD folder) but I don't know if Azure can run the Powershell.
3) any other ideas? Pleaes provide example code.
4) Can ssis create a new Excel file?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
yes, you can.. Kindly check the steps below..
Ideally I would create an Excel file with Date or time values all the times instead of forcing a single hard coded file name..
https://excelkingdom.blogspot.com/2017/11/ssis-package-to-dynamically-create.html