Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lauramayer
Posting Yak Master
152 Posts |
 Posted - 2004-04-28 : 14:01:41
|
| Good afternoon,I would like some thoughts/suggestions about a project. We have these handheld devices that users data enter information into. They then connect to the computer over the COM port. Right now it's using Access 2.0 and terminal.exe to create a text file then the text file is loaded into access again. The entire app is being rewritten and I've almost done it except for this part. Has anyone had experience with this? Or have any thoughts they would like to share to point me in the right direction?ThanksLaura |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-28 : 14:23:18
|
| You can use DTS if you've got an ODBC driver for your source data.Tara |
 |
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-28 : 14:27:04
|
| If you mean by source data -the handheld- thats a no. If you mean where its going to end up, yes. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-28 : 15:46:43
|
| Are you running Pocket SQL on the handheld? Are you still getting a text file via a COM port from the handheld?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-29 : 06:23:22
|
| No this is just a separate entity that creates a CSV that I have to pull out of the handheld then import it into SQLLaura |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-29 : 06:34:08
|
| Then use DTS to load the textfile... |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-29 : 07:10:38
|
| Rick,You can call a DTS package the same way you call a stored proc in VB right?Laura |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-04-29 : 07:22:42
|
| From command prompt you can call the dts package like this:dtsrun /S{servername} /E /N"Package name"or if the pacjage is in a job then you can execute the SQL procedure sp_startjob (refer to BOL).Duane. |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-29 : 07:53:43
|
| Excellent! No I just have to figure out a way to get the text out of the handheld...ThanksLaura |
|
|
|
|
|
|
upload from Handheld to SQL