From my license agreement.

Subscriber agrees that it shall not reverse engineer, disassemble, decompile or otherwise attempt to derive the source code of the software provided hereunder.

I think I would rather...

The vendor proc is encrypted. I know there are ways around that but I am somewhat reluctant.

The proc also accepts a date range ( I was simplifying in my example)...

I'm happy with my EAV setup.

My analysts create analytics and since there are a myriad way to analyze something its not hard to come up with new analytics. It happens...

>>Who is your users?

Business users making a decision on if they want to set MyFlag = 1

>>Can they write SQL?

Not at all. They need a user interface that will allow...

Thank you. My database structure has been fixed and the additional code you provided is working. The non-normalized structure I need to output to is necessary to satisfy the requirement...

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/67871/

My schema design is not vendor-provided, legacy, already-in-production, it simply is ...bad design.

Joe: thank you for pointing this out. I am now fixing the design.

Read this http://msdn.microsoft.com/en-us/library/ms162810.aspx

Can you use xp_cmdshell?

Where is you package saved as a file or on the server?

What is your variable in the package called?

Whats the datatype of the EntityID...

Here you pass a parameter to a stored procedure. The procedure then executes the package using the current value.

The variable in the package is called ID.

CREATE PROCEDURE [dbo].[uspExport]

ID decimal (10,0)

AS

DECLARE...

The third step is not applicable to using DTEXEC. The links were not intended to be a step- by step solution, just some building blocks you can use as you...

Some examples below.

First create the variable in your package and have your select statement reference the variable. then look at using DTEXEC to set the variable at runtime.

http://weblogs.asp.net/rrobbins/archive/2009/01/15/ssis-package-user-variables.aspx

http://consultingblogs.emc.com/jamiethomson/archive/2004/12/13/SSIS_3A00_-Passing-parameters-on-the-command-line-to-an-SSIS-package.aspx

http://www.sqldev.org/sql-server-integration-services/how-to-pass-variablesparameters-in-xpcmdshell-dtexec-to-an-ssis-2996.shtml

How are you calling the package?

You could call it with DTEXEC and use the SET option to dynamically set a variable within your package.

Thank you for your response. I removed Autheticated Users group from the permission list for Folder2 and now when logging in as TestUser I don't even see Folder2.

I hadd previously...

Actually non-linear regression. You have a curve of some type. You need a function to plot you curve based on your two points. You then need to find the intersection...

I believe what you are looking for is called linear regressions.

You have a X and Y axis and a line insects at 15:5 and 35:20 so then the question...