Viewing 15 posts - 1 through 15 (of 252 total)
Thanks again, I'm going to start today 🙂
June 12, 2023 at 9:59 am
thanks a lot for the reply, I know its not ideal not having everything in source control, its is a task on the list I am told
another question
Does the "Pull...
June 12, 2023 at 9:06 am
The current process is, the devs dev 🙂 and then once finished they create a script and send it to the dbas who run that script in management studio
I dont...
June 12, 2023 at 8:28 am
I haven't tried SSDT, id like to though
its completely new to me so I'm not sure how it could help, could you give me a start please
June 12, 2023 at 8:06 am
Create/alter procedure should be the first statement in a query batch
thanks for the reply
June 12, 2023 at 6:54 am
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...
September 29, 2022 at 8:53 pm
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...
November 5, 2021 at 6:58 pm
Hi, I am saving the changes, it seems to be a common problem
Thanks again for your help
August 25, 2021 at 12:37 pm
The password disappears in the SSIS connection after i close the window
August 25, 2021 at 12:07 pm
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?
August 25, 2021 at 12:05 pm
Hang on
i thought it had worked, test connection complete
now a couple of minutes later it test connection failed for the same error
August 25, 2021 at 12:03 pm
Hi
Thanks again.
I have followed the instructions and still the same error.
August 25, 2021 at 11:42 am
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....
August 25, 2021 at 11:18 am
Viewing 15 posts - 1 through 15 (of 252 total)