August 22, 2012 at 12:13 pm
I have Sql server 2005 business intelligence development studio installed into my machine.I need to develop one SSIS package.
requirement is:
1: read the raw text or CSV file which doesn't have header info.It contains only data.
2: Load all these data into sql server 2005 table.the table contain header (Columns).
NOTE: I have created the table in sql server. the text file will be tab delimeter.
Can you please provide the solution/code to me?
August 22, 2012 at 12:24 pm
Karan_W (8/22/2012)
I have Sql server 2005 business intelligence development studio installed into my machine.I need to develop one SSIS package.requirement is:
1: read the raw text or CSV file which doesn't have header info.It contains only data.
2: Load all these data into sql server 2005 table.the table contain header (Columns).
NOTE: I have created the table in sql server. the text file will be tab delimeter.
Can you please provide the solution/code to me?
This is one of the simplest things you can do in SSIS. Please try for yourself - there are plenty of resources on the Internet which will help you - and then post back any specific questions you may have.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 31, 2012 at 12:32 pm
A quick way to get started loading data with SSIS, as well as get a foot in the door to developing in it, is to use the Import/Export Wizard to import your file and choose to save the resulting SSIS package generated by the wizard for later use.
How to: Start the SQL Server Import and Export Wizard (SQL Server 2005)
Using the Import/Export Wizard
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply