Page 1 of 17012345678910...2025303540...Last »

#CONV15 – Convergence 2015 Atlanta – Day 3

David Meego - Click for blog homepageConvergence2015

Having managed to escape the zombies at the Rock-n-Rave party, Mariano and I were ready for another day at Convergence 2015.

We left home reasonably early, but as there had been some rain in the morning, the traffic on the freeway was banked right back so that even the entrance ramps were car parks. Mariano decided to take a different route into the city and while it did mean that we were continuously moving, I don’t think it saved us any time. :-)

By the time we arrived at the conference center, it was too late to sit in on the interactive discussion on Microsoft Dynamics GP Security: Tips and tricks that I was planning to go to. Oh well.

We had less people at the repeat of our session, CSG024-R2: Microsoft Dynamics GP 2015: Customizing the user interface, but it went well and we had lots of audience interaction and questions. Maybe that is because we bribed people with Tim Tams if they asked or answered a question.

Session
Mariano and David presenting (Picture by Beat Bucher)

After the session, I decided to go back to the Expo to try and cover the sections I had missed. James McCullough who was in the previous session decided to come along with me. It was nice to have someone to chat with as we went around the Expo.

This year they did not have any identifying labels on the stands as to which Dynamics products the exhibitor was compatible with. Also there did not seem to be any planning of locations for the exhibitors. For someone only really interested in Microsoft Dynamics GP and products that integrate with GP, it made going through the Expo a long process. I know some products integrate with multiple flavours of Dynamics, but surely there must be a better way to organise the stands.

After collecting lots of freebies, chatting with a number of the exhibitors and even solving a Rubik’s Cube at one of the stands, it was time for the Expo to close down for the night. I had completed about 75% of the Expo and planned to come back tomorrow to see the final section.

As I was leaving I caught up with Joe Carroll from Dynamic Partner Connections and Dynamic Communities. I love the work that Joe does for the community and it is always nice to stand next to someone my own size (well at least in one direction).

DavidJoe
David Musgrave and Joe Carroll

After the Expo, James had to run to catch a coach back to his hotel. I caught up with Mariano and we went back to the Omni Hotel’s Lobby Bar to relax and socialise before tonight’s Convergence Celebration event.

For the Convergence Celebration we all headed over to the Philips Arena again to listen to a DJ and then see a live performance from the popular band OneRepublic. Mariano had organised an extra ticket for a Colombian friend’s daughter who is currently living in Atlanta.

JenniMariano
Jenni and Mariano

 Crowd
The crowd getting excited as we wait for One Republic (click for larger)

 BeatMarianoJenniDavid
Beat, Mariano, Jenni and David

When we first arrived at the Philips Arena, we headed down to the area directly in front of the stage. But once the band started playing, I realised that someone of my stature is not very suited to standing in the mosh pit especially when someone like Rob Bernhardt is standing between me and the stage. I am a little too old and a tad too heavy to ask to sit on Rob’s shoulders, so I moved back up into the seats and sat with Cindy and Tanya. This gave me a much better angle to get some good photos and video of the band performing on stage.

OneRepublic
OneRepublic on stage

Check out some videos of the performance. I apologise in advance if they are a bit shaky as they were taken on a hand held camera from reasonably far away.

OneRepublic at Microsoft Convergence 2015 in Atlanta – Stop and Stare (direct link)

 

OneRepublic at Microsoft Convergence 2015 in Atlanta – Acoustic (direct link)

 

OneRepublic at Microsoft Convergence 2015 in Atlanta – Counting Stars (direct link)

 

OneRepublic at Microsoft Convergence 2015 in Atlanta – Finale (direct link)

 

OneBelievable
The end of an OneBelievable night.

After the show was over, I had to find Mariano again as he was providing my ride home. A bit of searching in the crowd and I was able to find him in the photo above. See the photo below where I have zoomed in a little.

 MarianoOnPhone
Where’s Mariano? Oh there he is … on the phone again!!!

So here ended another great, but long day.

Last day tomorrow.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

Continued here:
#CONV15 – Convergence 2015 Atlanta – Day 3

March 31, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 2

#CONV15 – Convergence 2015 Atlanta – Day 2

