Oh don't let me down Lynn, you my only option here. :laugh:

I tried goggling and I did not get much either.

One link told me to register the dll which I...

I have logging set to log OnError and OnTask Failed but this is all that the log contains:

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

Obviously I'm not doing it right?

I'll take a closer look at...

Lynn Pettis (3/28/2012)

First, is it me...

This is in the Job History:

Step NameLoadXYZDW_CYP_A_Thru_C

Duration00:09:51

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: UserName\ServerName$. ...2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved....

opc.three (3/27/2012)

As in where it is stored in msdb.

For the highlighted package the comand line to...

I changed the query timeout property on the Linked Server and the query completed.

I have logging set to log OnError and OnTask Failed but this is all that the log contains:

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

Obviously I'm not doing it right?

I deleted all of the dtsx files in the cfolder and copied the file again and I was able to rename it.

:unsure:

Thanks,...

Path as in where it stores it in the file system or the Data Collector?

I thought that it is stored in the Database?

I'm confused, could you...

Thanks for...

I'm getting the error again.:w00t:

Look at my last post at this link:

http://www.sqlservercentral.com/Forums/Topic1085904-148-2.aspx#bm1273125

I woke up in the middle of the night and I realized what might be the problem.

Prior to having this problem I could not start the SQL Server Integrated Services...

Lynn Pettis (3/26/2012)

Are you providing the UserKey...