Data Import Functionality Using SQL Server

DTS (Data Transformation Services) in SQL Server is very powerful feature and can be used to solve many database related issues starting from data migration, conversion and import/export. Even content publication/management applications can be developed easily using DTS. SQL Server’s DTS support is extended with latest version of SQL Server 2000. This article’s main goal is not only to expose the DTS functionality of SQL Server but also to show the simplicity in using DTS packages to implement core functionality.
This case study takes up a sample financial web application “Trade Analysis” designed and developed by Prakash Financials. Trade Analysis application supports trade analysis for client specific trade data. Client in this article represents mostly an organization. ‘User’ is any user that uses the services of “Trade Analysis”. There may be many users from one single organization/client and there may be more than one client registered for the using “Trade Analysis”. When an organization decides to use “Trade Analysis”, few users from the organization are registered with “Prakash Financials”, with same or different access privileges.

Article by Jayram Tallamraju, more

Comments

Post a Comment

Popular posts from this blog

SQL 2008

SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. more
Read more

SQL Buddy

Image
This is a C# Open source version of SQL Query Analyzer with code completion - If you type in a table name and hit ctrl-space, it has a dropdown with the columns, etc. I need a version that works from usb drive. Source SQL Buddy .
Read more

Microsoft a BI Force

Image
Microsoft BI is a new tool. It is delivered through three layers or workloads: data warehousing, reporting and analysis, and performance management. These are designed to provide a consolidated, comprehensive data source and tools to help improve decision making. Microsoft BI is to help decision makers at all levels. An IDC report issued this summer—found that Microsoft’s BI market share growth outpaced that of most rivals. More to the point, both Gartner and IDC now agree: Microsoft is now a BI force to be reckoned with, trailing established leaders such as Business Objects SA, SAS Institute Inc., and Cognos Inc. for overall BI market laurels. more
Read more