Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Integration Services Interview Questions > How do I transfer flat file to SQL Server

:: Categories ::

Interview Question in SQL Server Integration Services


 

Interview Question :: How do I transfer flat file to SQL Server


Is there a step by step method? See, I'm a novice to SQL Server, we were trying to test the SSIS functionality available in SQL 2005, particularly in server management studio, i need help..anyone who could help me..thanks!
Answers to "How do I transfer flat file to SQL Server"
RE: How do I transfer flat file to SQL Server?

Use a DTS package. Data Transformation Service allows you to capture data from many different sources, including flat files, and import the data into a table in your database.



Your best bet for step by step assistance is to review the "SQL Books Online" sections that deal with DTS.



Here are general steps:

1 - Create a table with the required fields to put the data in (Destination).

2 - Know the path and filename of your flat file (Source)

3 - Create a DTS package by defining the Source, the Destination, and the Transformation mapping.
 
Vote for this answer ::  
RE: How do I transfer flat file to SQL Server?

sql tutorials- http://sqlstring.com/
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License