Welcome to the Dot Net Tech Community

Experience The Freedom To Share...

Monday, July 12, 2010

SSIs RecordSet Destination to DataTable in Script Task

Hi All,

Let us how to convert from RecordSet to DataTable

Variables _var;_var = Dts.Variables;
System.Data.Oledb.OledbDataAdapter da = new System.Data.Oledb.OledbDataAdapter();

DataTable dt;da.Fill(dt, _var["rsName"].value);

No comments:

Post a Comment