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 7, 2014 2:29 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 3:25 PM
Points: 603, Visits: 778
Hi,
Please some one let me know how to run the ssis package on the fly .
Thanks
Post #1539402
Posted Friday, February 7, 2014 2:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 4:43 AM
Points: 5,401, Visits: 7,512
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 7, 2014 3:33 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:42 AM
Points: 3,014, Visits: 3,099
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,
SQL Server developer at Seavus
www.seavus.com
Post #1539420
Posted Saturday, February 8, 2014 5:50 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 3:25 PM
Points: 603, Visits: 778
Thank you
Post #1539488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse