April 21, 2008 at 1:16 pm
I have written a SQL query inside a "OLE DB Source" via the "Build Query" button. I'll refer to it as MainQuery. The query uses multiply Tables and Views. I had to make a change to one of the View it uses. However, when I go back to the MainQuery that uses that View it doesn't seem to take the changes I made.
Should it have taken the changes automatically? Do I need to do some type of 'refresh' to activate the View changes or do I have to add the View to the query again?
Any help would be greatly appreciated,
Dale
May 6, 2008 at 2:53 pm
I'm assuming you are seeing a validation error when you open the package (a yellow bang)? When I see those, I'm usually able to click on the yellow bang and it will ask me if I want it to fix itself. I usually allow it to since it usually gets it right. Otherwise, you'll have to manually edit each item in the package and make the same adjustments there you made in the view.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply