DSXchange

Sounded more like 'I accidentally checked the Create Table option' to me... and yes, you would need a value for column's precision for Oracle to be able to create the table. If that's really what they wanted.

I think I agree!

Carefully read the error message again... it's not a RCP error, per se.

You really should push back, use the right tool for the job rather than just say that it's "not an option" for you. :? I am getting below error when I use the Exec statement in SQL Where exactly in the stage are you trying to execute the procedure? How exactly do you have everything set? W...

Your Admin is... incorrect, I'm afraid. The Stored Procedure stage exists all the way up to the most current 11.x version and is what you should be using IMHO. Here is a documentation link for 8.7 which shows support for SQL Server and shows where you should set it to a "Source" for use as...

So, it is your version that doesn't allow you to use the Stored Procedure stage, as in SQL Server is not supported? I seem to recall it supporting ODBC, however, even way back in 8. That being said, what kind of 'values' does it return - something that needs to be check or processed by the job or ar...

So... an Oracle connector to run a SQL Server procedure using ODBC?

Okay... "update some data" is still pretty darn vague. Is something about this stopping you from using a simple DML statement to do the update? And why all the questions about put_line, anonymous blocks, error logging, exception handling and such? That would imply much more is needed than ...

That's funny - all these years living over a UNIX basement and I don't ever really think of using "unset". I'm typically defining variables unique to process environments outside of our daily job runs and either not setting them unless needed or for Boolean values explicitly setting them t...

How about starting a new post and letting us know exactly what issues / questions you are having? We can always link back to this one if it proves to still be relevant.

Sure but basically the same thing. Either set it an empty string first regardless and then set it to your parameter list when it needs it or simply leave it not set in the process's environment and then only set it when needed. In either case it be "empty" and will just basically not appea...

I'd also be curious what exactly what see it in Outlook means? You mean the preview pane while still inside the Outlook email? Or after double-clicking the attachment so it opens up in another tool? Assuming the former as the latter would open a csv file in Excel... and if changing the extension mak...

Perhaps try using a ".txt" extension rather than ".csv"?

Yes, true... that is exactly what they are for.

However, I will say that in my experience when you see something like this:

A fails. Sometime later with no changes or intervention, A runs fine.

This is usually resource related. As in a lack thereof.