Home > database >  SSIS OLEDB goal setting dynamic table name
SSIS OLEDB goal setting dynamic table name

Time:01-14

Demand is 001. The CSV, 002. The CSV, 003. The CSV import SQL SERVER, and a series of files, the corresponding table 001002003,
Table in SQL SERVER 001002003 build good,

Using a FOREACH loop container, add a "data flow task", increase the flow of data source, even the good data table, and then add a data flow target, in the "data access mode choice" "the name of the table or view name variables", then "variable name" then I set a global variable, set up verification delay,
Execution process, appear the OLEDB target error:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB Error has occurred. Error Code: 0 x80040e37.
Opening a rowset for "001" failed. Check that the object exists in the database.
Error: 0 xc004706b, located in the data flow task, SSIS. Pipeline: "OLE DB target" failed the validation and returned the validation status "VS_ISBROKEN".
Error: 0 xc004700c, located in the data flow task, SSIS. Pipeline: One or more component failed validation.

001002003 list but actually exists, and, if I choose the fixed table 001, can be implemented by,
  • Related