SSIS error when deploying from VS 2013 to SSISDB in SQL 2012

An SSIS package has been developed in SSDT-BI Microsoft Visual Studio Professional 2013 (freely available download).

When we deploy the package to SSISDB in SQL Server 2012 RTM or SP1 (11.0.3153.0) and run it, it returns the following error, because the SSIS 2014 package format is not downgradable to SSIS 2012 version format.

 “The package failed to load due to error 0xC0010014

“”One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.””. This occurs when CPackage::LoadFromXML fails.

   at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events)

   at Microsoft.SqlServer.Dts.Runtime.Project.LoadPackage(IProjectStorage storage, Package package, String streamName, IDTSEvents events)

   at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)

   at Microsoft.SqlServer.Dts.Runtime.PackageItem.LoadPackage(IDTSEvents events)

   at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerExecutionEvents.LoadPackage(PackageItem item)

   at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.StartPackage()

   at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.PerformOperation()”           
                          
“Package:Error: Package migration from version 8 to version 6 failed with error 0xC001700A “”The version number in the package is not valid. The version number cannot be greater than current version number.””.”                   

“Package:Error: Error loading value “”<DTS:Property xmlns:DTS=””www.microsoft.com/SqlServer/Dts“” DTS:Name=””PackageFormatVersion””>8</DTS:Property>”” from node “”DTS:Property””.”                                   

“Package:Error: The version number in the package is not valid. The version number cannot be greater than current version number.”

 

The underlying cause is that currently (Sept 2014 timeframe) SSDT BI 2014 for Visual Studio 2013 does not support SSIS packages for SQL Server 2012.

It is a common feature request, and the product group is well aware of the demand.

http://connect.microsoft.com/SQLServer/feedbackdetail/view/944882/ssdt-bi-2014-backward-compatibility-for-ssis-2012

At present SSDT for VS 2013 only works with SQL Server 2014. You have to use SSDT-BI for Visual Studio 2012 with SQL Server 2012 SSISDB.

 

Thanks, Jason

What version of Release Management Server/Client do I have?

This blog keeps a track of Release Management Server/Client versions starting from its inception. There are 3 ways to find out the version number: Method 1: You will find the Application Version , and the Database Version under Administration->Settings on the Release Management Client application. Fig. RM 2013 Client Method 2: You can also find the version numbers from the Control Panel -> Programs and Features. Method 3: You can also manually find out the version by finding out the file version…(read more)

App-V 5: On why the App-V 5 Sequencer *Really* Reboots

Prior to version 5 of App-V, when you sequenced an application that required a reboot, the reboot was simulated in that the sequencer would process the reboot action including the Pending File Operations and the RunOnce registry keys (RunOnce, RunOnceEx, GuiRunOnce, etc.) when monitoring ceased. In most cases, the simulation would be fine and all of the necessary reboot tasks would be processed properly. There were some exceptions – notably the famous disappearing Google Chrome application…(read more)

Entering Unicode Characters

As noted in the post Symbols and Emoji we have the ability to input characters in much more powerful ways than possible before the advent of modern computers and smart phones. We can insert symbols chosen from large galleries (Character Map, Office Insert Symbol Dialog, Office math ribbon, soft keyboards) to represent words and ideas. We can use Input Method Editors (IMEs) to enter any East Asian character and, for that matter as we see below, any Unicode character. In Microsoft Office applications, we can use the math linear format to enter arbitrary built-up mathematical expressions. We can use autocorrect to replace symbol names by the corresponding symbols. This post summarizes methods of entering symbols by their character codes including a couple of methods that probably aren’t familiar to audiences outside of China.

First let’s look at entering symbols by their Unicode code points. The alt+x “input method” is discussed in several of my posts, such as in Sans Serif Mathematical Symbols. For this method, you type the hexadecimal character code and then alt+x to convert the code to the symbol. This works in Word, Outlook, OneNote, RichEdit-based programs like WordPad. But it doesn’t work in NotePad, for example.

There are a couple of other ways of entering any character by its code. RichEdit supports arbitrary Unicode entry via alt+numpad digits. The code is entered as a decimal number while an alt key is pressed. Decimal isn’t very convenient, since the Unicode Standard displays code charts with hexadecimal character codes. Accordingly alt+x is easier with RichEdit. A curious anomaly came to my attention recently: alt+numpad numbers below 256 use the original IBM PC character set, all of which have counterparts in Unicode. For example, 1 is a smiley face. Windows dutifully translates the codes to the corresponding Unicode character. One user (at least) wants to include such choices in his password characters. Seems nice and secure, although you do need a numeric keypad which may limit its utility.

