Viewing 15 posts - 2,356 through 2,370 (of 6,676 total)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2019 at 10:32 am
If the file is missing - that generally means Integration Services was not installed on the server. It must be installed for the catalog to be created and utilized.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2019 at 10:23 am
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 3, 2019 at 1:26 pm
1. No - there is nothing you can do to prevent the client machine from being restarted
2. No - you cannot assume that the process completed successfully based on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 3, 2019 at 12:37 pm
I'm a bit thrown off because I am...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 3, 2019 at 12:20 pm
I am not following the reasoning for the issue - if you add the new column with a default value the previous rows will be NULL and only new rows...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2019 at 3:45 pm
Sorry - not clear...are you trying to pull data from a single source flat file and split it into two destination files? Or do you have 2 source files that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2019 at 2:33 pm
You need SQL Server Integration Services - which does not appear to be installed.
Interesting that everything else seems to be installed though - and you probably don't...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2019 at 1:58 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2018 at 12:36 pm
Jeffrey Williams ― Charles R. Swindoll How to post questions to get better answers faster
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
Managing Transaction Logs
December 29, 2018 at 10:02 am
I would consider limiting access to the 'global' database through stored procedures or functions that can be signed with a certificate. Using a certificate - you don't have to add...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2018 at 12:38 pm
I utilize the Managed .NET Provider for Intersystems Cache in my SSIS projects that extract from that platform. It works quite well and allows for managing the OLEDB Destination batch/commit...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 27, 2018 at 4:07 pm
Declare @custid int = Null --1805;
Declare @ord tinyint = 1;
With customers
As (
Select ref.R_Index
, LastName...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 22, 2018 at 8:11 am
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 22, 2018 at 7:52 am
Why would you want to return a different set of data? This type of output could not bind to external applications like SSRS/SSIS because the system would not be able...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 21, 2018 at 11:53 am
Viewing 15 posts - 2,356 through 2,370 (of 6,676 total)