David Meego - Click for blog homepageConvergence2015

I was exhausted already and it was only Day 2 of the Convergence 2015 conference.

As there were no sessions Mariano and I planned to attend first thing in the morning, we started the day a bit later. The downside is that the morning traffic had built up by the time we left and so it took a bit longer to get into Downtown Atlanta.

Once we got to the Georgia World Congress Center, we went to the Speaker Workroom to make final preparations for customisation session later in the day. Not very exciting, but it did help make the session better for those who attended.

At the CSG024-R1: Microsoft Dynamics GP 2015: Customizing the user interface session as Mariano and I were getting our machines setup and the audio guy was wiring the microphones for us, I noticed someone in the audience with writing on their shirt that looked like it had my name on it.

I had to stop and investigate further. It turned out that Steven Vallarian, knowing that I was negotiating with Microsoft for the rights to the Support Debugging Tool, Menus for Visual Studio Tools and SnapShot, had got a number of t-shirts made up with the wording “Free David Musgrave’s Code”.

FreeCode
David Musgrave and Steven Vallarian with the Free David Musgrave’s Code shirts

Thanks to Steven, a few lucky people have one of these rare shirts. While I loved the thought that went into the shirts, the negotiations with Microsoft had already been successful by the time Convergence started. This meant that Beat Bucher’s #FreeCode hash tag, did not really trend on Twitter. However, it did provide everyone with a laugh. Thanks Steven for the shirts and for putting a smile on many faces.

After that the session went very well, with brief explanations of the strengths and weaknesses of each of the options for customizing the Microsoft Dynamics GP 2015 user interface. We covered Modifier & Visual Basic for Applications (VBA), Visual Studio Tools (VST), Modifier with VST instead of VBA and Dexterity. We had demos of each tool in action, but due to time constraints, only discussed the code at the conceptual level. The source code for these demos will be posted soon on this blog and Mariano’s blog.

The message for this part of the session was that there are many options available to you and you can mix and match the tools to find the best solution for your customization.

We also surprised people by including a couple of demos for the new Service Based Architecture functionality added to Dexterity for Microsoft Dynamics GP 2015. We showed posting a batch via a web service call and pulling data into a Project Sienna application.

The message here is that you no longer have just limit yourself to customizing the user interface, but you can now extend the user interface into other environments and devices using REST based web services.

Thank-you to everyone who came to the session, especially those who answered questions or came up afterwards to ask questions or say hello. Hope you enjoyed the Tim Tams.

After the session, I had a meeting to go to, but wanted to see if I could find Pam Misialek. Pam was my contact at Microsoft for the software code negotiations and I had to give her one of Steven’s t-shirts. While looking for her, I found Chad Sogge, who had always been supportive of giving me the code for the products I developed. I thought it appropriate for him to have a shirt as well.

Chad
Chad Sogge showing his support. Thanks Chad

Chad told me that Pam was in a particular room, so stuck my head in the room to see if she was free…. Only to be spotted and called to the front of the room by Mark Polino, just before they started the popular DDG101: Excel, Excel, Excel. An Excel Shootout session. I had time to wave to everyone, give Pam the t-shirt (without an explanation, which confused her as the code was already “free”) and make a quick exit.

After my meeting, I went back to the Expo and continued visiting the various exhibitors. Sadly, I ran out of time and the Expo closed after I had only been there a little while.

I caught up with Mariano and we headed back to the Omni Hotel Lobby bar to relax and chat with other attendees and presenters. While there I caught up with the eOne Solutions team who are always ready to have their photo taken.

eOne crew
eOne Solutions team, including my ex-Microsoftie pal Patrick “Superman” Roth

After a few drinks, Mariano and I sat down at the Omni Hotel’s Prime Meridian restaurant (just next to the lobby bar) to have some dinner before the Rock-n-Rave party. Just after we sat down, Cindy and Tanya (who were at our customisation session) came in and were going to sit at another table. As much as I enjoy Mariano’s company, dinner would be much more interesting with additional people, so I asked them to join us. They are much prettier than Mariano anyway.

Dinner
Dinner: Mariano Gomez, Cindy Reeves, Tanya Markwith and David Musgrave

