I'm working with our SQL Server 2008 and want to create a new SSIS package via the SQL Server Business Intelligence Development Studio, but I have a question as far as saving it to SQL Server or File System.
Which is the best practice? And why?
Also, when I create a new package and try to save it, I don't see the option to save it to SQL Server, it just asks me for a path. How can I save it to SQL Server?