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...

I think the important thing isn't what naming convention you use, but that you choose one and stick to it. There's been a lot of discussion here and elsewhere...

DBCC CHECKDB and REBUILD INDEX. For the latter, you may prefer to use scripts instead of a maintenance...

How often does the job run? What happens if you create a job to execute a trivial T-SQL statement and run that - can you see the history for...

How do you run your maintenance plan? You will only see anything in the job history if you run the job that was created with the maintenance plan, not...

Athar

You can use an expression to set the connection string for the file connection manager.

John

No. Both outputs look exactly the same to me. Most people don't have the time or patience...