After dinner we headed over to the Rock-n-Rave party which had a zombie theme to it this year. Thanks to the sponsors of the party: http://www.rock-n-rave.com/sponsors/

JohnMike
John Lowther and Mike McDowell: One is ugly and the other is a zombie

 RocknRave
Rock-n-Rave party at Georgia Railroad Freight Depot

 ZombieLisa
Zombies don’t scare me … much

 ZombieCraigOra
Craig Klapman and Ora Goldman scare Ora’s daughter

Mariano and I did not stay too late as we needed to be awake for the repeat of our customization session the next day.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

Read the article:
#CONV15 – Convergence 2015 Atlanta – Day 2

March 31, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 7

#CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote

David Meego - Click for blog homepageConvergence2015

Today was the first day of the actual Convergence 2015 conference.

The first stop for the day was to one of the Speaker Rehearsal Rooms so that Mariano could fine tune his role in the MVP portion of the Microsoft Dynamics GP general session later in the day.

After the rehearsal we joined the long queues of conference attendees heading across the road from the Georgia World Congress Center to the Philips Arena (Home of the Atlanta Hawks) for the Opening Keynote for Convergence 2015.

The Opening Keynote for Convergence 2015 featured Satya Nadella, Microsoft CEO as well as Kirill Tatarinov, Microsoft Executive Vice President, Business Solutions. It was very well attended (I believe the conference had about 12,000 attendees), which meant that we had to go to the upper level to find a seat. Here is the view from the “Gods”.

Arena
Opening Keynote: The view from our seats

Thanks to my camera’s 20x optical zoom, I was able to get some closer photos during the session.

Satya
Satya Nadella, Microsoft CEO

RussellWilson
Russell Wilson from Seattle Seahawks discussing how he uses his Surface Pro 3

SatyaDemo
Satya doing his own demos… and they even worked too!!

 SurfaceHub
Surface Hub (an 84 inch, 4K screen with an integrated computer and built-in
sensors, cameras, speakers, microphones, WiFi, Bluetooth, NFC and more)

Kirill
Kirill Tatarinov, Microsoft Executive Vice President, Business Solutions

For the actual content of the Opening Keynote, the best method would be to watch it yourself online via the Convergence Video Library.

Use the link below to go directly to the session video:

After the keynote, I headed back over to the Sidney J. Marcus Auditorium in the GWCC for the Microsoft Dynamics GP Product Roadmap and Strategy general session. Mariano had already left as he had to be there early to get prepared.

Day 1, to be continued …

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

Visit site:
#CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote

March 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 6

#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

David Meego - Click for blog homepageConvergence2015

The conference starts today with the partner only pre Convergence event, PreGame.

PreGame

The PreGame is organised by Dynamic Partner Connections and is a partner focussed half day event. It is described as “Over 600 Microsoft Dynamics partners gathered in Atlanta, to hear from 70 expert speakers during 25 partner-centric sessions contributing to 1 Dynamics Partner Community”.

The day started with Mariano and I going to Georgia World Congress Center to register for Convergence 2015.

Welcome
Welcome to Convergence 2015

While at the main entrance between Buildings A and B, we met with some of the LATAM Microsoft team.

Mexico Office
LATAM Microsoft Dynamics Team with Mariano and David.
Do their tops mean that I have lost my Superpower?

We then walked over to the Westin Peachtree Plaza hotel for the start of the PreGame event. This was my first chance to meet up with some of the other Microsoft Dynamics GP MVPs (other than Mariano) and with some of the GPUG team.

GPUG & MVP
David Musgrave, John Lowther MVP, Belinda Allen MVP,
Kim Peterson GPUG, Mariano Gomez MVP and Bob McAdam GPUG

At this time I should point out a common misconception. I am not a Microsoft MVP and have never been one. As a Microsoft employee for 13.5 years I was not eligible and I have to be outside of Microsoft for 12 months before I can be eligible. So, even though the actual MVPs and many in the community treat me as an “Honorary MVP”, it is not official.

