SMTP Connection Manager connections aren't shared?

Dear all,

I'm seeing that SMTP Connection Manager connections aren't shared between .dtsx.

Why not?

Let me know

TIA

[638 byte] By [enricvives] at [2007-12-24]

«« C# .net2.0 dataset problem
»» Binding objects to DataGrid - public fieald instead of public properties

# 1

Do you mean in the contxt of a package at run-time?

No connections are shared by default, but you can turn this on, see the RetainSameConnection property for the connection in the Property Grid.

DarrenSQLIS at 2007-10-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

Hi Darren,

I don't see such property. Where is it?

I see Smtpserver,SupportsDTCTransactions,UseWindowsauthentication and so on.

Thanks again,

enricvives at 2007-10-8 >

# 3

Quite right, there is no such property. So I guess it cannot be done, which is a bit annoying. Time for feedback, I think this behaviour would be usefull for all connections.

It appears only DB type connections and Excel has this property.

DarrenSQLIS at 2007-10-8 >

# 4

OK. Thank you

enricvives at 2007-10-8 >

SQL Server

SQL Server Integration Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech