Hi,

I found out an error while I execute DTS on schedule, but i can manual execute on local package but not on schedule.

the error message is like this:

cannot found ODBC data source and no default ODBC found on OLEDB provider.


how can i solve a proble as this?


Thanks and regards

Did you provide a datasource manually, or just use the default?

When you execute a package manually, the package runs under *your* user context. If it is executed by a schedule, it runs under the account that the SQL Server Agent runs under. Maybe this account has a different default database assigned.

Make sure you explicitly name your database in your connection. Also, make sure that the account that the SQL Server Agent runs under has sufficient permissions to perform the tasks in the DTS package.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Where is the DTS package saved? where is it scheduled? you may be saving it locally and scheduling it remote.




Sal

Jane,

When you run a scheduled process you'll also want to make sure that you have any server aliases and/or ODBC DSN's setup on the server that are used in the DTS package and are already on your local machine. This is in addition to the security context difference that Imar mentioned.

Take care,
Jeff

i dunno how to check the setting, i had check before, cannot find out, any idea where i start to check it?



thanks

What setting are you referring to? We all suggested a different solution, so it may be useful if you indicate what setting you want to change.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.