Hello everybody
I have one sqlserver table with an attribute type date
i'm using a odbc stage to "insert rows without clearing"
i'm suging a odbc stage to select a row
i'm using a transformer just to match directly
i'm getting errors:
(1)
[...]: DSD.BCIOpenW results of function SQLColAttributes(data) gave MetaData mismatch
COLUMN.TYPE Expected = Date Actual =
and i have to define attribute data as varchar(10) so i don't get this error
(2)
[...]: ..load.load_gg_dados_comboio_dia: DSD.BCIPut call to function SQLExecute failed.
SQL statement:INSERT INTO gg_dados_comboio_dia(data) VALUES (?)
SQLSTATE=22008, DBMS.CODE=241
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]filed to convert data and/or hour [...]
data = 2020-01-01
Can someone help me, please ?
using odbc stage to input date data into sqlserver
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Tue May 31, 2005 5:01 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: