1. Open Ms Visual Studio 2005, Create new project > Bussines Intelligence Project > Integration Services Project 2. Drag OleDBSource and connecting to Script Component ( as destination ) 3. Set Your Connection and SQL query that data want to export 4.Adding script to Write output data and Create Text File. Open script editor, with double … Continue reading
Introduction In an earlier article of mine, An Introduction and Overview of the Microsoft Application Blocks, we outlined the purpose and benefits of Microsoft Application Blocks. Application Blocks encapsulate two common patterns encountered in application programming, data access and exception management. Application Blocks provide value by making our programming more efficient and our programs more maintainable. … Continue reading