rocky_498 (6/25/2014)
Hi Guys,What I am trying to do, Extract the data from SQL table and Insert in Email Body and email to user. I got good article on Internet, I follow all steps as it is, but still I am getting error.
Here is the link
Not a bad article, but that's how to send information to a procedure and redirect so you can see it during testing to a msgbox. I would have expected a Send Mail task here in a For Each Loop from a recordset object.
But I am getting Error: here is my error. Please guide me how I can fix this error.
Thank in advance!
Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
We're going to need a lot more specifics about what you're doing here. As in, what your script object code looks like. That's not a SSIS error, nor a SQL error. It's a .NET (C# I believe) error for arrays.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA