Hi SO,

Can you please verify that you have set everything as outlined in the following MS KB?

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811

(Check all manual steps)

Hm, i tried to get the error message from a new package, but it actually ran successfully this time. Both the oracle and the oledb parameter syntax returned the correct...

Hello Antares,

Regarding your suggestion on the second example (disconnected edit for parameter declaration): It would be very interesting, but I cannot seem to get it to work with Oracle. Do...

Sorry, the 2 at the end seems to have dropped off from the link.

Use http://p2p.wrox.com/topic.asp?TOPIC_ID=15542 instead.

Shouldn't the following already be a derived table?

SELECT SomeIntCol - 100 FROM dbo.BaseTable

Obviously it is not a subquery.

Hi Rob,

I am not sure what you are trying to do here.

Shouldn't the company names be unique?

If the update you are trying to do succeeds, you would have several companies...

Yeah, the PIVOT is very unintuitive.

I found this information helpful:

http://p2p.wrox.com/topic.asp?TOPIC_ID=1554

What happens if you execute the queries in the opposite order?

Hi Grant,

that sounds reasonable. I just wanted to know whether you had some more information than I do.

Thanks for letting me know.

I hereby apologize as well, but I will...

Hi Grant,

what makes you sure this time that it does not make a difference?

Did you get this information from Microsoft ?

I am pretty sure that I had examples in the...

Just to be on the safe side, can you try to re-type the whole query in the SQL Editor and then add the space? (SELECT * FROM SERVER. .SCHEMA.TABLE)

Not sure...

Regarding the original error - did the error message show the wrongly built 3-part name as in my case?

SERVER.SCHEMA.TABLE

I assume you can run any statement after you have "temporarily disabled access" to the file.

Then add the black text into the results tab.

But just a thought. (If that is...

.NET will not work with DTS...

But very good article. I have had similar "problems" in the past but used different strategies:

When executing other packages within a package I usually use...