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.

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.