ssis package not able to deploy on Named instance

Question

Post reply

ssis package not able to deploy on Named instance

Oracle_91

SSChampion

Points: 14548
More actions
February 26, 2010 at 1:17 am

#139103

Hi,
In SQL 2000, we can import the DTS packages into SQL Server MSDB database for a Named Instance.
But in SQL 2005 and am not able to save/deploy the SSIS package in MSDB database???
Is there any work around to save in MSDB or else do we need to LIVE with saving the package in File system and using a stored procedure i.e DTExec utility we need to call that package???????
Any thoughts????

Viewing 11 posts - 1 through 10 (of 10 total)

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

Suresh Arumugam Hall of Fame Points: 3370 More actions · Answer 1

hi,

Did you try to use below option of Visual Studio to directly save the package into Sql server?

File -> "Save Copy of Pacakagename.dtsx As..".

Above option would help you to deploy package into Integration Servcies where the package would get deployed. Other option is to use the deployment manifest file (if you have) to deploy into Integration services.

Note: You would need to be more specific while mentioning the server name as its named instance like 'Servername\instancename'.

Hope this helps.

-Suresh

Regards,
Suresh Arumugam

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

SSIS is not really instance aware, in other words even if you have 3 SQL instances on a server you only have 1 SSIS server.

Now the tricky part is that SSIS server can store packages in ANY of the SQL instances, but only 1.

CEWII

Oracle_91 SSChampion Points: 14548 More actions · Answer 3

Oracle_91

SSChampion

Points: 14548

February 27, 2010 at 12:58 pm

#1126139

Thank You So much.

It work Fine 😀

Oracle_91 SSChampion Points: 14548 More actions · Answer 4

I have created a package in SQL 2008 BIDS and saved in a NAMED instance.

To verify whether it is saved or not, I also connected to SQL Server Integration Services instance.

--Under Stored Packages

-MSDB

-Normalization

Also, i queried whether the package was correctly saved or not using the below query

select * from msdb..sysssispackages

