February 7, 2014 at 2:29 pm
Hi,
Please some one let me know how to run the ssis package on the fly .
Thanks
February 7, 2014 at 2:31 pm
Connect to the SSIS server, rt-click, execute package?
Otherwise, more details, please.
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
February 7, 2014 at 3:33 pm
Deploy the package to SSIS.
Configure a job to execute it.
From ssms you can call:
USE msdb ;
GO
EXEC dbo.sp_start_job N'Job_calling_ssis_package' ;
GO
You can put that code in a SP and execute it.
From .NET you can call the SP executing the job.
Regards,
Igor Micev
Igor Micev,My blog: www.igormicev.com
February 8, 2014 at 5:51 am
Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply