Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

I currently produce a data file on an AS400 for use in a SQL 2000 database.I use the ... although I am not sure.<BR><BR>When I try to import the file to SQL, it recognizes my data as one ...

BR>Unfortunately I do not have extensive knowledge of SQL Server and have a stupid question. How can I import a 50k - 80k HTML file into a single field in the database. I have looked at the DTS ...