Calling SSIS package from MS Access
Could you explain your requirement in detail...
why you want to run SSIS package from Access??
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
May 31st, 2011 8:55am
HI,
I have a Fuzzy logic package on SSIS now i want it to give it to my User.
How should i Go about it NEED HELP ???????
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 9:10am
You could potentially setup a job with a proxy (http://msdn.microsoft.com/en-us/library/ms189064.aspx) for the package and then use sp_start_job to excute it from the access database.
You might have to do some code behind in access for this to work. (Seen here:
http://www.databasejournal.com/features/msaccess/article.php/3407531/How-to-Execute-SQL-Stored-Procedures-from-Microsoft-Access.htm)
May 31st, 2011 1:38pm