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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-16 : 09:40:18
|
| JAY writes "I KNOW YOU DON'T LIKE DTS, BUT I HAVE A GOOD ONE FOR YOU. I CREATED A SIMPLE DTS MOVING DATA FROM SQL TO FOXPRO, IT WORKS FINE. THEN I TRIED TO PUT THAT DTS IN A JOB AND IT BLOWS UP. I GENERATED THE COMMAND LINE FROM THE DTSRUNUI. I FIGURED OUT MY FIRST PROBLEM WAS AN OWNERSHIP ISSUE. I OWNED THE DTS AND THE SERVER OWNED THE JOB. WELL I CHANGED MY DTS TO "SA". THE JOB STILL DOES NOT WANT TO EXECUTE. IS THERE A BETTER WAY TO GENERATE MY COMMAND LINE. IF YOU HAVE ANY IDEAS I WOULD LOVE TO TRY THEM. THANKS FOR YOUR HELP!!" |
|
|
|
|
|
DTS WITHIN A JOB