For my first session I went to the session “ISV Confidential: How to Work the Microsoft Dynamics Ecosystem and Get Results”. It was a great session with a number of experienced ISVs on the panel giving us the benefit of their experience. They explained how big flashy product launches are not as effective as the prolonged approach with reputation building and word of mouth marketing. A consistent and long term marketing presence is needed to build the client base. It was also a good opportunity for me to get some feedback on the pricing model I am planning for the rebadged Support Debugging Tool.

We then had a Dynamics GP general session: “Product Strategy and Roadmap”. This was a preview of the content we would see in the Convergence Dynamics GP general session, with a bit more depth. It allowed the partners to be ready for any questions their customers attending Convergence might have.

The usual suspects were there, including Errol Schoenfish, Pam Misialek, Chad Sogge and Jeff Trosen.

Errol
Introduction by Errol Schoenfish. #IfErrolCanDoIt

Not sure if Pam is telling me off for taking a photo, emphasizing a point or throwing down a rap tune.

Pam
Pam Misialek laying down the law

The main take away points from this session where the latest product roadmap slide. The Roadmap now shows planned releases for GP 2015 R2 and GP 2015 R3 as well as the next version in the latter half of 2016 onwards.

Roadmap
Microsoft Dynamics GP Roadmap

We also got to see some more details of what is planned for the upcoming releases. Below is a summary slide of what is planned for the GP 2015 R2 release due mid 2015.

GP2015R2_Features
Microsoft Dynamics GP 2015 R2 features

We had a demo of the All-in-One document viewer for Purchasing which allows you to see the entire flow of documents between Requisitions, Purchase Orders, Invoices and Receivings for a vendor. Very cool. This All-in-One view will be added to other series (Sales, Inventory, etc.) in future releases.

We also had a preview of the next generation of the Web client which will work on HTML5 rather than Silverlight. This will make the vision of any browser on any device a reality.

After the general session, I went to the “User Panel: What Do Customers Really Expect?” session. This was an interesting session which hopefully helped partners to understand how to best work with their customers. A great example that came out of that session shows how not to have good relations with a customer. Without mentioning any names: A customer who had not heard from their partner for a while, invites the partner to lunch to touch base and re-establish a working relationship. The partner sends three representatives who enjoyed a nice meal paid for by the customer. Shortly after, the customer receives an invoice for 6 hours consulting (3 consultants for 2 hours). An excellent example for relationship building… NOT.

The final session for the day was the PreGame Closing Keynote featuring the new Vice President Dynamics Partner Sales and Programs, Direct of ERP Partner Strategy, Victor Morales.

Before Victor spoke we had a presentation from Brian Deming who introduced us to the new independent, non-profit membership organisation which will service the professionals for all Dynamics products. Its initial focus will be on certifications for Dynamics GP and Dynamics NAV and eventually for Dynamics SL. This organisation is The Association of Dynamics Professionals and its website can be found at http://dynamicspro.org/. Please go to the site to register your interest. They plan to officially launch the association in September 2015, however, if you are interested in helping with the development of the certification exams, please contact them now.

DynamicPro
The Association of Dynamics Professionals

Hal Howard then spoke to us about Dynamic Communities (including the user groups, such as GPUG) and  gave us some interesting statistics.

DynamicCommunities
Dynamic Communities

Finally, we heard from Victor Morales, who explained how he is still new and learning lots about Microsoft and his new role. He is very open to feedback and improving the working relationships between Microsoft and its Dynamics Partners.

Victor
Victor Morales

Victor also provided us with some statistics of how both the Microsoft Cloud and Microsoft Dynamics ecosystems are growing.

CloudAndDynamics
Microsoft Cloud and Dynamics Momentum

The session finished with a quick question and answer session. The day ended with the Microsoft Partner Reception where partners could relax and have a drink and some nibbles and chat with other partners. The networking that occurs at these sorts of receptions can be some of the most valuable time spent at a conference.

One last stop: Mariano and I went to the MVP Mingle held at Stats Food & Drink. This event was sponsored by FastPath and Data Masons and allowed the MVPs for all the Dynamics products to socialise and relax together. I abused my “Honorary MVP” status and gate crashed. Well, Mariano was my transport home, so I was not going to lose him. I spent much of the night chatting with Beat Bucher (another Honorary MVP).

