Hi All,
I recently asked a question about storing data and a database was the preferred option which I understand.
The company I work for use a variety of tools but the one I have to work with is Teradata.
My question is how do I load said csv or pipe delimited text files, daily circa 10k records, into different Teradata tables. I’ve tried various options but it returns a login error and eventually locks the Teradata user account.
I’d have thought it be simpler but I’m likely missing something… the ODBC seems to need to specify the database and table from what I can see which won’t work as each file has its own destination table.
If I can get it to work and apply logic based on the file then it can definitely be a macro.
Obviously, the import works fine in Teradata…
Achieved this with SSIS many times so I am a little perplexed and would appreciate any thoughts.
Thx
