SSIS Job Execution

Tags: , ,
Comments: No Comments
Published on: December 13, 2010

While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed requirement.  I was attempting to create a process that would perform the entire process consistently.  Amongst the items that I needed to include in this process to “refresh” the QA environment was the need to run a couple of SSIS packages.  SSIS was not installed on this particular server where I was creating this process.  I needed to have a way of executing two SSIS packages without installing SSIS on the local server.

With that need, I decided to test a remote execution of a job that had SSIS steps.  The method I decided to use was to employ OSQL.  Here is what I did for that.

[codesyntax lang="tsql"]

[/codesyntax]

I added that line of code to a SQL Agent Job step.  The job step type is Operating System (CMDExec).

This method works well for me since I had already tested the package on the remote server and knew that it worked.  There are several other methods as well, this happened to be implemented more quickly for me at this time.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">






Calendar
December 2010
M T W T F S S
« Nov   Jan »
 12345
6789101112
13141516171819
20212223242526
2728293031  
Content
SQLHelp

SQLHelp

  • @billinkc: @Clem1029 #sqlhelp in my quick testing, before installing SSDT-BI, I had the AS folder in 12, not in 11. Installed and it showed up.
  • @billinkc: @Clem1029 #sqlhelp Does C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\ProjectTemplates\Analysis Services exist or 11.0
  • @tjaybelt: #sqlhelp any problems with installing SQL Server 2008R2 Web edition on Windows Server 2012?
  • @AskSQL: Anyone using Win2012R2 getting the SCSI VPD error when validating for WSFC? http://t.co/D8rLebe8dF Says I "don't have inquiry data" #SQLHELP
  • @Clem1029: Is there a registry key or file that will indicate that SSDT BI is installed on a machine? #sqlhelp
  • @sqlstudent144: Can DTSRun be installed separately from a SQL Server instance? & on a win 2008 srvr? #sqlhelp
  • @toosuto: What's the impact of restarting the DTC? #sqlhelp
  • @SirSQL: @_dave705 sys.xp_sqlagent_enum_jobs to check running status #sqlhelp or enum method dir sqlserver:\sql\localhost\default\jobserver\jobs | gm
  • @SirSQL: @_dave705 you would have to call an sp_start_job and then poll the status of the job until it's complete and handle that in PS #sqlhelp
  • @_dave705: @SqlBrit Since the sql agent job is asynchronous it does not return any status even if the job fails unless you have idea #sqlhelp

Welcome , today is Tuesday, September 30, 2014