Pour les futurs étudiants du cours "MS SQL Server Developer", Evgeny Turkestanov, enseignant et expert en bases de données, a préparé un article utile.
Nous vous invitons également à un webinaire ouvert sur le thème "Polybase: la vie avant et après". Dans la leçon, les participants, accompagnés d'un expert, verront comment il était possible d'interagir avec d'autres bases de données avant Polybase, et comment cela fonctionne maintenant.
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, :
, . , , , , .