Soumya Ranjan Das

Subscribe to Soumya Ranjan Das: eMailAlertsEmail Alerts
Get Soumya Ranjan Das: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Soumya Ranjan Das

SQL Server integration Services (SSIS) is the de-facto standard for data migration and ETL (Extract, Transform and Load) operations in the Microsoft BI suite of technologies. Nevertheless, SQL Stored Procedures are still the preferred choice in some of the applications for carrying out data migration activities like loading a delimited flat file into a SQL Server table. Teams involved in data migration activities with SQL Server Suite often come across the requirement of importing data from flat files. The initial Research and Development phase emphasizes two of common approaches: Import data using SSIS Packages. Import data using custom SQL Stored Procedures. Each of approach has its pros and cons and should be properly evaluated to ensure the most appropriate one is selected for the in-hand requirements during the analysis phase. Incorrect decisions taken initially ... (more)