I tried again with new project and new package. All 4 Execute SQL package works outside Sequence container but, inside the 1st Exec SQL package fails.....

Does anyone else know?...

I have tried starting OFF & ON few times the service - Distributed Transaction Coordinator. Are you asking this?

I performed this task differently. This was my first package for learning. Thank you all !

I have created variable called SCHOOL_NO and assigned...

I had to assign alias to each columns within one of the subquery and not outside the subquery. But,thank you for giving me the right direction.

Got an error ''DATEFROMPARTS' is not a recognized built-in function name.'

Yes I am summing up reading for monthly. I want data to be displayed monthly like for October 2012...

I want to aggregate to monthly values for the reading. Currently it is displaying. I want to display Reading value for Oct 2010, November 2010 likewise My...

Thank you everyone it worked.

ok I found the issue and fixed it. I didn't download the sqlexpress at all before now donwloaded and connected successfully to the database engine. Thank you all...

I can't see any SQL Server services. How to/from where can I install the instance?

I have installed SSMS 2012 on win 7. Inside both, SQL server services and SQL server Network config it says - "They are no items to show in this...

I have already installed SQL Server 2012 with shared features like Management tools - Basic, SQL Client Connectivity - SDK and Local DB.

I need step by step guidance how to...

I opened SQL Server Configuration Manager but, I can't see any server name at all. Please check the screenshots attached.

Please need help here as I can't start practice on the sql server until I fix this error. Please help.......

Can anyone advise for MCSA 70-461 from where can I download the sample database TSQL2012?