Are there any other messages in the errorlog at around the same time?

John

Please can we see the definition of the stored procedure?

Thanks

John

Your ACCRUALPROFILE INSERTs violate the primary key constraints on that table.

John

OK, then something strange is going on since that is what error 3041 appears to mean. Are you sure you haven't inadvertently included a log backup as part of...

http://support.microsoft.com/kb/928317

You must be using a different search engine. Try this:

http://www.lmgtfy.com/?q=Error%3A+3041%2C+Severity%3A+16%2C+State%3A+1

John

Possible because the SQL Server Agent service account doesn't have access to the location of the csv file.

John

Yes. Search the internet for that first message. You'll get plenty of hits telling you exactly what the problem is.

John

Ayie

Please search this site for "splitter function". Jeff Moden has written a number of articles that comprehensively cover what you're trying to do.

John

In that case, it's the permissions of the SQL Server Agent service account that are important, not the account you are logged on as. Is the CSV file on...

SinisterPenguin (7/25/2011)

---

Personally I wouldn't use an expression just run your T-SQL in a Execute SQL task - e.g.

SELECT CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))-1),DATEADD(MM,-1,GETDATE())),120) as Column1,CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(GETDATE())),GETDATE()),120) as column2,

CONVERT(VARCHAR(10),DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))-1),DATEADD(MM,-12,GETDATE())),120) as column3

Then set the Execute SQL task...

I think the question is this: are you running the package from Visual Studio logged in as yourself, or are you running it via a SQL Server Agent job?

John

The NOLOCK hint can cause dirty reads, so only use it if you don't require the data returned to be totally accurate. Instead, concentrate on optimising your queries. ...

It's not really clear what your question is, but I think you need to use the REPLACE function.

John

Jeff Moden (7/18/2011)

---

It's just me, I know, but I name my tables after what a single row of any given table contains. Part of the reason is for tables...