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 |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2009-03-31 : 12:45:31
|
| Hello Friends,I am trying to create a SSIS package referencing a DTS 2000 package that I already have. DTS 2000 package is running fine. In SSIS package using the same files I have some issues with the Flat File Connection Manager.I have a flat file which does not have any column names in it, but it has 7-8 different columns seperated by spaces. In DTS, I just used {CR}-{LF} and ANSI Code Page. I have done the same in SSIS. But when I preview the step in DTS 2000, I am able to preview all the columns well organized, but in SSIS, I am just getting one column for all the records. And in that one column also, the data is not coming right.It is coming vertically.For instance, I have one row in my flat file like:001 XYZ 1234 Street USAIn the preview, I am getting this above mentioned row like this:Column 0001XYZ1234I wonder why is it doing this and what is that I am doing wrong?I have everything set up same as in DTS, but I am sure I am missing something. I guess I will have to add the columns manually for the flat file, but not sure. Is adding columns manually only the way to achieve this or am I committing some mistake?Please do let me know if you know about this.Thanks. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-04-01 : 10:10:15
|
| What is the format you have chosen for the Flat File connection manager?You need to have it as 'Delimited'. And have {CR}{LF} as row delimiter.No column delimiters. |
 |
|
|
|
|
|
Flat File Connection Manager Issues