May 31, 2011 at 4:53 am
Hi All,
I want to call a SSIS Package through MS Access VBA Code. So is there any way out that I can call SSIS Package through MS Access. Thanks for the help in advance.
June 1, 2011 at 1:28 pm
Maybe from a stored procdure that you execute in Access.
http://www.codeproject.com/KB/database/Call_SSIS_from_SP.aspx
June 1, 2011 at 1:33 pm
dtexec.exe
You'll need to run it from a command line opened from the VB, set your necessary parameters, etc.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply