January 16, 2013 at 9:47 am
Both yours and the post above yours were most helpful and looks like I'm on the right track finally... thanks!
January 16, 2013 at 9:54 am
You're welcome. Glad we can help. I actually thought about suggesting using the Import Wizard but Gus already posted it. Either one of them should help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 12:55 pm
I'm glad to see you're not going to copy and paste from Excel. I've found that when doing this, data isn't pasted it as it should be, so I avoid this like the plague. Dates and numeric strings formatted with leading zeros are especially problematic. It'll eventually get you into trouble.
Also, using SSMS's data import is so much faster than just pasting into a table that I can't even tell you. What would take me 20 minutes of waiting for a paste to complete would take a few seconds when using the process formerly known as DTS. There's those darn transaction logs that get hit by lots of pasting...
January 16, 2013 at 6:38 pm
Ed Wagner (1/16/2013)
I'm glad to see you're not going to copy and paste from Excel. I've found that when doing this, data isn't pasted it as it should be, so I avoid this like the plague. Dates and numeric strings formatted with leading zeros are especially problematic. It'll eventually get you into trouble.Also, using SSMS's data import is so much faster than just pasting into a table that I can't even tell you. What would take me 20 minutes of waiting for a paste to complete would take a few seconds when using the process formerly known as DTS. There's those darn transaction logs that get hit by lots of pasting...
It's not just the log.
The "Edit top 200 rows" is a cursor. Check it out in Profiler or a trace/Extended Events.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 17, 2013 at 12:53 am
If you are importing using DTS/Import Export wizard. you might want to Edit the data type and length of the source. Cause thats what might be causing the truncate.
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply