ᾤࡨ SSIS ӧҹ¡ҡ鹵͹ҹͧѷ᷹ͧ SQL

ź ź
Ţ (Article ID): 918760 - ԵѳǢͧ㹺
· | غ

Һ˹ҹ

ҡ

ͤس¡ᾤࡨ Microsoft SQL Server 2005 ԡ (SSIS) ҡ鹵͹ҹͧѷ᷹ͧ SQL ա¡ᾤࡨ SSIS ҧá ҤسöѺ¹ᾤࡨ SSIS зӧҹº¹ͧ͡ѷ᷹ SQL

͵ͧ䢻ѭҹ ˹Ըյ仹 ԸաشѺҾǴ˵ؼŷᾤࡨ ˵ؼŷᾤࡨҨǨ繴ѧ:
  • ѭռ㹡¡ᾤࡨѷ᷹ SQL ᵡҧҡҧᾤࡨ
  • ѭռԷ ҧ Ҷ֧Ѿҡ¹͡ᾤࡨ SSIS
ᾤࡨҨӧҹʶҹó仹:
  • ѨغѹöʹѺѺҡᾤࡨ ʶҹóҨԴ鹶ҺѭջѨغѹͺѭաôԹ÷ᵡҧҡҧᾤࡨ е駤ҤسѵԢͧᾤࡨProtectionLevel͹حҵѨغѹʹʤѺᾤࡨ
  • SQL Server ѡҤʹͧҡѨغѹԷ
  • Ҷ֧ͧҡѨغѹԷ㹡¹ѧѹҶ֧ǨѴá ҧ ʶҹóҨԴ鹡Ѻԡúѹ֡ͤ͡Թʼҹ ʶҹóöԴ鹡Ѻҹ ѺèѴá 蹧ҹк SSIS
  • ըʷա˹ᾤࡨ SSIS ըʷդ HKEY_CURRENT_USER ըʷդ HKEY_CURRENT_USER ੾м
  • ҹ͡èѴáͷͧѭռѨغѹԷ١ͧ
Ըշ 1: ѭվ͡բͧѷ᷹ͧ SQL

Ըշ 2: 駤Ҥسѵ SSIS ᾤࡨ ProtectionLevel ServerStorage

Ըշ 3: 駤Ҥسѵ SSIS ᾤࡨ ProtectionLevel EncryptSensitiveWithPassword

Ըշ 4: á˹ᾤࡨ SSIS

Ըշ 5: ҧẺͧᾤࡨ

ʶҹ

ӧҹԴҡ͡Ẻ

Ţ٧

鹵͹㹡ҧѭ

  1. к㹰ҹмǹ˹觢ͧ SQLServer2005SQLAgentUser ҧ سöҧͧ
  2. ҧᾤࡨ SSIS Шҡ 繧ҹ ExecuteSQL ǨѴá OLE DB ѧ msdb ͧ ѡе仹: '٨Ǩԧͧ Windows' -SQLSourceType: "µçû͹" -SQLStatement: "sp_who"
  3. ᾤࡨ ¡º
  4. ôѧࡵ ProtectionLevelسѵԶ١駤 EncryptSensitiveWithPassword
  5. ҧҹͧѷ᷹ͧ SQL 繢鹵͹ͧҹ 㹡 ¡㹰ҹ ¡ ԡ ԡâͧѷ᷹ͧ SQL ͵ͧ¡ҹ鹵͹
ͤ㹻ѵԧҹ SQL Server ѷ᷹ʴŷѡɳе仹:

Թ繼: ôԹᾤࡨ 鹵͹

ʹʤѺͧᾤࡨ

