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 |
|
aprichard
Yak Posting Veteran
62 Posts |
 Posted - 2009-10-31 : 09:16:43
|
| Hi,When i call dts using DTEXEC, it throws error "Coould not load package"but its working fine when exectue dtsx package individualy.i am woring on sql server 2005Please give me suggestion what i have to do |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-31 : 10:46:15
|
| show us your command.are you executing dtexec or is SQL Agent? If SQL Agent, make sure sql agent service account has permissions.when you saved package, did you allow it to store security info, or did you set to allow sever to control access? |
 |
|
|
|
|
|
Dts Not working