Oracle error through DTS

Hi all,
I'm hoping someone can help me out with an issue that I'm having. I have a script that runs in Oracle just fine, but because of the permissions that I have I cannot create a job in Oracle to execute the package so I created a job in SQL server to execute
the SQL.
When I use the execute SQL task and execute the package I get the following error:
ORA-01861: literal does not match format string.
I'm using an OLE DB connection to an Oracle 8i box. I can literally take the code in the execute sql task and paste it into SQL Navigator and execute there and it works fine.
Any help provided would be greatly appreciated.
Thanks
It's hard to say without see the sql you are running but
trying using OpenQuery to execute the script and see if that
works. Generally you get that Oracle error with dates and
date formats.
-Sue
On Wed, 28 Jul 2004 14:51:02 -0700, "J. Gonzalez"
<JGonzalez@.discussions.microsoft.com> wrote:

>Hi all,
>I'm hoping someone can help me out with an issue that I'm having. I have a script that runs in Oracle just fine, but because of the permissions that I have I cannot create a job in Oracle to execute the package so I created a job in SQL server to execut
e the SQL.
>When I use the execute SQL task and execute the package I get the following error:
>ORA-01861: literal does not match format string.
>I'm using an OLE DB connection to an Oracle 8i box. I can literally take the code in the execute sql task and paste it into SQL Navigator and execute there and it works fine.
>Any help provided would be greatly appreciated.
>Thanks
|||I always forget about openquery. I'll give it a shot.
Thanks!
"J. Gonzalez" wrote:

> Hi all,
> I'm hoping someone can help me out with an issue that I'm having. I have a script that runs in Oracle just fine, but because of the permissions that I have I cannot create a job in Oracle to execute the package so I created a job in SQL server to execu
te the SQL.
> When I use the execute SQL task and execute the package I get the following error:
> ORA-01861: literal does not match format string.
> I'm using an OLE DB connection to an Oracle 8i box. I can literally take the code in the execute sql task and paste it into SQL Navigator and execute there and it works fine.
> Any help provided would be greatly appreciated.
> Thanks
|||I'll chalk this one up as user error on my part. I didn't cast a field correctly (which explained why it didn't error out when there were no records).
J
"J. Gonzalez" wrote:

> Hi all,
> I'm hoping someone can help me out with an issue that I'm having. I have a script that runs in Oracle just fine, but because of the permissions that I have I cannot create a job in Oracle to execute the package so I created a job in SQL server to execu
te the SQL.
> When I use the execute SQL task and execute the package I get the following error:
> ORA-01861: literal does not match format string.
> I'm using an OLE DB connection to an Oracle 8i box. I can literally take the code in the execute sql task and paste it into SQL Navigator and execute there and it works fine.
> Any help provided would be greatly appreciated.
> Thanks
|||We all do it - stare at the sql and convince ourselves it is
correct. Thanks for posting back.
-Sue
On Tue, 3 Aug 2004 08:01:02 -0700, "J. Gonzalez"
<JGonzalez@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I'll chalk this one up as user error on my part. I didn't cast a field correctly (which explained why it didn't error out when there were no records).
>J
>"J. Gonzalez" wrote:
ute the SQL.[vbcol=seagreen]