http://msdn.microsoft.com/en-us/library/ee730351.aspx

looks like the results from a csv/txt file?

Tried using SSIS and selecting "First column is headers", delimit it properly to assign columns?

Are you trying to produce a measure of adding 2 periods? eg. 11 + 12,

or 201301+201302?

I'd consider kicking of an executable batch job from ssis.

ref: http://ask.metafilter.com/50369/How-to-move-files-into-subdirectories-in-batch-job

Any information in error log on the failure?

%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

select criteria from yourtable where datecolumn < dateadd(dd, 30, '20110420')

Example:

select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,

{ ManualProcessing].[All ManualProcessings].[MANUAL]} ON ROWS

FROM [Transactions]

where

(

except([Product].[All Products].Children,{[Product].[All Products].[Debit}),

...

yes, but define "Database Testing" what testing will be done/required? or are you 4-5 developers? Or SQL DBA's?

Define DB Testing Team?

First, more info on your error: http://msdn.microsoft.com/en-us/library/aa337272(v=sql.90).aspx

Possible Fix: http://support.microsoft.com/kb/934396

SQL Backup Simulator for testing http://archive.msdn.microsoft.com/sqlbackupsim

If all the resources required for the SQL Services are in a group and dependencies have been configured correctly, the yes, move the group and all relevant resources will failover.

"Invalid connection string attribute."

Koen Verbeeck (7/12/2012)

---

Maybe a little bit too easy 😀

But apparently some people still get it wrong.

Or maybe they just sneezed while picking the answer and thus accidentily clicking the wrong...

Error message?

something like...."SQL Server blocked access to procedure 'sys.xp_cmdshell'" ?

Hi Gopi

This is a SQL Server Forum, and I doubt anyone here would be able to help you.

Best if you seek a COGNOS specific forum and raise your question...