TestpkgF797646D-6276-4077-A92B-AA8F97BABCCENULL2010-05-26 16:10:52.00000000000-0000-0000-0000-0000000000000x0105000000000005150000008ACE31E646417D21BAEBAA5634FD01000x3C3F786D6C2076657273696F6E3D22312E30223F3E3C4454533A45786563757461626C6520786D6C6E733A4454533D227777772E6D6963726F736F66742E636F6D2F53716C5365727665722F44747322204454533A45786563757461626C65547970653D22535349532E5061636B6167652E32223E0D0A3C4454533A50726F7065727479204454533A4E616D653D225061636B616765466F726D617456657273696F6E223E333C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256657273696F6E436F6D6D656E7473223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2243726561746F724E616D65223E415349415041435C6D766164616D7564756C613C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2243726561746F72436F6D70757465724E616D65223E4D564144414D5544554C412D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4461746522204454533A44617461547970653D2237223E352F32362F3230313020343A31303A353220504D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225061636B61676554797065223E353C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2250726F74656374696F6E4C6576656C223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D6178436F6E63757272656E7445786563757461626C6573223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225061636B6167655072696F72697479436C617373223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256657273696F6E4D616A6F72223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256657273696F6E4D696E6F72223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256657273696F6E4275696C64223E363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256657273696F6E47554944223E7B37313841333239312D424536342D344235372D423242442D3242373739394545413931427D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22456E61626C65436F6E666967223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436865636B706F696E7446696C654E616D65223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2253617665436865636B706F696E7473223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436865636B706F696E745573616765223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225375707072657373436F6E66696775726174696F6E5761726E696E6773223E303C2F4454533A50726F70657274793E0D0A3C4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E4353435448434442434845315C53514C324B382E44434442534554322E73613C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4F4C4544423C2F4454533A50726F70657274793E3C4454533A50726F706572747945787072657373696F6E204454533A4E616D653D22496E697469616C436174616C6F67223E405B557365723A3A536F7572636544425D3C2F4454533A50726F706572747945787072657373696F6E3E3C4454533A50726F706572747945787072657373696F6E204454533A4E616D653D225365727665724E616D65223E405B557365723A3A536F757263655365727665725D3C2F4454533A50726F706572747945787072657373696F6E3E3C4454533A4F626A656374446174613E3C4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252657461696E223E303C2F4454533A50726F70657274793E3C4454533A50617373776F7264204454533A4E616D653D2250617373776F7264222053656E7369746976653D2231223E3C2F4454533A50617373776F72643E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E6E656374696F6E537472696E67223E4461746120536F757263653D4353435448434442434845315C53514C324B383B557365722049443D73613B496E697469616C20436174616C6F673D44434442534554323B50726F76696465723D53514C4E434C4931302E313B4170706C69636174696F6E204E616D653D535349532D5061636B6167652D7B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D4353435448434442434845315C53514C324B382E44434442534554322E73613B4175746F205472616E736C6174653D46616C73653B3C2F4454533A50726F70657274793E3C2F4454533A436F6E6E656374696F6E4D616E616765723E3C2F4454533A4F626A656374446174613E3C2F4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E4E6F726D616C697A6174696F6E2E6C6F673C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B42453535444636442D433441362D343642392D384638372D3030353030323538324642317D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E46494C453C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C65557361676554797065223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E6E656374696F6E537472696E67223E433A5C4454535F5265706F7369746F72795C4E6F726D616C697A6174696F6E2E6C6F673C2F4454533A50726F70657274793E3C2F4454533A436F6E6E656374696F6E4D616E616765723E3C2F4454533A4F626A656374446174613E3C2F4454533A436F6E6E656374696F6E4D616E616765723E0D0A3C4454533A436F6E66696775726174696F6E3E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E66696775726174696F6E54797065223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E66696775726174696F6E537472696E67223E433A5C4454535F5265706F7369746F72795C4E6F726D616C697A6174696F6E2E786D6C3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E66696775726174696F6E5661726961626C65223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E436F6E66696775726174696F6E20313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B36373843434230372D384430432D343636452D414331382D3044363341353343394133377D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A436F6E66696775726174696F6E3E0D0A3C4454533A4C6F6750726F76696465723E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6E666967537472696E67223E4E6F726D616C697A6174696F6E2E6C6F673C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E53534953206C6F672070726F766964657220666F7220546578742066696C65733C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B30373734333041372D363837422D343746352D423433342D3739383243413039343035317D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E577269746573206C6F6720656E747269657320666F72206576656E747320746F2061204353562066696C653C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4454532E4C6F6750726F76696465725465787446696C652E323C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C496E6E65724F626A6563742F3E3C2F4454533A4F626A656374446174613E3C2F4454533A4C6F6750726F76696465723E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6173744D6F64696669656450726F6475637456657273696F6E223E31302E302E323533312E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F7263654578656356616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224578656356616C756522204454533A44617461547970653D2233223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F726365457865637574696F6E526573756C74223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C6564223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C5061636B6167654F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C506172656E744F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D61784572726F72436F756E74223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2249534F4C6576656C223E313034383537363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F63616C654944223E313033333C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225472616E73616374696F6E4F7074696F6E223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A5661726961626C653E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C75617465417345787072657373696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224E616D657370616365223E557365723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22526561644F6E6C79223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252616973654368616E6765644576656E74223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22496E636C756465496E446562756744756D70223E323334353C2F4454533A50726F70657274793E3C4454533A5661726961626C6556616C7565204454533A44617461547970653D2238223E323030365130343C2F4454533A5661726961626C6556616C75653E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E4461746150726449443C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B41384146453130462D424441322D343538352D383141432D4231383938384546313031317D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A5661726961626C653E0D0A3C4454533A5661726961626C653E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C75617465417345787072657373696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224E616D657370616365223E557365723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22526561644F6E6C79223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252616973654368616E6765644576656E74223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22496E636C756465496E446562756744756D70223E323334353C2F4454533A50726F70657274793E3C4454533A5661726961626C6556616C7565204454533A44617461547970653D2238223E313330303C2F4454533A5661726961626C6556616C75653E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E46616349443C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B36383336443443412D303034412D344233422D384646422D3445423630354445304636327D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A5661726961626C653E0D0A3C4454533A5661726961626C653E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C75617465417345787072657373696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224E616D657370616365223E557365723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22526561644F6E6C79223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252616973654368616E6765644576656E74223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22496E636C756465496E446562756744756D70223E323334353C2F4454533A50726F70657274793E3C4454533A5661726961626C6556616C7565204454533A44617461547970653D2238223E44434442534554323C2F4454533A5661726961626C6556616C75653E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E536F7572636544423C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B42304534323736312D383339392D344544362D393945362D3546313941324545413037427D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A5661726961626C653E0D0A3C4454533A5661726961626C653E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C75617465417345787072657373696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224E616D657370616365223E557365723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22526561644F6E6C79223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252616973654368616E6765644576656E74223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22496E636C756465496E446562756744756D70223E323334353C2F4454533A50726F70657274793E3C4454533A5661726961626C6556616C7565204454533A44617461547970653D2238223E4353435448434442434845315C53514C324B383C2F4454533A5661726961626C6556616C75653E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E536F757263655365727665723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B37444637444332372D363542442D344236462D423845442D3134413646353645304435357D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A5661726961626C653E0D0A3C4454533A5661726961626C653E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C75617465417345787072657373696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224E616D657370616365223E557365723C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22526561644F6E6C79223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2252616973654368616E6765644576656E74223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22496E636C756465496E446562756744756D70223E323334353C2F4454533A50726F70657274793E3C4454533A5661726961626C6556616C7565204454533A44617461547970653D2238223E6263686F793C2F4454533A5661726961626C6556616C75653E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E5573657249443C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B44363236413933322D303531392D343444352D413639452D3637353844413745393735447D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E3C2F4454533A50726F70657274793E3C2F4454533A5661726961626C653E0D0A3C4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F6767696E674D6F6465223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C7465724B696E64223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576656E7446696C74657222204454533A44617461547970653D2238223E322C372C4F6E4572726F722C392C4F6E5761726E696E673C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6C756D6E46696C74657222204454533A4576656E744E616D653D224F6E4572726F72223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6D7075746572223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F70657261746F72223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22536F757263654E616D65223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22536F757263654944223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4944223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D65737361676554657874223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22446174614279746573223E2D313C2F4454533A50726F70657274793E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6C756D6E46696C74657222204454533A4576656E744E616D653D224F6E5761726E696E67223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22436F6D7075746572223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F70657261746F72223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22536F757263654E616D65223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22536F757263654944223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4944223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D65737361676554657874223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22446174614279746573223E2D313C2F4454533A50726F70657274793E3C2F4454533A50726F70657274793E3C4454533A53656C65637465644C6F6750726F7669646572204454533A496E7374616E636549443D227B30373734333041372D363837422D343746352D423433342D3739383243413039343035317D222F3E3C2F4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A45786563757461626C65204454533A45786563757461626C65547970653D224D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D3839383435646364383038306363393122204454533A54687265616448696E743D2230223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4C6F636174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E41646472657373223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225461736B436F6E74616374223E457865637574652053514C205461736B3B204D6963726F736F667420436F72706F726174696F6E3B204D6963726F736F66742053514C2053657276657220323030383B20C2A92032303037204D6963726F736F667420436F72706F726174696F6E3B20416C6C205269676874732052657365727665643B687474703A2F2F7777772E6D6963726F736F66742E636F6D2F73716C2F737570706F72742F64656661756C742E6173703B313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F7263654578656356616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224578656356616C756522204454533A44617461547970653D2233223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F726365457865637574696F6E526573756C74223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C6564223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C5061636B6167654F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C506172656E744F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D61784572726F72436F756E74223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2249534F4C6576656C223E313034383537363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F63616C654944223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225472616E73616374696F6E4F7074696F6E223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F6767696E674D6F6465223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C7465724B696E64223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576656E7446696C74657222204454533A44617461547970653D2238223E3C2F4454533A50726F70657274793E3C2F4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E414C4350726F636573734465665F53746172743C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B46344235373433452D394242442D343745312D394433382D3238353432323536444232317D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E457865637574652053514C205461736B3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D383938343564636438303830636339313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C654576656E7448616E646C657273223E303C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C53514C5461736B3A53716C5461736B446174612053514C5461736B3A436F6E6E656374696F6E3D227B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D222053514C5461736B3A54696D654F75743D2230222053514C5461736B3A497353746F72656450726F633D2246616C7365222053514C5461736B3A427970617373507265706172653D2254727565222053514C5461736B3A53716C53746D74536F75726365547970653D22446972656374496E707574222053514C5461736B3A53716C53746174656D656E74536F757263653D2245584543206462612E414C4350726F636573734465665F537461727420404661634944203D203F2C40446174615072644944203D203F2C2040557365724944203D203F2C20405265744D7367203D202727222053514C5461736B3A436F6465506167653D2231323532222053514C5461736B3A526573756C74547970653D22526573756C74536574547970655F4E6F6E652220786D6C6E733A53514C5461736B3D227777772E6D6963726F736F66742E636F6D2F73716C7365727665722F6474732F7461736B732F73716C7461736B223E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2230222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A4661634944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2231222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A446174615072644944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2232222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A557365724944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C2F53514C5461736B3A53716C5461736B446174613E3C2F4454533A4F626A656374446174613E3C2F4454533A45786563757461626C653E0D0A3C4454533A45786563757461626C65204454533A45786563757461626C65547970653D224D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D3839383435646364383038306363393122204454533A54687265616448696E743D2230223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4C6F636174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E41646472657373223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225461736B436F6E74616374223E457865637574652053514C205461736B3B204D6963726F736F667420436F72706F726174696F6E3B204D6963726F736F66742053514C2053657276657220323030383B20C2A92032303037204D6963726F736F667420436F72706F726174696F6E3B20416C6C205269676874732052657365727665643B687474703A2F2F7777772E6D6963726F736F66742E636F6D2F73716C2F737570706F72742F64656661756C742E6173703B313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F7263654578656356616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224578656356616C756522204454533A44617461547970653D2233223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F726365457865637574696F6E526573756C74223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C6564223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C5061636B6167654F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C506172656E744F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D61784572726F72436F756E74223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2249534F4C6576656C223E313034383537363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F63616C654944223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225472616E73616374696F6E4F7074696F6E223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F6767696E674D6F6465223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C7465724B696E64223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576656E7446696C74657222204454533A44617461547970653D2238223E3C2F4454533A50726F70657274793E3C2F4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E496E7465726E616C204E6F726D616C697A6174696F6E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B43413646433145412D453337322D344231302D414343342D3335304338313637373838417D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E457865637574652053514C205461736B3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D383938343564636438303830636339313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C654576656E7448616E646C657273223E303C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C53514C5461736B3A53716C5461736B446174612053514C5461736B3A436F6E6E656374696F6E3D227B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D222053514C5461736B3A54696D654F75743D2230222053514C5461736B3A497353746F72656450726F633D2246616C7365222053514C5461736B3A427970617373507265706172653D2254727565222053514C5461736B3A53716C53746D74536F75726365547970653D22446972656374496E707574222053514C5461736B3A53716C53746174656D656E74536F757263653D2245584543204442412E4E6F726D616C697A6174696F6E5F496E7465726E616C20404661634944203D203F2C20404461746150726449443D203F2C2040557365724944203D203F2C20405265744D7367203D202727222053514C5461736B3A436F6465506167653D2231323532222053514C5461736B3A526573756C74547970653D22526573756C74536574547970655F4E6F6E652220786D6C6E733A53514C5461736B3D227777772E6D6963726F736F66742E636F6D2F73716C7365727665722F6474732F7461736B732F73716C7461736B223E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2230222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A4661634944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2231222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A446174615072644944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2232222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A557365724944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C2F53514C5461736B3A53716C5461736B446174613E3C2F4454533A4F626A656374446174613E3C2F4454533A45786563757461626C653E0D0A3C4454533A45786563757461626C65204454533A45786563757461626C65547970653D224D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D3839383435646364383038306363393122204454533A54687265616448696E743D2231223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4C6F636174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E41646472657373223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225461736B436F6E74616374223E457865637574652053514C205461736B3B204D6963726F736F667420436F72706F726174696F6E3B204D6963726F736F66742053514C2053657276657220323030383B20C2A92032303037204D6963726F736F667420436F72706F726174696F6E3B20416C6C205269676874732052657365727665643B687474703A2F2F7777772E6D6963726F736F66742E636F6D2F73716C2F737570706F72742F64656661756C742E6173703B313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F7263654578656356616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224578656356616C756522204454533A44617461547970653D2233223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F726365457865637574696F6E526573756C74223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C6564223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C5061636B6167654F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C506172656E744F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D61784572726F72436F756E74223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2249534F4C6576656C223E313034383537363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F63616C654944223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225472616E73616374696F6E4F7074696F6E223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F6767696E674D6F6465223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C7465724B696E64223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576656E7446696C74657222204454533A44617461547970653D2238223E3C2F4454533A50726F70657274793E3C2F4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E534354204E6F726D616C697A6174696F6E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B35343743334633412D373933432D343638332D424531312D4542384334304336343135327D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E457865637574652053514C205461736B3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D383938343564636438303830636339313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C654576656E7448616E646C657273223E303C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C53514C5461736B3A53716C5461736B446174612053514C5461736B3A436F6E6E656374696F6E3D227B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D222053514C5461736B3A54696D654F75743D2230222053514C5461736B3A497353746F72656450726F633D2246616C7365222053514C5461736B3A427970617373507265706172653D2254727565222053514C5461736B3A53716C53746D74536F75726365547970653D22446972656374496E707574222053514C5461736B3A53716C53746174656D656E74536F757263653D2245584543204442412E4E6F726D616C697A6174696F6E5F53435420404661634944203D203F2C40446174615072644944203D203F2C2040557365724944203D203F2C20405265744D7367203D202727222053514C5461736B3A436F6465506167653D2231323532222053514C5461736B3A526573756C74547970653D22526573756C74536574547970655F4E6F6E652220786D6C6E733A53514C5461736B3D227777772E6D6963726F736F66742E636F6D2F73716C7365727665722F6474732F7461736B732F73716C7461736B223E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2230222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A4661634944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2231222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A446174615072644944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2232222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A557365724944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C2F53514C5461736B3A53716C5461736B446174613E3C2F4454533A4F626A656374446174613E3C2F4454533A45786563757461626C653E0D0A3C4454533A45786563757461626C65204454533A45786563757461626C65547970653D224D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D3839383435646364383038306363393122204454533A54687265616448696E743D2230223E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E4C6F636174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22457865637574696F6E41646472657373223E3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225461736B436F6E74616374223E457865637574652053514C205461736B3B204D6963726F736F667420436F72706F726174696F6E3B204D6963726F736F66742053514C2053657276657220323030383B20C2A92032303037204D6963726F736F667420436F72706F726174696F6E3B20416C6C205269676874732052657365727665643B687474703A2F2F7777772E6D6963726F736F66742E636F6D2F73716C2F737570706F72742F64656661756C742E6173703B313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F7263654578656356616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224578656356616C756522204454533A44617461547970653D2233223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D22466F726365457865637574696F6E526573756C74223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C6564223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C5061636B6167654F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224661696C506172656E744F6E4661696C757265223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224D61784572726F72436F756E74223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2249534F4C6576656C223E313034383537363C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F63616C654944223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D225472616E73616374696F6E4F7074696F6E223E313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244656C617956616C69646174696F6E223E303C2F4454533A50726F70657274793E0D0A3C4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F6767696E674D6F6465223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2246696C7465724B696E64223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576656E7446696C74657222204454533A44617461547970653D2238223E3C2F4454533A50726F70657274793E3C2F4454533A4C6F6767696E674F7074696F6E733E0D0A3C4454533A50726F7065727479204454533A4E616D653D224F626A6563744E616D65223E4E756D6572696320526573706F6E7365204167677265676174653C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224454534944223E7B42384644304633362D384532452D343636462D383532452D4535384243464145423230307D3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224465736372697074696F6E223E457865637574652053514C205461736B3C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224372656174696F6E4E616D65223E4D6963726F736F66742E53716C5365727665722E4474732E5461736B732E4578656375746553514C5461736B2E4578656375746553514C5461736B2C204D6963726F736F66742E53716C5365727665722E53514C5461736B2C2056657273696F6E3D31302E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D383938343564636438303830636339313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2244697361626C654576656E7448616E646C657273223E303C2F4454533A50726F70657274793E3C4454533A4F626A656374446174613E3C53514C5461736B3A53716C5461736B446174612053514C5461736B3A436F6E6E656374696F6E3D227B30443537364141312D334231432D343338322D424135332D4334424539314439453736307D222053514C5461736B3A54696D654F75743D2230222053514C5461736B3A497353746F72656450726F633D2246616C7365222053514C5461736B3A427970617373507265706172653D2254727565222053514C5461736B3A53716C53746D74536F75726365547970653D22446972656374496E707574222053514C5461736B3A53716C53746174656D656E74536F757263653D2245584543204442412E4E756D65726963526573706F6E73654167677265676174655F5343542020404661634944203D203F2C40446174615072644944203D203F2C2040557365724944203D203F2C20405265744D7367203D202727222053514C5461736B3A436F6465506167653D2231323532222053514C5461736B3A526573756C74547970653D22526573756C74536574547970655F4E6F6E652220786D6C6E733A53514C5461736B3D227777772E6D6963726F736F66742E636F6D2F73716C7365727665722F6474732F7461736B732F73716C7461736B223E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2230222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A4661634944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2231222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A446174615072644944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C53514C5461736B3A506172616D6574657242696E64696E672053514C5461736B3A506172616D657465724E616D653D2232222053514C5461736B3A4474735661726961626C654E616D653D22557365723A3A557365724944222053514C5461736B3A506172616D65746572446972656374696F6E3D22496E707574222053514C5461736B3A44617461547970653D22313239222053514C5461736B3A506172616D6574657253697A653D222D31222F3E3C2F53514C5461736B3A53716C5461736B446174613E3C2F4454533A4F626A656374446174613E3C2F4454533A45786563757461626C653E0D0A3C4454533A507265636564656E6365436F6E73747261696E743E0D0A3C4454533A50726F7065727479204454533A4E616D653D2256616C7565223E303C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224576616C4F70223E323C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D224C6F676963616C416E64223E2D313C2F4454533A50726F70657274793E0D0A3C4454533A50726F7065727479204454533A4E616D653D2245787072657373696F6E223E3C2F4454533A50726F70657274793E3C4454533A45786563757461626C652049445245463D227B46344235373433452D394242442D343745312D394433382D3238353432323536444232317D22204454533A497346726F6D3D222D31222F3E3C4454533A45786563757461626C652049445245463D227B35343743334633412D3739305106A895D12E-5EFA-40E5-951E-06C606B7E51A0NULLNULL

