A error about using FDM Integration Import Scripts to Import Data from Microsoft SQL 2008
hi experts,
I want to import SQL Data to FDM. When I ran the integration script in FDM its showing :
-------------------------------------------------------------------
Error: An error occurred importing the file.
Detail: Data access error.
At line: 62
Stacktrace:
upsOBJDMw.clsImpProcessMgrClass.fLoadAndProcessFile(strFilename[String], strLoc[String], strCat[String], strPer[String], blnMerge[Boolean])
Hyperion.FDM.Pages.ImportPage.buttonImport_Click(sender[Object], e[EventArgs])
-------------------------------------------------------------------
The statement at which my script fails is:
DW.DataManipulation.fExecuteDML(strSQL)
Below is the Integration Script:
--------------------------------------------------------------------------------------------------
Function FDM3(strLoc, lngCatKey, dblPerKey, strWorkTableName)
Dim cnSS 'ADO connection object
Dim strSQL 'SQL string
Dim rs 'Source system recordset
Dim rsAppend 'FDM recordset