During the closing session, the upcoming events were highlighted, so here is a quick reminder to mark your calendars.

  • reIMAGINE 2015 in Fargo, ND, USA on 21-23 September 2015
  • GPUG Summit 2015 in Reno, NV, USA on 12-16 October 2015
  • PreGame at Summit 2015 in Reno, NV, USA on 13 October 2015

Hope to see you at these events.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

View post:
#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

March 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 10

#CONV15 – Convergence 2015 Atlanta – Pre Conference

David Meego - Click for blog homepageConvergence2015

Wow, Time has gone so quickly. I had the good intentions of posting about each day of the Convergence 2015 conference on the next day. I had already created all the blank placeholder posts in preparation.

Then reality struck…. With days starting around 6am to get ready and drive into town and finishing at midnight or later, it was just not possible to write the blog posts and get some (not enough) sleep.

Anyhow, I am back in Australia now and will attempt to give you a taste of what the conference was like.

I arrived on Friday 13th (lucky I am not superstitious), which gave me Saturday to sleep in a little. I did not want to sleep in too much as the quicker you can shift your sleep patterns, the quicker you can get over the “Jet Lag”. Atlanta time was currently a full 12 hour shift from Perth, so I was completely messed up.

So I got up about 9am and said hello to Mariano’s demon dogs (ok, it happens to all dog’s eyes when you use a flash). Mariano and his kids were out doing volunteer work for the day and so the puppies were pleased to see me.

DogsAngel and Ebony

I remembered that I had not taken a photo of the stash of Aussie contraband that I smuggled into the USA, so I laid it all out and took a photo (minus two packs of Tim Tams and a pack of Chicos already given to Mariano).

Stash
The Stash: 12 of 14 packs of Arnott’s Tim Tams, 5 of 6 packs of Allen’s Chicos
and 2 tubes of axle grease Vegemite

I spent the rest of Saturday working on the customisation presentation that Mariano and I would be delivering in a few days time. I decided it might be handy to have some demos for the presentation, as

  1. Sessions with only PowerPoint slides are boring
  2. People have come to expect it with our sessions

So, I created the primary demos based on the same customisation built using Modifier & Visual Basic for Applications (VBA), Modifier & Visual Studio Tools and Dexterity. I also fine tuned the presentation deck.

I got a relatively early night and tried to get a good night’s sleep…. Hard when you wake up multiple times because your body clock keeps saying “Get up you lazy sod, it’s daytime.”.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Dynamics, GP, Microsoft, News Tagged: Conference, Convergence 2015, News

See more here:
#CONV15 – Convergence 2015 Atlanta – Pre Conference

March 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 10

Downloads for the Support Debugging Tool

David Meego - Click for blog homepageAs you should have heard by now, Winthrop Development Consultants has an agreement with Microsoft to continue the development and support of the Support Debugging Tool.

It will be re-released once it has been rebranded, renamed and updated.

However, Microsoft has removed the downloads for the Support Debugging Tool from PartnerSource and so even previous releases cannot be downloaded.

I have updated the Winthrop Development Consultant’s web site Product page to provide access to the downloads for the previous versions.

Please note that the new Winthrop branded product will be available for the last three versions of Microsoft Dynamics GP; GP 2010, GP 2013 (including GP 2013 R2) and for GP 2015. It will have improvements and new features and will definitely be worth updating to once released.

Get the previous versions from http://winthropdc.com/SDT.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, Microsoft, News, Products, Support Debugging Tool Tagged: News, SDT, Support Debugging Tool

More:
Downloads for the Support Debugging Tool

March 26, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 12

Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

 

I am sure if were in the non-English countries, you might need to use code pages other than CP1252 to support your characters, and 1256 would your right choice for example if you been in Arab speaking countries, but this makes a problem when it comes to Analysis Cubes installation.

Once you install the Analysis Cubes and finish all wizard issues you feel like things are becoming easy and will proceed to start your job getting your cubes inititalized and then you will be start getting below errors:

Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “INTERID” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC02020F4    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “CMPNYNAM” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x800470C8    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The external columns for component “OLE DB Destination” (22) are out of synchronization with the data source columns. The external column “CompanyID” needs to be updated.  The external column “CompanyName” needs to be updated. 
End Warning 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004706B    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: “component “OLE DB Destination” (22)” failed validation and returned validation status “VS_ISBROKEN”. 
End Error 