To Run the package in ssms, i right click on the package and Executed it. IT is working fine!!!

But i want to execute the same package from command line, but am getting the below error.

Can anyone figure out i went wrong??? Any syntax error??

My basic question is , from command line using DTExec how to execute an ssis package which is stored in SSIS package Store.

Please find the attached "Run5_From_GUI.JPEG". It is working fine in GUI, i want to run it in command line.

What would be the correct syntax for that.

Run1

=======

C:\>DTExec /SQL Testpkg /server "MACHINENAME\SQL2K8"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:00:29 AM

Could not load package "Testpkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_getpackage'.). The SQL

statement that was issued has failed.

Source:

Started: 3:00:29 AM

Finished: 3:00:29 AM

Elapsed: 0.125 seconds

Run2

=====

C:\>DTExec /SQL TestPkg /server "CSCTHCDBCHE1\SQL2K8"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:13:13 AM

Could not load package "TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_getpackage'.). The SQL

statement that was issued has failed.

Source:

Started: 3:13:13 AM

Finished: 3:13:13 AM

Elapsed: 0.125 seconds

Run3

====

I also tried, when connecting through ssms for Integration Services, i have given only the ServerName and not the complete Named instance since integration services does'nt have any NAMED instance.

But i have given a trail.hmm... but still not working ...

