Extracting Data from a Flat File with SQL Server 2005 Integration Services
page 1 of 2
Published: 06 Jun 2006
Unedited - Community Contributed
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): 54715/ 72

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.


View Entire Article

User Comments

Title: Reading a value from a flat file to a variable?   
Name: Bruno Pimenta
Date: 2010-01-14 5:36:13 AM
Comment:
I was looking for a simple way to read a value from a flat file into a variable, without using record sets, is this possible?

Thanks,


-----------------------
Satish

You can do this by connecting the flat file task to a script, using an error connection (red arrow) and them making the script return a message, if you have trouble doing this, drop me an email at birpimenta@gmail.com
Title: How to handle Exceptions   
Name: Satish
Date: 2010-01-09 4:11:26 AM
Comment:
Very good exercise. In this exercise i want to add a logic to throw a message when the flat file is not found in the source location. How to handle this. Please provide your answers to satish439@gmail.com
Title: How to handle exceptions   
Name: Satish
Date: 2010-01-09 4:09:38 AM
Comment:
Very good exercise. In this exercise i want to add a logic to throw a message when the flat file is not found in the source location. How to handle this
Title: Flat file source problem   
Name: Emanuele
Date: 2008-06-09 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: 2008-06-07 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: 2008-03-15 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: 2007-11-15 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: 2007-11-15 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: 2007-11-05 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: 2007-11-02 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: 2007-09-15 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: 2007-08-28 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: 2007-08-28 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: 2007-03-15 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: 2007-03-14 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: 2006-08-08 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






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-09-21 4:31:23 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search