the ssis package - when we transfer to the dba, we keep the security on the package as 'do not store key/password' option. but there is a package we are working which involves more secure details and data (financial etc).. the dba has asked to provide proper security before putting in the network drive for them to pick up..
what security do you recommend? how would you do it if you were the programmer?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.