custom .NET code is code stored within either a SSIS "Script Task" or a "Script Component"

The custom script code (VB or C#) is embedded in th dtsx file.

The reason for the integration of SSIS and a configurement management tool is two fold:

1) TL9000 compliance

2)...

I've got a SSIS package that contains several C# custom components (tasks & data-flow) and I'm after a tool that is capable of showing differences in embedded C# custom code

At...

Thanks - I've just finsihed a simple transfer script.

The MySQL is part of a realtime data monitoring system so the load that we place on it for exctraction to a data warehouse cannot be great.

However, part of the...

Thank you Elliot.

The other things that I have to consider are:

1) The load that I place on the MySQL system

2) The aggregation is being used as a distinct...

I also posted this on the SQL Server 2005 Security forum and got the answer to use IS_SVRROLEMEMBER which solves my problem.

dmoldovan (12/1/2009)

---

Try this example taken rom BOL ---> IS_SRVROLEMEMBER (Transact-SQL)

IF IS_SRVROLEMEMBER ('sysadmin') = 1

print 'Current user''s login is a member of the sysadmin role'

ELSE IF IS_SRVROLEMEMBER...

Thanks for the advice. So it looks like I've got to:

1) Create a linked server to OLE DB Provider for Microsoft Directory Services

2) Find out which Windows...

The implementation of security is a multi-layered activity and there is no one solution that will solve all attacks.

My understanding of SQLServer2008 TDE featurte is that it prevents a physical...

Thanks rchesler.

However, I don't think that it is the solution to my problem.

I want to set up a data-driven subscription for an existing report that has several multi-valued parameters. ...

I've found two solutions, or rather work arounds, that are both related to background images:

1) Modify the "Title text" text box's properties:

a) Set...

The concept of using a background image should be common practise. The fact that the report designer supports a Z-plane means that overlaying objects should be possible. If...

It can be done in HTML, eg in VS2008, so I'd expect SSRS2008 to support it.

Thanks for the response Ramesh.

However, I've got a problem with the Script Component

>> Script Component (this should update the value of the variable @LastID to [CurrentID]

In that the variable...