Why Debugging is Greyed Out for SSIS Packages
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.
Boydo
My name is Boyd and I’m a Service Management Specialist with a knack for operational data gathering, transformation, analysis and reporting.
In 2012, I obtained my Masters of Science in Information Technology through the University of New South Wales @ The Australia Defence Force Academy (UNSW@ADFA).
I was also part of an online community known as the Panasonic Insider Crew in the capacity of “Insider Guru” for Panasonic Australia where I interacted with other tech enthusiasts and find out more about Panasonic's latest gadgets.
I love technology, gadgets, and the Internet and maintain a keen interest in these areas locally, nationally, and globally. I hope by sharing my views on these topics that people will receive an honest point of view from someone with a genuine interest in these topics.
I have also written and edited articles for Neowin - you can check out my articles over @ https://www.neowin.net/news/poster/boyd_chan
I hope you enjoy reading my blog!
Follow Us!