I would want the most accurate really. My problem is that datediff returns an integer and if I've got a datediff divided by a datediff with the numerator part of...

Quick question...if I have three separate insert statements within the same stored procedure does the @@rowcount get re-set after each insert? If so, could I set three output parameters and...

That's worked like a dream thanks!!! Brilliant!!!

That's where I put the content in before, however I hadn't put in HTML tags. Should I put a "BR" tag in wherever I want a carriage return then?

Where should I be looking for this field please? Is this in BIDS view of the report?

Just also found out that if I run the process from the scheduled task and change the executable name to include the unc path i.e. \\server name\c$\ instead of c:\...

Curiously by the way, I've got it to work another way but it's more a cheat than anything. The executable is currently set to run from a windows scheduled task....

Sorry, it's an executable program written in vb.net with a command line parameter. I set using a configuration file the location of the exe, the command line parameter and the...

Ok, many thanks. Will try that out.

That's great thanks. Much obliged. I should have known that one really! lol

Worked out what this was in the end. I had set up the Ado.net connection in the connection manager area and it kept on losing the password for the odbc...

Can someone answer this for me please?

Anyone able to assist here please?

Yes, the same authorisation error I have in BIDS.

It's the ADO.NET connection I've used here. It's New ADO.NET connection > .Net Providers\Odbc Data Provider connection.

I'm still trying the execute package solution rather than moved on to running it in dtexec. It fails in BIDS, but I have a sql agent job that runs the...