Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mickeyj2
  • Order by date
  1. mickeyj2

    Strip Quotes from Flat File in SSIS

    Thanks for your help.
  2. mickeyj2

    Strip Quotes from Flat File in SSIS

    Hi, Ok, here’s my situation. I have a CSV flat file. When you look at it in a text editor, the format is like: "Contact Name","Customer","Adr1","Adr2","Adr3","City","State","Zip","Ctry","Phone","Slsm","Email" In other words, quotes surround all of my data. In SSIS, I have built a package...
  3. mickeyj2

    BULK INSERT Intro

    Hello, I'm back. After many frustrating tries, I think the best thing to do is to use SSIS to create a package, let SSIS clean it, and write the files into the table using a BULK INSERT. I also used a format file to accomplish this. It finally worked on a Friday evening right before I was...
  4. mickeyj2

    BULK INSERT Intro

    Hi gmmastros, Thanks for all of your advice. I did try the followindg: SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]') And after enabling Ad Hoc Distributed Queries, I received this message: Msg...
  5. mickeyj2

    BULK INSERT Intro

    Hmmm.... I guess this is a little over my head. I'm not understanding what I'm looking for. I'm see many "0d" and "0a" fields, but they're not at the end of my line? Why is this so convuluated? Someone ran a CSV file for me, and I haven't modified it at all, but just want to import. And I...
  6. mickeyj2

    BULK INSERT Intro

    Hi, Ok. I should have clarified. I've tried several BULK INSERT statements. At first I had a comma-delimited file and then out of frustration, I tried making a tabbed file. That's where the \t came from. Also initially, my rowterminator was '\n\. So right now, I'm using the following...
  7. mickeyj2

    BULK INSERT Intro

    Hi, Thank you for your comments. A couple of things. I did try importing the data using the import wizard, but it complained about my 11th column (that's the last column that I'm having trouble wtih). I'm copying a sample of my data, and this is dummy data not identifying real people...
  8. mickeyj2

    BULK INSERT Intro

    Oh, by the way, I've seen several posts about quotes around the data. My files don't have any quotes around any of the data. Thanks.
  9. mickeyj2

    BULK INSERT Intro

    Hi All, Can someone clue me in on BULK INSERT? I've used it to create a table of one column, and everything worked fine, but now I have a TXT file of about 11 fields. I've tried importing the data by using this as a comma-delimited CSV file, and I've tried the import by using it as a...
  10. mickeyj2

    Writing a book using Word

    Hi, Good luck on your book. I was once like you and initially turned to Word for many desktop publishing tasks. Mine was creating manuals, etc. I know someone had suggested FrameMaker, but if you're looking for an entire suite, FrameMaker has been replaced with Adobe's InDesign, which is...
  11. mickeyj2

    Flash Movie Won't Load

    It's ok. I got it to load. I used an absolute path, but actually, I shouldn't have to do that. Thanks anyway.
  12. mickeyj2

    Flash Movie Won't Load

    Hi, Ok. I'm very, very new to Flash, though I've been developing for years. But I need to get a movie up and loaded on my website. I created a slideshow in Powerpoint, and then converted it to a .SWF file, which I loaded onto my site. Now in my Coldfusion file, I say the following: <EMBED...
  13. mickeyj2

    Resolving My Search Results

    Hi, I'm creating a search application. I have a file my srchform.cfm and it works fine. It returns results in the template srchresults.cfm. Here's some of the contents of my srchresults.cfm file: <CFSEARCH NAME="search_card" COLLECTION="card"...
  14. mickeyj2

    Viewing Plain Text Emails

    Hi donb01, Thanks for the information. I really appreciate it. I'll try looking at this mail in Outlook as plain text and re-address defaulting my mails to plain text for users who can't read HTML. Thanks again for your help. mickeyj2
  15. mickeyj2

    Viewing Plain Text Emails

    Hi, I'm in the process of creating some automated emails. I want to do it in HTML. In my company, the majority of my colleagues can accept an HTML format, but there's a handful that accept Plain Text only. I want to see how my HTML email will look in Plain Text. I tried using telnet to view...
  16. mickeyj2

    FTP Upload Question - Spending Way Too Much Time

    Hi Jock, Sorry its taken me so long to answer - my computer crashed. Thanks for your help on this. It worked like a charm. I hadn't realized how much I'd forgotten about FTP. Thanks for all of your help. mickeyj2
  17. mickeyj2

    FTP Upload Question - Spending Way Too Much Time

    Hi, I had one more question. I've scheduled a daily run of my batch file from within Windows XP. Is there any way to "dump" the run of that batch file to a log file that I can review, so I'll know exactly how it ran? Thanks for your help. mickeyj2
  18. mickeyj2

    FTP Upload Question - Spending Way Too Much Time

    Hi Jock and longhair, This worked out for me just fine. After I moved the FTP batch to another file and had my DOS batch call it, then it worked out. Thanks for your help. mickeyj2
  19. mickeyj2

    FTP Upload Question - Spending Way Too Much Time

    Hi, Its been a while since I've done straight FTP batch. I'm VERY embarassed to have to ask this question. I'm writing a batch file. The first part of the batch pulls some files down to my local machine. That part works great. Now, I'm trying to add (to the latter half of my batch...
  20. mickeyj2

    hostmysite downtime

    Hi, I've used InfoQuest for years, and it sounds like your clients might be a perfect fit. Check them out at http://www.infoquest.com. I've never had any downtime with them. Let me know how it works for you. Good luck, mickeyj2

Part and Inventory Search

Back
Top