Hi Ashish,

'user2' only has public server role on the database and EXECUTE permission on 'proc1'.

Hi jerry-621596,

The IMPERSONATE permission of 'user2' to 'user1' is required when using the EXECUTE AS clause.

I...

Hi SSCrazy,

Thanks for your inputs especially your suggestion to login to the computer using the Proxy account.

It allowed me debug the specific components of the DTS.

The Access Denied error comes...

Yeah, that's what we did since it will be more efficient in terms of performance and data integrity of the import process.

Just curious if it is natively possible in DTS.

It...

There are miscellaneous information in the first 10 lines like the date the file was created, the title of the report, etc.

The column headers starts in line 11.

Thank you everyone for your insights.

We'll be more prepared next time and set-up a trace to audit any changes in the database.

That's also what I fear.

Thanks again Gianluca.

I already bookmarked the page since it contains two more interesting articles about SQL Index and T-SQL performance tuning. I will read the topic about the aggregates.

Thanks for...

Sorry for the late reply.

Knowing that the query optimizer will only compute the scalar function once and then use the return value for the rest of the SELECT statement makes...

@crazy4sql

I was referring to the SQL Server Authentication of the OLEDB Connection Manager. Using SA authentication causes the SQL Server Agent Job to fail.

@Koen Verbeeck

That's what I also...

Thanks for your reply.

You are right, the two modules will not share data, only the table.

I also believe it is better to create a new table even if the structure...

Thanks for your reply.

The supposedly new identical table will be frequently updated by the system. With this in mind, is it better to create this new table?

The supposedly new column...

Thank you very much Roy. That gave us clear direction on our goal.