I thought this is a permission issue, SSIS is running under particular user or machine account and that account does not have access to the certificate in the personal...

Thanks

can we save Execl file to txt, i mean just save as would work, Its format wont be change.

Thanks a lot Jonathan.

Any body having any clue how to open Dynamic Recordset with command object?

Seting command Time out solves my problem.Lots of thanks for that

Now i am dealing with another problem.

With command object i could not open recordset with Dynamic cursor, the recordset is...

Thanks

Thanks Stokes thanks a lot.but my problem is bit diffrent

i have to do it without cursors

I have same structure for both the tables

I want to concatenate...

I have two tables having same structure.

Create table #temp1(

cID varchar(10),

Field1 varchar(10),

Field2 varchar(10),

Field3 varchar(10))

DATA

--------------------------------------

1    A    B    C

2    D    E    F

3    D    E     F

4     I    J     K

Second Table

Create table #temp2(

cID varchar(10),

Field1 varchar(10),

Field2...