 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
Extracting Data from a Flat File with SQL Server 2005 Integration Services
|
Published:
06 Jun 2006
|
Abstract
In this article you will learn how to extract data from a flat file with SQL Server 2005 Integration Services. |
 |
by Web Team at ORCS Web
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
42867/
312
|
|
|
|
| What happened to DTS? |
SQL Server Integration Services (formerly Data
Transformation Services) provides a comprehensive solution for transferring and
transforming data between diverse data sources. The architecture of SSIS has
been redesigned to separate package-control flow from data flow. Two engines
have been introduced to handle these aspects of data transformation: the SSIS
Run-Time engine and the SSIS Data-Flow engine.
The SSIS Designer is hosted in Business Intelligence
Development Studio, making it possible to develop SSIS projects while
disconnected from the server. You can also develop SSIS solutions using SQL
Server Management Studio.
|
|
|
|
|
Article Feedback
User Comments
Title:
Flat file source problem
Name:
Emanuele
Date:
6/9/2008 9:57:48 AM
Comment:
hi to all,
I'm working with a Flat File Source in "Fixed Size" modality, so I'd like to check prevently if the file is good formed, i'd like to check that it's a multiple of byte of a single raw..
anyone can help me? thanks
|
Title:
Adding Source Filename Column
Name:
Paul
Date:
6/7/2008 6:14:34 PM
Comment:
Thx for the article. Can you tell us, step-by-step, how to add a column to the destination table that contains the name of the source text file? TIA.
|
Title:
thanks
Name:
Ankit
Date:
3/15/2008 3:49:10 PM
Comment:
Thanks for the nice startup. I was able to transform the theory into practical.
However, i guess u should provide flat file for download, also sometime in the article it was very clear from to right click, etc.
Anyhow, thanks for the nice article.
|
Title:
Naming the file (dynamically)
Name:
Steve
Date:
11/15/2007 1:14:56 PM
Comment:
I'm not sure you can dynamically name it using SSIS GUI, however you could name it programmatically using SSIS advanced functionality.
I recommend you post your questions on http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL experts that can provide assistance.
|
Title:
Naming the file (dynamically)
Name:
Will
Date:
11/15/2007 10:03:50 AM
Comment:
Is there a way one can dynamically name the file using a date stamp (day and year)?
Example: WillsFile20071114
|
Title:
Thousands of Records
Name:
Steve
Date:
11/5/2007 5:37:34 PM
Comment:
SSIS should import the records with no problems. How long it takes could depend on your data structure. If you are running into errors, I recommend you post your questions on http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL gurus that can provide assistance.
Thanks,
Steve
|
Title:
Thousands of Records
Name:
Prem
Date:
11/2/2007 5:16:41 AM
Comment:
HYe peeps,
I want to know how to import flat files into sql server which consisting of thousands of records atleast with some speed
Looking Farward for the response
Regards to all
|
Title:
Fixed Length columns
Name:
Vijay
Date:
9/15/2007 6:21:05 AM
Comment:
HI, It's Fine.. But I want the same thing with fixed length columns. How to do that one. Can you help please... Thanks in advance...
|
Title:
Import
Name:
Steve
Date:
8/28/2007 2:23:18 PM
Comment:
What errors are you getting? Another resource for asking your questions are posted at the bottom of the article.
http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL gurus could also provide assistance.
|
Title:
Flat File text
Name:
Gem
Date:
8/28/2007 11:28:29 AM
Comment:
Hello
data from my flat file contains a / . I would normally put " around the data and set " as the text qualifier ths however is not an option and I cannot import data with a / within it. Any suggestions.
Regards
|
Title:
Not working fro me
Name:
Steve Schofield
Date:
3/15/2007 2:33:17 PM
Comment:
I would verify you are logged into the server with SA or permissions to perform this. Also,check the windows event logs to see if there are any specific errors when you ran this process.
|
Title:
Not working fro me
Name:
SAM
Date:
3/14/2007 9:41:06 PM
Comment:
Hi,
I followed the complete procedure.But in the end it does nothing.Flat file source as wel as Data flow task turns red in the end but no data is transferred actually. Please Help.
|
Title:
Restrict duplicacy
Name:
ss
Date:
8/8/2006 2:15:04 AM
Comment:
Hi;
I am able to import data from a flat source file to sql server,but when I'm executing the packages for number of times it is transferring the same data into the database,can you tell me how to restrict the problem of duplicacy.
Thanks
ss
|
|
|
|
|
|
