"Export-DataTableToSQLiteDB : DataTable already belongs to another DataSet."

Question

I'm using PWPS_PWDM (which works pretty well) to gather info from Deliverables Management. With some assistance getting set up, I have been able to get a Submittals information dataset sorted into datatables, and from there into Excel. I'd like to just write the tables straight into a SQLite database, using the Export-DataTableToSQLiteDB cmdlet, but when I try to run the command I get an error message: "Export-DataTableToSQLiteDB : DataTable already belongs to another DataSet." 
 I think I'm missing something obvious here. Can anyone tell me what's going on?

Zachary Kerr · Accepted Answer

Hey Matt, glad you got it working. A simple solution is to just copy the whole data table. Something like this: foreach ($table in $Dataset.Tables)
{
 $table_copy = $table.Copy()
 Do-Whatever -InputTable $table_copy
} That will save you having to rebuild the tables and populate row by row. Hope this helps.

"Export-DataTableToSQLiteDB : DataTable already belongs to another DataSet."

Top Replies