Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Executing Procedure in SSIS package Expand / Collapse
Author
Message
Posted Saturday, June 15, 2013 6:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 17, 2013 11:52 AM
Points: 3, Visits: 35
Hi guru12
I am facing same problem while working on SQL server CDC.
Per your last comment did you change in procedure @LastLSN to INT ( instead of BINARY(10))?

I understood that u put

in parameter mapping Usertable::Tablename input and User::StartLSn output.
and in resultset selected single row,and result setname=o,User::StartLsn.
parameterdatatypes both string and package variables also string,

I am not getting option to select parameterdatatypes as string, did you put varchar here ?

Could you please clarify what changes fixed your issue??

Thanks in advance.
Post #1463914
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse