Not exactly.

Im talking more about having the master server be where you schedule and manage all the jobs. Any data flows would pass though the ssis server's memory before...

Well, it is tough to get too specific without knowing what your source/destination servers are or the particulars of your package.

But you can define an expression on a connection manager,...

What version of ssis?

I guess my question is: how is the name of the connection getting changed? By a user editing the package? By a script in the package? Other...

You still haven't told us WHY, which would help with the what.

Here is the basic problem. By trying to set you variable to a connection name via expression, you...

I might be missing something, but is there a reason you can't deploy to ONE server (an SSIS server), and dynamically change the sources/targets, instead of deploying the same package...

Well played, sir.

ShinyBaldHead (1/31/2014)

---

Is it possible to set a SSIS string to only the name of a database connection manager or even the connection string it uses ? I don't see an...

SSIS could use a bunch of features both for performance and for organization / etc of packages.

- Some sort of batch ole db command transform so you could, say, take...

And if you're not, you can just group by customer_id in a CTE...

Do you want one record per customer or one per order?

Using the analytic functions:

DECLARE

@statusTABLE

(

AccountINT,

AStatusVARCHAR(20),

SDateDATETIME

)

INSERT INTO @status VALUES

(322702,'Active','2012-07-31 09:36:21.697'),

(322702,'Active','2012-08-24 04:57:42.890'),

(322702,'Active','2012-08-24 10:11:34.730'),

(322702,'Hold','2012-08-24 10:11:53.013'),

(322702,'Hold','2012-09-24 05:29:17.357'),

(322702,'Active','2012-09-24 07:06:49.580'),

(322702,'Active','2012-09-24 07:07:06.660'),

(322702,'Drop','2014-07-31 09:36:21.697')

;WITH Islands( Account, AStatus, SDate, pStatus ) AS

(

SELECT Account, AStatus, SDate, LAG(AStatus,1,0) OVER (ORDER BY SDATE)...

Do you get any errors in the data flow? Or just 700 records as if everything was ok?

Does the view show all the rows when you just query it...

Of course the DBA isn't dead. And the cited blogger was making his point with purely anecdotal evidence.

However, his point seemed mainly that a lot of places don't bother...

Or, if it is 2012, you can deploy to the catalog and have the connections set up there. It will change the protection level when you deploy.