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 1 years, 2 months ago by stan.
• This reply was modified 1 years, 2 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 1 years, 2 months ago by stan.
• This reply was modified 1 years, 2 months 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 1 years, 2 months 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.

thx kaj, we are querying it in sql off a linked server.  i'm no expert but i believe we still have/want to go thru a driver (installed on our sql...

thx kaj, we are querying it in sql off a linked server.  i'm no expert but i believe we still have/want to go thru a driver (installed on our sql...

thx Ken.  Still trying to get our staff to tell me what the db2 erp they use is called.   ARGHH.  From what I've seen that might restrict our choices of...

i got our worst offenders down from 2hrs 48 minutes total to 31 minutes total by simply using frederico's code recommendations on a sister post in this forum.

in the image...

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