Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to connect FedEx Shipping Manager Integration Assistant to a SQL 2008 R2 database. I have a view created that has all the necessary fields to populate in the Integration Assistant. The problem, I am having, is I can make a change to the view on the SQL box, and it's not getting to the Integration Assistant.

I have attempted a new Integration, but, the new fields are not showing up. I have even attempted to use Excel and connect through using Microsoft Query, and I'm getting old data. I can change the view, but, it won't show up in Microsoft Query.

share|improve this question
    
Have you tried refreshing the view? exec sp_refreshview N'[dbo].[vMyView]' – Shawn Melton Mar 27 '14 at 17:58
1  
Funny, I was just talking about this. In addition to running sp_refreshview, make sure your view doesn't use SELECT * - if you add the columns there explicitly, this type of thing shouldn't happen in the first place. – Aaron Bertrand Mar 27 '14 at 18:04
    
Shawn -- performed an sp_refreshview command completed. No change in the integration – SQLBeard Mar 27 '14 at 19:51
    
Aaron -- Would never use SELECT * for a view. Everything is explicit. – SQLBeard Mar 27 '14 at 19:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.