|
|
|
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 How to run my Curser more faster? Posted by raj at 11/28/2004 4:13:02 PM I have a stored procedure written for number of updates, inserts to the
database. This stored procedure takes too long to run. I have created few
indexes around few tables, but the response time is not that defferent.
THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
...more >>
Export data to Excel using DTS within ASP Posted by X. Zhang at 11/26/2004 9:05:03 AM I tried to export data from SQL Server to a Excel file within ASP. I use
DTSPackage object library V2.0. I know that it can connection to a Excel file
using the following code in VB. But I got problem within ASP. The error shows
up while my ASP running: "Microsoft VBScript rnntiom error: Objec...more >>
create a DTS package that run for each Table/Query row Posted by clickout c at 11/26/2004 8:20:03 AM
Hi all,
i'll try to explain my problem in the best way!
I'd like to create a DTS package that make a spreadsheet file where each
sheet represents an ubication of objects and contains the list of
objects for that ubication.
In order to obtain this I'm thinking to run 2 queries, the firs...more >>
How to FTP via VPN to sites with real adresses on different IP's ? Posted by Jason Robertson at 11/25/2004 5:41:36 PM Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites u...more >>
How to FTP a Text file from DTS Posted by Marinus Willemstijn at 11/25/2004 9:37:29 AM I have sucessfully created packages that can FTP a text file form a server
and tehn import the data to SQL. Now I want to export data to a Text file
and then FTP it to another Server. There is no FTP task then can ftp to
another Unix Server ftp:/xxxx. Am I missing the obvious?
Thanks for any h...more >>
Problem importing data with SQL Posted by (powerpoint NO[at]SPAM powerpoint.com.mt) at 11/25/2004 9:35:43 AM I have a problem importing data with SQL. I want to transfer data from one SQL server to another. Apparently I only managed to transfer data when the new table is empty. I am choosing Append data to existing table but this is not working for me.
What am I doing wrong?
*************************...more >>
Help with importing data Posted by Al at 11/25/2004 4:29:01 AM I am trying to import data from MSAccess. when I choose the data source and
enter the userID and Password I get the following error:
***************************************************
Error Source:Microsoft Jet Database Engine
Error Description:Cannot start your application. the workgroup info...more >>
delete existing connections within DTS Posted by PPega at 11/25/2004 3:39:03 AM Does anybody know how I can delete existing connections within DTS...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Uplaoding excel file into SQL database Posted by sangeetha saravanan at 11/25/2004 2:00:17 AM
Hi,
How to upload data from an excel sheet into SQL database? We are using
ASP.Net Webmatrix and C# as backend.
Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
browse for file Posted by Andre at 11/24/2004 10:54:55 AM I'm writing a dts package that imports a file. I want to allow my user to
browse to the file, but can't figure out how. Any suggestions?
Thanks, Andre
...more >>
Deligation of DTS Pakages? Posted by Baldini at 11/24/2004 10:01:02 AM Hi.
Some facts first:
Win2003 64-bit and SQL2000 64 bit on 3 Cluster nodes
Q:
I have to do Deligation of DTS Pakages to the Developers without giving them
sa rights. I have read the the following pages:
http://eddorre.com/comments.aspx?post_id=204
http://www.sqldts.com/default.aspx?212 ( how...more >>
Querying Oracle... Posted by Michael Vardinghus at 11/23/2004 9:35:18 PM .....is done best how ?
Have heard of Toad...or perhaps linked server and then use query analyzer ?
But this way I cannot get a list of tables on the Oracle database ?
And second (or third..) I need to have an Oracle client on the SQL Server
that needs to get data from Oracle ? Not just an ...more >>
Inremental Update in DTS Posted by Muhammad Mansoor at 11/23/2004 6:51:38 PM Hi All,
Can any tell me how can i plan only get the rows that have been updated only
after the last DTS Process.
Thanks,
Mansoor...more >>
Package.Execute code no longer works in Yukon Posted by jimd at 11/23/2004 3:49:04 PM In SQL2000 I can execute a DTS package with this code just fine
DTS.Package2Class test = new DTS.Package2Class();
object pVarPersistStgOfHost = null;
test.LoadFromSQLServer("myServer",null,null,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,"myPackage",ref
pVarPe...more >>
Import and Schedule DTS on MSDE Posted by inquisite at 11/23/2004 3:11:06 PM I have .dts file from another sql server. I would like to import and install
this file as a DTS package on MSDE and schedule it to run periodically.
How do I do this in MSDE 2000....more >>
Problem in runing job Posted by Mariame at 11/23/2004 12:21:52 PM Hi everyone
i have a package that have two tasks if the first one failed , it goes to
the second task
when i execute the package, it run succefully
but when i schedule it, the job take hours & doesent failed neither
successed , it stay runing so i stop it.
i repeat it many time & still the j...more >>
DTS Error - Data too large for specified buffer size Posted by Scott Natwick at 11/23/2004 10:55:54 AM I'm trying to import data into my table and I'm received an error message
that I've been unable to resolve.
The message is:
Error Source: Microsoft Transformation Services (DTS) Data Pump
Error Description: Data for source column 3 ("column_name") is too large for
the specified buffer size....more >>
Cannot Get Pass String Limitations In DTS Posted by Jamie Carper at 11/23/2004 8:21:02 AM I am getting burned in every direction I take to get around this problem.
I have a loop in a Stored Procedure that reads records from a table to build
the SQL string to create the structure of another table. In this loop I am
concantinating the field names together.
Doing this I CANNOT ex...more >>
SQL2K DTS Connection Busy with the results from another command Posted by mrsifteruk at 11/23/2004 1:59:12 AM ?I have a dts package which is run once per day and will fail on 1in6
attempts at execution with the above error. It is running on a dual proc
Win2000 Server, I have been unable to recreate it on a single proc dev
machine.
Is the issue related to the package stucture (we are using multiple ...more >>
How do I get dts to assign a value inserted by a procdure in a temp table to a global variable. Posted by ajayz90 NO[at]SPAM hotmail.com at 11/22/2004 2:51:15 PM I have a stored procedure as follows :-
Create Procedure GetNewYear_mnth
as
Declare @OldYear int,
@OldMonth int,
@NewYear int,
@NewMonth int
select @Oldyear=max(uc_year_num) from tprocess_control
select @OldMonth=max(UC_MNTH_NUM ) from tprocess_control where
uc_year_num=@OldY...more >>
migrate data between servers /newbie, help appreciated Posted by mark_s_nospam NO[at]SPAM ev1.net at 11/22/2004 1:04:35 PM i have an existing sql database with data and i'm trying to migrate the
data to another empty sql database. our software's been updated and the
new database's schema's been changed. i want our existing data inserted
into the new database. i've tried to use dts but am having problems.
first try...more >>
DTS executing single scheduled task multiple times on same day Posted by Dermot Grady at 11/22/2004 11:06:20 AM I have a DTS job that is scheduled to run once a day at 5PM. The job
invokes a couple of batch files which in turn execute a java application
and periodically I am seeing from the logs that the job appears to be
executed multiple times on the same day -- usually within a couples of
seconds ...more >>
Incremental export best practice? Posted by obesityrules NO[at]SPAM gmx.li at 11/22/2004 5:33:36 AM Hi,
I have several dts packages which I want to set from "export all
records" to incremental export. I need to export these records once an
hour, so my first idea is to modify the select statement to only
include the records from the last hour, but, when the server misses a
turn for some reas...more >>
Import data from multiple acces db Posted by Import data from multiple acces db at 11/22/2004 1:49:07 AM Hi , i need an help .
I need to import data from database access to sql server database , and this
is not a problem . The really problem is that the database access is
variable .
My idea is to insert database location on an sql server table and use this
to change dynamically datasource on my...more >>
How to import text files using a wildcard in the filename Posted by Art VanDelay at 11/22/2004 1:36:59 AM I am trying to import IIS logs using a DTS package. I have everything
working, except I cannot figure out how to tell it to do al the logs in a
directory, instead of a specific filename.
Also what would be the best way to make sure it doesnt import duplicate into
the database? I dont see a ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |