I'm in a standard SQL Server Integration Services Package. I have created a connection to my local db instance. I drop a data flow task and then using a OLE DB source and Destination, I start creating my expected simple data flow.
Problem: I create a new table to dump my data from the source in SSMS and go back to visual studio's and look for it in the OLE DB Destination -- Name of the Table or the view drop down menu option and it's not there.
How do I refresh the cache without needing to close the ENTIRE program and reopen it?
I've asked some colleagues and they say they just close the entire program and reopen. So, at my work, I'm not the only person having this problem.
What doesn't seem to work:
- Tried to change connections in the drop down
- Tried to delete the destination connection and recreate
- Close the package and reopen
- Close the solution and reopen
- CTRL+SHIFT+R
What has worked:
- Close the entire program, visual studios, and reopen
This hints to me that it's somehow cached in visual studios.
Is there a easier way? I feel like there has to be... this is just silly that I have to close the entire program each time I add a table ... I reject this reality and wish to create my own!