Progress: 2015-03-23 10:18:58.26    
Source: Copy Data from Results to CompanyMaster Task     
Validating: 50% complete 
End Progress 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004700C    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: One or more component failed validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC0024107    
Source: Copy Data from Results to CompanyMaster Task     
Description: There were errors during task validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC00220E4    
Source: Run Company     
Description: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run.  . 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x80019002    
Source: DynamicsGP_TWO_to_DynamicsGPWarehouse_Package_Master     
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. 
The Execution method succeeded, but the number of errors raised (6) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.  End Warning  DTExec: The package execution returned DTSER_FAILURE (1). 
Started:  10:18:57 AM 
Finished: 10:18:58 AM 
Elapsed:  0.842 seconds. 
The package execution failed. 
The step failed.

Obviously it is all about the first error, different code pages are exist and therefore your data cannot be copied from the production database to the data warehouse, going further with investigations I been able to get around this error by unifying the code page in my packages, and this is by simply allowing a flag in cubes SSIS packages to use the default code page “AlwaysUseDefaultCodePage” to be “True” and your issues will no longer be shown:

image

Now the challenge here you need to extract the packages from the MSDB store, to your Visual Studio and perform this change, save your package and re-import this back to your MSDB, this will need to be done to the following packages:

DynamicsGP_DynamicsGPWarehouse_FiscalPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_GLBudgets.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDAGroups.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDATransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_GLTransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemCurrentQuantity.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemMaster.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingPurchaseOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingSalesOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PurchaseOrderDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesPerson.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesTerritory.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalExpense.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalRevenue.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingDetails.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriodAmounts.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_CheckbookRegister.dtsx
DynamicsGP_DynamicsGPWarehouse_CompanyMaster.dtsx

Luckily, I found a script that makes this easier, it allows you to extract all your SSIS packages from MSDB to file system instead of pulling these one by one, it will save the packages to a folder on your “C:” drive, and all what you need to do then is copying these to your visual studio and start changing the flag, below the script:

;
WITH FOLDERS AS
(
    — Capture root node
    SELECT
        cast(PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
    WHERE
        PF.parentfolderid IS NULL

    — build recursive hierarchy
    UNION ALL
    SELECT
        cast(F.FolderPath + ” + PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
        INNER JOIN
            FOLDERS F
            ON F.folderid = PF.parentfolderid
)
,   PACKAGES AS
(
    — pull information about stored SSIS packages
    SELECT
        P.name AS PackageName
    ,   P.id AS PackageId
    ,   P.description as PackageDescription
    ,   P.folderid
    ,   P.packageFormat
    ,   P.packageType
    ,   P.vermajor
    ,   P.verminor
    ,   P.verbuild
    ,   suser_sname(P.ownersid) AS ownername
    FROM
        msdb.dbo.sysssispackages P
)
SELECT
    — assumes default instance and localhost
    — use serverproperty(‘servername’) and serverproperty(‘instancename’)
    — if you need to really make this generic
    ‘dtutil /sourceserver localhost /SQL “‘+ F.FolderPath + ” + P.PackageName + ‘” /copy file;”C:Packages’ + P.PackageName +’.dtsx”‘ AS cmd
FROM
    FOLDERS F
    INNER JOIN
        PACKAGES P
        ON P.folderid = F.folderid
– uncomment this if you want to filter out the
– native Data Collector packages
– WHERE
–     F.FolderPath <> ‘Data Collector’

Once you run this on your SQL Server the result will be set of commands like the below, run these commands using CMD and go to find these in your C:Packages folder:

dtutil /sourceserver SERVERNAME /SQL “DynamicsGPWarehousePackage” /copy file;”C:PackagesPackage.dtsx”

Execute these over CMD and find your files on C: drive, select all and paste the files inside your Visual Studio and start your modifications, once done import back updated packages to SQL Integration Services one by one and rerun your job.

Hope that this helps.


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Visit link:
Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

March 23, 2015 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 15