You can store SSIS packages in three locations Physical files (File system), SSIS package store or SQL Server.
- File system stores SSIS package in simple folders.
- “SSIS package store” saves package in ”C:\Program Files\Microsoft SQL Server\..\DTS\Packages”.
- SQL Server stores package in SQL Server database called as MSDB.
In case you are fresher to SSIS, SSAS and SSRS you can start seeing our videos step by step
Do not forget to see our SQL Server interview question videos
Visit for more author’s blog on SQL Server interview questions
write a comment