Viewing 15 posts - 76 through 90 (of 96 total)
Thanks guys. I appreciate the explanation.
pat
November 11, 2010 at 6:21 am
After reading the article I tried running the recommended resource at the bottom of the page, pr_rebuildindexes.sql. After cutting and pasting this into SQL Query Analyzer, I receive numerous errors...
November 11, 2010 at 6:07 am
Gatekeeper,
Thanks. I did not see your post while I continued to work on this issue. You were 100% correct. When i used the full FormatFile the import was successful.
This contradicts...
July 15, 2010 at 8:52 am
Steve,
I have stumbled upon a half a##ed solution. If I first import the whole csv file into a SQL table that has all the rows. Then I do an Insert...
July 15, 2010 at 8:42 am
It seems to me that the formatfile should look more like
9.0
10
1SQLCHAR00","0""
2SQLCHAR00","2TimePoint""
3SQLCHAR00","3rtPrice""
4SQLCHAR00","0""
5SQLCHAR00","0""
6SQLCHAR00","6daPrice""
7SQLCHAR00","0""
8SQLCHAR00","0""
9SQLCHAR00","9versifyId""
10SQLCHAR00"\r"10extermalNodeID""
If I do not include all the columns from the csv file in this definition, SQL server will not know...
July 15, 2010 at 8:36 am
Steve,
Thank you for adding the Openrowset code. I tried it and it did not work. I received the message, "Invalid column number in the Format File c:\Formatfile.txt". I googled Openrowset...
July 15, 2010 at 8:28 am
Changebluesky,
Thanks for the idea. I will be using VB to download them from the FTP site, to loop through the files and to do the Bulk Insert. The only thing...
July 15, 2010 at 4:35 am
I haven't found the complete answer but I wanted to update this post with what I have found.
The following Bulk Insert command will move data from a text file to...
July 14, 2010 at 8:30 pm
Jeff,
Thanks for pointing me in the right direction. It looks like the Format File will do all that I need. I assume if I do not specify a field in...
July 12, 2010 at 2:25 pm
Paul,
I agree that explicit is clearer than implicit. I will reread your post and the reference a couple of times and will hopefully retain some of it.
In practice, I will...
July 2, 2010 at 6:58 am
Just to be complete in my post I should have shown:
Select Cast(2 as decimal(18,6))/cast(3 as Decimal(18,6))) from Table :666666666666666666
pat
July 2, 2010 at 5:39 am
Eugene and Paul,
Thanks for continuing the discussion. I can go back to my previous practice of choosing the smallest data type. I can use 1.0 * in all my divisions...
July 2, 2010 at 5:22 am
Eugene,
Thanks for clearing things up with points 1 and 2.
If you don't mind I would like explore question 3 a bit.
I am a VB programmer. Historically, I have done my...
June 30, 2010 at 10:30 am
Gail,
Thanks for the advice, especially pointing out that the way we are doing it requires an update to the data file. Our problem is a lack of resources.
Tomorrow the...
May 17, 2010 at 9:13 pm
Jason,
Yes, I wasn't clear on that. It is detached. I am trying to attach it (a SQL 2000 database) to a SQLExpress 2008 instance.
pat
May 17, 2010 at 5:05 pm
Viewing 15 posts - 76 through 90 (of 96 total)