Recent content by Programmer99

I tried just connecting to the flat file and had some issues I could not get around. The main issue I had was that I could not get the formatting to recognize the carriage return lines to every line gets thrown off by one from the previous line. I changed all the options to CR/LF, LF, CR and...

I have a linked table to a text file in an access database and am trying to import that linked table into SQL 2005 database. The problem I am having is when I go through the SSIS import designer and choose the acccess database source file, those linked tables do not show up nor do any queries...

I tried all of those options and it still did not make a difference. I should be able just to switch that option instead of having to reconnect to the file and reestablish that it is a LF correct?

I need to import a flat file into a SQL 2005 database table. The text file has fixed lengths so I defined all these lengths and thought I was good to go. When I previewed it, I noticed the file has carriage return lines so it was messing all the formatting up. My question is how to get around...

do you know the code I would use to connect to the table to create a recordset. I have experience in VB but am not sure how to link to an Access table in the module. Thanks.

I have a table that contains many SSNs and some of them are in the table more than once. What I'm trying to do is create a new field and populate the field to a value of "1" for each unique SSN. For instance for the rows that have multiple SSNs, I want to value the first new field to 1 and the...

I have a table that contains many SSNs and some of them are in the table more than once. What I'm trying to do is create a new field and populate the field to a value of "1" for each unique SSN. For instance for the rows that have multiple SSNs, I want to value the first new field to 1 and the...

Is it possible to have a Stored Procedure call a UDF?

I'm thinking I'll have to do some sort of Left Outer Join like... Select LastName, FirstName, HasDriversLicense From Borrower b Left Outer Join DriversLicense dl on b.BorrowerTrID = dl.BorrowerTrID I just don't know how to display a Y if they have an entry in the DriversLicense table or a N...

The HasDriversLicenseFlag is a column, it is just the Column name I want to display for the user.

I have a query that is returning information from a table like... Select LastName, FirstName, HasDriversLicenseFlag from Borrower I need to look in the DriversLicense Table to determine if the borrower has one or not. If they do, display "Y" else Display "N" for the HasDriversLicenseFlag...

Very nice! If I need to format other fields such as a Phone Nbr, would I use the {0: to handle those Nulls as well?

I need to do the same thing and what you describe works great, except if the value being returned is NULL. How do I get around this?

I would still like to use the CustomValidator because I use many other validators such as RegularExpressionValidator and RequiredFieldValidator. They work perfect so I would like to figure out what is wrong with my CustomValidator.

<asp:Button id="btnLoanCertProfileAdd" onclick="AddLoanCertProfile" runat="server" Width="35px" <asp:CustomValidator id="ctvNewProfileName" CssClass="ErrorMsg" runat="server" ControlToValidate="txtLoanCertProfileName" Display="Dynamic" ErrorMessage="Profile Already...