Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id
Hello ALL
what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.
I also want to update some users using a different text file.
Please help me with the best way to do this
Thanks in advance
View Complete Forum Thread with Replies
Related Forum Messages:
Select Bad Email Addresses From Table
Hi all, I'm having a bit of an issue with this query. I'm not that familiar with MS SQL so please forgive me. I'm trying to select the bad email addresses in a table so I can remove them or correct them but I'm not getting any results that are helpfull. Bellow are some of the queries I've tried select email from person where email != "*@*" returned all addresses plus null fields. select email from person where email not like "%@%" (this didn't work at all) And a few other that are similar Could somebody please kick me in the right direction. TIA Jason
View Replies !
Email Addresses To Outlook
Is there a way to export a list of email addresses to outlook based on certain query conditions? So for example, lets say using pubs, I want to send out an email to a group of authors who have published only one book. So could I essentailly query for the authors and then have those corresponding authors emails sent to outlook so that I could send out a generic email asking them if they are going to write another book or something like that? The Yak Village Idiot
View Replies !
Mass Email: Text Body Keeps Looping In Each Email
First off, my server uses CDO, the updated version of CDONTS, to send mail. The script works however, it sends the emails out and keeps looping the message body within the text of the email. here's an example: I added fake users to my table called REALTORS. this was the result of the email sent out: <!-- START EMAIL MAIL OUT --> I am an realtor in Florida and I found you from surfing around Poop Title http://www.poop.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around Haha titleage http://www.hahaha.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around niclipse . com http://www.niclipse.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around. I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code." <!--[==-- EMAIL MAIL OUT FINISHED -------> ANY IDEAS ON HOW TO SEND EACH EMAIL TO EACH USER INDIVIDUALLY WHILE USING THE INFORMATION LINKED IN THE DATABASE WITHOUT LOOPING OTHER PEOPLE'S DB INFO IN THE SAME EMAIL? Here's the script below.... <title>Email The List</title> <% nickemail = request.form("sender") subject = request.form("subject") If Len(subject) > 0 Then dsn="Provider=SQLOLEDB;Data Source=sql.string.com, etc ect" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dsn Set RS = Server.CreateObject("ADODB.Recordset") SQL = "SELECT title, url, email FROM Realtors" RS.open SQL, conn Do While NOT RS.eof strTXT = strTXT & "I am an realtor in Florida and I found you from surfing around" If Len(RS("title")) > 0 Then strTXT = strTXT & vbcrlf & vbcrlf & RS("title") & vbcrlf strTXT = strTXT & RS("url") & vbcrlf & vbcrlf Else strTXT = strTXT & "." & vbcrlf & vbcrlf End If strTXT = strTXT & "I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a ""vote"" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation." &vbcrlf &vbcrlf strTXT = strTXT & "If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories:" &vbcrlf strTXT = strTXT & "http://www.realestate321.com/resources/resources.asp" & vbcrlf strTXT = strTXT & "Once added you will be placed in a ""holding bin"" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a ""robot"" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot." & vbcrlf &vbcrlf strTXT = strTXT & "Best Regards," & vbcrlf & vbcrlf strTXT = strTXT & "Nick McGirr" & vbcrlf strTXT = strTXT & "Real Estate Agent" & vbcrlf strTXT = strTXT & "http://www.realestate321.com/" & vbcrlf strTXT = strTXT & """Buying and Selling Homes in the (321) Area Code.""" set objMessage = createobject("cdo.message") set objConfig = createobject("cdo.configuration") ' Setting the SMTP Server Set Flds = objConfig.Fields Flds.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 Flds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost" Flds.update Set objMessage.Configuration = objConfig objMessage.To = RS("email") objMessage.From = nickemail objMessage.Subject = subject objMessage.TextBody = strTXT 'objMessage.HtmlBody = strHTML objMessage.fields.update objMessage.Send RS.movenext Loop Conn.close set Conn = nothing set objMessage = nothing set objConfig = nothing ShowThanksMsg Else End If ShowForm Sub ShowForm %> <% Session("department")="home" %> <center> <form action=email.asp method=post> <table border=0 cellpadding=4 cellspacing=2> <table> <tr><td><font class=tbody><b>From:</b></font></td><td><input type=text name=sender value="me@me.com"></td></tr> <tr><td><font class=tbody><b>To:</b></font></td><td><font class=tbody>Brevard County Emails</font></td></tr> <tr><td><font class=tbody><b>Subject:</b></font></td><td><input class=inputfield type=text name=subject size=22></td></tr> <tr><td colspan=2><input type=image align=right src=/_images/submit.gif border=0 name=B1></td></tr> </table> </form></center> <!-- <tr><td colspan=2><font class=tbody><b>Comments:</b></font><br><textarea class=inputfield rows=3 maxlength=100 name=message cols=40></textarea></td></tr> --> <% End Sub Sub ShowThanksMsg() response.write "<center><font size=5><b>Message Sent!</b></font><br><br>" response.write "your message has been delivered to all members." End Sub %>
View Replies !
Many Addresses In A Database
I need to allow for many addresses in my database for each client that is entered. I'm looking for suggestions on how I should handle this. I will need to do mailings to the clients and will need a way to select the address record that the client indicates as the mailing place. Thanks for any thoughts.
View Replies !
Unique Addresses From Table. SSIS Newbie Please Answer
Hello ALL, My source columns are: Customer Record DESTINATION TABLE Name Address_line_1 sex city PID state legal_street zip_code legal_state ID legal_city mail_street mail_city mail_state mail_zip My client needs. All Unique Addresses from the Source. . That is the duplicates should be removed and uniques should be available. Please let me know first what he wants then also tell me what to use in the data flow and how to start. I want to understand the logic. Note: Two persons might have the same address or One address might belong to 2 or more people. This is what my client said. Please give me what should i have in the output
View Replies !
IP Addresses
I'm trying to connect to a local instance of SQL Server using an IP address and its not working. When I looked up the connect string, it shows only the IP address replacing the Server name, not the instance name, i.e. Server=127.0.0.1 - how does it know which instance to use? Can I use the 127.0.0.1 loopback address for the server (as its on a local machine)? Do I have to use 'Network Library = DBMSSOCN' to tell the client to use TCP/IP? (TCP/IP is showing as an enabled protocol in the Client Network Utility)
View Replies !
Update Bad Addresses
I got got a pile of bad email addresses to update in our SQL database.I know how to do this for individual records using the update command.Is there a way to execute an update using the list of addresses in anexcel spreadsheet or some other form of list? This kind of scriptingis new territory for me.
View Replies !
Changing The IP Addresses
We are changing IP Addresses and installing a firewall on our SQL 6.5/7.0 Servers. Besides the obvious Network connections, anything else I should check for on the database end?
View Replies !
SQL Server 7 - IP Addresses
Morning all! A quick question for you all, We will be changing the IP address of our SQL 7's server sometime next week. Does any1 know of any issues/problems that could occur if we do so? Thanks in advance for any and all help Gurmi
View Replies !
Replication And IP Addresses
I want to replicate between 2 servers not on the same network. One has to be addressed by IP. Currently replication does not support IPs - anyone have a workaround. Will this be resolved in the future? Seems this is a pretty common scenario if your db is on a hosted site. -cg
View Replies !
Registering Servers With IP Addresses
I hope someone can help me with this problem. I need to replicate some tables from our store servers to our corporate server. All of them are 6.5, and the corporate server will subscribe and the stores will publish. I have registered all of our stores on the corporate server so that I can enable them for replication. The problem is that to be able to register them I had to create a system DSN for ODBC, but that would only work if I used the IP addresses. Unfortunately, then when I try to enable them on the corporate server I get an error stating that name (which is the IP address) is not a valid object identifier. In ODBC I did actually use a real name (not an IP) for the name, a normal description, and the IP is in the Server field. Is there some way to use an alias? What am I doing wrong?
View Replies !
SQL 7 EnterPrise And Multiple IP Addresses.
We have a Compaq Proliant 5500 Clustered Solution running NT 4.0 EnterPrise and SQL 7.0 EnterPrise version. When we run the Fail-over wizard under SQL7 Enterprise we have to specify an IP Address and a NetBios Name which is 172.21.5.185 and SCCSQL. Once this is done we can only connect to SQL using this IP Address or NETBios Name. We would like to access the SQL Server via 192.168.200.187 which is our private backup network. We have other servers non-clustered servers running SQL7 and who can be accessed by our public as well as our backup network. According to Microsoft’s Technet article Q235987, it says that this is not possible. Is there any registry hack that we can use to access SQL via 172.21.5.187 as well as 192.168.200.187 Any sugession will be appreciated. Thanks Richard. Network Support WA Newspapers Perth Australia
View Replies !
Remote Connections From Specified Ip Addresses
Hi, Is there any way to ony allow remote access to an instance of SQL Server 2005 from a specific set of ip adresses? (and How To..) My problem is i only want certain machines to access the server. Any other suggestions to achive this are most welcome. Thanks for your time Leroy
View Replies !
Two Different Addresses In The Navigation Pane?
I have a report with a Matrix table. When it€™s fully populated I have 5 rows. These rows are different categories in a CRM system. In these categories there are a lot of Opportunities listed. The thing here is that category 1-4 exist in one table, really a view, and category 5 exist in another different view. So to gather all the information into one single Matrix table to later have subtotals and stuff I just made a little Union of the two select queries. Now one the column in the table is of course Topic. And from here my client wants to be linked to the right CRM card. The problem I have encountered is that how can I have to different addresses on one single cell in the table? In the Navigation pane in the cell that corresponds to the Topic, for now I have an address like this: =string.Format("http://{0}/SFA/opps/edit.aspx?id={1}", Parameters!srv.Value, Fields!objectid.Value) What I need to change when it€™s a category 5 Opportunity is €œopps€? to €œcat5€?and add €œ&etc=10008€? to the end of the address. Any ideas? PS. {0} and {1} are parameters, one server parameter and one opportunity ID parameter. Kind Regards
View Replies !
Mailing Report To Several Addresses
Hi, I've created a report with a parameter (a customer number). If I schedule the report and I fill in the parameter value, I can also fill in the email address in the schedular and so the report is created with the correct parameter and send by email (as PDF in attachment) to the customer. This all works very goor but you can imagine that we have a lot of cutomers. So defining hte schedules for all of our customers is impossible. So I tried to create a report which returns the customer number and the corresponding email adres. Is there a way to schedule this report en send the customer number and email adres to a linked report so it gets mailed. I hope you understand what I intend to do :-)
View Replies !
Xp_cmdshell Does Not Work With Ip Addresses
Hi I am having a very strange problem. Say I have a shared folder '\chdmpassrv ranfiles' on my network with 'Full Control' Permissions to 'Everyone' [Full Control to Everyone in Security tab also]. Then following command executes perfectly dbo.xp_cmdshell 'dir \chdmpassrv ranfiles' But if the server name in the shared path is replaced by the IP address of the path then it does not execute and the error is Access Denied as following. dbo.xp_cmdshell 'dir \10.8.15.74 ranfiles' Same command i.e.: dir \10.8.15.74 ranfiles executes without error from command prompt. The Log on user for SQL Services is LocalSystem but that should not make a difference as the folder is shared with full rights to all. It seems that xp_cmdshell does some special handling for IP addresses in the command string before executing the command string. Please comment
View Replies !
Changing IP Addresses Of The Cluster
Hello! We will be moving our two cluster running SQL Server 2005 64-bit SP2 on Windows 2003 to the different datacenter. IP addressed of both nodes will be changed by DNS names remain the same. I was wondering if anyone had issues with this. Out thought is that we just need to update IPs in Cluster Manager. Comments are welcome. Igor
View Replies !
Help Split List Of Email Add Comma For Evry Email
need help split list of email add comma for evry email i have tabe "tblLogin" and in this table i have field emall like this emall ----------------------------------------- aaa@hhhh.mm nnn@hhhh.mm mmm@hhhh.mm need to do ilke this Code Snippet @list_email = (SELECT emall FROM tblLogin) --------------------------i get this -----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm @recipients = @list_email Code Snippet IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] ) BEGIN DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX) SET @xml =CAST(( SELECT FirstName AS 'td','', LastName AS 'td','' , Date_born AS 'td','' , Age AS 'td','' , BirthdayToday AS 'td','' , BirthdayThisWeek AS 'td' FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX)) SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl> <tr> <td>name</td> <td>fname</td> <td>date</td> <td>age</td> <td>aaaaaaaaa</td> <td>bbbbbbbbbbbbbbb</td> </tr>' SET @body = @body + @xml +'</table></body></html>' EXEC msdb.dbo.sp_send_dbmail @recipients =N'rrr@iec.co.il', @copy_recipients='rrrrr@iec.co.il', @body = @body, @body_format ='HTML', @subject ='ggggggggggggggggggggg', @profile_name ='ilan' END ELSE print 'no email today'
View Replies !
Pushing Data Using Server Ip Addresses
There was a problem in SQL 6.5 when pushing objects/data from one server to another using ip addresses. Transfer manager would see the period in the ip address and translate that as being the local server. It would then drop the local (source) objects and data, then recreate he objects. Is this still an issue in SQL 7.0 and if it is could someone direct me to the kb article. Thanks in advance Bob
View Replies !
Selecting First 10 Addresses In Each City In Each State
Greetings: I read with great interest a post on getting hte top 75 per cent by month, but still get through this problem. I have a table containing addresses, city names and state names, Each row has a unique address. I want to get the first ten addresses for each city in each state. I've tried something like the following which didn't work. Suggestions on how to solve the (simple) problem would be appreciated. Select top (10) city,state,address from address_list alan
View Replies !
Locking SQL Express To Recieve FROM Certain IP Addresses?
Hi All, A client of mine has an update to the software they use which requires SQL ports to be pinholed on the router to allow direct connctions from point of sale terminals. I'm not happy with the idea but thats not my call. Is there a way to restrict IP addresses that can connect to SQL Express ? (without havng to get them to buy a new router) Cheers. Irish
View Replies !
Changing TCP/IP IP Addresses Under Protocols For SQLExpress
SQL Server Configuraton Manager, Protocols for sqlexpress, TCP/IP When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab. I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there? Thanks, Bill
View Replies !
Changing IP Addresses Of MS SQL Server In Clustered Environment
Hi all,I have a MS SQL server 2005 in a clustered environment (with 4 physicalservers/cluster nodes). I need to move the cluster to another office,which implies that I need to reassign IP addresses of all cluster nodesas well as SQL servers (goups) installed on this cluster.Is it possible to change the IPs without damaging the cluster? If so,could you please provide me with some information on this subject?Thanks,aleu
View Replies !
TCP Port Addresses With Multiple Names Instances.
I have several 64 bit SQL 2005 servers that up to 4 named instances residing on them. Before going into production I need to change the port addressing to use fixed TCP ports. I have SQL Browser running to enbale me to see the named instances. What steps are required to change to using specific TCP port addresses and is there a particular range to use ?
View Replies !
Sending Emails With System.Net.Mail To Addresses From A SQL Query
I have the following code on a form: <asp:SqlDataSource ID="building_a" runat="server" ConnectionString="<%$ ConnectionStrings:vol1ConnectionString4 %>" SelectCommand="SELECT [E_MAIL] FROM [Sheet4$] WHERE ([BUILDING] LIKE '%' + @BUILDING+ '%')" OnSelecting="building_a_Selecting"> <SelectParameters> <asp:Parameter DefaultValue="a" Name="BUILDING" Type="String" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="building_b" runat="server" ConnectionString="<%$ ConnectionStrings:vol1ConnectionString4 %>" SelectCommand="SELECT [E_MAIL] FROM [Sheet4$] WHERE ([BUILDING] LIKE '%' + @BUILDING+ '%')" OnSelecting="building_b_Selecting"> <SelectParameters> <asp:Parameter DefaultValue="b" Name="BUILDING" Type="String" /> </SelectParameters></asp:SqlDataSource> <asp:TextBox ID="subj" runat="server" Width="500px">Subject</asp:TextBox><br /><br /> <asp:TextBox ID="messg" runat="server" Rows="20" TextMode="MultiLine" Width="500px">Message</asp:TextBox><br /><br /> <asp:Button ID="bldga" runat="server" Text="Building A" OnClick="Button1_Click" /><br /><br /><asp:Button ID="bldgb" runat="server" Text="Building B" OnClick="Button2_Click" /><br /><br /> <asp:Label ID="resultLabel1" runat="server" ForeColor="red"></asp:Label> And I have the following code behind:protected void Button1_Click(object sender, EventArgs e) {SmtpClient smtpClient = new SmtpClient(); MailMessage message = new MailMessage(); try {MailAddress fromAddress = new MailAddress("me@mydomain.com", "My Name");MailAddress toAddress = new MailAddress("them@theirdomain.com"); message.From = fromAddress; message.To.Add(toAddress); message.Subject = subj.Text;message.IsBodyHtml = false; message.Body = messg.Text;smtpClient.Host = "myhost"; smtpClient.Send(message);resultLabel1.Text = "Email sent!"; }catch {resultLabel1.Text = "Send failure"; } } The queries get e-mail addresses from a SQL database for all people who work in a particular building. The buttons will send an email if I give a To address. How do I write the code so that clicking on the "Building A" button will send the e-mail to the addresses from the query results individually? Any ideas?
View Replies !
SQL Server Agent Notifications To Multiple (three-plus) Addresses Fail
We have SQL Server 2000 Standard and recently moved from Exchange 5.5to Exchange 2003. This problem occurred both before and after thee-mail change.We would like to send notifications of failed jobs to multiple peoplein case one person happens not to be in on the day there is a problem.Setting up an operator with an e-mail name that combines twoaddresses seems to work ok as long as we use a format like thefollowing:smith_john; jones_maryorJoin Bytes!; Join Bytes!However, when we add a third name, we start getting problems. Thefirst and third accounts listed get the message but the second onedoes not -- apparently because the address gets corrupted. Forexample (based on the message received at one of the good addresses),a message sent to:Join Bytes!; Join Bytes!;Join Bytes!goes to Smith and Jackson successfully but Jones' address is corruptedto:Join Bytes!omand, of course, fails.From some other testing, it appears that the last three characters ofthe first address always get appended to the end of the secondaddress.Has anyone else run across this? If so, is there a known fix? I hadhoped Exchange 2003 would fix the problem. Most likely, we will trysetting up a personal distribution list under the account from whichthe messages are sent. I just wanted to give one more shot to findingthe problem -- both because I would like to know and because beingable to string together addresses is a little easier than having to gothrough the person who can give us access to the account to set thePDL.Thanks.Jonathan LevyChicago Department of Public Health
View Replies !
How To Load Text File Into A Table?
1 4/19/06 abc3100UD:Dcod25-uss1 PAGE 1 REPORT ON xxxx cs PREVIOUS DAY - PREV REP LOAN # BORROWER STAT STAT APP DATE INITIAL ORD DT LOANAMT CLIENTNAME 0 0123454681 xxxx, xxxxxxxxxx 10 9 06/04/05 abc 060418 $310,000.00 ABC temp plus 1 $310,000.00 0523468431 xxxxx, xxxxx xx 14 13 06/04/04 efg 060418 $127,120.00 cAPITAL MANAGEMENT INC 1 $127,120.00 0542616443 xxxxx, xxxx xxxxxx 14 13 05/12/01 hij 060418 $200,000.00 fRIENDS CLUB 1 $200,000.00 0516545461 xxxxx, xxxxxxxx x 205 204 06/03/02 klm 060418 $283,992.00 MICROTECH TECHNOLOGY 0135554455 xxxxx, xxxxx xx 115 114 06/04/04 060418 $230,000.00 ABC TEMP PLUS 2 $513,992.00 0151981313 xxxxxxxx, xxxx xxxxxx 205 204 06/04/05 nop 060418 $80,000.00 INTERNAL REFERRAL 1 $80,000.00 0111111111 xxxxx, xxxxx 115 114 06/03/05 qrs 060418 $86,800.00 gMA INC 0222222222 xxxx, xxxxxxxxxx 115 114 06/04/03 060418 $156,720.00 INTERNAL 0333333333 xxxxx, xxxxxx 205 204 06/04/03 060418 $156,720.00 HOME 3 $400,240.00 TOTAL 9 $8,005,672.00 1 abc351Uab:cod5K-SUM - 5a INITIAL COUNT 0 ABC 1 EFG 1 HIJ 1 KLM 2 NOP 1 QRS 3 How can I load the above txt file into a table with following schema? Loan(BorrowerName, Loan#) All I need is the borrower name which are xxxxx, xxxx and loan numbers.
View Replies !
How Load A Text(CSV) File Into Database
Hi All, I want to load a text file into database without using Bulk Insert. I readed the text file and kept in a datatable. I need to insert this data into database. how can i bing data in datatable to dataset. how can i update changes in dataset to database. Please help me.... Thank you.
View Replies !
One Or More Of The Server Network Addresses Lacks A Fully Qualified Domain Name (FQDN).
Hello Guys, I had been trying to solve this error with no success : One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again. The syntax for a fully-qualified TCP address is: TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port> I had installed three instances on my local machine to test Data base mirroring : Principal : running SQL Developer Instance Mirror : running SQL Developer Instance . Witness : Running SQL Express. Database mirroring already enabled using startup flag : -T1400 i even tried to configure it with out a witness but still have the same error . I used the follwoing server name in the mirroring wizard(not localhost) : Principal : TCP://Ali-laptop:5022 Mirrored : TCP://Ali-laptop:5023 Witness : TCP://Ali-laptop:5044 whats the problem guys?!
View Replies !
Bulk Load From Text Delimited File To SQL Table
Hi, I am new to SSIS but i have avg working knowledge in sql. My problem is as follows ,I have a text pipe dilimited file in some folder and the number of columns and the name of the column is not consistant. It can have N number of column and it can have any column names. I need to load this text file data into a sql table. All that i want is to load this file to SQL Database with some temp name. Once i get the table in SQL Database, i can match the column names of both taget table and this temp table and only push those column which matches with the target table. For this i can frame Dynamic SQL. This part is clear to me. Now the problem is , I developed a SSIS pacakge to push the text file to SQL Table. I am able to do this. But if i change the column names or added new column SSIS is not able to push the new columns. Is this functionality available in SSIS, is it can be dynamic like this? I hope i am clear with my prob... if need any clarification please let me know thanks in advance Mike
View Replies !
Email Subscription - Plain Text Body
Hi, I'm using a data-driven subscription to email reports. In one case, I need to email a report to an email-to-fax service. The fax service requires the email body ("Comment" in the subscription) to be in plain text, but it seems that the Reports Server formats it as HTML. Does anyone know how to change the way reporting services formats the emails? Regards, Greg McNamara
View Replies !
How Do I Configure SQL Server 2005 Reporting Services To Deliver Subscription E-mails To Addresses External To My Windows Domain
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain? I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted. For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list. Any insights?
View Replies !
Capture File To Email
Does anybody know of a way to set up a task which will send an email with an attachment other than using sp_sendmail. Sp_SendMail will run a query and send the results as a text file. But I need to run a stored procedure which generates an Excel spreadsheet then have an email sent with the Excel file as an attachment. The sp_sendmail text file just doesn't work with the information I am generating so I need to find another solution. Thanks for any help.
View Replies !
Extracting The Attached File From An Email
Hi there, I need to extract a attached file which is sent via email. I believe that I can do this via SSIS... but I would like to know how... Could you kindly send me any idea about how can I do it? Thank you, so much. Luis Antonio
View Replies !
Send Email Only If There Is Data In The File
Hi i have a SSIS package, that looks at the @@rowcount in a table and if the rowcount is >= 1 then send the information on to a file. Now i want to only email my self to say if the file has data in it. Is there anyway of doing this on the send email task. Can i use an expression ?. I've check and i can't see a away of checking the file size etc.
View Replies !
|
TRACKER
