Viewing 15 posts - 2,806 through 2,820 (of 3,738 total)
John Mitchell-245523 (6/23/2011)
Back up to a separate drive, across the network to a separate server, or direct to tape - whichever works best for you. But don't have your...
June 26, 2011 at 12:21 pm
Verify that the mapped drive is still available if not re-map.
June 26, 2011 at 12:18 pm
Shubhajyoti Ghosh (6/25/2011)
But I just want to know why it is not working?
Try setting the SqlBulkCopyOptions to FireTriggers in the SqlBulkCopy
constructor.
June 26, 2011 at 12:12 pm
You may want to try and narrow the size of your csv file that you are working with to help identify the problem.
June 25, 2011 at 10:56 am
dji (6/25/2011)
The execution was successful
Sounds like your definition does not match or something?
June 25, 2011 at 10:37 am
I would be interested in seeing the error that you get when importing the csv file using the import wizard.
June 25, 2011 at 9:07 am
clarmatt73 (6/24/2011)
When i run the code the CurrentDb is still set to the old path, is there a way to update the database so that the VBA recognises the new...
June 24, 2011 at 5:46 pm
techzone12 (6/24/2011)
When I go to...
June 24, 2011 at 11:06 am
When you say that you installed the components did that include installing the DTS Designer?
Are you copying the .dtsx files?
June 23, 2011 at 5:00 pm
reefshark (6/23/2011)
I thought the 2008 R2 Express version has a 10GB limit.10.0.2573.0 (X64) is not 2008 R2 Express? I couldn't find any build lists to verify.
Are you connect...
June 23, 2011 at 12:21 pm
reefshark (6/23/2011)
"CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database"
Isn't the the Express version of 2008 R2...
June 23, 2011 at 12:09 pm
When you restart SQL Server it clears the buffers, forces a recompile and recreates TempDB.
Are you noticing a consistent performance gain or is it erratic?
Have you tried running profiler?
June 23, 2011 at 11:30 am
dji (6/23/2011)
The SSIS method would require learning a whole new language by the sounds of things? My only experience with SSIS is through the wizard which offers no options for...
June 23, 2011 at 11:10 am
Jayanth_Kurup (6/23/2011)
SSIS has a for each loop task which can be used to iterate thru as many files as required.
You should consider this option.
MySQL? :w00t:
June 23, 2011 at 10:24 am
dji (6/23/2011)
Using windows7 and IE 8.0, was unable to add an attachment:w00t: Have had to go onto win xp machine to add attachment?
What is the path of the file?
When you...
June 23, 2011 at 9:59 am
Viewing 15 posts - 2,806 through 2,820 (of 3,738 total)