Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

Any help would be greatly appreciated.

Jimmy

share|improve this question
    
Have you tried refreshing the view? exec sp_refreshview N'[dbo].[vMyView]' –  Shawn Melton Mar 27 at 17:58
    
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 at 18:04
    
Shawn -- performed an sp_refreshview command completed. No change in the integration –  SQLBeard Mar 27 at 19:51
    
Aaron -- Would never use SELECT * for a view. Everything is explicit. –  SQLBeard Mar 27 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.