| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Best method for daily syncing of databases from various sources? Posted by Yorro at 10/31/2005 8:11:45 PM Greetings,
I have a newbie question. I've been reading methods of syncing a Foxpro
DB to a MSSQL server daily. Each record luckily contains a last
modified date so it may make it easier.
DTS seems like the way to go but I wish to perform more advanced logic
mainly:
* Sync only new r...more >>
Log Shipping or Replication Posted by Gabe Matteson at 10/31/2005 4:46:34 PM Which would you recommend to setup as a failover database server? (We do not
have the ability right now to setup a sql cluster). What is the difference
between log shipping and database replication? Pros/Cons? Thanks.
- Gabe
...more >>
DTS Scheduled Job Posted by Kibagami23 at 10/31/2005 10:43:15 AM I have a scheduled job to run daily at 6:00 am, but it only executes
the first day after scheduled after that it stays on "Executing Step 1"
and since the job doesn't finish it doesn't start the day after that,
how can stop the job after it completes, because the job does
everything it supposed ...more >>
Record Length of DTS text file Posted by Stan at 10/31/2005 7:05:07 AM Is there a way to force a DTS .txt file to always be a set length? I have
fixed length fields and the customer needs the record to be 80 characters.
Do I need to create a 'dummy' variable to be a filler a blank spaces?
Thanks
--
Stan Gosselin...more >>
Import from Excel 2000 to SQL Server 2000 Posted by KKSMS at 10/31/2005 6:08:34 AM Is there a tool or code which I can use to import multiple Excel 2000
Spreadsheets data into SQL Server 2000 tables.
Earlier I had been using EM data import feature to import the data one
excel spreadsheet at a time. But now am at a point where there are
plenty of Excel spreadsheets (to impor...more >>
File splitter Posted by karenmiddleol NO[at]SPAM yahoo.com at 10/31/2005 4:22:24 AM I have a large text file but a process that is external to DTS can
process only 10000 records in the text file.
So before calling this external program I want a file if it greater
than 10000 records to be split into multiple files of size 10000
records each.
Please advise the best way to sp...more >>
SSIS Connection Posted by Michael Tissington at 10/29/2005 10:52:15 AM (not sure the best news group to post this)
I'm trying to create a new OLEDB connection in the RTM version of SQL 2005
I get back the following error
The connection manager 'OLEDB' is not properly installed on this computer.
(Microsoft.DataTransformationServices.Design)
This is a clean...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |