In December I has type c influence that evolved into type A (the bad kind) that resulted in a collapsed lung on Christmas day.

yesterday I got a text message from...

Thanks for the response

Another concern is the alert that we get if CPU usage is very high or Disk is busy more than 50% ...

As a DBA , I...

Now you are making less sense. How is SSIS involved?

are you saying that you are using a view within an SSIS package to get data into a table in SQL?...

Here's an XML approach.

declare @t table 
(
RowID int identity,
line varchar(80)
)

insert into @t (line)
select 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' union
select 'BSNC002647745191912080000001 PTE5P02 146650455 RTY 094D Q'

;
with...

ok, now I think I understand  - why not just use the convert(nvarchar(50) , myfield) in the view - but it won't help you if the oracle server is varchar

ok, lets be clear that we are on the same page

var and nvar are on the table. not the view. I think you are looking in the wrong place

dropping a...

Go to Norway and get a reindeer steak... amazing

except that I got a lecture from my mother saying that I had killed Rudolph and spoiled Christmas for all the kids

just keep going - when you are done, maybe write it up and post it to steve… I like a good refresher course on things I haven't done for a...

Hi jeffrey

All good points, a lot of these jobs are multi step - I think i'll test the option to quit with sucess

still - 400 jobs 🙁

do your view definitions (ie create view/table) get controlled by the oracle server (i'm guessing heterogeneus data services) ?

there's a possibility (if this is the case) that oracle is not...

It is a big amount of work,  but we also came from an Access system and eveolved - as for the backups, well yes your database will get bigger, but...

amen to customers screwing up CSV files, adding columns etc.  🙂

and I get the  difference in import format files (csv, XML etc) and that you have to create new packages...

I'm not going near anything that uses the words "sour milk", "seal flippers", "sheeps head" or "testicles"

I'd rather swap all of my tables to heaps, remove keys and forget to...

filestream is for storage of files within a filegroup on the database, maybe it would remove your need to get the filenames. the files are contained in the database.

we use...

don't - I went once and it was "an experience" (this is from Wikipedia)

Kæstur hákarl, fermented Greenland shark.

Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and cured in...

• This reply was modified 5 years, 7 months ago by MVDBA (Mike Vessey).