C:\>DTExec /SQL TestPkg /server "CSCTHCDBCHE1"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:16:39 AM

Could not load package "TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

004005 (Login timeout expired). The SQL statement that was issued has failed.

Source:

Started: 3:16:39 AM

Finished: 3:16:54 AM

Elapsed: 15.266 seconds

Run4

====

I tried to execute as same as it is from GUI parameter.

Please attached Run4_From_GUI mode screen shot. The same thing, i tried in command line it is showing the below error

C:\>DTExec /sql \TestPkg /server "MACHINENAME\SQL2k8"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:28:12 AM

Could not load package "\TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_getpackage'.). The SQL

statement that was issued has failed.

Source:

Started: 3:28:12 AM

Finished: 3:28:12 AM

Elapsed: 0.125 seconds

Oracle_91 SSChampion Points: 14548 More actions · Answer 5

I went to the target server where integration services is running and done the following. still not getting ....

C:\>DTExec /sql "TestPkg"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:49:10 AM

Could not load package "TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

004005 (Login timeout expired). The SQL statement that was issued has failed.

Source:

Started: 3:49:10 AM

Finished: 3:49:26 AM

Elapsed: 15.485 seconds

C:\>DTExec /sql "\TestPkg"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:49:45 AM

Could not load package "\TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

