You're right. It doesn't seem to be a particularly good way to derive your InitialCatalog for the connection manager.

There's one other thing I'd add... whilst it's possible to set the...

Populate a recordset with a query against sys.databases.

[font="Courier New"]SELECT [name]

FROM SYS.DATABASES

WHERE state_desc = 'ONLINE'[/font]

Then use a for each ADO enumerator to loop through the recordset.

The main advantage to using variables is it allows more transparency/visibility of how the package works and it allows you to run the package both in development studio and through...

Hi again folks,

Just wanted to confirm that you definately can use one config file for more than one package.

There is no secret to it, and there is no necessity to...

Thanks Michael,

I did some tests and the performance of the update on the subscriber doesn't appear to be significantly different regardless of how I perform the update on the publisher,...

Hi Brandie, thanks for the feedback.

Looking at your dataflow there is something that I think could improve the performance even further.... if you don't have a requirement for rows...

My guess here is still date formats.

I tried out your function and passed in 2 identical dates which I believe is how SSIS converts a date to a string.

SELECT [dbo].[fVoidRequestDate]('2008-04-08','2008-04-08')...

Have you checked regional or date format settings on the machine that's executing it?

If the dates are being passed in different formats according the user, then you may be...

Hi Brandie,

How about this... I apologise if this seems a little sketchy, but I think this could work. Multicast straight after your merge into 2 pipelines. Pass one through an...

Hi Ann,

There are certain statements that you can't parameterize in Execute SQL task or OLEDB source.

From memory they are sub-selects, joins and functions (there may be more). In these instances...

If it absolutely has to be HTML then use a script component and the System.Web.Mail class which provides the properties and methods for setting the format and encoding options.

Alternatively include...

You're right... I've been using SSIS pretty much since it came out, and I'm often reminded of the struggle I had at the outset. Its probably harder to get your...

No you shouldn't need a connection if you're just testing the attributes.

Here's something to get you started (You'll need the system.IO namespace)...

[font="Courier New"] ...

What I think I need to do - outer loop of server names (this works). Next loop is inside of the server name loop and it queries the DBA database...

Hi Patrick,

To add a constant for your contact_id, you could do this by using a JET SQL Command for your excel source:

SELECT

F1 AS Col1,

F2 AS Col2,

1 AS ContactId

FROM [Worksheet$]

To add...