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 |
|
Frank Tudor
Starting Member
1 Post |
 Posted - 2007-06-25 : 14:19:17
|
| Hi guys, I have not posted to this site before, but I am wondering if someone knows about DTS ODBC source files and maybe if I am having some kind of permsissions problem.I am trying to create a DTS import through SQL Server 2000 and pull data via an Advantage Database ODBC. I can seem to get it to work on a remote server with the Management tools installed, but if I try to schedule it as a task it fails.Anywas the files are on one server and the odbc is installed coorrectly, but when i try to import the tables I get this error message:[url]http://qa3.com/images/sqlbomb.bmp[/url]Any one know why this is happening? My goal is to set a scheduled task to import these tables every night from an export that is written by another team.Thanks,Frank |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-25 : 21:51:42
|
| Did you check Advantage Database document as the message said? |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-06-27 : 14:59:11
|
| Since you posted the error as a link to an external image that I can't get to through our proxy server, I can't help you. It's unfortunate for you that you were too lazy to type the error into your post here, as I'm extremely familiar with both Advantage Database Server and SQL Server; I probably could have given you some help. |
|
|
|
|
|
|
ODBC error