Bulk Insert Task

siberiaskeinData Management

Nov 20, 2013 (3 years and 11 months ago)

220 views

Bulk Insert Task


Not commonly used. Ex: You
extra data from a db and you
email it. Recipient would use the
Bulk Insert Task to import Data.


Data Flow Task


Loads and transforms data into
an OLE DB destination.


Execute Package Task


Allows you to
execute a package
from within a package, making
your SSIS packages modular.


Execute Process Task


Executes a program external to
your package, like 1 to split your
extract file into many files before
processing the individual files.


File System Task


This task can handle director
operations like creating,
renaming or deleting a directory.
It can also manage file operations
like moving, copying, or deleting
files.




FTP Task


Sends or receives files from an
FTP site.


Script Task


Runs a set of
VB.Net or C# coding
inside a Visual Studio
environment.


Send Mail Task


Sends a mail message through
SMTP.


Analysis Services
Processing Task


Processes SQL Server Analysis
Services Cube, dimension, or
mining model.


XML Task


Parses or processes an
XML file.
It can merge, split, or reformat an
XML file.


Package


A collection of tasks that execute
in an orderly fashion.
(precedence constraints help
manage which order the tasks
will execute in)




Task


An individual unit of work. It
provides funct
ionality to your
package. It can move a file, load
a file into a db, send an email,
write a set of VB.Net code, etc.


Containers


Provide structure and scope to
your package.


Event Handlers


Respond to raised events in your
package.


Precedence
Constraints


Provider ordinal relationship
between various items in your
package. (help manage which
order the tasks will execute in)


OLE DB Source


Connects to nearly any OLE DB
data source like SQL Server,
Access, Oracle, or DB2 to name
just a few.


Transformation


A key component to the data
flow that changed the data to a
format that you’d like. (All done
in memory).



CONTROL FLOW ITEMS
-
ActiveX Script Task


Parses and executes an ActiveX
script task.


CONTROL FLOW ITEMS


Analysis Services Execu
te
DDL Task


Provides ability to execute DDL
query stmts against an Analysis
Services Server.


CONTROL FLOW ITEMS


Analysis Services Processing
Task


Provides ability to process
Analysis Services objects such as
Cubes and Dimensions.


CONTROL FLOW
ITEMS


Bulk Insert Task



Copies data from a file into a db.
Loads data or file into a table by
using this command.


CONTROL FLOW ITEMS



Data Flow Task

Encapsulates the data flow
engine that moves data between
sources and destinations
providing the facility to
transform, cleanse and modify
data as it is moved.

CONTROL FLOW ITEMS


Execute Package Task


Enable DTS package to run on
other packages as part
of the
workflow.


CONTROL FLOW ITEMS


Execute Process Task


Executes WIN32 executables


CONTROL FLOW ITEMS
-
Execute SQL Task


Execute configurable sql queries.


CONTROL FLOW ITEMS



File System Task


Performs file systems operators
such as copying and

deleting.


CONTROL FLOW ITEMS



FTP Task


Performs FTP operations such as
sending and receiving.


CONTROL FLOW ITEMS


Message Queue Task


Send and Receive messages.

CONTROL FLOW ITEMS



Script Task


Provides customer interaction
task authoring.


CONTROL FLOW ITEMS



Send Mail Task


Sends an email message.


CONTROL FLOW ITEMS


Transfer Data Task


Transfers a db from a source SQL
Server instance to a destination
SQL Server instance.


DATA FLOW SOURCES



ADO NET Source


Extracts data from a
relational db
using .net provider.




DATA FLOW SOURCES



Excel Source


Extracts data from an excel
workbook.


DATA FLOW SOURCES


Flat File Source


Extracts data from flat files.


DATA FLOW SOURCES


OLE DB Source


Extracts data from a relational db
using OLE DB provider
.
A
programming interface for
data

access

from Microsoft
.


DATA FLOW SOURCES



Raw File Source


Extracts data from a raw file.


DATA FLOW SOURCES



XML Source


Extracts data from an XML file.


DATA FLOW
TRANSFORMATIONS



Aggregate


Aggregates and groups values in
a dataset.



DATA FLOW
TRANSFORMATIONS



Audit


Adds audit information on rows
in a dataset.

DATA FLOW
TRANSFORMATIONS



