thx jeff, their product gets installed on our sql server.   various related objects are then defined on our sql server under that product.  thru these objects, yes , we send...

i posted a how to question for this at https://www.sqlservercentral.com/forums/topic/dont-see-a-file-system-task-approach-to-copying-excel .    i was hoping to avoid copying content by using the file system task.

i'll post my conclusions and questions for the community in another post.

thx Phil that's a great idea.    i'll circle back here once i've stood up a poc.

the simple answer is yes.   and we even found one record with costs in it that is completely blocked from both inside netsuite (suite ql) and externally (odbc driver).   oracle...

thx frederico.   I'll focus on utf's.  and define my connectors as utf's.   and tell her all files must be utf.   i think all but one of her files is currently...

it seems to me utf is strategic if (like us) you expect some extended character set data from europe etc.

if thats a decent idea, does anybody know what the general...

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