õ駤Ѻ SSIS ᾤࡨProtectionLevelسѵ EncryptSensitiveWithUserKey ᾤࡨ١ѹ֡ SSIS Ѻ੾ǹҧ ͧèѳСͺ¤سѵԷͧ "Ӥѭ ʼҹ ͼ ʵԧ ѧ ᾤࡨ١ź Ѩغѹͧ仵ͧѺѺسѵԷӤѭ㹡öʹѺ ҧá ѨغѹաõͺʹͧͧѺöŴᾤࡨ ͤس¡ᾤࡨҹ鹵͹ҹͧѷ᷹ͧ SQL ѭ鹤 ѭաúԡúѷ᷹ͧ SQL ѭռ鹹ѡռҡҼҧᾤࡨ ѧ 鹵͹ҹͧѷ᷹ͧ SQL öŴ Шӧҹ鹵͹ͧҹ ᾤࡨͧҡöӡ ҧ ᾤࡨöӡ OLE DB ͡ FTP ᾤࡨͧҡöʹѺŻШӵǷеͧա

ӤѭԨóҡкǹþѲҾǴ͡˹Һѭ㴷 麹ͧ õ駤 EncryptSensitiveWithUserKey ͧProtectionLevelسѵԶ١駤ҷջԷҾ õ駤ҹöѺǹŴͧҡзҹ㹵͹á سöᾤࡨͤس͡Թѧѭշ ͡ҡسööªþ Dtutil.exe SSIS ͵ͧ¹ŧдѺûͧѹ ¡.cmd к¤觢ͧѷ᷹ SQL ҧ ӵ鹵͹ҹ ͧҡسöٷԵ Dtutil.exe ặǹͺ سöӵ鹵͹ҹѺᾤࡨǡѹ
  1. ᾤࡨسͧ ʼҹѺ¹
  2. öª Dtutil.exe ҹҧ кԺѵԡ ( Exec) 鹵͹ҹͧѷ᷹ SQL ͵ͧ¹سѵProtectionLevel EncryptSensitiveWithUserKey кǹùǢͧѺᾤࡨöʹѺ ʼҹ ᾤࡨ re-encrypting 㹡Ѻᾤࡨ١駤㹢鹵͹ͧѷ᷹ͧ SQL ҹ¡㹰ҹ ¡çҹ

    ˵ ͧҡժͼЪͧ šзͧᾤࡨѧͧҨ١ӡѴ

Ǩͺ سբͼԴҴͧ´ǡѺǢͧᾤࡨ SSIS

᷹Т鹡Ѻ´㹻ѵԧҹ SQL Server ѷ᷹èӡѴ سö SSIS к سբŢͼԴҴǡѺǢͧᾤࡨ SSIS ͡ҡسö¡ᾤࡨ к exec ᷹к SSIS

ǡѺúѹ֡ SSIS

ԡккѹ֡ SSIS سѺҾ´ǡѺôԹᾤࡨФ ¤ ᾤࡨѹ֡ سͧ˹ᾤࡨúѹ֡ ͤس˹ᾤࡨúѹ֡ ´ʴ¡Ѻ仹 㹡óչ سзҺ ͧ͹حҵ:

OnError, DOMAINNAME, DOMAINNAME\USERNAME, FTP Task,{C73DE41C-D0A6-450A-BB94-DF6D913797A1},{2F0AF5AF-2FFD-4928-88EE-1B58EB431D74},4/28/2006 1:51:59 PM ѹ 28/4/2006 1:51:59 PM, -1073573489, 0 x öѧ FTP "ǨѴá FTP "

OnError, DOMAINNAME, DOMAINNAME\USERNAME, Task,{C6C7286D-57D4-4490-B12D-AC9867AE5762},{F5761A49-F2F9-4575-9E2B-B3D381D6E1F3},4/28/2006 SQL Թ 4:07:00 PM ѹ 28/4/2006 4:07:00 PM, -1073573396, 0 x 㹡ͧ͡ "user01.msdb" Ҩ١˹ҧ١ͧ ͤسҨԷѺ͹

ǡѺк exec ʴŢ

Ըաäк exec سͧǹǺҧԵ÷Ѵ SSIS ¡Ժѵԡ÷Ѵ Dtexec.exe SSIS ͡ҡ سöѡɳС÷ӧҹͧҹ٧ͧѾ ͡ҡسö Ѿͧ鹵͹㹻ѵ ͡¹鹷ҧѹ֡ ѧ ѵԧҹ SQL Server ѷ᷹

仹繵ҧͧ÷Ѵ:

dtexec.exe /FILE 
"C:\_work\SSISPackages\ProtectionLevelTest\ProtectionLevelTest\AgentTesting.dtsx" /MAXCONCURRENT " -1 
" /CHECKPOINTING OFF  /REPORTING V  /CONSOLELOG NCOSGXMT


úѹ֡ /console 觡Ѻ´¡Ѻ仹:

Error: 2006-04-27 18:13:34.76
   Code: 0xC0202009
   Source: AgentTesting Connection manager "(local).msdb"
   Description: An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'DOMAINNAME\username'.".
End Error


Error: 2006-04-28 13:51:59.19
   Code: 0xC0016016
   Source:  
   Description: Failed to decrypt protected XML node "DTS:Property" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.
End Error


Log:
     Name: OnError
     Computer: COMPUTERNAME
     Operator: DOMAINNAME\username
     Source Name: Execute SQL Task
     Source GUID: {C6C7286D-57D4-4490-B12D-AC9867AE5762}
     Execution GUID: {7AFE3D9E-5F73-42F0-86FE-5EFE264119C8}
     Message: Failed to acquire connection "(local).msdb". Connection may not be configured correctly or you may not have the right permissions on this connection.
     Start Time: 2006-04-27 18:13:34
     End Time: 2006-04-27 18:13:34
End Log

ҧԧ

ѺǡѺѭҤ¡ѹ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
904800سѺͤͼԴҴ "ͼԴҴŴ" ͤس¡ᾤࡨͧԡá SQL Server 2005 SQL Server 2005
ѺǡѺԸաٷԵ Dtutil.exe 㹡ôԹҹش ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
906562ԸաٷԵ dtutil (Dtutil.exe) ͵駤дѺûͧѹͧشͧᾤࡨúԡ㹡 SQL (SSIS) SQL Server 2005
ѺǡѺԸաҧẺͧᾤࡨ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
908018ԸաҧẺͧᾤࡨ SQL Server Business ǡͧѲ Studio


ѺǡѺѡҤʹ㹡ᾤࡨ SSIS ProtectionLevelسѵ Ǣ "ͤþԨóѺԡѡҤʹ" SQL Server 2005 ˹ѧ͹Ź

Һ 駤Ң鹵͹ҹͧѷ᷹ŧʶҹй ѺǡѺ͡բͧѷ᷹ͧ SQL SSIS Ǣ͵仹 SQL Server 2005 ˹ѧ͹Ź:
  • èѴҧüԵдѺôԹᾤࡨ㹺ѷ᷹ SQL
  • ҧ͡բͧѷ᷹ͧ SQL

سѵ

Ţ (Article ID): 918760 - Ǥش: 12 áҤ 2556 - Revision: 6.0
Ѻ
  • Microsoft SQL Server 2008 Service Pack 1
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2005 Service Pack 3
  • Microsoft SQL Server 2005 Service Pack 2
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL 2005 Server Enterprise
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
Keywords:
kbsqlsetup kbprb kbsql2005ssis kbsql2005setup kbexpertiseinter kbexpertiseadvanced kbtshoot kbmt KB918760 KbMtth
¤
Ӥѭ: «ͿŴ¤ͧ Microsoft ᷹繹ѡŷ繺ؤ Microsoft պ¹ѡкŴ¤ سöҶ֧㹰ҹͧ Ңͧسͧ ҧá Ŵ¤Ҩբͺͧ ҨբͼԴҴ㹤Ѿ ٻẺҡó ǡѺóշǵҧҵԾٴԴ;ٴҢͧس Microsoft ǹѺԴͺͤҴ͹ ԴҴͤ·ԴҡҼԴҴ ͡麷Ţͧ١ Microsoft աûѺاͿŴ¤繻Ш
仹繩Ѻѧɢͧ:918760

ʹ

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com