|
Iain Wiseman wrote: Thanks for replying. So you are saying that you cannot ignore errors easily in SSIS and count them
Not knowing how your SSIS package is constructed makes answering this harder.
For a Data Flow task (which is the most likely thing you're using), you can often pipe errored rows to a separate file.
Its still not "minutes" work though 
|
|
|
|
|
Jamie is correct, this will be a PITA to accomplish in SSIS. Anything that does the transform is bloody difficult, trapping the error rows would be a nightmare. SSIS and Biztalk are an attempt to dumb down the ETL layer so power users can do it - they FAILED.
I load my data into a table of varchar columns, the bulk copy does not care what the data is like then. I then use a stored proc to do the transorms. It is MUCH easier to manipulate the data in TSQL or C# than in SSIS.
|
|
|
|
|
Thanks all,
I come from an open source background and want to treat my colleagues who use microsoft fairly. All I want is the number of records in error and possible which they are. I assume that once you have a package to load them theat error reporting was easy. Reading this SSIS does not provide this easily. With oracle PLSQL this would simply be looking at a return code and doing something. I will ask the developer how to proceed.
|
|
|
|
|
This works on the development machine but after installing on another workstation the application errors.
Please help/
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at PeerAssistLoader.StandardProcedures.NET_AuthenticatedMailSend(String mailFrom, String[] mailTo, String[] mailCC, String Subject, String MessageBody, String smtpHost, Int32 smtpPort, String smtpNETAuthUser, String smtpNETAuthPassword)
at PeerAssistLoader.frmConfigurationMgr.SendEmail(String AlertType, String Subject, String MessageBody)
at PeerAssistLoader.frmConfigurationMgr.btnUpdateAssistUsers_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
PeerAssistLoader
Assembly Version: 1.16.31.434
Win32 Version: 1.9.23.417
CodeBase: file:
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
Microsoft.ReportViewer.WinForms
Assembly Version: 9.0.0.0
Win32 Version: 9.0.30729.1
CodeBase: file:
----------------------------------------
Microsoft.ReportViewer.Common
Assembly Version: 9.0.0.0
Win32 Version: 9.0.30729.1
CodeBase: file:
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.4926 built by: NetFXw7
CodeBase: file:----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.4926 built by: NetFXw7
CodeBase: file:----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.DirectoryServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
Microsoft.ReportViewer.ProcessingObjectModel
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.8
CodeBase: file:
----------------------------------------
expression_host_b75c906bcd1143d69b962f2790f3bfac
Assembly Version: 10.8.30729.1
Win32 Version: 9.0.30729.1
CodeBase: file:
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
|
|
|
|
|
Figured it out I was being dumb. I forgot to account for an array not being populated yet.
|
|
|
|
|
Hi, i am making an application in which the label keeps scrolling up. The problem i have is i want to do right alignment so that i get "." in a sequence like
Basket...........
ball................
keyboard.......
can anyone help me with this please!!
i have tried this, but it isn't working for me,
for (int u = textBox1.Length; u = 40 ; u++)
{
strDotsBuilder.Append(".");
}
|
|
|
|
|
You should check your for loop again.
int u = textBox1.Length; u = 40
should probably be
int u = textBox1.Length; u < 40
[EDIT]
Actually, your code shouldn't even compile. Did you do a typo here on CP?
[/EDIT]
modified on Tuesday, October 20, 2009 2:57 AM
|
|
|
|
|
The only way I know to do that successfully is by selecting a monospaced font such as "Courier New", then append filler characters (for which string.PadRight is useful).
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Hi,
I am currrently workin on something where in i would like to hide some content in an email which i would retrieve later after the mail has been sent . I would need to get this hidden content at the recieving end.
Could anyone help me out with this.. I am using c# with framework 3.5 to create the email message.
Thanks in advance
|
|
|
|
|
Pretty much impossible. Unless you hide it in an image or something, some sort of attached file that needs a third party program to extract the info.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi,
I think you can use a hidden img and set its src to some page that you have.
When the email is opened, the action can transfer the data to your web page.
In that page you can deal with the data and save it anywhere you want.
modified 27-May-14 5:27am.
|
|
|
|
|
Hi..
i would like to add a calendar in my windows application form.
i have added some dates as special in a table.
i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??
should i need to create a user control???
If yes, which property i have to set to display the dates as bold??
thanks in advance
|
|
|
|
|
Ishqalways wrote: should i need to create a user control???
I expect so.
Ishqalways wrote: If yes, which property i have to set to display the dates as bold??
The Bold property on the label class would be a good guess.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Ishqalways wrote: i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??
The standard MonthCalendar control has a property called BoldedDates. Just pass it an array of the DateTime's you need in bold and it'll take care of the rest.
Here's a link with some more info:
http://msdn.microsoft.com/en-us/library/system.windows.forms.monthcalendar.boldeddates.aspx[^]
Hope that helps! 
|
|
|
|
|
There is a image field in the table, and I save the picture into this field, now I use below code, how to set the value of the Tables[0].Rows[0][0] to one cell of Excel sheet?
string strCon = "Data Source=0;Initial Catalog=dbtest;Persist Security Info=True;User ID=sa;Password=ok";
SqlDataAdapter m_da = new SqlDataAdapter("select fa from G_Control", strCon);
DataSet ds = new DataSet();
m_da.Fill(ds);
Thanks in advance!
|
|
|
|
|
who can help me on it ?many thanks!
|
|
|
|
|
Hi,
Can anyone advise me on how to search within a SharePoint document?
I've seen several examples of how to use a keyword or SQL search but having tried the code out, I only seem to be able to match against metadata such as the document's title, and various columns, such as keywords (of course). I thought that SharePoint MOSS 2007 would allow me to search the content of a document if I wished. Am I mistaken? Can anyone suggest a way of searching within a SharePoint document?
|
|
|
|
|
Bug Me Not wrote: Can anyone suggest a way of searching within a SharePoint document?
The first thing I'd do is search within the SharePoint forum
only two letters away from being an asset
|
|
|
|
|
Hi i m new in C#.i want to know how to write code behind the next and continue buttons.pls reply me soon.coz code project.com is a platform that guides everyone.
regards
|
|
|
|
|
We love to help people, but sometimes, it's not really possible. The term 'code behind' relates to ASP.NET, and this is not the ASP.NET forum. Are you writing a web site. What continue and next buttons are you talking about ? Are you using a specific control that includes these buttons ?
If you don't know that we need this sort of info, then you probably would do better to buy a book and read it, but odds are good you're at work, in a job you're incapable of doing, and posting here because you want us to fill the gaps for you. We can't do that, based on the info you provided.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
+5 for saying 'odd's are', we don't need another thread like in the VB forum...
|
|
|
|
|
I am trying very hard to be nice, and to be helpful. I see he's not responding. I bet he just asks the same question the same way in a week from now 
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
No no, he just ran off to the nearest book store.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Assuming you have placed the buttons on your form, double click them and the appropriate event handlers are created in the code. You can now enter code into these handlers to cope with them.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
I'm really stuck here. I have been Googling this all day and no luck.
I'm working in a C# WinForms app that reads data from Excel into a DataSet. Here's the SQL:
string Query = "SELECT [TPMA Run Date],[Buyer],[Item],[PO Number],[PO Line],[PO Due Date],[Date Required]," +
"[New Date],[Status Comment],[Status Code],[Prior Week New Date],[Prior Week Status]," +
"[Prior Week Status Code],[SEQNUM] FROM [Current MRP Action Messages$]";
If I change it to this, it works fine:
string Query = "SELECT * FROM [Current MRP Action Messages$]";
Here's my conn string:
ConnectionString = @"provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
The Excel file has column headers in the first row.
Anyone know what's wring here?
Everything makes sense in someone's mind
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
