Hello guys, i'm getting a weird error - I've 2 packages, the first one calls the other, both are password driven and have the same pwd. The first package is kicking off correctly, executes several tasks and after it calls the next package using "execute package" task, the package starts running , it successfully executes 1st step which is a script task and then it fails trying to execute a "execute sql task' with the following error:
Error code: 0x80040E4D. An OLE DB record is available.....login failed for user id...blah blah blah...
any help is greatly appreciated.
Thanks