January 3, 2008 at 2:30 am
Hi all,
I have a ssis package that will copy the data from the excel file to the database as per the schedule. i have deployed that package in my sql server as sql server deployment and scheduled that job too.I need to pass parameters to that package during runtime. so i have exported that to the config file. Now when i call that package from sql server with actual variable values and the modified values its working fine.
ow i need to call the same package from the asp.net page. Also i need to pass the values for those variables from asp.net. but when i call that the package is not producing the same result as that it produces when calling from the sql server itself.
I have package deployed in a remote machine and i m accessing that package from my machine. the excel files are also in my machine. The path for the excel files are correct but it always fails.
Plz let me know the solution if any of u come across the problem
January 7, 2008 at 3:55 am
Call a stored procedure from ASp.net .Stored proc can call dtexec using xp_cmdshell.
This(dtexec) will run your SSIS package.
Cheers
Sid
May 27, 2008 at 11:50 pm
sid (1/7/2008)
Call a stored procedure from ASp.net .Stored proc can call dtexec using xp_cmdshell.This(dtexec) will run your SSIS package.
how to use the Configuration File for the SSIS Package.
What the Parameter can be passed in the Configuration file?
Cheers
Sid
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply