what sources can be used for an
SSIS package and explain them:
ADO NET Source , Excel Source, Flat File source, ole db
source, Raw File source and XML source are the sources that can be used for an
ssis packages.
ADO NET Source= The
ADO NET source uses an ADO.NET connection manager to connect to a data source,
and the connection manager specifies the .NET provide
Excel Source= It uses an Excel
connection manager to connect to a excel data sources.
Flat File source=It uses an Flat
files connection manager to connect to a txt.file, csv files, delimineted
files e.t.c
ole db source= It uses an Oledb
connection manager to connect any databases using oledb provider
Raw File source= The Raw File source reads raw data from a file
XML source=The XML source reads
an XML data file and populates the columns
No comments:
Post a Comment