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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-02-28 : 08:50:00
|
| I have a DTS Pkg which has a Activexscript task and a execute sql task. When I schedule the DTS pkg the activexscript task works fine but the pkg fails on the execute sql task with the following error: The Package is been scheduled on the production SQL Server Box.Error string: No value given for one or more required parameters Error source: Microsoft OLE DB Provider for SQL Server Error string: No value given for one or more required parameters DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.When I run the Package Manually on the production box everything works fine. What could be the issue here. The parameters being passed to the stored procedure everyhting looks fine and the stored procedure is on the Prodn DB.Ramdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 19:45:12
|
| How are you scheduling it? Through the Schedule Package...? Or by calling DTSRun in the job? Try DTSRun:DTSRUN -SServer1 -E -NPackageNameTara |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-03-04 : 19:49:04
|
| I had this problem before and it seemed that the DTSRUN encrypted string generated by SQL gets corrupted. I fixed by doing what Tara suggests.Did you create a job to execute the package on a development server and then move it to the production server??Edited by - ValterBorges on 03/04/2003 19:52:14 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 20:15:24
|
| If you want the string to be encrypted (like it is when you do it from EM by selecting Schedule Package) you can do this:DTSRUN -~SServer1 -E -~NPackageNameTara |
|
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2003-03-04 : 21:01:47
|
| Hi Folks,Thank you for your replies. I got the DTS package to Schedule on SQL Server 2000 Production box without any changes. I use a lot of global variables in my package.Ramdas NarayananSQL Server DBA |
|
|
|
|
|
|
Scheduled DTS Package....