Environment variables are actually stored in the registry. So, exporting them using something like "regedt32" will give you a ".reg" file that you can save into source control.

The export...

SQL 2008 R2 Express can only be a subscriber (have a look at http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX)

So, you will need something like Standard Edition to be able to replication to SQL 2008 R2...

I got to finish my lunch

Express12 (3/17/2014)

---

I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an...

Check what version of SSIS was used by your colleague to create the SSIS package. I suspect that a different version was used.

doug.brown (3/13/2014)

---

Would something like this work?

=IIF(Fields!Employee.Value Is Nothing, "0", SUM(IIF(Fields!Employee.Value = "FullTime",1,0),"Production") ) --- This will give the sum of Fulltime employees

=IIF(Fields!Employee.Value Is Nothing, "0", SUM(IIF(Fields!Employee.Value = "Partime",1,0),"Production") )---- This...

Go with Phil's suggestion if you can.

Assuming that you are using separate SQL Server instances, another option is to use "User" environment variables instead of "System" environment variables. Use...

aaa121 (2/18/2014)

---

Hello all,

Could you suggest the best way to structure the following, which I am sure is a common situation.

Ok so I have a monetary value (fact) posted on a...

Looks like you haven't installed the SAPBI connector on the server that you are using to run the package from

shohelr2003 (2/23/2014)

---

I use SQL Server 2008 R2 (x32) and Office 2007. I installed AccessDatabaseEngine(x32). Then I execute the following statement.

select * from openrowset(

'Microsoft.ACE.OLEDB.12.0',

'Excel 12.0 Xml;Database=D:\Book1.xlsx;HDR=YES',

'Select * from [Sheet1$]'

)

And received the...

Yes but

create database [DELETE]

does work

I am just waiting for someone...

These tasks are not relevant to analysis services databases. The...

I looked outside - no clouds. In fact it is 40 degrees C outside (104 Fahrenheit) at the moment. I really would have likely for it to be...

I suspect that because of the differences between charts in RS 2005 Vs RS 2012, there is no way for the RS 2005 chart to be automatically upgraded in RS...

Rather than dropping/renaming tables, how about using the ALTER TABLE...SWITCH command. It will not leave you with any period when the table doesn't exist (SQL manages that for you)...