Jacob Wilkins (2/24/2016)

---

TheSQLGuru (2/24/2016)

---

You are NOT the first to do something with SQL Server without really understanding what you are doing or why. As a SQL Server consultant I make...

TheSQLGuru (2/20/2016)

---

kevaburg (2/20/2016)

---

Hi Folks,

we are doing a database Migration that involves a conversion of non-Unicode data to Unicode. The process involves the conversion of every non-Unicode table in the...

I would be hesitant to say it that it is fixed. The error seemed to be quite obvious....

Apart from the fact you might not see the error at the...

I reckon Eddie is on the right track. We had a Situation whereby a LUN was accidentally removed as a Cluster resource and that threw a spanner in our...

Hi,

Oracle does tend to make things more complex than it really Needs to be..... 🙂

The solution I used is to use the TNS_ADMIN variable to store the location of TNSNAMES.ORA....

Many thanks for the reply and, yes, that was the Problem.

Thanks for a really quick Resolution!

Regards

Kev

Hi Gail and Phil,

now I feel like a numpty! Funny thing really......now it works! 😀

Thanks for your time and help.....

Regards,

Kev

UPDATE:

A more detailed error message reads:

Error: 0xC002F304 at Bulk Insert Task, Masseneinfügungstask: Fehler mit folgender Fehlermeldung: 'Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE...

UPDATE:

I have narrowed it down to the BULK INSERT Statement itself:

bulk insert [DWHStaging].[dbo].[v_Abverkaufsquote] from 'G:\DataStaging\DWHStaging\Source\Abverkaufsquote\RFA_Abverkaufsquote_2015-08-07_12.17.48.csv' with (firstrow = 2, datafiletype = 'widechar', fieldterminator = '0x3B', keepnulls, rowterminator = '0x0d0a');

I have...

Here the complete stored procedure:

USE [DWHStaging]

GO

/****** Object: StoredProcedure [dbo].[sp_IMPORT_Abverkaufsquote] Script Date: 07/08/2015 19:00:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[sp_IMPORT_Abverkaufsquote]

as

create table #filelist(pos int identity(1,1), name varchar(max))

insert...

Hi There,

sorry my mistake....

The ESXi Cluster is running datacenter Edition, the SQL Servers are Enterprise.

Regards,

Kev

MMartin1 (4/30/2015)

---

I wouldn't mind having some sample data to determine if the original primary key actually made sense. As Jeff mentioned a temporal based partition means having some sort...

Hi all!

Many, many thanks for the tips. I have decided to use a combination of the advice given here.

I will add an identity column in the table and assign...

Jeff Moden (3/16/2015)

---

kevaburg (3/16/2015)

---

roger.price-1150775 (3/16/2015)

---

Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.

Why are you renaming the files ?

If it's to ensure a file is only...

roger.price-1150775 (3/16/2015)

---

Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.

Why are you renaming the files ?

If it's to ensure a file is only processed once you...