Executing SSIS package with Excel as Data Source
Hi, I am pretty new to SSIS. The version I am working is 2005/2008. My scenario is to upload values from excel (multitab) to different tables. The suggestion provided was to use SSIS package and hence I have developed a sample Data Flow which reads the source data (from excel) and have an OLE Db connection to insert into Oracle tables. This executes fine in my local PC. The requirements in the form of excel will be posted to SSRS server (currently used to view the reports). Q#1. Is there a way to execute my SSIS package in SSRS server with Data Source as excel loaded in SSRS server Q#2.How to map the (excel) present in the server path as Data Source in my SSIS package. Q#3.On either case the client PC have no SSIS/SSRS installed to execute my package, on such case how can the SSIS package be executed from the server. Q#4. Are there any special ways to handle this scenario. Note: The major problem we face is in mapping the path of the excel sheet. Thanks in advance -LakksRegards
June 28th, 2011 9:17am

Hi, I am pretty new to SSIS. The version I am working is 2005/2008. My scenario is to upload values from excel (multitab) to different tables. The suggestion provided was to use SSIS package and hence I have developed a sample Data Flow which reads the source data (from excel) and have an OLE Db connection to insert into Oracle tables. This executes fine in my local PC. The requirements in the form of excel will be posted to SSRS server (currently used to view the reports). Q#1. Is there a way to execute my SSIS package in SSRS server with Data Source as excel loaded in SSRS server Q#2.How to map the (excel) present in the server path as Data Source in my SSIS package. Q#3.On either case the client PC have no SSIS/SSRS installed to execute my package, on such case how can the SSIS package be executed from the server. Q#4. Are there any special ways to handle this scenario. Note: The major problem we face is in mapping the path of the excel sheet. Thanks in advance -Lakks Regards Re #1: SSRS != SSIS, there is no direct link, you may want to resource to creating a webpage to launch the SSIS packages; Re #2: You simply use an Excel Data Source which you point to the Excel file path; Re #3: SSIS engine executes packages, to develop you can use a PC w/o the SSIS installed, packages can be anywhere but eventually you need SSIS somewhere to run; Re #4: I think #3 addresses this question. Beware that packages from ver of SSIS 2008 will not run on SSIS 2005 machine. I think I know how to solve your issue: just use the Data Export Import Wizard to load the Excel file to Oracle and save the result as SSIS package, you will be done in 5 min with all the issues solved for you.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 9:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics