How to schedule the BIML File

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  December 18, 2014 at 2:46 am

  #296045

  Hi ,

  I have created simple BIML Script file which generating a SSIS Package.

  It Contanis Single Data Flow Task ,OLEDB Source and OLEDB Destination.

  Now my Concern is that my new SSIS package getting input from Master package , on the basis of that my new SSIS Package will be function.

  Now I don't know how to schedule the BIML Script file.

  My package flow will be like

  1-Master Package:-It will pass the input which is the tablename to the New SSIS package

  2-Biml Script:-It will create SSIS package on fly

  3-New SSIS Package:-It will accept the filename from the Master package and change the Source table and destination table accordingly.

  please suggest me the best solution.

  Thanks & Regards,

  Vipin jha