Scenario:
Let's consider, we have a Flat file which contains
the tables those need to be truncate before we load them again. We need
to create an SSIS Package that can read the list of Table Names with
schema and then Truncate them in given Database in SSIS Package. Once
they are Truncated, we can have Data Flow Tasks to load them. But in
this package we will be only building the Part how to Truncate them and
the list of Tables can change anytime.
In this video we will learn how to save the query in a variable and then use in Execute SQL Task.
In this video you will learn following items
- How to Create SSIS Package from Scratch
- How to read list of Tables from a Flat File those need to be truncated from SQL Server Database
- How to Create String Type Variables in SSIS Package
- How to Write Expression on Variable to built SQL Statement
- How to use SQL Query ( Dynamic SQL) Saved in Variable in Execute SQL Task
How to build Query in expressions and Save into a Variable and Use Variable in Execute SQL Task as SQL Statement Source in SSIS Package
TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com
ReplyDeleteHello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com
Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.
For those who want an emergency loan, I offer you an affordable 3% interest rate. Rejected by multiple banks? Are you desperate for debt consolidation financing? Alternatively, you need financing for each track's business. Therefore, we are the best solution for your needs. We offer loans to interested clients without penalty. If you are interested. You can contact us via email {directaccesservice@gmail.com} or whatsapp @ +15754148400
ReplyDelete