martes, 20 de agosto de 2013

BI - Include a packake as a Job


After did your package, insert as a job in SQL Server


  • Select in Visual Studio -> Save As
  • Go to the file system and copy the file to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL
*You have to put the file in this path if not SQL Server will not be able to read the file.
  • Go to SQL Server Manager 
  • Expand SQL Server Agent

  • Right click in Jobs
    • Select New Job
    • Type a Name
    • Click in Steps
    • Click in New
    • Type a Name
    • In Package select the file *.dtsx
    • In the Tab "Execution options", select "Use 32 bit runtime"
    • Click OK
  • In Jobs do right click and select Start Job at Step
  • Ready!!


No hay comentarios:

Publicar un comentario