How to create a Package XML Configuration file?

Question

Post reply

How to create a Package XML Configuration file?

jirakst

Ten Centuries

Points: 1047

February 23, 2017 at 2:09 pm

#319009

Hello,

I want to export data from SQL to Excel, but when I in Data Flow add OLE DB command for my localhost SQL connection, an error appears

SSIS Error Code DTS E OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14
I wanted to create an configuration file since I've ead it may be due to an authetification issue, but when I creat new package like DataTransfer.dtsx and choose SSIS menu, there's no option "Package Configuration" for version 2016 as suggest https://msdn.microsoft.com/en-us/library/ms365339.aspx
I can't load any data, how can I fix it?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

You can get to the Package Configuration Organizer through the Properties window. Click on the design surface of your package and press F4. Then click on the ellipsis button next to the Configurations property and the Package Configuration Organizer will appear.

John

jirakst Ten Centuries Points: 1047 More actions · Answer 2

Thanks, I found that.
But unfortunetelly this error appeared when I restarted my computer:
Warning loading DataTransfer.dtsx: The configuration environment variable was not found. The environment variable was: "DataTransfer". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid. C:\Users\jirak\Documents\Visual Studio 2015\Projects\Integration Services Project\Integration Services Project\DataTransfer.dtsx 1
I was following MSDN tutorial: https://msdn.microsoft.com/en-us/library/ms365339.aspx

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

I don't recommend using an environment variable - there are too many problems such as the one that you're seeing. And you have to restart your computer - fine in test or development but no so easy in production. Use the Specify configuration setting directly option, and pass the name of the configuration file in as a parameter whenever you run the package.

John