Cache Transform


Cache column associated with
the input column.




DATA FLOW
TRANSFORMATIONS



Character Map


Applies string operations to
character data.


DATA FLOW
TRANSFORMATIONS



Conditional Split


Evaluates and directs rows in a
dataset.


DATA FLOW
TRANSFORMATIONS



Copy Column

Copies columns.

DATA FLOW
TRANSFORMATIONS



Data Conversion


Converts columns to different
data types and adds the columns
to the different dataset.

DATA FLOW
TRANSFORMATIONS



Data Mining Query


Data Mining query.


DATA FLOW
TRANSFORMATIONS



Derived Column


Updates

columns values using
expressions.


DATA FLOW
TRANSFORMATIONS



Export Column


Exports column values from
rows in a dataset to file.


DATA FLOW
TRANSFORMATIONS



Fuzzy Grouping


Groups rows in a dataset that
have similar values.




DATA FLOW
TRANSFORMATIONS



Fuzzy Lookup


Looks up values in a data
reference set using a fuzzy
matching.


DATA FLOW
TRANSFORMATIONS



Import Column


Imports data from files to rows
in a dataset.


DATA FLOW
TRANSFORMATIONS



Lookup


Looks up values in

a data
reference set by using exact
matches.


DATA FLOW
TRANSFORMATIONS



Merge

Merges two sorted datasets.

DATA FLOW
TRANSFORMATIONS



Merge Join


Merges data from two datasets
by using a join.


DATA FLOW
TRANSFORMATIONS



Multicast

Creates copies
of a dataset.

DATA FLOW
TRANSFORMATIONS



OLE DB Command


Executes a SQL command for
each row in the dataset.


DATA FLOW
TRANSFORMATIONS



Percentage Sampling


Creates a sample dataset by
extracting a percentage of the
rows from a dataset.


DATA FLOW
TRANSFORMATIONS



Pivot


Pivots the dataset to create a
less normalized version of the
data.


DATA FLOW
TRANSFORMATIONS



Row Count

Counts the row in a dataset.

DATA FLOW
TRANSFORMATIONS



Row Sampling


Creates a sample dataset by
extracting

a number of rows
from the dataset.


DATA FLOW
TRANSFORMATIONS



Script Component


Executes a custom scripts.


DATA FLOW
TRANSFORMATIONS



Slowly Changing Dimension


Updates a slowly changing
dimension.


DATA FLOW
TRANSFORMATIONS



Sort

Sorts data.

DATA FLOW
TRANSFORMATIONS



Term Extraction


Extracts terms from data in a
column.


DATA FLOW
TRANSFORMATIONS



Term Lookup


Counts the frequency a term in a
reference table appear in a
dataset.




DATA FLOW
TRANSFORMATIONS



Union All


Merges
multiple datasets.


DATA FLOW
TRANSFORMATIONS



Unpivot


Creates a more normalized
version of a dataset.


DATA FLOW DESTINATIONS



ADO NET Destination


Writes a database using an ADO
NET provider.


DATA FLOW DESTINATIONS



Data Mining Model Training


T
rains data mining models by
passing the data that the
destination receives through the
data mining model algorithms
.

DATA FLOW DESTINATIONS



DataReader Destination


Creates an ADO.NET in memory
dataset.



DATA FLOW DESTINATIONS



Dimension
Processing


L
oads and processes an SQL
Server Analysis Services
dimension.

DATA FLOW DESTINATIONS



Excel Destination


Loads data in an excel workbook.


DATA FLOW DESTINATIONS



Flat File Destination


Loads data in a flat file.




DATA FLOW DESTINATIONS



OLE DB Destination


Loads data in a relational
database using an OLE DB
provider.


DATA FLOW DESTINATIONS



Partition Processing


L
oads and processes an SQL
Server Analysis Services partition.


DATA FLOW DESTINATIONS



Raw
File Destination


Indicates what option is being
used to write the file.


DATA FLOW DESTINATIONS



Recordset Destination


Creates and populates an in
-
memory an ADO.NET record set.


DATA FLOW DESTINATIONS



SQL Server Compact
Destination


Loads data int
o a SQL Server
destination.


DATA FLOW DESTINATIONS



SQL Server Destination


Loads data into a SQL Server
Database.