Click here to Skip to main content
15,903,030 members
Home / Discussions / Database
   

Database

 
QuestionNeed to find out what drivers are missing on the Production Server Pin
indian14321-Sep-17 7:32
indian14321-Sep-17 7:32 
AnswerRe: Need to find out what drivers are missing on the Production Server Pin
Eddy Vluggen21-Sep-17 23:23
professionalEddy Vluggen21-Sep-17 23:23 
Questionreference in DB design Pin
a_yosef19-Sep-17 0:01
a_yosef19-Sep-17 0:01 
AnswerRe: reference in DB design Pin
Richard MacCutchan19-Sep-17 0:28
mveRichard MacCutchan19-Sep-17 0:28 
AnswerRe: reference in DB design Pin
Eddy Vluggen19-Sep-17 1:11
professionalEddy Vluggen19-Sep-17 1:11 
QuestionName for Sql Table Pin
King Fisher8-Sep-17 0:08
professionalKing Fisher8-Sep-17 0:08 
AnswerRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:20
professionalJochen Arndt8-Sep-17 0:20 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:22
professionalKing Fisher8-Sep-17 0:22 
GeneralRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:28
professionalJochen Arndt8-Sep-17 0:28 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:38
professionalKing Fisher8-Sep-17 0:38 
GeneralRe: Name for Sql Table Pin
King Fisher8-Sep-17 0:28
professionalKing Fisher8-Sep-17 0:28 
GeneralRe: Name for Sql Table Pin
Jochen Arndt8-Sep-17 0:36
professionalJochen Arndt8-Sep-17 0:36 
AnswerRe: Name for Sql Table Pin
Eddy Vluggen8-Sep-17 1:02
professionalEddy Vluggen8-Sep-17 1:02 
AnswerRe: Name for Sql Table Pin
Richard MacCutchan8-Sep-17 5:21
mveRichard MacCutchan8-Sep-17 5:21 
AnswerRe: Name for Sql Table Pin
jschell8-Sep-17 8:21
jschell8-Sep-17 8:21 
QuestionVisual studio 2010 ssis Pin
Joanna Webster7-Sep-17 1:43
Joanna Webster7-Sep-17 1:43 
GeneralRe: Visual studio 2010 ssis Pin
Richard MacCutchan7-Sep-17 4:43
mveRichard MacCutchan7-Sep-17 4:43 
AnswerRe: Visual studio 2010 ssis Pin
Simon_Whale7-Sep-17 5:06
Simon_Whale7-Sep-17 5:06 
AnswerRe: Visual studio 2010 ssis Pin
Chris Quinn7-Sep-17 5:48
Chris Quinn7-Sep-17 5:48 
QuestionSql server 2008R2 merge statement doesn't always find a match (even though it exists) Pin
#realJSOP31-Aug-17 4:13
professional#realJSOP31-Aug-17 4:13 
AnswerRe: Sql server 2008R2 merge statement doesn't always find a match (even though it exists) Pin
#realJSOP1-Sep-17 4:30
professional#realJSOP1-Sep-17 4:30 
QuestionEncrypting Connection string of a connection in an SSIS Package Pin
indian14329-Aug-17 8:45
indian14329-Aug-17 8:45 
Hi,

I have few SSIS Packages which have Connections which deal with sensitive Data, so far how I am doing is, I have a variable which holds the Connection string of the sensitive Data Connection, I am going to set that variable value at runtime from .Net code which executes the Package, the variable value is stored in the Database in AES Encrypted format, to protect my Connection String so far I am deleting the User Id Password values from the variable, before putting SSIS Package onto the FileSystem to be executed by .Net code (this is so that unwanted people can't see the credentials). But when I need to test, debug or edit the Package I need to put the values statically and execute the Package to see the results, because Dataflow needs static connection with proper connection string (there are Dynamic Dataflows are there which can pickup the connection string at run time, but we are not using those here though).

So far this is what going on to protect the credentials for the sensitive Database. But if I can encrypt the Connection string even at the static level and edit or execute the Package, it would be great, is there anyway to do it? Or is there any better approach to secure my credentials than this approach, please give me your great suggestions. Obviously I believe few more brains are better than one brain in lot of situations.

Thanks in advance my friends.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

Questionhelp SQL query Pin
trungysp198625-Aug-17 16:06
trungysp198625-Aug-17 16:06 
GeneralRe: help SQL query Pin
PIEBALDconsult25-Aug-17 18:18
mvePIEBALDconsult25-Aug-17 18:18 
AnswerRe: help SQL query Pin
Member 133967936-Sep-17 13:58
Member 133967936-Sep-17 13:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.