004005 (Login timeout expired). The SQL statement that was issued has failed.

Source:

Started: 3:49:45 AM

Finished: 3:50:01 AM

Elapsed: 15.453 seconds

C:\>

Oracle_91 SSChampion Points: 14548 More actions · Answer 6

I also tried to validate the package still............its killing me !!!

C:\>dtexec /sq TestPkg /ser cscthcdbche1 /va

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Started: 3:54:08 AM

Could not load package "TestPkg" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80

004005 (Login timeout expired). The SQL statement that was issued has failed.

Source:

Started: 3:54:08 AM

Finished: 3:54:23 AM

Elapsed: 15.422 seconds

C:\>

Oracle_91 SSChampion Points: 14548 More actions · Answer 7

This time i tried differently

For double cross checking purpose , i saved the package to File system and tried to again add to a different project in BIDS ,

Then it is hsowing error.

Please find the attached screen shot "package erro.JPG"

Note: My package do have the package configurations.

Package properties : DoNotSaveSensitive

Oracle_91 SSChampion Points: 14548 More actions · Answer 8

I have created the package on dev which has Visual Studio 2008 and am trying to add to a project on target server which has Visual Studio 2005.

Does it make any difference?If that is the case how to fix it??/

Again, do i need to create the package in Visual studio 2005 only 🙁 ???

Suresh Arumugam Hall of Fame Points: 3370 More actions · Answer 9

Hi,

Check if the below link works. It has an idea to run the package using DTExec utility.

http://blog.davyknuysen.be/2008/08/26/import-excel-files-with-sql-server-integration-services-on-a-64-bit-server/

Suresh

Regards,
Suresh Arumugam

Oracle_91 SSChampion Points: 14548 More actions · Answer 10

At last,Found it my self.

Hope it helps other team members :-))

You can generate the script from GUI mode itself and append the DTEXEC in front of the command line

Way-1

------

DTEXEC /DTS "\MSDB\TestPackage" /SERVER MACHINENAME /CHECKPOINTING OFF /REPORTING V

Way-2

--------

DTEXEC /SQL "\TestPackage" /SERVER "MACHINENAME\SQL2K8" /CHECKPOINTING OFF /REPORTING V

Both are working fine ….:-)))