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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 435, Visits: 443
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: Today @ 1:23 AM
Points: 6,158, Visits: 7,223
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:35 AM
Points: 2,901, Visits: 2,927
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 435, Visits: 443
Thank you
Post #1539488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse