|
|
|
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 performance / lock problems... Posted by Jéjé at 10/31/2004 10:45:12 PM Hi,
I've a strange behavior on my server.
I've a lot of packages to execute. (I've 1 big package which execute all
other packages, near 80 to execute)
A day all works fine, and the next execution the same package on the same
data takes 10 more times !
Normally in 1hour all is done.
actu...more >>
CSV File to database question Posted by ebferro at 10/31/2004 3:58:01 AM I've got a .csv file named proddata.txt that I'd like to import into a SQL
server table entitled production. I'm confused as to how to do this. Is
there some information somewhere that would explain how to set up the
datasource and do the import, etc?
Thanks in advance....more >>
Send Email Task Posted by Sa at 10/29/2004 6:46:52 PM Hello,
I am new to DTS. If I want to use the "Send Email Task", it requires the
"MAPI". May I know where I can download the "MAPI"? Thanks a lot.
Sa
...more >>
Change DTS Package Owner without being in Sysadmin Role Posted by carlos NO[at]SPAM eddorre.com at 10/29/2004 4:42:44 PM I've seen this question around the newsgroups so I thought that I
would post my soltuion to it. The undocumented stored procedure
sp_reassign_dtspackageowner works fine if you are in the System
Administrator server role but it's not very good for allowing, say,
developers to change the owner of ...more >>
send email task again!!! Posted by Ed at 10/29/2004 2:23:06 PM Hi,
I installed a SQL SERVER Evaluation version at home and I have a Comast
Cabel Internet Connection. and for sure, I have a email account in my MS
Outlook.
However, I am not able to use xp_sendmail command?
Am i missing something?
Thanks
Ed...more >>
Format File Error?? Posted by Steve at 10/29/2004 1:48:01 PM
Hi,
I have to import a data file into my table. My table has 4 columns & the
datafile has 3 columns. I am using the following format file with fixed
length.
7.0
3
1 SQLCHAR 0 5 "" 1 order_number
2 SQLCHAR 0 7 "" 2 item_number
3 SQLCHAR 0 15 "" 3 type
4 SQLCHAR 0 0 "\r\n" 0 info_...more >>
DTS a read only DB Posted by Sammy at 10/29/2004 12:20:28 PM Hi I am using two servers with sql 2000 I have being
trying to dts a read only database into a another database
with the recreate all objects.I have being able to copy
other databases but this one keeps failing. Do you know if
there is a problem using DTS on a read only DB.
Thanks for any...more >>
Moving a access97 database to sql server 2000 version Posted by Jack at 10/29/2004 11:58:05 AM Hi,
I need to move a access 97 database to sql server 2000. What is the best way
to achieve this? Is there any upsizing wizard for the above verisons. Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help me about Data Driven Query Task Posted by LoiseauBien at 10/29/2004 9:50:54 AM Hi,everybody!
I want to transmit the source data of SQL SERVER 2000 to other SQL SERVER
2000 database server by Data Driven Query Task every 10 minutes.
Because the source data will be modified by data-collector at any moment, i
want to use Data Driven Query Task function to transfer the change...more >>
How To Transfer Data from SQLServer2000 to Oracle 9i Posted by Rowthri via SQLMonster.com at 10/29/2004 5:57:08 AM Hi
i want to move a set of tables into sqlserver2k to oracle
is it possible to using DTS package? but i want to using dts thro a
stored procedure how could i use dts package in stored procedure?
tell me
Regards
Rowthri
*****************************************
* This message was poste...more >>
How to read data from a cube modify and save it back Posted by karenmiddleol NO[at]SPAM yahoo.com at 10/29/2004 5:36:01 AM I have a cube which as some data and now I need to modify the data in
the cube based on some business rules and write the data back.
Can you please give me ideas what is the best way I can do it through
a DTS package.
Thanks
Karen...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |