_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SSIS-Tip

Contents

1 所鍵螳 り 觧り..
2 Error: 0xC00291D7
3 C# 覲 豌襴
4 wmi out of memory
5 error code 0x80070057 lookup task BIDS る螳 讌 螻, Job Agent 觧
6 error code 0xC02092B4
7 襦貉 焔 豸′
8 "譟壱 "(535)(襯) 豌襴 蟲 "acnt_key"(534) ProcessInput 覃螳 ろ給
9 Syntax error, permission violation, or other nonspecific error
10 °り規襴


1 所鍵螳 り 觧り.. #

select 
    aa
,   bb
from openrowset('Microsoft.ACE.OLEDB.16.0', 'Excel 12.0;Database=c:\code\test1.xlsx', 'select * from [Data$A2:K]')
where 1=1

select 
    aa
,   bb
from openrowset('Microsoft.ACE.OLEDB.16.0', 'Excel 12.0;Database=c:\code\test2.xlsx', 'select * from [Data$A2:K]')
where 1=1
暑り SQL Server螳 襷煙 螳 螳 . 襷 ろ覃 豐蠍壱 伎蟲覃伎 ろ 炎概/ろ 蟆曙郁 .
企 蟆曙 襴狩蟆 ろ. 麹 sleep 譯手.. 豌

select 
    aa
,   bb
from openrowset('Microsoft.ACE.OLEDB.16.0', 'Excel 12.0;Database=c:\code\test1.xlsx', 'select * from [Data$A2:K]')
where 1=1

waitfor delay '00:00:05'

select 
    aa
,   bb
from openrowset('Microsoft.ACE.OLEDB.16.0', 'Excel 12.0;Database=c:\code\test2.xlsx', 'select * from [Data$A2:K]')
where 1=1

waitfor delay '00:00:05'

2 Error: 0xC00291D7 #

VS ssis ク讌螻 ろ覃 れ螻 螳 る 覃讌螳...
Error: 0xC00291D7 at mail_delete 2, Execute SQL Task: No connection manager is specified.
Error: 0xC0024107 at mail_delete 2: There were errors during task validation.

覿覈 襴 螻褐 磯 ろ 蟆曙郁 .

ク讌譴 xxx.dtsx襯 螻 れ 伎企. れ り 伎 蟆企.
伎? SQL れ 轟覓語螳 讌 危エ覺. 襯 れ replace 蟲覓語 轟覓語螳 讌 讌..

3 C# 覲 豌襴 #

MessageBox.Show(Dts.Variables["begin_dt"].Value.ToString());
Dts.Variables["覲"].Value = "覲螳企?"; 

4 wmi out of memory #

  • WMI Out Of Memory issues
  • Windows Management Instrumentation 觜

5 error code 0x80070057 lookup task BIDS る螳 讌 螻, Job Agent 觧 #

  • : lookup task る. BIDS る螳 讌 螻, Job Agent 觧
  • る: SSIS る 貊 DTS_E_PROCESSINPUTFAILED. "譟壱 "(2177)(襯) 豌襴 蟲 "lookup task"(2176) ProcessInput 覃螳 ろ給(る 貊 0x80070057)
  • 願屋: 一危 襴 ろ(Data Flow Task) RunInOptimizedMode 煙 False襦 れ

6 error code 0xC02092B4 #

  • ssis OLE DB Source sp call覃 企 螳 螳 覦.
  • OLE DB 螻糾螳 SQL 覈轟 讌 覦讌 給. --> 企 覃語襯 覬.
  • SET NOCOUNT ON SET FMTONLY OFF 襯 覿 願屋.

7 襦貉 焔 豸′ #

  • cpu 32 core (hyper threading, 64 cpu), ram 256gb, win2k8 r2, sql2k8 r2, ssis, local -> local
  • 企 : 287 byte
  • 襦一: 6 2豌襷 蟇
  • 覯レ螳 : 3螳 34覿 (碁煙り heap )
  • 覿轟°: 800MB
  • 覿 螳蟇 螻 蠏碁 ..


8 "譟壱 "(535)(襯) 豌襴 蟲 "acnt_key"(534) ProcessInput 覃螳 ろ給 #

  • : 貊: 0xC0047022 覲: play SSIS.Pipeline る: SSIS る 貊 DTS_E_PROCESSINPUTFAILED. "譟壱 "(535)(襯) 豌襴 蟲 "{Task覈}"(534) ProcessInput 覃螳 ろ給
  • 譟一: Turn Off Visual Studio ---> .. .. 覈襯願..
  • Lookup 伎襦 觧 讌襷 VS 覃 觧讌 .. sql 襴覃 觧 蟆曙郁 . 覓企 覃覈襴 企螳 豢 ..

9 Syntax error, permission violation, or other nonspecific error #

企 螳 覦一 . 覯.. 襾語.. れ 襴覃 . 谿場覲企 2005覯 BIDS 觧伎. 2008 R2碁..SP ..
OLE DB Source sp 襷り覲 讌 蟇碁 語.. 蠏碁 蠏碁郁.. 蠏碁..ADO.NET Source襦 覲蟆渚 譴..襷り覲 蠍一..
option ( optimize for .. 旧 (企 40糾唄企 襭 覈 豌襷蟇 insert 伎 糾螳 螳煙讌 ..) 蠍一..

"declare
    @bdt char(8)
,   @edt char(8)

set @bdt = '" + @[User::bExecDT] + "'
set @edt = dateadd(dd, 1, @bdt)
select
	a.acnt_key
,	a.p_key
,	case when a.end_money = 0 then 1 else 0 end allin_cnt
,	a.events_money
,	a.r_key
,	b.game_svc_key
,	b.den_key
,	a.seq
,	b.attb_key
from ods.gostop.play_end a
	left join ods.gostop.room b
		on a.r_key = b.r_key
		and b.std_dt between dateadd(dd, -31, @bdt) and @edt
where a.std_dt = @bdt
order by seq
option ( optimize for (@bdt = '20110601', @edt = '20110602'))
"

企蟆 一危 襴 ADO.NET Soruce Command 覿覿 Expression 譴..覓語伎 讌朱 覲 る 蠑 觧企 蟆伎..
蠏碁 企蟆 螻豎る.
"declare
    @bdt varchar(10)
,   @edt varchar(10)

set @bdt = '" + @[User::bExecDT] + "'
set @edt = dateadd(dd, 1, @bdt)
select
	a.acnt_key
,	a.p_key
,	case when a.end_money = 0 then 1 else 0 end allin_cnt
,	a.events_money
,	a.r_key
,	b.game_svc_key
,	b.den_key
,	a.seq
,	b.attb_key
from ods.gostop.play_end a
	left join ods.gostop.room b
		on a.r_key = b.r_key
		and b.std_dt between dateadd(dd, -31, @bdt) and convert(date, @edt)
where a.std_dt = convert(date, @bdt)
order by seq
option ( optimize for (@bdt = '2011-06-01', @edt = '2011-06-02')) -- 蠍 譯朱
.. 覦.. ..


10 °り規襴 #

  • 蟆所: 讌螻 るジ SET Null 螳 蟇磯給. --> ..OLE DB覲語 蟆所 伎碁 觧蟲壱!! sqlり set ansi_warnings off襯 覿譯殊..讒..
  • OnError,SSISTBL_NEO_PREMIUM_SEARCH_INDEX,2007-10-25 ろ 6:31:52,2007-10-25 ろ 6:31:52,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "郁屋 覯 '(null)' OLE DB 螻糾 'STREAM'(螳) 'BulkInsert.P_RVW_NM' 覈視 一危磯ゼ 覦給. ".
    • SSIS ろ 2005朱Μ Native Client 郁屋襦 ′ 覓語伎 Null襦 覦 讌 蟆曙郁 企企 Trace襯 貅譴 .
    • 願屋覦覯: DBCC TRACEON(7307, -1) ろ convert(varchar(50, 貉)螻 螳 convert 伎..
      • 7307 : gargisur Fix up data while validating data length of remote columns 襷覯 蟆貎朱Μ 一危
    • 豢豌: http://blog.naver.com/PostView.nhn?blogId=atlaslee&logNo=20049689610
  • Connection is busy with results for another command
    • れ 蟆朱 覈蟇 貊 一危磯ゼ scd襯 豎る. 覲襦.. 蠏碁蟾 螳 譯 覦..
    • れ 蟆朱 覈蟇 貊 一危磯ゼ scd襯 豎る. 讌襦.. 蠏碁蟾 螳 螳 覦..
    • れ 蟆朱 覈蟇 貊 一危磯ゼ truncate table insert 豎る. 蠏碁蟾.. 讌 覈襯願. 覃一 螻 覺殊...
  • 64bit 襾語 'Microsoft.ACE.OLEDB.12.0' 螻糾 襦貉 貉危一 焔 給.' 覃讌.. [http]64bit螻糾襯 れ企 /passive 旧 譯手 れ(cmd). (れ 覿手 .)
  • "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". 螳ロ ろ : 貎朱Μ 覓語螳 蟇磯 "ResultSet" , 襷り 覲 郁屋 覦襯願 れ讌 給. --> 襷り覲螳 讌, 襷り覲 誤 覈視讌 危エ覺. .. 覯..
  • "OLE DB 覲" ク讌 "SQL 覈" 襷り覲 l 豕豐襦 一讌 SQL覓語伎 譯殊企 襷り覲襯 語讌 覈詩螻, "覲襯 SQL 覈" 手 . .. 手海.. 企一 覃讌企..

    SQL 覈轟 襷り 覲襯 豢豢 給. 螻糾 覈轟 襷り 覲 覲企ゼ 蟲覓 覿讌 覈詩 給. 蟆曙 豌 SQL 覈轟 覲 ル "覲襯 SQL 覈" ′語 覈襯 .
    ろ殊 覈襦 企 覃讌螳 .

  • [http]Scaling Heavy Network Traffic with Windows
  • [http]SSIS Expression Editor & Tester
  • DataReader 覲 CommandTimeout 蠍磯蓋螳 30企. 蠏朱.. 願 螳 る 蟇碁Μ 貎朱Μ覃 觧. 0朱 譴 觧 覦讌.
  • Performance Tuning Guidelines for Windows Server 2008
  • High_Performance_Network_Adapters_and_Drivers_in_Windows.docx
  • 覲 ?
  • MySQL 讌 SQL Server襦 ♀幻朱 譟磯 螳 . null豌襴 覓語 蠏碁郁碓 螳朱.. 蠏碁覩襦 覲語 螻蠍ク讌蠍一 讌る手骸 る豌襴 '覓伎'襦 ..
  • Magic Quadrant for Integraion Tools
  • ssis 讌螻襯 る 豢覿 覃覈襴襯 螳讌螻 伎 . 襷 螻螳覲, 讌覲, 覲襦 讌螻襯 螻 願 豐 100螳願, 10糾唄企朱 100覯朱 讓手 讌螻覃 . 10糾唄 100朱 覃 1,000襷 蟇伎企. row 蠍語伎 磯 るゴ讌襷 2GB 讓曙 覃覈襴 豌襴螳 螳ロ. 譬貎..
  • ssis 覲豌襴襯 る 覲豌襴 覿覿螻 覲襯 螳 磯 . 蠏碁 讓暑. 覲豌襴 螳ロ 語伎 Erlang 覲襯 螻旧讌 . (螻旧覃覈襴朱 螳 )
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2019-10-22 21:39:48

覩碁 襴れ 襷 讀蟆蟆 ロ 殊 襷る. (覲狩襯)