Hello sgmunson,
thanks for getting back to me,

i am doing this to help eliminate duplicate rows when i join it back to another table, which the table is...

ahh that would help right saravanatn lol, sorry

the output i...

Sorry John, but big thanks for answering the question, it worked perfectly 🙂

big thanks Lowell, i will roll with that solution 🙂

Thank you ZZartin for the response, i tried to use *
however i get:
Error: 0xC002F304 at File System Task, File System Task: An error occurred with the following error...

sorry also, i am using SSIS 2015, and using foreach for all files (depending the quantity), and within foreach i am using file system task... any help please 🙂

that could be the problem, can you show me where to put them? i am new to powershell.

thanks 🙂

ok, so i sorta answered my question, I had our system teams make a CNAME, and i made an SQL alias on the configuration, anything locally on the server that...

cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

thanks again

YAY I got it to work 🙂

ok so it was 2 things, first the access denied, in this article:

https://knowledgebase.progress.com/articles/Article/000026672

the second issue i ran...

Small update, now when i run query:
select *
from OpenQuery([Progress],'Select * from customer')

i get this error message below:

OLE DB provider "MSDASQL" for linked server "Progress"...

Hey Jeff,

big thanks for replying, also good catches, yes i double check to make sure i had that part "4) Go to the Security tab, choose the radio...

UPDATE: I got it to work, when creating the ODBC... it helps if you hit ok or Apply to create the connection, Me = Idiot, anyways got it to work,...

ahh got ya, big thank you 🙂

Question 1, got ya they have to be the same name thanks 🙂

Question 2, gotya, so has to be different server, thank you again 🙂