User receives the following error message when trying to import the data:-
Orchestrate data flow import has failed. The detailed information is as follows:
Invalid object name NAME OF FILE.CSV
Import Command:-
SELECT DISTINCT STITEM05 As ItemCode
,STITEM05 As ItemDescription
,1 AS MfgBatchSize
,Blend as ProcessCode
,Kg As UnitCode
,LEFT(STITEM05,1) As ItemTypeCode
FROM [NAME OF FILE.CSV]
The data source is set to Current Database instead of the CSV ODBC connection, for the relevant data source. Please complete steps 1 to 7 within the second section of the solution, in the following article, to change the data source to the relevant ODBC connection.