Viewing 15 posts - 16 through 30 (of 89 total)
R.P.Rozema (12/13/2011)
http://www.sqlservercentral.com/Forums/Topic1168980-392-1.aspx#bm1169083
I have been on the link and come up with this, my problem is that I get an error which I dont understand would affect things...
Error
Msg 2627, Level 14,...
January 9, 2012 at 8:51 am
Thanks for the reply, I've googled it and found a couple of tutorials which have been very helpful. Testing it on test data seems to be what I am looking...
October 27, 2011 at 8:29 am
steveb. (9/26/2011)
October 26, 2011 at 3:39 pm
jez.lisle (8/11/2011)
Mark-101232 (8/11/2011)
Without sample data it's hard to tell, but alsoSessionSlotDate = DATEADD(dd,1,SessionSlotDate)
is always false - typo?
I've attached sample data
Table scripts
CREATE TABLE TestData (
SessionID numeric(10, 0) NOT NULL
,SessionSlotDate...
August 11, 2011 at 8:36 am
Mark-101232 (8/11/2011)
Without sample data it's hard to tell, but alsoSessionSlotDate = DATEADD(dd,1,SessionSlotDate)
is always false - typo?
I've attached sample data
August 11, 2011 at 7:55 am
Ninja's_RGR'us (8/2/2011)
Missing indexes are contained in the actual plan.
If it "only" takes 55 minutes to run just...
August 2, 2011 at 3:32 pm
All, Thanks for the help and advice... erm where to start with the replies 🙂
I know you all are doing this in your free time and very grateful you took...
August 2, 2011 at 2:19 pm
GilaMonster (7/25/2011)
Nolock means potentially incorrect data. Not just dirty reads but also duplicate rows and missed rows. If those reports just have to be mostly accurate...
July 25, 2011 at 5:00 am
John Mitchell-245523 (7/25/2011)
July 25, 2011 at 4:48 am
GSquared (3/29/2011)
You're probably missing the Office 2007 data providers, based on the error.They can be found at: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
Thanks, I'll download and install this and see what happens.
March 30, 2011 at 1:36 am
LutzM (3/29/2011)
Is it possible the Excel file is still open (= in use by another application)?
Thanks for the reply but it wasnt open, the file was a copy into a...
March 30, 2011 at 1:35 am
I have been googling Bulk Inserts and found this below... I have tried and it seems to work very well at the moment.
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
Thanks for all the...
October 28, 2010 at 6:53 am
Brandie Tarvin (10/28/2010)
Jez,So you'd be doing this manually instead of scheduled as an automatic job?
Have you tried the Import / Export Wizard? It can import flat files.
Where I'm working I...
October 28, 2010 at 6:16 am
Ivan Mohapatra (10/27/2010)
The Meannig Of BCP is Bulk Copy Program ,Are u using SQlcmd or powershell for bulk insert ?
I would be using SSMS to run this
October 28, 2010 at 4:35 am
Nope... I mean you can if you want but BULK INSERT may be a better option. It's very similar to BCP except that it doesn't require the use of xp_CmdShell....
October 27, 2010 at 4:32 pm
Viewing 15 posts - 16 through 30 (of 89 total)