123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computer-Programming >> View Article

Sql Server Integration Services 2

Profile Picture
By Author: Team USATInc
Total Articles: 49
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

It is necessary to identify all data formats at both the source and at the destination. Most often, they are quite different, with perhaps the odd commonality or two. Consider the case of a currency flat file. It would have four columns of data: the average rate of the currency, a currency key, a date key, and the end-of-day rate. This data is to be moved to another file, which is formatted differently, e.g., with columns for Column Name, Data Type, Lookup Table and Lookup Column. The Column Name will have four rows to incorporate the data input. These rows are the column headings of the source file, viz., average currency rate, a currency key, a date key, and the end-of-day rate. Analysis of the source and destination data formats indicates that lookups will be necessary for the CurrencyKey and TimeKey values.

In SSIS, the programmer will need to create a compatibility program. This involves a number of steps:
1. Creating a new integration services project

2. Adding and configuring a flat file connection manager

3. Adding and configuring an object linking and embedding-database (OLE DB) connection ...
... manager

4. Adding a data flow task to the package

5. Adding and configuring the flat file source

6. Adding and configuring the lookup transformations

7. Adding and configuring the OLE DB destination

The first step in creating such a program is to build what Microsoft calls an Integration Services project. This project includes the templates for the objects — data sources, data source views, and packages — that are to be used in a data transformation solution. The language factor, which is locale-sensitive data, is also an issue that needs looking at. If the computer is not configured to use the regional option English (United States), additional properties are to be integrated in the software to make it interpretable at the destination (see reference 1).

The second step in SSIS is adding and configuring a Flat File Connection Manager. Here, a Flat File connection manager is added to the package just created. Data can now be extracted from a flat file. Using this manager, file name and location, locale and code page, and the file format, including column delimiters, can be programmed to apply when data extraction begins. In addition, the data type for individual columns can be manually specified, apart from automatically mapping the extracted data to Integration Services data format. The remaining five steps can then be carried out by the programmer.

References:
1. http://msdn.microsoft.com/en-us/library/ms170057%28v=SQL.105%29.aspx

BY Unique Solutions of Advanced Technologies Inc

USATInc.com is the online presence of the company. They provide quality, reliable and cost effective IT Solutions that eliminate bottlenecks and frustration in running a business. USATInc.com is helping customers achieve success via custom software development, custom programming services, legacy applications management, IT consulting, and staff augmentation services. Their service offerings aimed to improve business operations, business efficiency and profitability.

Total Views: 301Word Count: 473See All articles From Author

Add Comment

Computer Programming Articles

1. Best Accounting Software 2025 In Zambia: Tips And Best Practices
Author: Doris oseR

2. Aryabhata And The Birth Of Zero: A Legacy That Powers Modern Ai And Machine Learning
Author: Pydun Technology Private Limited

3. Top 5 Video Conferencing Solutions Of 2025
Author: Ben Gross

4. Best Practices For Building High-performance React Native Apps
Author: William

5. Top 10 Reasons To Pursue Full Stack Java Development In India
Author: Rohan Rajput

6. Transform Your Digital Presence With Expert Drupal Development
Author: manish

7. We Provide It Solutions That Help You Succeed
Author: We provide IT solutions that help you succeed

8. What Makes A Full Stack Developer Stand Out In 2025?
Author: Shrushti Gurav

9. Effortlessly Convert Sale Orders To Purchase Orders In Odoo
Author: CodersFort

10. Best Software Development Comapny In Wayanad, Kerala, India
Author: TRUSTWAVES

11. How To Spot Red Flags In Invoices And Stop Fraud Instantly?
Author: Invoice Temple

12. Top Ai Development Company In Delhi: Leading Artificial Intelligence Services By Doubleklickdesign
Author: Prince

13. What Are The Best Coding Institutes In Bhopal?
Author: Shankar Singh

14. Innovating Blockchain Strategies With Mev Bot Technology
Author: aanaethan

15. How To Choose The Right Coding Institute In Bhopal
Author: Shankar Singh

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: