What is the SSIS package and what does it do?

For Latest Info About SSIS > https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

From the above referenced site:

Microsoft Integration Services is a platform for building
enterprise-level data integration and data transformations solutions.
Use Integration Services to solve complex business problems by copying
or downloading files, loading data warehouses, cleansing and mining
data, and managing SQL Server objects and data.

Integration Services can extract and transform data from a wide
variety of sources such as XML data files, flat files, and relational
data sources, and then load the data into one or more destinations.

Integration Services includes a rich set of built-in tasks and
transformations, graphical tools for building packages, and the
Integration Services Catalog database, where you store, run, and
manage packages.

You can use the graphical Integration Services tools to create
solutions without writing a single line of code. You can also program
the extensive Integration Services object model to create packages
programmatically and code custom tasks and other package objects.

Getting Started with SSIS – http://msdn.microsoft.com/en-us/sqlserver/bb671393.aspx

If you are Integration Services Information Worker – http://msdn.microsoft.com/en-us/library/ms141667.aspx

If you are Integration Services Administrator – http://msdn.microsoft.com/en-us/library/ms137815.aspx

If you are Integration Services Developer – http://msdn.microsoft.com/en-us/library/ms137709.aspx

If you are Integration Services Architect – http://msdn.microsoft.com/en-us/library/ms142161.aspx

Overview of SSIS – http://msdn.microsoft.com/en-us/library/ms141263.aspx

Integration Services How-to Topics – http://msdn.microsoft.com/en-us/library/ms141767.aspx

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)