Ch 9 Data Validation, Destinations
In the Chapter 9 Data Validation example, the book specifies 'Add two SQL server Destinations to the data flow designer' but this resulted in an error indicating that a bulk insert could not be performed and that perhaps the task required administrative rights. I instead added two OLEDB destinations ,and the package performed without error.
|