I have created a DTS to update a table in the costumers DB in our website SQL Server.
Firs i delete * from tblSyncClientes (on website), then copy * from my local table to tblSyncClientes, update tblClientes(on website) from tblSyncClientes, add new entries and im done.
When i go to Local Packages on my local server and right click the package ->execute package, it works just fine! But when i program this packages it fails , the server event viewer just informs me that the job fails...no other details.
Does anyone have an idea what could i be doing wrong??
Thanks in advance!!
Saludos desde Guadalajara, tierra del tequila!!!