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 |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2007-10-22 : 09:05:08
|
| I created a package within BIDS which tests successful. However when saved into MSDB and I execute the package, the package completes without any issues however doesn't work.All the package is doing is a simple backup and copy operation but fails without any errors within the Execute Package Utility.Has anyone seen this issue before? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 22:27:45
|
| Why do those in ssis at first place? |
 |
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2007-10-25 : 06:52:04
|
| My reason for running the package in SSIS(DTUtil) is to validate the package works, and then to run the package using DTSExec which I intend to enable a user to execute.The steps work successfully within BIDS, however when saved and run from MSDB or cmd shell DTSExec the package runs in a mms, without errors and doesn't perform the work. Have I missed some kind of build or compile step in BIDS? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 22:27:40
|
| You can enable package logging to see what happens. By the way, any remote server involved in the package? If so, ensure sql services account has permission to access remote site. |
|
|
|
|
|
|
Execute Package Utility Issue