Greetings!
I worked on ETL (Extract, Transform, and Load) at SSIS (Sql Server Integration Services) in MSBI (Microsoft Business Intelligence Tool) for two years from 2008 to 2010 by converting old DTS to new SSIS. What is the scope of SSIS now?
Hello Murali Kannan S.P.
you can find the following links for your reference
https://www.c-sharpcorner.com/UploadFile/9d28bf/differences-between-ssis-2005-20082012/
https://www.datasciencecentral.com/profiles/blogs/job-scope-for-msbi-in-2021
https://medium.com/@kalyanicynixit/what-would-be-the-msbi-technology-future-in-2020-4441e7917108
https://www.quora.com/What-is-the-future-scope-of-ssis-ETL-tool
When you create variables in the scope of the object in question, they have undergone changes with the 2012 version of SQL Server. The variables created will always be at the package level and explicitly indicate and move to the different scopes you need, this is already a native capability of SSDT (formerly known as BIDS).
In SSIS Designer, to define the scope of the variable, do one of the following: To set the scope to the package, click anywhere on the design surface of the Control Flow tab. To set the scope to an event handler, select an executable and an event handler on the design surface of the Event Handler tab.
- Badges
- Science topic