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 🙂

Thanks SSCommitted, one last thing to ask... has anyone ever installed multiple instances on 1 cluster, example:

All one Server

Server1
InstanceA
InstanceB
InstanceB

And I am...

Ok so to make things easier, and we tested, and worked beautifully, we went with mirroring, with this solution which is similar to log shipping, so big thanks SSChampion for...

Gotya thanks, I will try that out, thanks again 🙂