Click here to Skip to main content
15,937,429 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi all,

I have multiple files which are seperated by * as delimeter. How to import those files to database in ssis.
Please can anybody help me.
Thank you.
Posted
Comments
The Doer 24-Jun-13 21:55pm    
Which types of files are these? Are they table data? In which form they do exists?
xyz from Bangalore 24-Jun-13 23:51pm    
Those are text files only but column delimiter is '*'.
The Doer 24-Jun-13 23:54pm    
Do you want to enter those into some tables?
xyz from Bangalore 24-Jun-13 23:55pm    
ya.

1 solution

As i experienced there is no way to pass the columns which are delimited by "*" but you can use them with the delimiter as -
","
TAB
colon(:)
Semicolon(;)
VerticleBar(|)

1.Replace your text file content of "*" with any of the Above one,

2.Go for Data flow task, take flat text file.

3.Choose your .txt file from BROWSE option.

4.Use Column Delimiter whichever you have chosen.

5.Use OLEDB Destination for the Data Importing into Destination.

Hope it let you some way out.

Best Regards,
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900