Nothing immediately comes to mind. It would be interesting to know the root cause. How much time do you have to fiddle with this to find the root cause? Time...

WebTechie38 (7/21/2011)

---

Well, I got that part to work.

I had to put quotes at the beginning and the end of the expression.

After that, it evaluated properly.

Now the last part:

1. Load the...

If you are saying that you want the file...

WebTechie38 (7/21/2011)

---

Thanks for the help!

Here is the expression that I am using:

Data Source=@[User::CurrServer]; User ID=RptUser;Initial Catalog=MY_CUSTOM;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Package-{44F8A456-FBBD-4165-8B66-A1E1A1D38E75}MYSERVER.MYDOMAIN.NET.MYDATABASE;

Here is the expression error message:

TITLE: Expression Builder

------------------------------

Expression cannot be evaluated.

For...

Please read this article:

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

😛

Yeah, if you can start storing 1 instead of NULL, so that when you want to use the column you don't have to convert NULL to 1 on the fly,...

Excellent! HTH

PS Read that article about variable names 😉

Ninja's_RGR'us (7/21/2011)

---

TheSQLGuru (7/21/2011)

---

You simply must make improvements to your schema/data to allow you to remove the ISNULL(A, B) = something. Not only is it a CPU burn, it also...

I won't say much more about the actual script itself. I think you are close, and I gave you a solution in C# that all you have to do is...

It sounds like you're close. Please post the expression you're trying to use as well as the exact error message you get when it fails to evaluate.

If you don't mind...

That's a good lead. I am curious about...

I would:

1. Create an Active Directory group that corresponded to each database instance, e.g. PayrollSqlSysAdmins.

2. Add the relevant AD User Accounts into the AD Groups.

3. Add each AD Group to...

Thanks for the reply Steve.

Correct.

Therefore, they want...

I'll assume you were talking to me with the SSCrazy response since I am the only one on this thread with that designation. My nick is opc.three BTW, SSCrazy is...

Stamey, to be sure you're going to have to write all the code by hand. Define the list of objects you need to inspect (what I started to do), figure...