Thanks for your replay... I think this will give me an answer...

and... I agree with you about categorizing errors on the way as i described but... My PM want to...

Thanks to all... I succedded to fill FileName column. Only error handling left.

Can somebody give me an example how to deal with this recuirement:

If the file is imported successfully then...

The problem is how to take the file name that I'm importing and fill the table with it. The situation is like that: The table that i'm filling it with...

It is not about a job interview nor university final exam nor homework. This is my task at work and i have 3 days to finish it. Yesterday was my...

Hi,

First, the solution with insert sqlstatement task is not what I need, because I want to have the file name when the data from the file is importing.

Second, emily (or...

Sorry, but it doesn't help me.

Hello,

The problem is solved. Finally, it works :). When i setup delegation for the service account ("Trust this user for delegation to any service (Kerberos only)") the problem was solved.

Thanks...

Thank you for trying to help me. I will continue wit this on monday when our system administrators will be here and I will let you know if I find...

You are absolutely right. If I login on the Server A it works. Now, if you can tell me how to make this to work from my computer it will...

Yes, it has

Yes, it has

Hello again,

I'm one step up 🙂 with my linked server. Now, when I create a linked server in profiler I see that the user who is accessing is AnonimusLogin, instead...

Can somebody please provide me a link where I can find step by step how to setup account delegation (Kerberos), because I think that somehow, this is a problem......

Sorry but I've tried from master and from other databases but didn't succeed.

Table exists on both server:

SELECT * FROM ServerB.MyDatabase.dbo.TableSize

Table exists only on Server B

SELECT * FROM ServerB.MyDatabase.dbo.BackupHistory