Author

SQL Server Setup Error – There was an error generating the XML document. Error code 0x84B10001.

Error: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt If we look at the start place of the error, it says System.Security.Cryptography.CryptographicException. This means that there are some issues while encryption of the data. And the real error message is “The requested operation cannot be completed. The computer must be trusted for delegation and the current user account... » read more

0
Read
echiang
Transfer Files Using Remote Desktop

By default, Windows Dedicated Servers have no FTP server installed or setup. The easiest way to securely transfer files between the server and your computer is use Remote Desktop. Click the Start menu on your PC and search for Remote Desktop Connection. Launch Remote Desktop Connection and click on Show Options. Select the Local Resources tab and click More. Under Drives, check the... » read more

0
Read
echiang
SSIS Connection Manager Not Saving Changes

Problem: The Connection manager has been configured to be updated in Package Configuration. Solution: Go to “Control Flow” tab -> right click -> Package Configurations Set to point to new configuration file. Source: https://social.msdn.microsoft.com/Forums/security/en-US/8fb47c45-f1d9-4eaa-a2a1-f126ccbc1ef2/connection-manager-changes-are-not-saved-after-edit-the-package-still-retains-the-old-server-name?forum=sqlintegrationservices https://social.technet.microsoft.com/Forums/officeocs/en-US/7a9f1ea3-7dbf-4389-9856-9ad745c9e9fe/ssis-connection-manager-not-saving-changes?forum=sqlintegrationservices

0
Read
echiang
Outer / Cross Apply

SQL Server 2005 introduced the APPLY operator. SQL Server APPLY operator has two variants; CROSS APPLY and OUTER APPLY The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the... » read more

0
Read
echiang
Data Flow Task

The Data Flow task encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved. Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data. A data flow... » read more

0
Read
echiang