Viewing 15 posts - 136 through 150 (of 1,118 total)
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.
June 22, 2011 at 9:06 pm
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?
June 22, 2011 at 8:59 pm
How many physical CPUs do you have?
June 22, 2011 at 8:57 pm
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....
June 22, 2011 at 8:53 pm
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...
June 9, 2011 at 10:42 pm
harry.sh16 (5/23/2011)
My problem is Microsoft OLE DB Provider for...
June 9, 2011 at 10:39 pm
Open AssemblyInfo.cs file. What do you have specified for AssemblyVersion property ?
June 2, 2011 at 7:10 am
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...
June 2, 2011 at 7:09 am
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...
May 20, 2011 at 6:09 am
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...
May 20, 2011 at 6:05 am
The row terminator symbol is specified in the last defined column in the Flat File connection manager.
May 20, 2011 at 5:58 am
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...
May 20, 2011 at 5:53 am
Check this post how to use OLEDB connections in script.
May 11, 2011 at 9:14 pm
balasach82 (5/11/2011)
We are converting an pdf file into bytecode/byte array and then trying to load that into an...
May 11, 2011 at 9:13 pm
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.
May 6, 2011 at 5:43 am
Viewing 15 posts - 136 through 150 (of 1,118 total)