The Script task provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides. The Script task can also combine functions in one script instead of using multiple tasks and transformations. You use the Script task for work that must be done once in a... » read more
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
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
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 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 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
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.
Error: The filegroup ‘xxxxxx’ cannot be removed because it is not empty. Fix: Remember to remove the partition the filegroup belongs to.
Searching for files in Windows File Explorer *text All files ending with text.