The Simplified Chinese IME on Windows 8.1 offers two ways of inputting characters by code: the vgb and vuc methods. These approaches have the advantage that they work with all applications that handle East Asian IME’s. For these you switch to the Chinese IME and type either vgb or vuc. Immediately the text switches from lower case to upper case. Next you type the character code. For vgb, you type the eight-digit character code in the GB18030 code page. For example, to enter ᥐ (U+1950, Tai Le letter KA), you can type vgb8134F434. No space is needed at the end since the eighth digit automatically terminates the field and replaces the vgb entry with the resulting character. This is handy if you’re familiar with GB18030. Most people would prefer to use Unicode since it’s so widely accessible and well documented. For this you type vuc followed by the hexadecimal Unicode value. To enter ᥐ with the vuc method, type vuc1950<space>.

That these IME methods allow a user to enter arbitrary Unicode characters has caused problems for RichEdit’s font binding. Basically an assumption was made long ago that a single font could handle all characters that a given IME could deliver. Gradually this assumption has had to be relaxed. It turns out that the vuc method can be recognized and font bound just as alt+x is font bound. But the vgb method is sneakier in that you don’t get a chance to recognize the full vgb code before the resulting character arrives.

Azure Dev Camps

Here’s your chance to roll up your sleeves and learn about the latest Microsoft Azure development tools and technologies. Join Microsoft technical experts at your local Microsoft Cloud DevCamp and leave with code running in the cloud!

You will learn how to use the new Microsoft Azure features and services like Microsoft Azure Virtual Machines, Websites, and Visual Studio 2013 to build and move a variety of apps to the cloud, including websites, mobile applications, and enterprise-class applications.

Developers of all languages are welcome. With Microsoft Azure, you can use practically any language, framework, or tool to build or move existing applications to the cloud.

For more information or to register, select a city near you.

Central Region

Date

Chicago, IL

10/8

St. Louis, MO

10/8

Minneapolis, MN

10/14

Cincinnati, OH

10/15

Kansas City, KS

10/28

Dallas, TX

10/28

Detroit, MI

11/4

Downers Grove, IL

11/12

Houston, TX

11/13

Nashville, TN

11/19

Indianapolis, IN

12/2

Austin, TX

12/4

Waukesha, WI

12/16

Dashboard Designer for PerformancePoint Services 2010 will not launch if you go to the BI Center main page and select the "Start using PerformancePoint Services" link

Issue

In some cases, Dashboard Designer for PerformancePoint Services 2010 will not launch if you go to the BI Center main page and select the “Start using PerformancePoint Services” link.

Cause

In some cases, the cause of this is that the master page for both the Site Master Page and the System Master Page for the BI site not set to v4.master.

Workaround

In this scenario, the resolution is to set the Site Master Page and the System Master Page for the BI site to use v4.master, and then Dashboard Designer for PerformancePoint Services 2010 will launch.

You can do this in Site Settings > Master Page.

Also, the user launching Dashboard Designer needs to be in the local Administrators group on their local machine.

 

 

 

 

Delivering Office 365 on your different screens and wrist

The Office team have also been busy creating plenty of new scenarios for using Office on a range of different devices (it seems as if every month there’s a new format of device appearing that can support a scenario with one of the Office apps). If you still think of Office as being an app that you install on your PC, then you might be surprised by some of the recent announcements:

OneDrive for Business for Android, which allows you to seamlessly access your 1TB of Office 365 storage from an Android phone or tablet.

Lync enhancements for iOS released last month included the ability to have the Lync Gallery View and up to four live video streams on your iPhone or iPad screen. Both of which make online meetings more interactive and visual.

image

There’s been a recent dash of enhancements to OneNote too:

OneNote on Android watchOneNote for Android Wear, so that you can now talk to your wrist and start dictating notes that get synced into your OneNote notebook – and onto any other devices you’re also running OneNote one.

Handwriting support in OneNote for Android tablets now allows you to write or draw with a stylus or your finger, so now you can easily create drawings, annotate on top of documents etc

OneNote for Windows 8 has received updates that focus on student features such as ink highlighting and better support for printing and inserting files. These features will help the Windows 8 version of OneNote to catch up with the features of the full desktop version of OneNote. I actually use both versions on my Surface 3, depending on what I’m doing, and whether I want a simple ‘notebook’ setup for handwritten notes, or I want the full-blown mode for extensive editing etc

StorSimple 5000/7000 Series: New Software Upgrade Patch v2.1.1.478 is now available

Software Patch v2.1.1.478 is now available to download for StorSimple 5000/7000 series at site. ftp://ftp.xyratex.com/pub/storsimple/Patch7

Key Points:

FAQs:

When should customer do Firmware Upgrade?

