|
|
|
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 Copying packages to another server Posted by JC at 9/30/2004 9:02:02 PM Is this possible. I don't see it as an option. I have some rather involved
transformations. I am moving the processing to another server and would hope
that I could copy the package and then change some of the settings and save
them on the new server. Can I do this?
John Cantley
...more >>
how to change dts owner name Posted by JJ Wang at 9/30/2004 5:12:12 PM hi,
does anyone know how to change a dts packeage's owner name
on sql 2000?
we have individuals that creates dts packages on
production servers, and we would like to change the dts
owner name from the individual accounts into server's own
account name.
many thanks!
JJ...more >>
creating jobs programmatically causes deadlocks Posted by dwaine at 9/30/2004 2:19:01 PM I'm using the sproc below to create jobs(using transaction) in an automated
fashion that will run cmdexecs after a configurable pause. This is
potentially HIGH VOLUME! The sproc is run using the ADO.NET
command.executenonquery method during the processing of text files to
determine what th...more >>
Populating table with data Posted by Joe at 9/30/2004 12:47:07 PM I don't know if this is the right group. If not, please redirect me.
I know how to create a database, complete with tables (CREATE TABLE ...).
What I would like to know is if I know what values need to populate the
various fields in a table, is there a way for me to automatically populate ...more >>
DTS error involving large tables Posted by StephenP at 9/30/2004 11:35:02 AM I have been having problems copying very large table (500,000 records or
more) from a SQL Server 2000 database to a Oracle 9i database. I have been
using DTS wizard to design a very simple data export. The DTS starts out
working fine but usually after 200,000 records, I will receive this err...more >>
disable sql server cache Posted by gerry at 9/30/2004 11:13:45 AM sql server 2000
we have a .net process that creates and executes a DTS package
programatically.
we are having an issue with memory consumption.
both our application's & sql server's memory usage rise with each package
creation and neither fall with the package release.
by using GC.Collect() an...more >>
Executing a DTS package from ASP.NET Posted by Cristiano Franco at 9/30/2004 11:01:03 AM Hi,
I have an web application where the use will trigger a process that has as
one of the steps running a DTS package to load contents of a .txt file to a
table in SQL Server. I have the package created and working fine in SQLServer
(and when I have a windows application as well). But when...more >>
More info on XMLScript usage in DTS? Posted by Fred Morrison at 9/30/2004 6:26:26 AM When I query the MSDN Library and Books Online for
XMLScript, I get only one hit (Adding DTS ActiveX Scripts)
that mentions XMLScript is available for use in ActiveX
script tasks within a DTS package. But no details are
offerred.
Where can I get more detailed information on XMLScript
(U...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Deleting DTS package from Meta Data Services Packages Posted by V at 9/30/2004 3:11:02 AM Hello,
I have a problem removing an old DTS package from the Meta Data Services
Packages in Enterprise Manager. Each time I try to perform a delete from the
client interface the client hangs and refuses to delete the package.
The delete option in the versions window is greyed out so I cann...more >>
Update or Insert Posted by Mark at 9/30/2004 12:43:01 AM
I want to load data from a data csv file into a sql server table. This will
happen on a regualr basis. But everytime we get the csv file it might have
old records t oo. So I want to specify if there is a record in the SQL server
table it should be an update else and insert. How do I go about...more >>
Problem while doing bulk copy Posted by Pradeep Kumar C at 9/29/2004 7:30:34 PM Hi ,
while i am trying to run follwoing bulk copy command
set @x =3D 'bcp "select * from '+@SourceDatabase+'..users where =
datediff(day,'''+CAST(@maxDate as varchar(30))+''',created) > 0 and =
UPPER(howmadeaware)<>''EXISTING CLIENT''" queryout =
\\10.0.0.253\D\SQLServerGenerated\output\int...more >>
DTS password resetting Posted by Tudor Sofron at 9/29/2004 1:40:36 PM Hi all,
can anybody please how to reset passwords for an DTS? I need to edit and run
it...but the former DBA left without giving us the passwords...
Thanks,
Tudor
...more >>
SLX and DTS Posted by Philippe RUELLO at 9/29/2004 11:11:30 AM Hello,
I'm trying to transfer data from a SQL db to a SLX SQL db with DTS. But when
I'm trying to define the DataPumpTask between my MS OLEDB cnx and SLX OLEDB
cnx, I obtain a message Error Hresult : 0x80040e14 without any string to
describe the trouble. For info, here's the definition of my SLX...more >>
SQL float truncation when exporting via DBASE in DTS Posted by ezelasky NO[at]SPAM hotmail.com at 9/29/2004 10:58:48 AM When I export a SQL table with a field that is defined as float(8)
using a dBase5 driver the digits after 5th digit to the right of the
decimal are dropped. Why is this happening? It doesn't happen when I
export to a FoxPro database. Would it be the dBase driver driver? If
so which driver sh...more >>
DTS Copy Database to new database on same server Posted by Edwin at 9/29/2004 10:36:32 AM I'm using DTS to copy a database into a new database thats
on the same server in MS SQL Server 2000.. The database is
about 1.5 gigs... i'm wondering how long should this
take? It's been about 20 minutes now and it's stuck at
22%, its been at 22% for the last 20 minutes.. is this
normal? ...more >>
Exchange to SQL via DTS & Exchange OLE DB Provider Posted by geoff at 9/29/2004 10:19:03 AM When using SQL DTS to connect to Exchange via the Exchange OLE DB Provider,
what is the syntax of the data source. SQL Server 2000 and Exchange Server
2003 are on the same box.
...more >>
Prob in Excel Data importing to SQL Server Posted by Shiv at 9/29/2004 8:17:02 AM Hi,
I am attempting to import data from an Excel spreadsheet into SQL 2000
I have 1 spreadsheet with 6 column headings
ProdID, Customer, Vendor, EffDate, EndDate, FixedPrice
I SQL Table with the same columns
ProdID int
Customer nvarchar
Vendor varchar
EffDate datetime
EndDate datet...more >>
Naming DTS tasks at a "Deeper" level Posted by SqlGuy at 9/29/2004 4:49:48 AM I've got a problem with the logging feature on DTS scripts.
Each task in the log is identified with some sort of generic prefix, and
then a very discriptive suffix: _1, _2, _3 or other such "meaningless"
sufix I have no way to correlate with the specific task. (Why isn't this
attribute shown ...more >>
SQL Compare Database Solution Help needed Posted by Stephen at 9/29/2004 3:21:03 AM I have to write a .Net application which can compare SQL Databases including
things like: -
DB structure, PK's, FK's,
indexes and types of indexes i.e. should be able to detect if the same index
has cascade set on one db and not on another, or unique on one and not the
other,
Constraints, ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |