What kind of flat file? Delimited, fixed width?

Maybe one of the flat files has data that is too wide for the column AffiliatedID?

It depends on how you want to use it I guess. It's about having a choice.

Each type of adaptor has its own strenghts and weaknesses. I've done tests where OLE...

I didn't...

Perry Whittle (1/22/2014)

---

The only issue ever caught me was the .net framework install on a machine with no internet access (typical when deploying on a VM), you have to install...

kbhanu15 (1/22/2014)

---

HI All,

TO avoid this issue any database setting to be change ?

i mean ( if we run the query 1st or 2nd time or 3rd time it should show...

This is an interesting article:

Does the SQL Agent Service Account Must be a SysAdmin?[/url]

It mentions the service account doesn't even need a SQL Server login.

I'm curious though under which account...

Another option is to have a first parameter which is just a text field.

Here you can enter your filter and the second parameter will be filtered using the text you...

This works fine:

DECLARE @test1 VARCHAR(10) = '€ 100.00';

DECLARE @test2 NUMERIC(10,2);

SET @test1 = RTRIM(LTRIM(REPLACE(@test1,'€','')));

SET @test2 = CONVERT(NUMERIC(10,2),@test1);

SELECT @test2;

If it doesn't work, check the regional settings.

TDP (1/22/2014)

---

Cool, thanks for the article.

If this were true, then the job would not fail giving the error 🙂

The server principal "Domain\SQLServerAgent" is not able to access the database "Database1"...

TDP (1/22/2014)

---

Nope, service account has no permissions at all.

The job is executing a stored proc that is not in msdb anyway, thus would need more than permissions to msdb...

The service account will probably have permissions in MSDB, and maybe that is all it needs to run the job.

SQL Server has caching, but it is really strange that it goes from 2 minutes to subsecond performance.

You can expect some performance improvement, but that is fenomenal. Care to share...

TDP (1/22/2014)

---

Hi all

I am running SQL Server 2012 ENT SP1.

The SQL Server Agent Service is running under account Domain\SQLServerAgent. Our SQL service accounts have no rights in SQL, not event...

The only issue I ever encountered while installing SQL 2012 was that I forgot to enable the .NET framework.

Error while enabling Windows Feature: Netfx3[/url]

I encountered issues though when upgrading to...

Nice question, thanks.