|
|
Browse by Tags
All Tags » Video » nugget » dataflow » ssis (RSS)
-
A few days ago I was alerted to a peculiarity of SSIS’s Script Component that I believe people need to be aware of. Its a peculiarity that can rear its head when your script component is synchronous and has multiple outputs. Here’s an example of a dataflow that contains such a component: Some things to note about this dataflow that you ...
-
In this, my latest video nugget, I demonstrate and compare three ways that you can insert data into a SQL Server table from the SSIS DataFlow:
OLE DB Destination without Fast Load
OLE DB Destination with Fast Load
SQL Server Destination
The demo peels back the covers to see how these three methods actually ...
|
|
|
|