4GB RAM. I have to look into SSIS, to see how I can do it; I need to be able format and put titles underneath the pictures.

On average 300kb/picture, hard disk space is not a problem, I have a new machine with plenty of disk space. Thanks for the link to the report size.

I found a way for ref cursors, here is the solution:

What you will need

1) Little bit of Oracle DBA assistance may be needed

2) VS studio would help in creating C#...

I did that, it looked fine.

It appears to be fixed now, still don't know exactly what caused the problem, and how it really got fixed. Here are the three things...

It appears to be fixed now, still don't know exactly what caused the problem, and how it really got fixed. Here are the three things that were done, after that...

Thank You. Can you please point me to where the SQL Server stores the password for xp_cmdshell proxy and the SQL Agent proxies you mentioned, so that I can change...

Thank You.

Thank You. Some what related question - if a windows ID (in sql server setup as windows authentication) has sysadmin authority and it is the owner of a database, when...

I am having trouble with linked server. In this linked server, only one windows ID is mapped to an Oracle ID (oracle id is only in oracle DB not related...

Hi Brandie,

Thank You. I was told that service accts have non expiring passwords (hopefully they were always that way), we never had in the past password change...

Thank You. I recreated the variables in the DataFlowTask pane, it defaulted to scope 'Data Flow Task', which matched to what is shown under 'Package Explorer' pane. It worked.

Initially...

Phil: That link you posted is of tremendous help, who would have known to publish metadata. Thank You.

'SQL NEW NEW': I managed to get it to work, the essential parts....

Thnx, but the problem is not Excel, it is with Available input columns, there are none from the 'OLE DB Source'.

Hello Brad,

In IE, I tried with the maximum allowed resolution on my PC 1280x1024, still part of the slides to the right...

Any one having trouble viewing this video, for me it is showing only half the picture. I tried increasing the resolution, lowering the text size, still only a partial video...