Viewing 15 posts - 2,221 through 2,235 (of 2,701 total)
Cool. The only thing is that I try to avoid trips through...
November 10, 2018 at 10:36 am
one other option (and there are more)
declare @tbl table
( juldate decimal(18, 0)
, timei float
)
insert into @tbl select 118063, 11456
insert...
November 10, 2018 at 9:31 am
November 10, 2018 at 8:09 am
Error looks quite clear.
----------
Could not use view or function 'InvoiceTotals' because of binding errors.
----------
one of your view is invalid because the underlying objects changed ...
November 7, 2018 at 8:47 pm
not quite
is_linked = 0 - reports the instance settings
is_linked = 1 - reports the specific linked server settings
Having the instance rpc_out enabled does not enable it...
November 7, 2018 at 4:47 am
select name, is_rpc_out_enabled
from sys.servers
where is_linked = 1
if is_linked = 0 that is the instance itself
November 7, 2018 at 4:28 am
not with standard SSIS methods
Depending on the file you can however use a C# script to parse the file and create the table yourself.
With bulk insert (T-SQL)...
November 6, 2018 at 5:39 pm
I've seen this happen before - on 2008 R2.
It was possible to generate the table and the index, but the filter definition would not be generated depending on the...
November 6, 2018 at 2:43 pm
Was correct in assuming that what you asking for was not really the real requirement.
Changing the delimiter alone is not the solution if you have to parse the...
November 6, 2018 at 1:24 pm
yes assuming that the file is a correctly formed delimited file
read file using old delimiter - split columns - write to new file using new delimiter.
dead...
November 6, 2018 at 12:29 pm
there are a few options - https://www.techradar.com/news/best-virtual-machine-software - some of these would be mainly for presenters out of premises as it allows all in a single computer.
Not mentioned...
November 5, 2018 at 3:45 pm
Cant try it at the moment but in any case a word of advise.
ACE driver with its SP1 is the most complete at the moment if not using...
November 4, 2018 at 4:26 pm
I would try out the following
on dataflow properties
November 2, 2018 at 3:19 am
create another master SP
parameter sp_level int
this requires that SP2 and SP3 do not call the previous sp, but rather depend on it having been executed previously and...
October 31, 2018 at 5:50 pm
Viewing 15 posts - 2,221 through 2,235 (of 2,701 total)