Any customer running appliance software >= v2.1.1.325 and <= 2.1.1.454 should do a Firmware upgrade

Should appliance running software >= 2.1.1.455 need firmware upgrade?

Ideally any appliance running software >= 2.1.1.455 do not need firmware upgrade, they should already be on latest Firmware.

Will the appliance run into any issues if Firmware upgrade patch storsimple-2.1.1.461-B47-firmware-bundle-install-patch.tar is run on the appliance that already has the latest firmware?

No, there are no issues if firmware upgrade patch is run on the appliance which already has latest firmware. The firmware upgrade will complete faster since it compares and skips if the latest one is found.

 

Big Savings on Microsoft Competency Exams

Build your product knowledge and capabilities by earning the certifications and accreditations that help you and your company stand out.

By purchasing a Microsoft competency exam pack, you take a step toward meeting your organisation’s Microsoft gold or silver competency requirements.

Provide exam vouchers to individuals within your organisation to prepare them for their Microsoft Certification exams and to achieve your organisation’s competency requirements.

Whether you’re looking to meet new competency requirements or to simply highlight your team’s world-class skills, this is a great way to get started.

Don’t delay, the promotion ends December 31, 2014, and the vouchers expire May 31, 2015.

 

image

image

How to order competency exam packs:

  1. Determine which pack you want: one, five or ten (remember that these vouchers are only good until May 31, 2015.
  2. Go to the Pearson VUE voucher site and click one of the PDF links to open the online voucher order form for your region.
  3. Fill in the order form. It is helpful to know:
    • Your Microsoft partner number
    • The currency you will be using to pay
    • Method of payment (credit card, PO, etc.)
  4. Click the “Submit” button to send your voucher order directly to Pearson VUE.
  5. Vouchers will be issued within two business days from the time of submission.

Learn to use the PowerShell cmdlet for testing the Microsoft Distributed Transaction Coordinator (MSDTC)

The following article assume the following:

        1. You have no firewall between the server and client or it has been disabled or configured to allow for DTC traffic to occur.

        2. The authentication scheme for DTC is supported by both server and client.

        3. The tester is running as system administrator with elevated permissions.

        4. You have permissions to execute PowerShell commands. (set-executionPolicy)

 

* You may use the MMC for Component Services to view the Transaction Statistics during this exercise. Load Component Services from the Administrative Tools and navigate to:

        [MMCComponent ServicesComputersMy Computer Distributed Transaction CoordinatorLocal DTCTransaction Statistics]

How to perform a local transaction

                1. Open C:WindowsSystem32WindowsPowerShellv1.0powershell.exe as Administrator

                2. Run the following command:

Start-DtcDiagnosticResourceManager

                3. Now create a variable to hold a DtcDiagnosticTransaction by running the following command: 

                $transObject = New-DtcDiagnosticTransaction

                4. To send the transaction, run the following command:

                Send-DtcDiagnosticTransaction–Transaction $transObject

                (Notice the Transaction Statistics now show an active transaction)                 

                5. Now complete the transaction by issuing this command:

Complete-DtcDiagnosticTransaction $transObject

                (Notice the transaction should be committed)                 

                6. If you are finished testing, you can stop the Resource Manager by issuing this command:

Stop-DtcDiagnosticResourceManager -Name “DtcDiagRM:3002″

               

How to perform a distributed transaction

For our example, I’ve named the two machines Server1x64 and Client1x64 to act as participants in a Distributed Transaction.    

        Perform these steps on the Server1x64 

1. Open C:WindowsSystem32WindowsPowerShellv1.0powershell.exe as Administrator               
2. Run the following command:

Start-DtcDiagnosticResourceManager    

        Perform these steps on the Client1x64

1. Create a variable to hold a DtcDiagnosticTransaction by running the following command: 

$transObject = New-DtcDiagnosticTransaction

               
2. To send the transaction, run the following command:

Send-DtcDiagnosticTransaction –ComputerName Server1x64

               
3. Now complete the transaction by issuing this command:

Complete-DtcDiagnosticTransaction $transObject 

                       

Cleanup: Perform these steps on the Server1x64

If you are finished testing, you can stop the Resource Manager by issuing this command:

Stop-DtcDiagnosticResourceManager -Name “DtcDiagRM:3002″

References:

 

Using the Set-ExecutionPolicy Cmdlet

http://technet.microsoft.com/en-us/library/ee176961.aspx

 

Configuring Microsoft Distributed Transaction Coordinator (DTC) to work through a firewall

http://support.microsoft.com/kb/250367

 

Microsoft.Dtc.PowerShell.Diagnostics

http://msdn.microsoft.com/en-us/library/windows/desktop/hh438328(v=VS.85).aspx