Hi all,

I need some help with importing data from a flat file to a table with SQL Server 2000 DTS.
The file that I need to import is a text file, but it doesn´t have all the records with the same lenght.
For example, the first record have 150 characters, but the second record have 162.

In this case, I need to fill the records with blank spaces to guarantee the file layout.

Anyone have any VBA script or source that I can use to develop my process?

Thank you very much.

Daniel