File System Task

The File System task performs operations on files and directories in the file system. For example, by using the File System task, a package can create, move, or delete directories and files. You can also use the File System task to set attributes on files and directories. For example, the File System task can make... » read more

Pivot

Used to convert rows to columns. Example 1: Example 2: Sources:

Sequence Container

The Sequence container defines a control flow that is a subset of the package control flow. Sequence containers group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow. The Sequence container can include multiple tasks in addition to other containers. Adding... » read more

Get Code From TortoiseSVN

To obtain a working copy you need to do a checkout from a repository. Select a directory in windows explorer where you want to place your working copy. Right click to pop up the context menu and select the command TortoiseSVN → Checkout…, which brings up a dialog box: URL: of repository: URL of repository folder. Checkout directory: Location of folder on... » read more

Transactional Replication vs Availability Groups

Transactional Replication  Configuration is not that easy. Replication is always table level. Lot of maintenance work. There is a latency and latency may increase in busy system. Need to configure it for each table. Not a high availability option.You can use it as a DR strategy.  AlwaysOn High Availability and Disaster recovery strategy.Built on top of Windows Failover Clustering... » read more

SQL Server AlwaysOn

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server. An availability group supports one set of primary databases and one to eight sets of corresponding secondary databases. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one... » read more

Dimensions CM

https://www.microfocus.com/en-us/products/dimensions-cm/overview Change and configuration management that streamlines development to release faster Software change and configuration management for Agile development.