I am also facing the same issue anyone faced this before?

Excellent Article! and very well explained. still I have very simple question.

I may be sounding asking a basic question but wanted to make some things clear here.

what happens when the...

I just have only single step in this job which is to run this SSIS package.

so you mean to say that machine name specified in windows and sqlserver name should be same while creating distributor?

I am facing similar issue in which my machine name is...

you was able to login because, you must be having alias created using your server IP and old server name.

If you remove that alias then you wont be able to...

you login using your old server name OR new server name? OR local host (.)

and which mode you using for login SA/windows?

is anyone able to identify?

even no checkpoints placed.

Nope all the tasks were in the enabled state, firstly that only I checked.

I am still facing this issue. whenever this issue raises I just remove all the arrows...

Lynn...no hard feelings about post on forum but i felt its important to raise a point about using that @temp variable.

here i am not criticizing anyone...but just informing [Smile] and...

why to do unnecessary efforts of using @temp variable?? method is not wrong but its time consuming 🙂 as its will firstly write value in variable and then

read from it...