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

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

Other recent topics Other recent topics