I must be missing something simple. I have the following Script that I am using, but it is not working:

Dim objRequest

...

I have searched the net for some good examples and tutorials and can't seem to get this concept to sink in. Perhaps I am just not getting the right...

So my SQL Task has:

SELECT * FROM F55DMCTL WHERE DY55STAT = '1'

Where would I put the expression?

I think that calling the CL will probably work out better. I will keep you posted. Thanks for your help!

I made the changes and it looks like it still does not like the VARCHAR in there. 🙁

I am still getting the same error. My connection string is using the IBMDASQL OLEDB connection. Should I use another type of connection parameter?

Thanks for the response. I set up a linked server called 'ODYSSEY' and tried to run this command based on your suggestion below and am getting the following error:

[Execute...

When I try to run it, I get the following error:

'ssh' is not recognized as an internal or external command,

operable program or batch file.

NULL

I am assuming that I need to...

Yes, agreed! Option #1 was to pull directly from Oracle but there is more knowledge in house with the SQL Server side over Oracle. The Oracle DB sits...

No, the password is still the same.

Yes, I am using SSMS to get the results. I thought about doing it with SSIS once I get it working. I used the following code to put...

It may be a permissions issue ultimately.

When you run the job yourself in Visual Studio window, it runs in the context of your own username/security.

When you put the job...

I have seen this issue and the SQL Server Agent user profile is the one that is used in execution of the scheduled jobs. So if user1 creates an...

Thank you!! This is perfect and worked out great.

Cheers!

Tim

I tried that when I was running into issues thinking that maybe bringing over a "flat" file would work and got the same results.