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.
Printable View
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.
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.
is there any other way of getting data into a SQL table other than calling a DTS package?
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