Thanks Phil, let me try that. I'll let you know how I make out.

Thanks Phil,

I'm testing it this way because I eventually want to wrap it in a for each file loop, reading each sql file and exe the code one by one,...

I had a similar result. After I closed the Server Manager window I was able to re-launch the SQL install but then the checks found the server needed to...

To add my 2 cents, I was also getting the following error even though the credentials and proxy were setup -

“Non-SysAdmins have been denied permission to run DTS Execution...

Thanks Brian,

I ran procmon and it gave a huge amount of output. I sifted through it for a few hours but can't find anything conclusive. I tried reducing...

Thanks, and yes - full permissions on the Log folder. Actually it's full permission on the folder Microsoft SQL Server a few levels up, but when checking the sub-folders...

Thanks for the info posted here. I got it working but we have both 2005 SP3 and 2008 R2 RTM running on a dev server so when I connect...

That did the trick!

Duh! I should have looked closer to the where clause.

Thank you,

Lori

OK, I just re-ran the test per the script verifying I'm in the right DB and the ObjectName is still Null. Per the default trace it should be capturing...

Great article, thanks!

I'm not seeing the actual objectName for anything though and tried it with both SQL 2005 SP2 and SQL 2008 SP2 CTP.

Thoughts on why this data is null?...

Had a similar problem with running SQL Server 2008 SP1 32bit to Oracle9 and received the Error 7399 for "Cannot initialize the data source object of OLE DB provider 'OraOLEDB.Oracle'...

Thanks Shawn. For our situation it's for HIPAA data. We are looking into NitroSecurity, and a few others, and I wondered who else was using network data capture...

Oh yes. I should have mentioned that

it is being upgraded to 2008 like the rest

of the servers. DTS rewrites to SSIS need

to come first, IP, so until then . ....

Thanks for your posting. My scenario was slightly different and your solution didn't work for me as-is. My particular environment is with running SSMS 2008 and pointing to...