Category Archive: SSIS

Oct 21

Mapowanie typów danych SSIS i SQL Server

Kto nigdy nie napotkał tego problemu, to znaczy, że nie pracował z SSIS`ami   SSIS Data Type SSIS Expression SQL Server single-byte signed integer (DT_I1) two-byte signed integer (DT_I2) smallint four-byte signed integer (DT_I4) int eight-byte signed integer (DT_I8) bigint single-byte unsigned integer (DT_UI1) tinyint two-byte unsigned integer (DT_UI2) four-byte unsigned integer (DT_UI4) eight-byte unsigned …

Continue reading »

Jul 08

Debuggowanie SSIS Script Component

Debugging is not possible untill 2012, but there are some ‘workarounds’ http://microsoft-ssis.blogspot.com/2011/04/breakpoint-does-not-work-within-ssis.html Dobrym rozwiązaniem jest debuggowanie z wykorzystaniem Trace loga // C# Code public override void Input0_ProcessInputRow(Input0Buffer Row) {     System.Diagnostics.Trace.WriteLine(“SomeMessage: ” + Row.YourColumn); } Programik do podglądania logów DebugView v4.81 http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx