Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vipin_jha123
Starting Member
31 Posts |
 Posted - 2014-12-18 : 04:50:30
|
| 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 package2-Biml Script:-It will create SSIS package on fly3-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 |
|
|
|
|
|
How to execute BIML File from Jobs