Thanks ill take a look

create table #Table1
(
_Field varchar(4)
, _Dependency varchar(4)
) 
go
insert into #Table1
select '0010', '0020'
union select '0010', '0030'
union select '0010', '0060'
union select '0010', '0070'
union select '0010', '0080'
union select '0010', '0090'
union select...

Hi

Thanks for the replies

I can run the package from a catalog on the server so I think the path is correct I the package for the server.

There does sound like...

Excellent Thanks

Hi, I am saving the changes, it seems to be a common problem

Thanks again for your help

The password disappears in the SSIS connection after i close the window

• This reply was modified 3 years, 2 months ago by  erics44.

It is saying the password did not match that for the login provided

it does

any idea why it would work for a short time?

Hang on

i thought it had worked, test connection complete

now a couple of minutes later it test connection failed for the same error

• This reply was modified 3 years, 2 months ago by  erics44.

Hi

Thanks again.

I have followed the instructions and still the same error.

Thanks a lot for the replies

details from the log

08/25/2021 11:05:39,Logon,Unknown,Login failed for user 'xxx'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only....

apologies I completely misunderstood linux

feel free to delete this thread

🙂 i thought it would be the same set up for linux systems and data files are kept in the same place in the same folder structure

Hi

Thanks for the reply

Linux data doesn't come with a database, I am told that the data is kept in files somewhere.

There is a data file and a index file for...

what if the ID field wasn't unique? would that make a difference?

thanks very much for the reply

I have looked at lots of information and been on a short course

if anyone has any teradata experience itd be really nice to ask some...