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

Replacing Batch File call in SSIS Package Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 2:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:34 AM
Points: 1,043, Visits: 209
I am new to SSIS.
I am trying to replace aaa.bat file call from SSIS package by Storedprocedure(batch file by StoredProcedure), I have written all the codes in Storedprocedure and its working fine. but i am just struggling to log the output to a text file.

In the Batch , some are sqlcmd statements so logs will be segregated to a single log. How do i get the logs same logs from execute SQL task in SSIS.
Post #1464514
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse