Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 5:06 PM
Points: 1,246, Visits: 2,035
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: Wednesday, September 23, 2015 3:34 PM
Points: 5,467, Visits: 7,660
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:01 AM
Points: 4,010, Visits: 4,728
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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 5:06 PM
Points: 1,246, Visits: 2,035
Thank you
Post #1539488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse