Search results for query: *

I solved my issue. When several of the "Execute SQL Task"'s failed. I copied the code from the stored procedure directly into the Task. It worked perfectly from there. Apparently the connection to SLQ Server was timing out.

Thanks but I have no idea how to do that. Can you walk me through it or point me to a URL that can? I've googled it but have not found the "how to's".

I have a stored procedure to parse a name field. Every once in a while the SQL Data Task will fail stating [Execute SQL Task] Error: Executing the query "SSISParseTheName2" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the...

I put your code to the test and it did exactly what I asked for. Thanking you for future projects!

Thanks for your reply. The data is from an application I am writing that creates two documents when our mainframe programmers complete their applications. Prior to moving them to production, they have to use my application to gather all of the required data. If they go in to do any edits...

Sorry, I'm using .Net 2008

I have this string 2/1/2012 - 321 2/1/2012 - 213 2/1/2012 - 21 2/1/2012 - 321 2/1/2012 - 231 2/1/2012 - 321 2/1/2012 - l;k;l 2/1/2012 - 546 2/1/2012 - 545 2/1/2012 - 45 2/1/2012 - kl; 2/1/2012 - 55464 1/18/2012 - added web2 1/18/2012 - added falcon 1/17/2012 - that I want to parse to this...

Wow! That was too easy. Thank you.

How do I format a field on a SQL Server Reporting Service report to show all of the characters in a date. For January 5, 2008 I get 1/5/2008. I want to show 01/05/2008. The data type in the SQL Server 2005 database is SmallDateTime. Thanks for your help. Penny

...machine at work it performs perfectly, on the clients machine and my machine at home (even in development with VB6) the grids don't fill. CODE: ********************************************* Sub FillGrid(ByVal Query As String) With Adodc1 .ConnectionString =...

...Sub Form_Load() Today = Format(Now, "Short Date") MakeConnection Dim diff As Integer '//Update the pets ages Set rs = db.OpenRecordset("select * from pets") With rs Do While Not rs.EOF diff = DateDiff("d", !AgeDate, Today) If DateDiff("d", Today, !AgeDate) >= 365 Then...

Thank you so much. It worked. I've been struggling with this for a couple of hours now.

I am trying to add two amounts of currency together. I have a function that will subtract them but when I change the minus to a plus it doesn't work. Can anybody tell me what I'm doing wrong? The function that works is: Pass in $333.33 and $111.11 Function CalculateMissing(ByVal Total As...

Thanks. I had no idea.

I am using VB.NET version 7.1. This is NOT a Windows app it is a WEB app. I am converting from VB6. My program interfaces with another program which has a button that puts data on the clipboard. I need a button on my app that when clicked, will paste the data from the clipboard to a specified...

That was too easy! Thanks so much.

How can I open a VB6 app in a vb.net web form? I have a VB6 application that will accept a parameter that I need to open with a VB.NET Web Form. I tried using Shell("\\ServerName\Folder\ApplicationName.exe ParameterValue") with no luck. Can anybody help. Thanks

Can anyone help me determine the date of the Friday prior to any given day. Ex: Today is Thursday, November 4, 2004. I need a query that will tell me that last Friday was October 29, 2004. Thanks

Perfect, thanks.

Does anyone have the code to create a new Catagory to use when scheduling a new job. It gets a bit confusing when everything goes under Uncatagorized.