sorry for the delay.    Frederico are you saying that if i found myself changing the conn mgrs from code pg 65001 (utf-8) to 1252 Ansi Latin, that i was...

• This reply was modified 2 months ago by  stan.

db2ls in the command prompt doesnt give me anything.  i get an error saying its not recognized as an internal or external command, operable program or batch file.  i ran...

• This reply was modified 3 months ago by  stan.
• This reply was modified 3 months ago by  stan.
• This reply was modified 3 months ago by  stan.

thx Phil, I like that solution.   And will use it and mark your post as an answer here in a second.

an ugly solution i got to work while experimenting went...

i can confirm today that CData's odbc driver does indeed show previously hidden netsuite fields once they start getting used (ie arent all null).

There is what sounds like a choice...

• This reply was modified 3 months ago by  stan.

i think somewhat consistent comments are starting to come in from CData (the competitor) and Oracle Netsuite.

CData clarified that their odbc driver taps into netsuite's suite ql API.   and there...

yes.

the 1st thing i tried was to add a dataset (last dataset) for sample size, plumb it to a param and then pass the param to the core dataset for...

thx pietlinden and sorry for the delay as i was travelling and temporarily distracted.

i am convinced of what the problem was and think maybe i now understand what MS's bizarre...

• This reply was modified 3 months, 1 week ago by  stan.
• This reply was modified 3 months ago by  stan.

here is one of the posts i see on this subject.   its hard for me to make the leap between a division and sql being unable to read a (next)...

• This reply was modified 3 months, 2 weeks ago by  stan.
• This reply was modified 3 months, 1 week ago by  stan.

thx jason and jeff.  I should have mentioned also that someone in this forum suggested power point waking up a pbi dashboard every so often.

i'm reluctant on pbi and ssrs...

• This reply was modified 3 months, 2 weeks ago by  stan.

i consumed the tsv files in ssis ok.  of course i had to change the delimiter to tab (columns in the connector edit->and you see that delim). and i did...

ok, tsv is a known file extension.   who knew.  i think now if i can consume a tsv in ssis (like frederico said) with no problems i'll ask her to...

thx frederico, thats good to know and i think a the answer.   i think to avoid problems when someone tries to open a .csv that really isnt a csv by...

thank you.   it looks like ibm i is listed on that one link's product supported list i showed.   i'm not sure but i dont think that is free.

since it looks...

the site our network guy was referring to is https://www.ibm.com/support/pages/db2-odbc-cli-driver-download-and-installation-information#%5B%3Ch2%3E%5DLicense%5B%3C%2Fh2%3E%5D , which he got initially from me.