|
|
|
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 Error while calling the function Server.CreateObject("DTS.Package") Posted by raman_imt NO[at]SPAM yahoo.com at 4/14/2004 3:27:43 PM I am trying to call my DTS Package through an ASP.
While using the Server.CreateObject Method, I get this error:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/Deciweb/MPC/IntradayConsolidation.asp, line 25
Invalid ProgID. For additional information specific to...more >>
DTS and Cluster Posted by Tunji at 4/14/2004 1:29:36 PM I assume its not required to have this package(s) run on both servers in an
ACTIVE - ACTIVE environment.
All opinions are welcome.
Thanks
--
Tunji
...more >>
Executing sp_start_job from Package Posted by Tim at 4/14/2004 11:17:46 AM I have a package step that executes sp_start_job to start
a job... On success of that step it runs another step.
However the step assumes success upon starting the job
and the job does not actually finish before it moves to
the next step.
I currently have a sleep command at the end of the...more >>
DTS Package execution fails Error (800403FE) Posted by Andre Beier at 4/14/2004 9:46:06 AM I wrote a VBScript to reduce the amount of records in a table with currently
25 Million records (100 MB).
The script worked fine on our development server. However, on the real
server, it failed. The only difference between the two servers is that the
real one is constantly getting data inserted...more >>
Running packages on remote server Posted by Dean at 4/14/2004 9:26:27 AM I created and tested DTS packages on my local server and everything worked
fine, the I copied the packages to our Test server using DTSBackup 2000 from
http://www.sqldts.com/default.aspx?242. Now I can not execute the packages
directly. If I create a job on the Test server, the Job sucessfully ru...more >>
Selectively executing steps disablestep Posted by fcagg at 4/14/2004 7:09:39 AM I have a package with many steps.
Depending on the circumstances, I only want certain steps
to execute.
The steps run serially, and are connected with an "On
Completion" workflow.
Each step's DisableStep property is valued using an INI
that is set by a Dynamic Property Task that runs first....more >>
DTS package execution from VB => Error 429 Posted by SEB at 4/14/2004 5:31:05 AM it works perfectlly, if i launch the program on PC with enterprise manager installe
but on other pc's it returns me an error => ActiveX component cannot be created
I put all the references to the DLL's , and threre were correctly copyed on pc
if somebody have a solution??...more >>
Pass variables from parent DTS to child DTS package... Posted by gr8patra at 4/13/2004 11:01:06 PM Hi there
I have a parent DTS that calls a child DTS through ActiveX scripts. Both of them have the same global variables defined in them. I need to call the child DTS from the parent and pass it a different date (one of the variables) to run it for. I don't seem to get it work. Here is the code...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Sheduled Times Change in DTS Package Posted by Tom at 4/13/2004 7:57:06 PM I have serveral DTS packages on an sql 2000 server used to import data from
text files downloaded from a mainframe database. The packages have been
running since November 2003 with no major problems until today. The
packages failed to run at the times scheduled (6 am Mon-Fri). When looking
at...more >>
Validation prior to inserting data Posted by jrp210 NO[at]SPAM yahoo.com at 4/13/2004 7:35:26 PM I created a DTS package that downloads a text file from an ftp site,
deletes the existing data in the sql table, and then inserts the new
data from the text file. The package works but I have run into
instances where the source text file has invalid data - duplicate
primary keys. When this ha...more >>
Basics on looping through text file. Posted by Ron Sissons at 4/13/2004 1:42:22 PM Hi,
I have server names in a txt file. like so
Server1
Server 2
Etc...
I want to be able to import the server names from the text file and update a
connection in a dts package. I checked the SQL DTS articles but most are not
good for starting point.
Any ideas?
Ron Sissons, DBA
...more >>
Importing data from Oracle to SQL Server 2000 Posted by AS at 4/13/2004 11:50:12 AM Hi,
We have an Oracle database and the applications on top of it that're written
in Developer 2000. We want to migrate to sql server 2000. Any pointers on
how I should go about doing that.
Also, I installed Sql server 2000 on another PC and tried using the
Import/export wizard to be able to im...more >>
PackageSQLServer.EnumStepLogRecords: displaying steplog records of running package Posted by Andrew at 4/13/2004 11:30:26 AM I have a problem displaying the correct steplog records of a running dts
package. When I start a job which executes a dts package and try to display
the current log records of this package right after starting the job, I get
log records of the previous 'run'. Waiting a few seconds before getting ...more >>
executing DTS package from Stored Procedure Posted by mitra fatolahi at 4/13/2004 10:21:41 AM Hello Everyone,
I like to know if a DTS package could be executed from
within a stored procedure.
I looked at the SQL Server Books Online and did not find
any help.
Thanks,
--Mitra ...more >>
multiple transformations in 1 dts Posted by kdabda at 4/13/2004 9:36:05 AM What about having like 20 transformations in 1 dts
Should I check for each file up front and if not there then disable the individual transformation
Any ideas how to check for multiple files and then turn on or off multiple transformations in one dts? I don't mind using the exact names of the f...more >>
LoadFromSQLServer And LoadFromStorageFile No Work Posted by Gustavo Morales at 4/13/2004 5:49:54 AM Mi application returns this error: -2147287038 "File No found"
Why?
...more >>
activex script to supply access file Posted by dk at 4/12/2004 4:12:17 PM a dts package tries to use an activex script
to change the file name of a connection
to an access database. The activex script
fails. this is the script - any idea what is wrong?
Function Main()
Dim objFSO, strFullNm
Set objFSO = CreateObject
("Scripting.FileSystemObject")
strFull...more >>
Import Text into Multiple tables Posted by csl at 4/12/2004 3:15:19 PM I have seen the import examples from sqldts
(http://www.sqldts.com/default.aspx?246) but was wondering
if there is anyway to automate the importing of multiple
text files with each text file going into a separate SQL
table. The format of the text files are all the same. ...more >>
Dts Questions ? Posted by Stan Sainte-Rose at 4/12/2004 12:46:31 PM Hi,
I would like to know if it's possible to do that from a DTS Package.
I have a table with these following fields :
SourceDataTable
SqlQuery
DestinationFile
I need to read this table and for each record
to change all the parameters from my dts package.
Right now, I know how to do t...more >>
Reading text files in subfolders Posted by Lab at 4/12/2004 10:06:03 AM Hi
I need to read a Folder containing many sub-folders to detect all "dat" files placed there (they come from Unix). When I find one, I need to convert it to Windows format (add the CR) and save it as txt file in another folder
I am new to vbscript and not sure if the "fileexists" FileSystemObje...more >>
Package Error Posted by jrp210 NO[at]SPAM yahoo.com at 4/12/2004 9:56:05 AM I have a package that downloads a file from an ftp site and inserts
the data into a table. This happens on a nightly basis. But before I
insert the data, I delete (truncate) the data in the existing table.
The problem is that there has been errors in the data file that I am
downloading (i.e. ...more >>
DTS Package thru stored procedure Posted by sreenath at 4/12/2004 8:18:24 AM hi,
I am trying to run a stored procedure to execute a DTS
Package as exactly explained in the following URL:
http://www.databasejournal.com/features/mssql/article.php/1
459181
but, I am always getting problem with
*** LoadFromSQLServer failed
HRESULT: 0x80030003
sp_OAGetErrorInfo fai...more >>
can tasks be renamed ? Posted by Antonio Lopez Arredondo at 4/11/2004 3:43:16 PM hi all !
have a very simple question.
one a package is already deployed and "up and running", is there any way to
"rename" tasks and transformations ?
the problem is that the logs files are very hard to understand when using
default names, and I couldn't find the way to rename all I alrea...more >>
Saving DTS Package to VB Code Programitically Posted by Jeff Block at 4/9/2004 3:51:36 PM Can anyone point me to an object that will let me get the VB Code for a DTS
package programatically ?
...more >>
Empty csv file Posted by Sunanda at 4/9/2004 1:31:06 PM I create a comma delimited flat file based on a view . Then if this process completes successfully, I read the file created into a table to do some processing. I do all this in a dts package
DB->Data Transformation Task -> Destination FlatFile -> On Completion -> Source Flatfile -> Data Transformat...more >>
DTS error importing from Access 2k Posted by Randy at 4/9/2004 10:01:04 AM I am trying to import data from Access 2000 to SQL2K. I am receiving the following error
Error at destination Row number 387. Errors encountered so far in this task: 1
Insert error, column 12 ('Birthdate', DBTYPE_DBTIMESTAMP), status 6: Data overflow
Invalid character value for cast specificati...more >>
Maintain production DB with changes from development DB Posted by George Prado at 4/9/2004 8:51:03 AM I have about 4 production SQL servers all with the same DB structure. Now I need to update them with changes done to my development server. What is the best way to update all four servers? Can DTS update the structure? Or will I have to write a script to update all 4 servers? Any help would be ...more >>
dts package and t log Posted by sqlsurfer at 4/9/2004 8:46:02 AM Why does the t-log appear to log the whole transaction of an import of data into a table when the database is in simple recovery model. I thought it would only log the extents that were effected but it takes a t log that is as large as the file being imported e.g. a 10 gig file needs 10 gigs worth ...more >>
activex script in dts package Posted by dk at 4/9/2004 5:11:49 AM
when clicking execute step for an activex script
in a dts package,
this error is displayed.
"ActiveX Scripting was not able to initialize the script
engine."
any idea how to resolve?
tia,
dk...more >>
Right Justify amounts Posted by Jim Covington at 4/8/2004 4:22:28 PM I am using DTS in SQL 2000 to download data to a text file. (Fixed Width
Columns)
All works well but the numbers are all left justified.
How to I right justify in Transformations?
Jim
...more >>
returning a value in stored procedure for dts lookup to use Posted by Gregor Anton at 4/8/2004 3:20:06 PM I have the following stored procedure that increments a key in a table
called sitekeys and then what I'd like to do is have it return the value as
I need to grab it with a DTS lookup. I have it working by doing a select
statement but was wondering if there is an easier way to just return the
va...more >>
To DTS or not to... that is the question Posted by Michael at 4/8/2004 3:01:00 PM I am trying to make a decision on the approach to use for making some daily
updates from a SQL Server database to an Oracle database. I currently have
a DTS package pumping some data over to staging tables in the Oracle
database. I have also built a script to move the data from the staging
tab...more >>
using Yukon DTS with SQL server 2000 Posted by tzahij NO[at]SPAM hotmail.com at 4/8/2004 2:47:30 PM Hi,
I am very new to DTS, so hope my quesion is not silly.
We are working on a long-term project (C#, about 50 men years,
scheduled to 3/2005). We are based on SQL server 2000.( although our
deployment dates will probably coincide with Yukon release, sigh )
Part of the project is integrat...more >>
Transform Data Task, parameterized SP: "No value given for one or more required parameters" Posted by jvanmatre NO[at]SPAM builderhomesite.com at 4/8/2004 2:05:23 PM This is a baffling situation:
I have a Transform Data Task in DTS (SQL 2000 SP2). The source for
the task calls a simple stored procedure with 2 parameters: @CID int
and @accesstablename varchar(50).
If I pass literals for both parameters...i.e.
exec ap_ds_getstagingdata 141, 'Points'
...more >>
DTS from sql 2000 to oracle Posted by Tracey at 4/8/2004 1:26:19 PM Hi.
I have a DTS package that contains about 15 tasks to
transfer data from a sql server database to oracle (8.05).
When i execute the task, the first 4 tasks are run and
then i get a "the number of failing rows exceeds the
maximum specified limit" error. Yet, the data is loaded
into o...more >>
How to DTS SQL Files to update Procs? Posted by JDP NO[at]SPAM Work at 4/8/2004 1:21:33 PM If there is an easier way, please advise.
Here's what I want to do.
Say I have 30 stored procedures that I want to be sure are up to date and expect
changes to in the development system. I then want to update in the live system.
I'm happy going thru the scripts one at a time as needed, an...more >>
bugs with IF, SKIPROW, or ISNULL? Posted by Gregor Anton at 4/8/2004 11:54:29 AM are there any bugs with if statements or skiprow?
when executing the transformation script below it doesnt skip any records...
I have to filter the records in the source query for some reason...
IF ISnull(DTSSource("MAIL ADDRESS")) and ISNull(DTSSource("MAIL CITY")) and
ISnull(DTSSource("MAI...more >>
DTS package to run stored procedures Posted by Chris at 4/8/2004 8:05:03 AM Is it possible to create a DTS package to run several (75) stored
procedures.
If the answer is yes how do I set it up.
Thanks
Chris
North Cotswold Computing
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
Cannot use source field twice Posted by Lou & Suzie at 4/8/2004 5:16:03 AM Hi
We are moving a source field to a destination field. We are then moving the length of the SAME source field to another destination field, but it is blank. If we swap the two moves over, whatever is the second line is empty
Can you only use a source field once ? Is this a know bug or are we...more >>
Timeout Limited to 9999 Posted by Mike Mattix at 4/8/2004 2:53:08 AM I have a task that takes a long time to run. I run it in the middle of
the night but it takes approx 2:45 mins to run. A DTS Win32 Process
task has a timeout parameter which is limited to 9999 seconds (2:46:39).
This cause some problems when the step does not complet on time. Is
there an...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |