|
|
|
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 Recommend a book on *writing* your own DTS? Posted by stevesusenet NO[at]SPAM yahoo.com at 4/7/2004 5:29:44 PM Hi;
Can anyone recommend a book on how to code your own DTS?
Thanks in advance
Steve...more >>
Data Driven Query - Milliseconds Posted by MS User at 4/7/2004 3:07:54 PM DTS
Transferring data from one table to another using 'Data Driven Query' task
and transformations in VB script with
DTSDestination("MyDate) = DTSSource("MyDate")
both fields are with datatype 'DATETIME'
After the transfer, I noticed - Destination table field (MyDate) is WITHOUT
millisec...more >>
DTS Creating Steps/Tasks and precendence Posted by Edward Hunter at 4/7/2004 12:30:51 PM Well I've done it now.
I've gone and used activeX to create a SQLCopyObjects task, because I
wanted to have full dynamic control over the properties of that task
including objects to be copied, flags, etc.
That part worked GREAT, the tasks and steps are visible in disconnected
edit, and the...more >>
Error attempting to execute a DTS package from an ADP Posted by nygard NO[at]SPAM mr.net at 4/7/2004 11:46:30 AM Hope someone knows the answer to this. I have looked at several other
similar postings as well as the Microsoft web site and I'm at my wits
end. I'm simply trying to transfer data from a SQL table to an Excel
spreadsheet. Here is the error:
"The Microsoft Jet database engine could not find th...more >>
Calling DTS packages from .Net Posted by marc at 4/7/2004 11:28:20 AM Hi,
I have a dts package which calls a win32 process.
when i call that dts package from a .Net client it tries to run the process
on the client and not on the server
how do I get the process running on the server.
thanks
Marc
...more >>
Import From TAB File Posted by Keith at 4/7/2004 10:03:49 AM I am trying to import data into a table in my database using DTS.
The table (SYS_DD_SIC_Codes) has the following structure:
[SIC_ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[SIC_Code] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SIC_80] [varchar] (50) COLLATE SQL_L...more >>
How do I get month NAME from a date? Posted by Maria at 4/7/2004 9:56:24 AM Not sure if this is the right forum for this, but I'm trying to extract the
month name (e.g. April) from a date in SQLServer. I know I can use DatePart
to get the month number. Is there an easy way to get the name, or do I need
to write code to convert?
Thanks
...more >>
Peformance Question (DTS Import Package) Posted by JN at 4/7/2004 9:31:06 AM Need your expert or experienced opinion and/or suggestions regarding performance tuning an import package. What's the best sourcing option? CSV or SQL Server views with INNER JOINs? If SQL Server views used with multiple inner joins, what's the best way to structure or design to get the best perform...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error when I setup the DTS import wizard Posted by new at 4/7/2004 9:02:23 AM ERROR:
The application or DLL c:\WINDOWS\SYSTEM32\MSDART.DLL is
not a valid windows image. Please check this against your
installation diskette
Thanks any help...more >>
scheduling DTS fails with sa rights Posted by kralemann.r NO[at]SPAM bex.battenfeld.com at 4/7/2004 4:31:28 AM Hallo to all,
I hope the SQL and DTS experts can help me.
I have problems with sheduling a small script copy data from Sql2000
to a flat txt-file.
When executing it in SEM on a different PC it works fine
when sheduling it on the sql server it fails with error 208.
I read a lot about this in t...more >>
DTS to run other DTS's Posted by Chris at 4/7/2004 3:40:54 AM I have created 23 DTS packages to transfer data from an other database
into SQL server. Rather than schedule each of these I would like to
create one more package that runs all the others.
Is this possible and if so how do I set it up.
Thanks
Chris
North Cotswold Computing
*** Sent vi...more >>
Using DTS to export data to textfile Posted by ohahaahr NO[at]SPAM hotmail.com at 4/7/2004 2:40:25 AM Hi !
I want to export data from a very big table on my SQL-server, to a
texfile, using DTS. The job is running every night.
The table contains 1.000.000 records, and i only want to export the
records that have been added to the table, since the last export.
Therefore i have a field (field3) t...more >>
DTS - SP from a client connection Posted by Arun at 4/6/2004 1:23:37 PM Hi,
When I execute an SP in a connection defined on a remote server from my
machine, it runs locally on my machine.
I am confused - shouldnt the sp run on that server with my machine as the
client?
...more >>
Inserting New Records Posted by Brennan at 4/6/2004 12:34:30 PM Hello:
I have a DTS package that moves some tables from a
production database to a reporting database. The tables
all have primary keys.
I do not want duplicate records in my destination tables
but when my DTS package runs, it just stops when it
reaches a value that already exists in ...more >>
Yet Another 'Execution was Canceled by User' Problem Posted by dirkStone NO[at]SPAM excite.com at 4/6/2004 11:37:53 AM This is a non-VBscript issue.
I have a package (PACK1) which has two tasks.
The first is a single transform data task that copies rows between two
identical tables. The transformations are 3 copy column type.
The second task is an execute sql task that truncates the 2nd table.
The workf...more >>
Custom task error handling Posted by gauss9 NO[at]SPAM hotmail.com at 4/6/2004 11:34:26 AM Hello,
I have a strange problem with my error handling.
I've started out with code found in the SQL Server 2000 DTS book.
The error handler looks like this:
-------
EH:
'Bubble any errors to the package eventsink
If Not pPackageEvents Is Nothing Then
pPackageEvents.On...more >>
Passing values to Variables in DTS Posted by JN at 4/6/2004 11:06:05 AM Hello
I am using SQL Server 2000
In my Transform Data Task Properties' Source tab of my DTS package, I have a SQL Query to get the SOURCE data, which is filtered by time period (begin date - end date). In the Gobal Variable tab of package properties, I have two variables defined like: BeginDate ...more >>
Programmatically connect to a DSN Posted by hngo01 NO[at]SPAM hotmail.com at 4/6/2004 9:01:24 AM Can I Programmatically connect to DSN in SQL 2k? If yes,
how to do that?...more >>
Create Send Mail Task Error: Initialization of MAPI failed Posted by Matt at 4/5/2004 6:11:59 PM When I attempted to create "Send Mail Task" in DTS, it pops up a package
error dialog:
Error Source: Microsoft Data Transformation Services (DTS) Package.
Error Description: Initialization of MAPI failed. Please make sure that you
have messaging services installed on this system.
Any ideas?...more >>
Urgent: again, ActiveX component can't create object, for a Job Posted by Mihaela M. at 4/5/2004 5:57:31 PM Hello again.
I've created a DTS, which creates an object , like this:
Set enobj=CreateObject("encrypt.encr")
I execute the DTS from Enterprise Manager, from the server, and it works.
Then, I set a schedule for the DTS, and a new job was generated for the DTS.
But when I try to execute the...more >>
Backing up DTS packages? Posted by Kim Noer at 4/5/2004 4:37:52 PM Hi there...
Quick question - how do I backup the packages I've created?
--
I doubt, therefore I might be.
...more >>
Urgent: ActiveX component can't create object in DTS Posted by Mihaela M. at 4/5/2004 3:23:28 PM I built a DTS package, which contains just one ActiveX Script Task
(VBScript).
In this script I have to create an object, used for crypting/decrypting
strings:
Set enobj=CreateObject("encrypt.encr")
This object is a DLL registered on the server.
I tested the script into an ASP page, it w...more >>
.NET & DTS FTP Posted by marc at 4/5/2004 3:16:28 PM Hi,
I have a DTS package that imports a file into folder d:\ftp\ thats runs OK.
If I run package in an .Net app (on an other machine!!!) I get the message
"Folder D:\ftp\ does not exist or is not accesible on destination."
What is wrong?
thanks
Marc
...more >>
DTS - Append and Update Posted by Paige at 4/5/2004 12:35:32 PM Greetings. I have a situation that I would like help with.
I have created a DTS to pull data from one table to
another. To help with my scenario, here is part of my
table structure
Table1 - (USERID, YEAR, FAMILYID, DELETED, (other fields))
PK - USERID, YEAR
Table2 - (USERID, YEAR, FAM...more >>
Problems running a scheduled DTS package Posted by slambert007 at 4/5/2004 12:16:04 PM
I have a DTS package that calls TurboFTP and FTPs a file. The package runs properly if I run it from DTS. The package is owned by a domain account, SQLAdmin, which is a member of the Domain Administrators. The owner of the scheduled job is the same domain account, SQLAdmin. Both SQL Server and ...more >>
Update files based using values from another file Posted by Dave Williams at 4/5/2004 10:02:21 AM I'm fairly new at DTS. I have a customer file with a field for turnover in
it plus a second file with turnover figures in it for each customer. For
each customer I want to update the turnover field linking the two files on
customerID.
What's the best way to do this?
Thanks - Dave
...more >>
Using DTS for INSERT and UPDATE Posted by D.J. at 4/5/2004 9:47:41 AM Hi there,
I'm having some trouble in finding out if can I use SQL DTS to perform
UPDATE statements onto my tables.
The environment is something like this: I have an Access Database and a
SQL Server database. It has only one table. And they're exactly the same
with the following struct...more >>
MSSQL Not releasing memory Posted by Stephen J Bement at 4/5/2004 9:28:00 AM I am running a DTS package via dtspkg.DLL objects in VB6. The package
executes all 19 Steps (38 Tasks) correctly but the SQL Server retains >200MB
of RAM after executing and consumes >500MB Swap Disk space. This brings the
system to a near stand still. Is there any way to tell SQL Server to 'writ...more >>
dts creates a single quote in integer field in excel file Posted by anonymus at 4/5/2004 8:56:03 AM Hi
I have adts pkg executes a simple query from a tbl it returns an integer and a varchar field and stores the result set in an xls file. First time when I created the pkg it creates the result set correct in xls file. I deleted the resulted rows in xls file and saved the file and ran the pkg agai...more >>
Urgent....globale variables... Posted by Michael Vardinghus at 4/5/2004 2:21:01 AM Just finishing off something and made an adjustment regarding global variables - but in a
execute sql statement i cannot seem to be able to use the global variable in an SET statement
Is this true - can it only be used directly in a where statement and not as part of a variable
\Michael Vardin...more >>
Package calling another package Posted by Michael Vardinghus at 4/4/2004 2:46:16 PM Is there some way I can get the "father"-package to automatically detect
changes in the "son"-package and update
the link ?
When changin something i have to open the father-package and point to the
son-package again.
And another thing ... what are the pro's and con's of saving packages to
...more >>
send emails via DTS? Posted by Matt at 4/3/2004 10:32:22 PM If I have emails stored in a table, it is possible for DTS to schedule the
task to send out those emails?? Some people told me to use DTS for
scheduling jobs?
Please advise. Thanks!!
...more >>
Changing DTS Package Properties Posted by Roy Goldhammer at 4/3/2004 2:39:33 PM Hello there
I've belt DTS package that import data from access file
On the DTS i gave path to the access file.
Is there a way to change the path of the Access connection on the DTS
package befure i execute it?
...more >>
Executing a DTS from another DTS... Posted by Andreas Terzis at 4/3/2004 3:02:31 AM Hi there,
I am trying to execute a DTS package from another DTS
package and change some variables in the original DTS. I
have used the info on the following page but it doesn't
work: http://www.sqldts.com/default.aspx?215. Would you
have any input?
Thanks,
Andreas...more >>
incremental Transform Posted by wg at 4/2/2004 6:43:59 PM hi,
i was wondering if there's a way to use the Transform task (or another
existing DTS task) to transform/copy data from one (or more) table into
another table in an incremental fashion. that is, only transform data
that has not already been transformed. this would be used in a package
...more >>
Dynamically determine which server DTS is saved to Posted by jjrzut NO[at]SPAM gene.com at 4/2/2004 4:29:34 PM Hi all,
I am running into an issue here. I am creating DTS packages that
manipulate data. I start on a dev server go to qa, then uat and
finally production. Currently each time I promote the Package to a
different environment I must go in and manually change the sql server
connection. I w...more >>
DTS and Temp Table Posted by Kevin Potter at 4/2/2004 2:43:32 PM Hi,
I am have a problem using a temp table in a stored procedure which is called
from DTS. Within the Transform Data Task Properties dialog the
Transformations for the Source does not display any fields. I know the
problem is caused by the temp table, what I want to know is there any work
a...more >>
DTS and Temp Table Posted by Kevin Potter at 4/2/2004 1:15:37 PM Hi,
I am have a problem using a temp table in a stored procedure which is called
from DTS. Within the Transform Data Task Properties dialog the
Transformations for the Source does not display any fields. I know the
problem is caused by the temp table, what I want to know is there any work
a...more >>
Passing parameter to DTS via VB Posted by Eugene at 4/2/2004 1:01:09 PM I'm using VB 6 with SQL 2000. I have a DTS package that works correctly in SQL Enterprise Manager. Now I have to incorporate it into a VB 6 application.
I'm using the following code
' Declare SQL DTS Object
Dim oPKG As DTS.Package, oStep As DTS.Ste
Set oPKG = New DTS.Packa...more >>
Export to Table with variable name in MS-Access Posted by Joachim Hofmann at 4/2/2004 12:03:18 PM Hello,
I want to create a package which does the following:
1) Use a query with variable value in the WHERE clause (from a global variable content).
I already know how to do this.
2) Output the resultset into a new MS-Access - Table which has the same name as the global varable
content.
...more >>
Alter Column Help Posted by PhilipL at 4/2/2004 10:59:12 AM Any help is appreciated here. My alter column code fails
below. I don`t know what I am missing here. The column is
a primary key and all I want to do is make it an identity
column. Thanks for any idea.
Phlip
-----------------------------------------------------------
ALTER TABLE dbo.HISTO...more >>
execute package task doesn't stop if it contains analysis services processing task with cube processing Posted by Alexander Nenashev at 4/2/2004 10:39:17 AM execute package task doesn't stop if it contains analysis services
processing task with cube processing
what is the matter? :(
...more >>
DTSRun and Batch file Posted by jlockard NO[at]SPAM rwd.com at 4/2/2004 8:27:09 AM Hello -
I'm running SQL Server 2000 and I've built 3 OLAP cubes that are
refreshed via DTS package, including an Analysis Services task to
re-process each cube. Now, I'd like to provide the ability for select
users to refresh/re-process the cubes without installing SQL Server
EM, Analysis Ser...more >>
DTS logging Posted by HartA at 4/2/2004 8:15:32 AM We run some of our DTS packages from a Job Scheduler not thru the SQL
scheduler. I want to know if there is away to capture the output of the DTS
from start to finish not just using the logging method. My question for this
is I have one package that starts on another server opens the command wind...more >>
VBScript: OpenTextFile - Permission denied Posted by Bodo v. Ulmenstein at 4/2/2004 1:42:18 AM Hi,
In a vbscript I attempt to concatenate textfiles:
....
Set fso = CreateObject("Scripting.FileSystemObject")
Set fld = fso.GetFolder( VKFolder )
For Each tFil In fld.Files
If Left(tFil.Name, 8) = "VERKAUF_" Then
fso.OpenTextFile(VKFolder + "\" + VKFileGesamt,
ForApp...more >>
Missing rows from Transform - Intermittent Issue?? Posted by pfk92000 NO[at]SPAM yahoo.com at 4/1/2004 8:40:56 PM Hi!
I have been having an intermittent problem with a Transform in one of
my DTS packages that I'm stumped on - when I run the Transform source
query thru SQL Analyzer, I consistently get 443K rows returned. When
I execute the DTS package (with the exact same SQL in the Trasnform),
I *usually*...more >>
Bizarre run time error from DTS ActiveX Task Posted by Jeff Block at 4/1/2004 5:49:56 PM This code errors out, runtime error stating Object does not support the
property or method from the 2ND write(transform...). If I run this script
from the command line, it works fine. But from DTS, the error.
And ideas ?
================== ================= ============
Set xml = CreateObje...more >>
Error while parsing for parameters Posted by Paul Makulski at 4/1/2004 2:15:53 PM SQL 2000
I have a Transform Data Task
that has a SQL query as the source.
It uses a function:
SELECT SegmentCode, SUM([Value]) AS Amount
FROM dbo.FnGLSegJE('200401', 'A', 62)
GROUP BY SegmentCode
If I hit preview, this works just fine.
But when I change the hardcoded '200401' t...more >>
using lookups in an if Statement Posted by nechamakatan NO[at]SPAM yahoo.com at 4/1/2004 11:45:34 AM I am trying to build a DTS that updates a centeral database with data.
I need to load only the new data each time.
So I build a lookup that gives me the max data in the destination db
and then tried to use it in an if statement.
It does not work. what am I doing wrong?
'**********************...more >>
Maintenance Plan Optimization job fails Posted by Stephen Rybacki at 4/1/2004 9:06:09 AM I have a production database that I created a maintenance plan for that includes integrity checks, optimizations, DB Backup and trans log backups. Everything works fine except that the optimization job fails every time. This is the case on our identical test and development databases as well. Spe...more >>
DTS from SQL Server 2000 to Oracle 8i Posted by (afrisman NO[at]SPAM retailexpert.com) at 4/1/2004 7:27:29 AM Hi to all.
I have a huge database (50 Gb) on SQL Server.
It takes more then 7 days for DTS to complete. I tried it both ways: Enterprise Manager and DtsRun command.
Is there any way to make it run faster, turn off som active default settings or something?
Any help appreciated!!!!
Thanx in adva...more >>
Connectivity with DTS: Dummy Posted by Jack at 4/1/2004 7:23:39 AM Hi,
I have a asp web site connected with SQL Server at the
back-end. From this site,I'm connecting with
dbc.open "DSN=Mydsn;UID=myUID;PWD=MyPassword"
If I have the IP address of that server.
Do you know if it's all I need to connect on that server
with DTS import/export Wizard.
...more >>
Replacing Blank Strings with Nulls Posted by Julian at 4/1/2004 5:55:17 AM Hello,
I am copying a table from one sql server to another and
some of the columns are coming over as blank strings, I
want these converted to NULLS, but at the moment they come
over as blank strings, is there an easier way other than
doing a column by column activex transform to convert...more >>
Export to Excel with different sources Posted by trond_wahlstrom NO[at]SPAM hotmail.com at 4/1/2004 3:31:01 AM I have created this report generator where the user should be able to
export the result to an Excel file. The users can pick their own
columns from a wide range of columns and a sourcetable(report_table)
will be created every time a user choose 'Export to Excel'. Is it
possible to create a DTS t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |