There is no solution or "trick" in SSIS that provides behavior similar to MSDTC. The approach you have described is the right approach based on the requirements you have.

Your question is very unclear. Can you post more details what kind of problem do you have? What is the exact error message you get?

How many physical CPUs do you have?

I suspect you get the above error during validation. Can you try the following - right-click on the FTP Task and select Properties. Then scroll-down and find DelayValidation property....

The problem is not SSIS. Just by looking at the timeout you have specified, it looks like you have connection issues. Can you elaborate what is the exact topology and...

harry.sh16 (5/23/2011)

---

Need download links for a OLEDB provider that i can use to connect to DB2 using SQL Server 2008 Standard Edition.

My problem is Microsoft OLE DB Provider for...

Open AssemblyInfo.cs file. What do you have specified for AssemblyVersion property ?

1. Retry means how many times the connection manager will try to establish connection before it fails.

2. The timeout setting is the time the connection manager will wait for response...

There are so many moving pieces that it is hard to tell what is happening. However one thing is for sure: DontSaveSensitive is not a default option and installing a...

The solution you have above is not very easy to maintain. If you have a file with another set of input columns, then you have to include another data flow...

The row terminator symbol is specified in the last defined column in the Flat File connection manager.

In what process and under what user account is the sql stored procedure running? The gpg application requires full user profile and access to the folders where your public/private key...

Check this post how to use OLEDB connections in script.

balasach82 (5/11/2011)

---

How to load Hexadecimal value into an Image column using either ssis 2005/DTS?

We are converting an pdf file into bytecode/byte array and then trying to load that into an...

You are not doing it correctly. Review the sample here and specifically how MessageSourceType property is being set.

This code will require including reference to microsoft.sqlserver.sendmailtask.dll assembly.