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?
http://msdn2.microsoft.com/en-us/library/ms190312.aspx
http://msdn2.microsoft.com/en-us/library/aa225968(SQL.80).aspx
MohammedU.
Moderator
SQL-Server-Performance.com
MohammedU,
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.
]]>