Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Expand / Collapse
Author
Message
Posted Friday, February 07, 2014 2:29 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:44 AM
Points: 344, Visits: 249
Hi,
Please some one let me know how to run the ssis package on the fly .
Thanks
Post #1539402
Posted Friday, February 07, 2014 2:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:16 PM
Points: 5,986, Visits: 6,931
Connect to the SSIS server, rt-click, execute package?

Otherwise, more details, please.



- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1539405
Posted Friday, February 07, 2014 3:33 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:57 AM
Points: 2,729, Visits: 2,646
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
Post #1539420
Posted Saturday, February 08, 2014 5:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:44 AM
Points: 344, Visits: 249
Thank you
Post #1539488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse