Resolved:

Seems I needed to set Protection Level = "Rely on server storage and roles for access control"

when importing the package from file system into MSDB.

Thanks. The way the documentation is written suggested each linked server had it's own "Provider Options" page

nivedita talukdar (6/24/2013)

I just edited the job and ran this below command:

SELECT * INTO trace_table1 FROM ::fn_trace_gettable('C:\PWB_Test\T.trc', 1)

The job went fine....and also deleted my T.trc file from folder...

But how do...

For one-time large deletes, I also do batches as suggested above. It can take a long time, but is not disruptive to other users and t-logs do not get out...

Thanks, that's helpful

I also found I needed the 64 bit ODBC driver:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=20065

I am now able to query MySQL data from SQL, so I have made progress !

No, I haven't delved into that .... not a lot of SSIS experience. The package itself runs fine though when run "stand-alone". It doesn't run when invoked from a...

Thanks for all the replies.

It runs every day at 4:00 am, and usually take 10 minutes. It processes a list of members and their recipeints of emails for reporting...

Nice Reply 😀

I don't really want to take on anything else right now, but may have to.

Back to my original question, would you expect that table to be locked until...

You asked for it 😛

Here's the code as I found it. The table being locked from other users is WebSiteMessageRecipient

CREATE PROCEDURE [dbo].[spWebSiteMessageDumpProcess]

AS

BEGIN

-- SET NOCOUNT ON added to prevent...

I only see a transaction inside the loop, doing a commit/rollback based on error code.

Good question .... not part of a solution that I know of .... (But I am part of the problem it seems

Do I need to save it as part of...

Yes, thanks

I think I sort of figured it out.

I have a job that captures blocking information and sends an alert and writes the blocking information to a table. Currently there's...

If I have 10 tasks in my package, can I select & run the first 6 all together ?

Then I can check output before running the next 4.

That is what I do. Then it goes yellow as it runs, and I hope green when it completes. But I cannot right click/execute the next task without first going...