![]() You may also need to load it into Integration Services through SSMS to store it MSDB if that's your thing. Of course, this could be a problem since now you need to either copy the package to the server every time you want to update or deploy it. ![]() You can modify the connection objects each time before you deploy to a new server. This gives you the power of treating it like an actual SSIS package. The wizard just provides an interface with limited SSIS actions inside SSMS.ฤก) Create your plan inside BIDS or Visual Studio. ![]() Remember, that since SQL 2005, Maintenance Plans are basically just SSIS packages.
0 Comments
Leave a Reply. |