Click here to Skip to main content
16,012,316 members

Comments by Nandhini Devi (Top 65 by date)

Nandhini Devi 25-Nov-15 16:23pm View    
Deleted
"Provider=SQLNCLI10.1;Data Source="+ @[User::SourceSQL] +";Integrated Security=SSPI;Initial Catalog="+ @[User::SourceDB] +";"
Nandhini Devi 23-Nov-15 20:41pm View    
create a new connection using oledb and property-> expression-> "Provider=SQLNCLI10.1;Data Source="+ @[User::SourceSQL] +";Integrated Security=SSPI;Initial Catalog="+ @[User::SourceDB] +";"
I entered this connection string and evaluated. Its working fine.
Nandhini Devi 18-Nov-15 1:38am View    
Thanks but I am trying to connect my database dynamically using variable in SSIS
Nandhini Devi 15-Oct-15 15:09pm View    
both answers are right
Nandhini Devi 15-Oct-15 2:46am View    
I have edited my question sir.