console app or windows app [Resolved]

[texas]

not sure what app to use but all i need to do is look in a network folder once a day to see if a files exist and call a DTS package to import the file into a SQL Server table.

[jmcilhinney]

Doesn't sound like you need a WinForms app. A console app that is invoked via a scheduled task would probably be your best bet. You could create a Windows service if you want it to be running constantly, but I'd go with the console and the schedule.

[texas]

is there any other way of getting data into a SQL table other than calling a DTS package?

[techgnome]

Sure... your app could open the file, read the contents then use SQL to insert the data into the database..... BUT.... if it's a large file ... DTS is much more efficient and uploading volumes of data than simple SQL inserts.

-tg