You could do something like:

DECLARE @operation as Varchar(10);

DECLARE @Count as int;

SET @operation = 'Inserted';

SELECT @Count = COUNT(*) FROM...

Doh!!! Thank you -- I...

I tried with single, double and no quotes around the stat name with same result.

The idea about a typo is a good one; so I dragged and dropped...

You cannot attach to a SQL Server 2012 database from an earlier version of SQL Server. Download the Adventure Works for your particular version of SQL Server from CodePlex.

HTH,

Rob

I'd guess a permissions issue. What account is the SQL Agent job running under? Does that user have permissions to see the folder where the flat file is?

HTH,

Rob

Look at adding three parameters to your report (@Statedate, @enddate and @value). It's pretty straight-forward in Report Builder or Visual Studio. Just right-click on paramters and add a...

Setting ConsumeContainerWhitespace to True (from default False) doesn't change the report width.

The '+' operator does string concatenation in T-SQL. Assuming CSN and Name are both string columns in your table. You can:

SELECT CSN + ' ' + [Name] AS...

Try doing a derived column transformation to parse out your original varchar(10) string to your mm-dd-yyyy string that you want, then use a data conversion transform to change the mm-dd-yyyy...

Do you use fuzzy grouping or fuzzy lookup transformations? If not, you're probably okay.

HTH,

Rob

What are these things that are opened or closed? Sales orders? Estimates? Claims? (I guess it really doesn't matter, but it helps me wrap my head around the...

Why wouldn't you have a DimSystem that describes the systems as well as a FactSystem that has your measures (Count, # of users, uptime, ...)?

Rob

My first guess would be a permisisons issue. Does the account the SQL Agent job is running under have needed permissions to access that batch file?

Just a thought,

Rob

While I know it's theoretically possible to build your SSAS db from a normalized relational db, I've never done it (nor seen it). I've always used a star schema...

I'd say your dimension goes in your data warehouse/data mart. I'm not sure from your description if that is #2 or #3.

--

#1) I'm assuming that your transactional system (AX)...