I got it to work.

Thanks.

My requirements have changed.

What I need to do is have a .NET Script execute a Stored Procedure against an Oracle Table.

It looks for a record with the current Date that...

Thanks!

How do I Execute in .NET to check the...

David Burrows (8/29/2014)

---

Your query is returning a date datatype, the gui interface (SSMS) is displaying as characters formatted as to the language of the login.

So

SELECT CONVERT(DATE,GETDATE()) AS CurrentDate;

and

SELECT ...

Luis Cazares (8/29/2014)

---

Equivalent in Oracle?

SELECT SYSDATE AS...

I want to do the Equivalent of the following SQL Select and return the result listed below:

SELECT CONVERT(DATE,GETDATE()) AS CurrentDate;

CurrentDate

2014-08-29

Thank you.

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.

Any ideas would be greatly...

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.

Any ideas would be greatly appreciated.

I just found the code.

INSERT INTO [table1]

(

...

opc.three (9/20/2012)

---

Why let the package that checks for the record exit? Just let it run. This way you would only need on SSIS package.

There are lots of options but here...

Thanks!

Thanks for the recommendations.

When I attempt to install Ignite I get an error that the Wizard was interrupted before Ignite could be installed.

There was an open query using an unfriendly name. I did not recognize it.

Thank you.

I was able to create the PK.

It does not drop the table. I can't select, create a PK, etc.

I never saw anything like this.

It continues for ever. I does not finish. Am I making myself clear?

GilaMonster (7/27/2014)

---

You have an expensive, long-running query. That's about all that can be said from the details given. If you want to know more, figure out (from the DMVs) who's...