i will try to find out.   i dont think any kind of "hog" is running there but i'll show our dba what you suggested.  I think that server is basically...

possible correction, testing now, the target fields didnt exactly match up , maybe the import expects them to match in spite of the column headings.   i'll post back here.

Indeed,  for...

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

thx brian, its not the only db on that server.  and that 322.8 meg you referenced is just a baseline/poc for a million tsv records.  the forecasted total would actually...

i'll check that Ken, thx.   Never thought of that.   we might download the keepers to tsv then also.   and ingest them straight from tsv's.   our dba didnt catch that potential...

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

very informative, thx Ken.

thx brian, we would do this on a sunday when users wouldn't be impacted and our level of potential embarrassment would be minimal.

we might be a bit more frugal about...

thx ed b but i'd like to leverage the fact that there are distinguishable data types in this file.   some are int etc.   not sure if doing that would generate...

thx Ken what do you mean by call another phone?  Not the one where the sequence you showed was followed?   Crazy!

thx ratbak.   an sms wouldnt wake me.   sorry if this is a duplicate but i could swear i posted this response already.   but didnt see it when i returned.

well...it wasnt MS, but rather a consulting firm that is notified when you chat on their website where adf is advertised.  Its actually 2 consulting firms and you pick one.

the...

im sitting with ms tomorrow to estimate what our cost would be in just ms charges if we were to migrate our ssis to adf presumably using smaller data objects...

thx jkunkel.   so $200 per month is about what you would expect.  i think you are saying for a low cu which would include the ability to do datasets and...

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

thx jkunkel.   to be clear, i believe adf is a subset of fabric and that is probably what you intended to convey.

either way let me ask a question that nobody...

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

thx jkunkel, do you mean adf?   the concern there is that its a big data tool.   if you want ssis you call it from there but why bother.  and im...

Thx Jeff.  You must be supporting a lot of code. I’m picturing bulk insert from a traffic cop sp on our server where I believe enough drivers and linked servers...

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