Click here to Skip to main content
15,566,233 members
Home / Discussions / Database
   

Database

 
AnswerRe: Better way of matching a customer address Pin
jschell26-Apr-15 8:26
jschell26-Apr-15 8:26 
GeneralRe: Better way of matching a customer address Pin
jkirkerx26-Apr-15 9:34
professionaljkirkerx26-Apr-15 9:34 
QuestionExporting Database in XML Pin
MattAtCetraCom22-Apr-15 8:54
MattAtCetraCom22-Apr-15 8:54 
AnswerRe: Exporting Database in XML Pin
David Mujica22-Apr-15 10:36
David Mujica22-Apr-15 10:36 
QuestionRe: Exporting Database in XML Pin
Eddy Vluggen22-Apr-15 11:33
professionalEddy Vluggen22-Apr-15 11:33 
AnswerRe: Exporting Database in XML Pin
MattAtCetraCom23-Apr-15 8:37
MattAtCetraCom23-Apr-15 8:37 
GeneralRe: Exporting Database in XML Pin
Eddy Vluggen23-Apr-15 8:48
professionalEddy Vluggen23-Apr-15 8:48 
QuestionCreating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 6:10
professionalDr Miroslav Stimac22-Apr-15 6:10 
Hello,

I am trying to build a SSIS Package programmatically with .NET (C#).

Now I have problems with the component "OLE DB Source" when trying to set the ParameterMapping in order to use variables in the data flow task.

C#
...
string srcSql = "SELECT bla bla from ABC where YY = ? and BB = ? ";
Source.SetComponentProperty("AccessMode", 2); 
Source.SetComponentProperty("SqlCommand", srcSql );

Guid ParamGuid = new Guid(TrackingIDOld.ID);
Guid ParamGuid1 = new Guid(TrackingIDNew.ID);

// Here I am trying to set the parameters. However, it does not work!
Source.SetComponentProperty("Parameter0 Name", ParamGuid.ToString());
Source.SetComponentProperty("Parameter1 Name", ParamGuid1.ToString());

Source.AcquireConnections(null);
Source.ReinitializeMetaData();
...


Alternatively, I also tried this, but it does not work, too:
C#
Source.SetComponentProperty("ParameterMapping", "User::TrackingIDOLD"); // Parameter 0
Source.SetComponentProperty("ParameterMapping", "User::TrackingIDNew"); // Parameter 1


Does somebody know the correct syntax how to set the parameters?

Thanks for any advices!

Best wishes,
Miroslav Stimac
AnswerRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
PIEBALDconsult22-Apr-15 6:15
professionalPIEBALDconsult22-Apr-15 6:15 
GeneralRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 6:31
professionalDr Miroslav Stimac22-Apr-15 6:31 
QuestionMaster slave model in databases Pin
holykrish20-Apr-15 20:10
holykrish20-Apr-15 20:10 
SuggestionRe: Master slave model in databases Pin
Richard MacCutchan20-Apr-15 22:45
mveRichard MacCutchan20-Apr-15 22:45 
AnswerRe: Master slave model in databases Pin
Mycroft Holmes21-Apr-15 1:43
professionalMycroft Holmes21-Apr-15 1:43 
QuestionAlert when row deleted (SQL Server 2012) Pin
Member 1151899220-Apr-15 3:03
Member 1151899220-Apr-15 3:03 
AnswerRe: Alert when row deleted (SQL Server 2012) Pin
Tim Carmichael20-Apr-15 3:14
Tim Carmichael20-Apr-15 3:14 
AnswerRe: Alert when row deleted (SQL Server 2012) PinPopular
David Mujica20-Apr-15 4:31
David Mujica20-Apr-15 4:31 
GeneralRe: Alert when row deleted (SQL Server 2012) Pin
Member 1151899221-Apr-15 0:44
Member 1151899221-Apr-15 0:44 
QuestionDebugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 14:20
Kyudos14-Apr-15 14:20 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 15:11
professionalMycroft Holmes14-Apr-15 15:11 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 15:27
Kyudos14-Apr-15 15:27 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 16:19
professionalMycroft Holmes14-Apr-15 16:19 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 16:41
Kyudos14-Apr-15 16:41 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 17:02
Kyudos14-Apr-15 17:02 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 18:37
professionalMycroft Holmes14-Apr-15 18:37 
QuestionHow to remove a 1000 seperator from a number Pin
Ambertje14-Apr-15 1:35
Ambertje14-Apr-15 1:35 

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.