I have all the installed Control Flow Tasks. At one time I did create a Execute T-SQL Statement task, but after a couple of days when I revisited the project it is still there on my design area, but has disappeared from the Control Flow Tasks group in the toolbox. I did a check of all items. It has disappeared. Any clue(s)? I have posted a screen shot in my blog.
Jay
http://hodentek.blogspot.com/2007/08/strange-behaviour-visual-studio-2005.html
That's because the T-SQL task is under the Maintenance Plan Tasks, not Control Flow Items.The Execute SQL Task under the Control Flow items, though, is a much better fit long term and will do the same thing as the Execute T-SQL Task.|||
Right you are. Need changing my glasses.
Jay
No comments:
Post a Comment