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 |
|
chetan06
Starting Member
11 Posts |
 Posted - 2007-03-29 : 02:23:15
|
| Hi Group.Currently i am facing problem while scheduling DTS Packages.I have tried to schedule a simple DTS Package (which takes the data from SQL and exports them into dat file) with one step.It is giving me one error :The process could not be created for step 1 of job 0x9BA1F2542C6097459C8D0F9CF82F9838 (reason: The system cannot find the file specified). The step failed.The path where i am exporting these records is properly named.When i execute this dts package, it is running properly.Regards,Chetan |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-03-29 : 03:36:45
|
| Did you try dtsrun? Create a new job step with the following operating system command:dtsrun /S databasename /E /N dtspackagenameI belive the /E means integrated security. Look up "dtsrun" in books online and you'll find all you need...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
chetan06
Starting Member
11 Posts |
Posted - 2007-03-29 : 04:00:58
|
| No success with this solution..Still getting the same errorCjain |
|
|
|
|
|
|
Problem while scheduling DTS Packages