Hello All,

I've solved the problem using access as a "pre-import" tool. My question is "Why should I have to do this?"

I could not pinpoint the error in SQL (I...

Hello All,

I get the number of rows inserted but this does not correspond to that row number in the text file. It almost looks as if the SQL import...

Since I failed at correctly using the bcp sytax to to anything successfully I switched to SSIS. I've designed my package and have set up the connections but I...

All,

Thank you for the suggestions. The issue is though...that it doesn't fail until 773,032!! This is a big "chunk" of data to sort through. Plus if I...

Hello All,

I just wanted to thank everyone for their input to this point. I am able to import the data and query out the pieces I needed. I'm...

Hello All,

Thanks for the suggestions. I have created three views of the data (based on the time frames I generally query). This will suffice for now but I...

You could also check out The Virtual Campus http://www.vtc.com/ . It is $30 per month but contains thousands of training videos on many different subjects....pretty good database...