This really helped!!

And as said, I hope I remember this when this problem crops up again.

Regards,

Namrata

I had thought that. However, I fail to understand that with so many jobs in there, why would it delete the history of only 1 instance of this 1 job.

This is 2008 R2.

I have used delay_validation before but FMTONLY is new. Will try and get back.

Thanks you so much for all your help.

I agree with the work around. But the question still remains and that is, whether the SQL task is taking so much time only for the connection. Or is it...

Thanks a lot. This helps. 🙂

Thanks a lot.

This helps.

Requirement:

There are 100 tables each with different number and type of columns and obviously different rows.

And then there is a condition to check if some 5 columns exists,...

The error was due to something else. However, when you view a variable the fact remains that it replicates the "\" , although that does not come in the way...

Got it!!!

It was looking for package B in the SQL server (One dropdown option for a Package task) as its location.

(and not the file system)

So Putting them in the dts/packages...

Yes, I found out from Microsoft too, that this cant be done using Data Flow task. There is a Data Flow task plus by Codec I think, which does the...

Yes.

0x00F41E6A8ECB7F479AF5A6826828 is the encrypted value for the password

now I want to decrypt it (that is get it back in the varchar format)

It gives me the decrypted value

UserNameTest Testing123 0x00F41E6A8ECB7F479AF5A6826828

However, if I do the same after the 2nd SP, I get

UserNameTest ...

after the inserts using the 1st SP, I just take the ID and try to decrypt using

SELECT A.Value,

CONVERT(varchar, DecryptByKey(A.Password)),

A.Password

FROM ServicesDatabase.dbo.IdentificationService A WITH (NOLOCK)

where IdentificationID = @IdentificationID

It gives me the...

Yes, they are the same. There is no syntax problem in the code. Everything else that the SP is supposed to return is coming out fine, except for the @Password(I...

actual SP

ALTER PROCEDURE InsIdentification

(

@TypeIDint

, @Valuevarchar(255)

, @Passwordvarchar(50)

, @IdentificationIDint OUTPUT

)

AS

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SET XACT_ABORT ON;

BEGIN TRY

OPEN SYMMETRIC KEY SSN_Key_001

DECRYPTION BY CERTIFICATE IdentificationCertificate;

BEGIN...