Read Text File from Flat File Connection Manager SSIS
hello experts,
i createing one task (user control) in ssis. have property grid in gui , 2 buttons (ok & cancle).
propertygrid has properties sourceconnection, outputconnection etc....right able populate connections in list box next source , output property.
now question guys depending on source connection should read text file associated connection manager. after validation should pick header (first line of text file bases on record type) , write new file when task executed. have following code reference. please let me know going in right direction or not..
what should go here ?
->under class a
public
override dtsexecresult execute(connections connections, variabledispenser variabledispenser, idtscomponentevents componentevents, idtslogging log, object transaction){
//some code read file , write new file
return
dtsexecresult.success;}
public
const string property_task = "customerrorcontrol"; public const string property_sourceconnection = "sourceconnection";
public
void loadfromxml(xmlelement node, idtsinfoevents infoevents){
if (node.name != property_task){
throw new exception(string.format("invalid task element '{0}' in loadfromxml.", node.name));}
else{
try{
_sourceconnectionid = node.attributes.getnameditem(property_sourceconnection).value;
}
catch (exception ex){
infoevents.fireerror(0,
"loadfromxml", ex.message, "", 0);}
}
}
public void savetoxml(xmldocument doc, idtsinfoevents infoevents){
try{
// // create task element xmlelement taskelement = doc.createelement("", property_task, "");doc.appendchild(taskelement);
// // save source fileconnection xmlattribute sourcefileattribute = doc.createattribute(property_sourceconnection);sourcefileattribute.value = _sourceconnectionid;
taskelement.attributes.append(sourcefileattribute);
}
catch (exception ex){
infoevents.fireerror(0,
"savexml", ex.message, "", 0);}
}
in ui class there ok click event.
private
void btnok_click(object sender, eventargs e){
try{
_taskhost.properties[
customerrorcontrol.property_sourceconnection].setvalue(_taskhost, propertygrid1.text);btnok.dialogresult =
dialogresult.ok;}
catch (exception ex){
console.writeline(ex);}
#endregion
}
SQL Server > SQL Server Integration Services
Comments
Post a Comment