|
|
|
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 DTS Import text file Posted by Mike P. at 6/28/2004 7:23:34 PM
I have SQL Server 2000 Enterprise Edition with SP3A. I
have set up a DTS job to import Windows 2000 Advanced
Server performance monitor output values from a text file.
Connection1 is a text file: E:\Server_dd_yyyymmdd.txt
Connection2 is a OLE DB Provider Connection for SQL
Server: Pe...more >>
DTS : SqlServer to Oracle, problem Create Destination Table Posted by tristant at 6/28/2004 6:22:24 PM Hi All,
I want to transfer data from SqlServer2000 tables into Oracle 9i.
I use Transform Data Task, when I specify the destination table, table does
not exist yet, and it dts offers to 'Create Destination Table', when I press
Create, the script is :
CREATE TABLE "Product_Temp" (
"KDPROD" CH...more >>
Can't create more than 256 partitions? Posted by FLX at 6/28/2004 5:16:43 PM I designed a partition scheme which will partition one extremely large table
into many partitions (> 256). I want to build a same name view on the top
of all these partions so that I don't need change any code in the current
system. The queries against the original table can still query against ...more >>
Job in a package Posted by Jérémie Gent at 6/28/2004 12:39:55 PM I'm looking for a solution for my Intranet users (ASP website) to execute
jobs on my SQL Server
As I don't know all the possibilities of SQL Server, I had thought I could
do a DTS package, save it as VB source code, compile it in a .exe
application which my ASP page would execute. I've already...more >>
Suppress Package/Job Failure Report? Posted by DHatheway at 6/28/2004 9:47:36 AM I set up a package with a SQL task that may or may not fail (I do a
raiserror if it fails). There's a notfication task dependent on the SQL
task step that will only fire on a failure in the SQL Task.
If the failure path is taken and the notification step works, I consider
this a "success." H...more >>
Error executing a job with SQL Server Agent Posted by Michael Vardinghus at 6/28/2004 9:38:35 AM Does anybody know what to do with this one:
Unable to determine if the owner (xxx) of job xxx has server access reason.
Could not obtain information about Windows NT group/user xxx. SQLSTATE
42000. Error 8198.
The owner of the job is set to the specific user - the user is part of a
windows ...more >>
Error while executing DTS job Posted by haseeb at 6/28/2004 9:28:21 AM Hi all,
I am running a DTS package job which runs on its schedule.
The job truncates the destination table and copies data
from source. The job runs fine most of the times and at
times the job fails with the following error msg in view
job history.
Please help me to resolve this issue.
...more >>
Not returning from errors Posted by Thomas Scheiderich at 6/27/2004 5:07:41 PM I have a package I am trying to move data from a progress database to our
SQL Server 2000 database.
I am getting some field size errors from Progress database, which is
expected. I have the max error count set to 100. I am passing the error
count to an Sql table on completion.
The problem...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Global Variables and SQl Task Posted by Ian Clare at 6/26/2004 4:11:01 PM Have a DTS package that uses a Sequence number off a table to insert records into a database using a incremented global variable.
Have a sql task that performs various other tasks and want to set the global variable from within the SQL task.
The question is, is this possible and how does one d...more >>
dts transaction Posted by news.microsoft.com at 6/25/2004 6:03:02 PM Hi,
I am trying to create a dts package to import about 10 tables from access to
SQL server using the DTS import and export wizard. I saved the dts package
and tried to add a work flow to make sure the person table is inserted first
before the other table. But how can I roll back the entire ...more >>
Help from experienced DTS Gurus Posted by Chumma Dede at 6/25/2004 1:55:08 PM Hi,
We have several large and complex DTS packages for converting from OLTP to
Star schema, and maintaining them on SQL server is becoming quite
cumbersome. Additionaly, we have to change the server/db names and other
parameters for different client installations and we're currently doing this...more >>
Modify DTS Package from Visual Basic Posted by krutyihoriok NO[at]SPAM hotmail.com at 6/25/2004 12:27:51 PM Hello. I'm trying to find out if it is possible for me to create some
sort of a function to automatically modify a DTS package in a given
SQL database. For example, I have 4 MS Access databases containing
tables that I need to modify slightly and pull into one table in an
SQL database. All 4 hav...more >>
VBScript and G.Variables Posted by Nexx at 6/25/2004 10:19:19 AM Greetings everyone,
I have a dts package with a dynamic properties task and the typical
assortment of sql queries, connections, etc... The dynamic properties
task exists to set the properties of various global variables which are
to be passed in from the command line.
Question, can I set one ...more >>
Execute Process Task in dts package Posted by Greg Barnes at 6/25/2004 7:57:16 AM I am having a problem running bat or cmd files in my dts
packages. Whenever I first create a new package which
runs a bat file, the package runs fine. However, if I log
out of Enterprise Manager or schedule to run the package
later, the bat file is never able to run. From what I can
tel...more >>
Automate Importing Daily Performance File into Table Posted by Dan at 6/25/2004 7:48:52 AM
My server has Windows 2000 Advanced Server as operating
system with SQL Server 2000 Enterprise Edition.
I would like to create a SQL Server DTS package to
automate the import of my daily performance monitor file.
My performance monitor file is created daily at 7:00 am
with the followin...more >>
dts loop problem Posted by aengusd at 6/25/2004 1:53:17 AM I've created a loop in a DTS, which retrieves connection information from a SQL table and then (is supposed to) populates tables in different Databases.
The loop works, but it keeps updating the same DB, rather than updating each of the individual DBs. The connection information seems to be updat...more >>
FTP Task : Where to specify the ftp site ? Posted by Newbie at 6/24/2004 11:55:28 PM I want to send a text file over to a ftp server via ftp.
so I use add the File Transfer Protocol Task and I see
that it only allows me to specify the source (which I
change to Directory since the text file is on my pc)
but I don't know how I could enter the IP address of the
ftp server ?...more >>
xp_cmdshell Posted by Paul at 6/24/2004 8:46:57 PM Hi, When I run xp_cmdshell in an ActiveX script that is
executed within a DTS package, I get the following error...
"Type Mismatch : 'xp_cmdshell' "
The below line is what I execute ....
xp_cmdshell 'open c:\test\blah.bat', no_output
I have tried different variants of the above to no a...more >>
Help desperately needed - UserDefinedFunctions with parameters in ExecuteSQLTask Posted by Andreas.Bretl at 6/24/2004 3:54:30 PM Hi all,
I try to implement the following in a DTS:
Executing a SQL-Task like the following:
SELECT ContactExists FROM BrainBase.DBO.IDP_CheckContactID(?)
(Table Function)
OR
SELECT BrainBase.DBO.IDP_CheckContactID(?)
(Function)
I want to write the result into a Glob...more >>
Processing AS task Posted by Michael Vardinghus at 6/24/2004 2:35:33 PM How come it doesn't tell me if something goes wroing in AS ? The package
just looks as is it is till running.
When doing the same thing directly in AS i get error information.
...more >>
Programmatically decrypt stored procedure? Posted by FLX at 6/24/2004 2:32:45 PM Does anyone know how to programmatically decrypt the stored procedures (In
SQL Server 2000) encryted with the "With Encryption" clause?
Thanks a lot,
Lixin
...more >>
Cancelling.. Posted by Michael Vardinghus at 6/24/2004 2:01:30 PM SQL / AS is great - but one thing annoys me - if I want to cancel a dts task
it seems as if it never works...it persists on doing a package till the end
and before starting a new package it will cancel and sometimes it just
doesn't get back when cancelled.
Is there someway to make this better ...more >>
Column name "X" was not found Posted by laura.guanchiale NO[at]SPAM unidos.com.ar at 6/24/2004 5:34:01 AM Hi ! When I execute a DTS from Enterprise Manager the package reported
"Column name Col00x was not found". This error happens when I change
the source TXT File. Is there a way to configure a "dynamically"
mappings cloumns ?
Thanks a lot...more >>
Data Pump Task with stored proc won't work Posted by pipo1 NO[at]SPAM ilse.nl at 6/24/2004 4:50:14 AM I have built a stored procedure that returns a result set I want to
use in DTS to populate a table, but on the Transformations tab I see
no Source columns?
The procedure uses data from several tables to populate a temp table,
which is then joined to other tables. Nothing very fancy...
On th...more >>
import a text file to SQL server Posted by CR at 6/24/2004 2:18:01 AM I have typed to import a text file to SQL server 2000 with MDAC2.8 installed.
The text file is with different record width in each row.
I use the 'add connection' and choose the data source 'Text File (Source) and my file.
In the text file properties, Fixed field, file type: ANSI, Row delimiter:{...more >>
Lost package info when we use Posted by Bernard at 6/23/2004 2:09:01 PM When i use this code
Dim objLotDts As New DTS.Package2
objLotDts.LoadFromStorageFile strNomLotDTS
objLotDts.SaveToStorageFile vstrNomFichierDTS
Set objLotDts = Nothing
I lost the comment put in the DTS package and all the task in this...more >>
Check Connection Posted by Gary Spence at 6/23/2004 2:30:02 AM Hello People,
I would like to check that I have a valid connection between SQL Server and an AS 400 (200 miles away) before I execute a DTS Package, an ActiveX script would be great, and also how to terminte the package if the connection is down, I'll be executing the package every 10 mins.
Much...more >>
Check connection to db Posted by YRAG1 at 6/23/2004 2:18:01 AM Hello People,
Can any one tell me how to check if the connection between SQLServer and an AS400 (200 miles away) is enabled using a DTS Package, I want to make sure the connection is there before I execute the package, an ActiveX script would be great, also how can I exit from a DTS package if the ...more >>
DTS Problem In Importing from Textfile Posted by vins at 6/22/2004 10:43:02 PM Hi.
I have Sql Server 2000 With Sql SP3 on Win2K.
I am Importing Data from Textfiles to a table which has a column of Varchar(512)
Thru DTS Package in VB6 but DTS Truncates the Column to 256 Charcters during import.
can anyone help me as this is urgent. I have a deadline to meet....more >>
DTS Performance Monitor Values to a table Posted by Pete at 6/22/2004 8:32:59 PM My server operating system is Windows 2000 Advanced
server with SQL Server 2000 Enterprise.
I have about 30 performance counters that collects
samples every minute on the server. I would like to
automated a system that will copy the values to a SQL
Server database table daily.
Please ...more >>
DTS as scheduled job and Security Authorization. Posted by jkiffer at 6/22/2004 1:45:02 PM I'm looking for some help in the best approach for the following solution. I need to do the following:
1. Create a DTS Package to run as a scheduled job.
2. The Package must do the following:
a. drop several tables on a local SQL Server database
b. create tables and copy their d...more >>
DTS Execution multiple servers dtsrun Posted by Jim Israel at 6/22/2004 12:59:10 PM How do you specify a "local" server without calling the
server by name. (Dynamic picture can not use a package)
Example: dtsrun /s GenericLocalName /n dtsrun...more >>
Length of String global variables Posted by Jamie at 6/22/2004 9:21:01 AM Hello,
Does anyone know the maximum length of global variable of type "String" in DTS.
I have a string (greater than 180) that works its way out through a stored procedure hierarchy, back out into DTS and then inserted into a table. The string ends up length 180 and the only way I can envisage t...more >>
Just copy a table structure or structure and data to another database Posted by Barry G. Sumpter at 6/22/2004 7:48:01 AM Hi all,
I just want to copy a table structure or a table structure and data to
another database.
Whats the easiest way to do it?
I've been just copy/pasting in enterprise manager.
Thanks,
baz
...more >>
DTS Transform Task Crashing out Posted by Siobhan at 6/22/2004 3:44:01 AM Hi
On my task I enter in the SQL query as the source and if I do preview, the correct data is shown. For my destination I have a .txt file, but when I try to 'Populate from Source' and 'Execute' Nothing happens. The column names in the Destination Box remain blank.. If I try to click on the 'D...more >>
DTS and System DSN Posted by manu_l63 at 6/22/2004 2:58:02 AM hi all,
I manupule a lot of excel files, so i ll make a DTS package. At this time my package it s ok, it make an delete of my table then copy in my excel file. I create a System DSN named test for excel in ODBC. When i ll try to use this i ve got error 0x80040e4e. Someone can help me please?...more >>
System DSN Posted by Manuel at 6/22/2004 2:52:01 AM Hi all,
I ll make a DTS pacakge. My package delete my table, then copy an excel file in it.
When I try to make the samething with a System DNS (because i must manupulate lots of excel files), it s wrong and i ve got error 0x80040e4e. Someone can help me?...more >>
execute DTS Package from a VB script Posted by alhoffmann NO[at]SPAM free.fr at 6/22/2004 12:34:16 AM Hello!
I'm trying to execute my VB Package from a VB script. My code is :
dtsPackage.LoadFromSQLServer _
ServerName:=gs_ServerName, _
ServerUserName:=gs_UserName, _
ServerPassword:=gs_Password, _
PackageName:=gs_PackageName
But I cannot find what is the gs_UserName and the gs_Password....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |