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=""> <s> <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

  • @Jamie_Wick: CheckDB on one db causing 833 error on tempdb (4 data files & not growing). Any suggestions/recommendations to help alleviate? #sqlhelp
  • @SQLHA: @richardslim You also have the very real problem of paths and crossing the streams. #sqlhelp
  • @SQLHA: @richardslim I can also poke myself in the eye with a sharp stick, but would never do that in real life. #sqlhelp
  • @jdanton: @gm_praveenk My rec would be to look at guides for migrating to virtual. Same concepts. Except more limited IO and network #sqlhelp
  • @jdanton: @richardslim It’s possible, but I wouldn’t do it, aside from testing. #sqlhelp
  • @richardslim: Is it possible to have traditional fail-over Clustered instances with locally installed instances in an AG on the same 2 servers? #SQLHelp
  • @gm_praveenk: Hi all Can any one help out in documentations of migration of physical sql server to cloud (hp cloud). #sqlhelp Thanks
  • @SQLSoldier: @DBArgenis @SportsNut70 More specifically, look for updates to heaps. #sqlhelp
  • @DBArgenis: @SportsNut70 that is orthogonal to the storage you use. Look for changes in database schema and workload. #sqlhelp
  • @SportsNut70: We migrated to Flash storage and now see Forwarded Records/sec avg about 5000. On SAN, we had 0. Should I be concerned? Is it Flash?#sqlhelp

Welcome , today is Tuesday, August 4, 2015