Transferring Text File
I am trying to transfer data from a text file over to a SQL Server Table.
I am using a DTS package and the text file is fixed width. I went in and
indicated the columns in the text file, but for some reason it cannot recognize
the end of the file. The file is generated by another database and the only
row deliminator it can put in is a "End of Record." How can I tell the DTS
package to end the row when it reaches an "End of Record." Thanks.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL