Transfer Error Messages Task (SSIS)

Transfer Error Messages Task, before discussing this task, we should know basic knowledge about Error Messages in SQL Server Management Studio.

Error Messages are used in SQL Server for different purposes for letting users know what kind of issue caused to stop the process. There are attributes for every Error Message  . Please refer to this link if you want to know more about Error Messages in SSMS.

Transfer Error Messages Task allows us to transfer the custom created or user error messages from one server to another server.

Source and Destination connection are the fields used to connect to servers. 

IfObjectExists: FailTask lets us to fail the task if the object already exists, Overwrite the existing or Skip this task if the error already exists.

TransferAllErrorMessages : We can transfer all the custom defined error messages if you wish to. If not we will need to select ErrorMessagesList for selecting required Error Messages to be transferred from the collection.

ErrorMessageLanguageList: For every error a language ID is associated with it. This states what type of language is used for the error message. We can select all messages under a particaular language using language ID.

Database Transfer Task(SSIS)

Database Transfer Task is used to copy or move the database objects(mdf and ldf files) from one instance to another instance or one server to another server. 

Properties : Few common proprieties on General tab such as Name and Description, depends on your requirements. 
On Database Tab, we will need to specify the Source and Destination Connection of the MS SQL Server instances.
Specify the source and destination database for copying the required files.

Method of copying or moving the database files states how you want to perform the operation.

Offline & Online are the two methods available.

• In online mode the operations are performed in connection with the servers.
• In offline mode the operations are performed after disconnecting with the server and copying or moving is done. It will reconnect after the operation is done. In offline mode the database is not available for any other resources.

Note : In Offline mode make sure that you got the correct network path for database files.

Overwrite Existing, can be used when there is a scenario of daily operations for same database where you want to the same database.

Reattach Source Database is enabled only we select offline method. This flag will reattach the database file to the instances if the task fails for any reason.

For copying all the other objects using SSIS, you can use Transfer SQL Server Objects Task. It opens a wide range of options for accessing all the objects in SQL Server.

P.S :  I am a beginner in MSBI and trying to learn. Please comment below.