Tag: technology

True

False

VB.Net

C#

VB6

VB.Net & C#

_Similarity

_Confidence

Similarity

FuzzyComparionFlags

Excel Connection Manager with Excel version 2007

Microsoft Jet 2007 OLE DB Provider

Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0

File Connection Manager

Type 1 dimensions

Type 2 dimensions

Type 3 dimensions

Inferred dimensions

Aggregate

Merge Join

Condition Split

All need Sorted data streams

Checkpoint information are saved in a file

Checkpoint allows a package to restart without returning tasks that already successfully completed

Any loop containers are started over from the beginning of the current loop

Data flow tasks and Control flow define restart points

Using the Send Mail control task

Using a script control task

Using Database Mail

You cannot send HTML mails from SSIS

Define a datetime variable and assign the above value

Define a date and time variables and add them together

Define the date time variable and pass it to a script component and add time component

You cannot set the above value from SSIS

127

136

100

38