Untuk calon siswa pada kursus "Pengembang Server MS SQL" Evgeny Turkestanov, seorang guru dan ahli database, telah menyiapkan artikel yang berguna.
Kami juga mengundang Anda ke webinar terbuka dengan topik "Polybase: Life Before and After". Dalam pelajaran ini, peserta, bersama dengan seorang ahli, akan melihat bagaimana mungkin untuk berinteraksi dengan database lain sebelum Polybase, dan bagaimana cara kerjanya sekarang.
MS SQL Server SSIS (- DTS), . , . , «» - , — . , . , , , , SSIS . , , . , .
DATETIME. , .
, :
1. SSIS
2. :
, , , . , , , .
3. , . . :
, , . , , , . , – , , . , :
.
Execute SQL Command , :
, , . SQL :
. .
Output . – ?
, , , C# MessageBox . :
, , . ? DATETIME. , SSIS.
SSIS package "F:\Projects\SSIS\TestMultiplePutput\TestMultiplePutput\TestMultiplePutput.dtsx" starting.
Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query " exec dbo.testMultipleOutput ?, ? OUTPUT, ? OUTPUT" failed with the following error: "Error HRESULT E_FAIL has been returned from a call to a COM component.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task
Warning: 0x80019002 at TestMultiplePutput: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "F:\Projects\SSIS\TestMultiplePutput\TestMultiplePutput\TestMultiplePutput.dtsx" finished: Failure.
The program '[50800] DtsDebugHost.exe: DTS' has exited with code 0 (0x0)
. «» COM – « , ». , , . SSMS, , . , - , , . , DATETIME DATE. , , OUTPUT .
:
, . .
DBDATE, , . , .
DBTIME , . - . , . DBTIME2. .
DBTIMESTAMP. - , SSIS. , , DATETIME. . , :
, , «» DBTIMESTAMPOFFSET, , , , , , :
, , , , , . Execute SQL Command T-SQL, :
, . , , , , .