Help with agent job to import from ODBC?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Ricciardi - 06 Mar 2008 02:41 GMT

SQL Server 2005 Standard Edition.

Using wizard, no problem to use SQL to import from ODBC data source. Saved
the DTS job to an SSIS package, unable to use with agent scheduler.

Error is DTS_E_PRODUCTLEVELTOLOW.

Please help why is this happening?

Reply to this Message

Uri Dimant - 06 Mar 2008 07:23 GMT

Frank
Do you want to move jobs to SQL Server 2005?

> SQL Server 2005 Standard Edition.
>
[quoted text clipped - 4 lines]
>
> Please help why is this happening?

Reply to this Message

Frank Ricciardi - 06 Mar 2008 16:25 GMT

I just want them to run as scheduled without operator intervention. I don't
really care how it do it.

Does that make sense?

thanks in advance..

> Frank
> Do you want to move jobs to SQL Server 2005?
[quoted text clipped - 7 lines]
> >
> > Please help why is this happening?

Reply to this Message