ssis package flat file import | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ssis package flat file import

how do I import a flat file that is space delimited in 2005. This is currently working in sql2000 with no problems. I have tried all options available.
What is the error you are getting? Can you post complete error? Did you try using OPENROWSET OR BULK INSERT?
Thanks for the suggestions. I finally figured it out. I had to manually create the columns. In sql2000 we did not have to do that.