Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-12-03 : 14:43:56
|
| I tried to use SSIS to import huge fixed width text data but I am confused of how to select data source:1) What format do I select? I select fixed width, is it ok?2) Under data source panel, do I need to go through columns, advanced...3) How to set row and column delimiter? |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-03 : 15:05:15
|
| This link shud guide u to set up a flat file source in SSIShttp://msdn.microsoft.com/en-us/library/ms139941.aspx |
 |
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-12-04 : 08:46:39
|
| You first need to create a flat file connection. When you set that up, a wizard will pop up and there you will be able to set row and column delimeters. Once you build this data source then you will be able to access it through data flow. |
|
|
|
|
|
|
How to use SSIS?