December 4, 2013 at 12:53 am
I've created a package to load xls file to my DB table. While running the package from BIDS, it's running perfectly but after copying my .dstx file to the server location and running it using dtexec utility, it gives following error:
"Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted."
December 4, 2013 at 1:05 am
What is the protection level of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 1:28 am
It's EncryptSensitiveWithUserKey.
December 4, 2013 at 2:20 am
Change it to DontSaveSensitive and try again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 3:06 am
I tried this as well but it's not working. The path i'm giving for this package is like:
C:/.../dtexec.exe /f "\\ServerA\SSIS\Packages\MyPackage.dstx"
Can there be any issue with the path ? Permissions for that path are good.
December 4, 2013 at 3:39 am
What is the full output of the dtexec log?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 4:14 am
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.5500.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 3:15:22 AM
Error: 2013-11-29 03:15:22.02
Code: 0xC0011006
Source: {12GE82DD-A13X-52A8-5542-2G7F5C4ADB59}
Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2013-11-29 03:15:22.02
Code: 0xC0011006
Source: {12GE82DD-A13X-52A8-5542-2G7F5C4ADB59}
Description: Failed to open package file "\\MyServer\SSIS\Packages\MyPackage.dstx" due to error 0x800C0006 "The system cannot locate the object specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
End Error
Could not load package "\\MyServer\SSIS\Packages\MyPackage.dstx" because of error 0xC0011006.
Description: Failed to open package file "\\MyServer\SSIS\Packages\MyPackage.dstx" due to error 0x800C0006 "The system cannot locate the object specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
Source: {12GE82DD-A13X-52A8-5542-2G7F5C4ADB59}
Started: 3:15:22 AM
Finished: 3:15:23 AM
Elapsed: 0.316 seconds
December 4, 2013 at 6:02 am
What is this package doing in the log?
Could not load package "C:\Working\Ankit\Recons\Recon82\EBAR
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 6:08 am
SSIS Package extension is "dtsx" not "dstx".
December 4, 2013 at 6:22 am
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".
Nicely spotted 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 7:03 am
Koen Verbeeck (12/4/2013)
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".Nicely spotted 😀
Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs. Rest is same as in logs.
December 4, 2013 at 7:48 am
Koen Verbeeck (12/4/2013)
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".Nicely spotted 😀
Appreciated 😎
December 4, 2013 at 8:33 am
Any help would be really appreciated. I have tried but not going anywhere. 🙁
December 4, 2013 at 8:59 am
sqlnaive (12/4/2013)
Koen Verbeeck (12/4/2013)
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".Nicely spotted 😀
Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs. Rest is same as in logs.
Huh? Are you deliberately repeating the same 'typo' for some reason?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
December 4, 2013 at 9:03 am
Phil Parkin (12/4/2013)
sqlnaive (12/4/2013)
Koen Verbeeck (12/4/2013)
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".Nicely spotted 😀
Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs. Rest is same as in logs.
Huh? Are you deliberately repeating the same 'typo' for some reason?
You see ? What impact this problem is having on my mind. Have to go for a coffee break. 🙂 It's dtsx. And this time it's final.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply