about create plan in SQlServer2008 r2

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 1

Hi,

Remove quotes around any components in connection string in data source of the job's step, Will resolve your problem.

Regards

Ashok

zsafakhah SSC-Addicted Points: 441 More actions · Answer 2

I Fixed it.

1- My sa password had ; charecter . i change it.

2- register dts.dll in C:\Program Files\Microsoft SQL Server\100\DTS\binn. I register it by regsrv32 Syntax.

and now every thing is ok:-D