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 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 |
|
|
|
|
|
How to execute BIML File from Jobs