Here is a quick tip for those using SSIS packages with Microsoft SQL Server.
If you use the data import wizard in SQL Server and save a copy of the SSIS package used to import data you might want to reuse that package to load more data in the same format. However, once you’ve loaded the package up in Visual Studio you might wonder why the debug options are greyed out.
The reason for this is quite simple as it is because the package has been opened outside the confines of a project. Some may think that you should just be able to run a package without it being attached to a project but that’s a constraint that needs to be observed, Anyway, you just need to import the package into a project in Visual Studio and you’ll be able to debug and run your package without further issue.