can the sql server successfully ping the other two DC's? do the logins which your using as service accounts exist on the other two DC's

can you post the details...

in that case its best to pass in date times as date times not varchars, so you can either cast or convert them to an ISO date format in the...

could you not use a data conversion task in the middle of the source and destination to convert in SSIS rather than in the actual query at the source

are you using parameters to pass in dates?

the @ means its a parameter/variable which is used to run the query block

eg

delcare @name = 'Anthony'

select * from users where name = @name

go into the data source and what DB does it want to access? if it matches the name of the DB in SQL then there is something else at...

looking at a default trace from my test bed it doesnt capture password changes.

it captures the audit login change property event and the details are "records modifications on login property...

itskanchanhere, we are all volunteers here and post in our spare time so please do be patient if you dont get a responce straight away.

i would say use the right...

something somewhere changed the password

take a look in the default trace file as it might still be in there if your lucky

but if not, without some sort of auditing on...

without more information on the "else" part of things I cant help, unsure what you want to else or what logic you want in the query and what outputs with...

State 8 is a password mismatch error, so something somewhere changed the password, unsure if this information is stored in the default trace but will most likely not be there...

Suction

what are you trying to do, please follow the link I suggested in providing the t-sql what you are wanting help on

duplicate post

replies here please

as a follow on from this, read the first link in my signature block, it will help you in the future on how to post code for tables procedures and...