|
|
|
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 Calling Sybase stored procedure from DTS Execute SQL Task Posted by John Doody at 12/7/2004 11:20:54 PM Is it possible to call a Sybase stored procedure from DTS using the
Execute SQL Task. I'll expect to pass input variables from global
variables and receive a result set from the stored procedure. Looks
like this is no problem with SQL Server.
The Sybase connection will be via ODBC.
Th...more >>
Package fails when run from Sql Server Agent Posted by Rlane at 12/7/2004 2:18:50 PM I have a stored procedure that createz a DTS package on the fly using
the sp_OA... stored procs. The procedure copies data from a Sql table
into an Access .mdb file.
When the procedure is executed in a Sql Server Agent step, it inserts
rows into the Access file, but fails before finishing.
Th...more >>
how to stop the whole package Posted by Ed at 12/7/2004 2:17:05 PM hi,
If i have five tasks in a package, how am I able to stop the whole process
once error occurs. Do i go to Properties --> Logging --> check on "Fail
Package on first Error"?????
um... what if i have 5 ActiveXTask in a package, do I use Main =
DTSTaskExecResult_Failure to stop the whol...more >>
Darren/Allen: File Filter problem Posted by bh_parker NO[at]SPAM hotmail.com at 12/7/2004 9:57:36 AM When I use the SQLDTS File Filter of your SQLDTS FTP Task, it is
applied to both the Source and Destination. Is there a way to apply it
to ONLY the Source?
Thanks.
...more >>
Emergency!! DTS help Posted by Biti at 12/7/2004 9:37:49 AM I have a DTS job that was running fine until this morning. I got
"ActiveX Scripting was not able to initialize the script execution
engine" I have never seen this before. Any idea how to solve this.
Thanks,
Biti
...more >>
DTS Error - Server to Busy Posted by Joern at 12/7/2004 7:15:05 AM Every time a run DTS package from a DTS package i get a message that my
server is too busy. I checked the server. The Server is not to busy. Anyone,
who knows the Problem ?
Thanks ......more >>
export excel start input Posted by Stefan Ljungstedt at 12/7/2004 3:43:02 AM Hello i have a dts packet how export a excelfile from sqlserver table. My
excelfile is existing like a form and I export some data from sqlserver and
then I change the excelfile name and I attached it to a mail and send it.
Question:
1. When I export data from the sqlserver the data is place...more >>
DTS and Identity Columns Posted by Gopinath R at 12/6/2004 10:27:13 PM Hello All,
I was trying to transfer a set of Records from a table (SourceTable) in one
database to a table (TargetTable) in
another database. The TargetTable has an additional IDENTITY column which is
set to get inserted automatically
- ie, I have UN-Checked the "Enable Identity Insert" che...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DTS package runs slow as a scheduled task Posted by ljhopkins_LOST and Cant find My Way at 12/6/2004 10:11:01 AM i have a dts package that when I excute from the DTS local it runs in about
10 min or so.
But when I schdule the package to run as a JOB it takes 30 + min
what am I doing wrong...more >>
DTS To Create Excel File with Dynamic Variables from VB. Posted by sudha at 12/6/2004 8:49:02 AM Hi All,
I am trying to execute a package with Global Variables which takes dynamic
date and excel filename and path from vb to global variables ,and creates
dynamic sql in ActiveXScript and executes the package.
Package runs fine from Sql Server for the first time but if i change the
exc...more >>
DTS pkg runs fine but when I scheduled it to run, it fails. Posted by SangHunJung at 12/6/2004 8:37:01 AM Hello,
I've SQL2000 Standard Edition running on Win2K server.
A DTS has two VB app and execute it with a parameter. DTS runs fine when I
open in E.M. and execute it. But when I scheduled it, it fails with
following error;
Step 'DTSStep_DTSCreateProcessTask_1' failed
Step Error Source: Mi...more >>
DST with Excel and NULLS instead of Numbers Posted by srussell705 at 12/6/2004 7:30:06 AM I did a quick DST using an excel price sheet and found allot of nulls
when I have a column general in the sheet having ONLY a numeric value.
If the column has 442**TDF it's fine.
But the same column in the same pull with 2 gives a NULL.
This is a pricing file that is going to send to a pr...more >>
primary key exception logging Posted by Andrew at 12/6/2004 6:43:02 AM I am inserting data from a text file into an SQLserver table.
the text file could have rows which cause a primary key exceptions.
I want to be able to log the row in the file that a primary key exception is
raised.
I need to use "Fast Load" so I cannot use the Data Pump Phase - Insert
F...more >>
FTP DTS Process not overwritting file Posted by James Johnson at 12/5/2004 4:16:25 PM I have a DTS procedure that calls this code via stored
procedure. Then I import the file into sql server.
Problem is that it is not overwriting the file in my
c:\localdirectory. Is there an attribute I should set
in my text file or is should I delete the file in the
directory before ft...more >>
Slow DTS Package on server-side Posted by Martin at 12/4/2004 2:14:19 PM Hi,
Since 2 weeks, we have a problem with SQL Server 2000. We have defined a
schedule job in witch we execute about 100 dts packages. This job usually
take about 2h30 to run but since 2 weeks, it takes about 8 hours. I've
noticed that if I execute a particular step on the server, it takes 1h...more >>
Passing GlobalVariable VB6 to dts Posted by Vic Spainhower at 12/4/2004 12:23:55 PM Hello,
I am trying to introduce myselfe to Global Variables in dts and I guess I'm
having a difficult time grasping how they work. The VB6 code follows and
beind it is the ActiveX script that is run in the dts package. When the dts
is run there is no data generated into a csv file which is ...more >>
urgent import/export or backup question Posted by thaar at 12/4/2004 4:39:05 AM dear all,
i am new to this disscusion group, i have long period participations in
cisco and oracle ...etc disscussion groups. my question is:
i have windows 2003 server and ms-sql server 2000. using entriprise manager
i have backups and export/import. how can restore only one table as an
...more >>
Run DTS by http, non-blocking Posted by William Campbell at 12/3/2004 9:14:47 PM I have a scenario where inspector's synchronize their PDA's at the end of
the day (we use SQL Server Merge Replication). When an inspector is done,
I'd like to kick off a cleanup process (that code would be in a dts
package).
The code on the PDA, if the merge replicaton was successful, would ...more >>
Code Window won't display code Posted by Vic Spainhower at 12/3/2004 4:36:23 PM Hello,
I am new to dts and I was going to create an ActiveX script to limit rows to
export to a csv file. I don't know what I did but the code window
disappeared and now I only see a list of functions and entry point box.
What did I do and how do I get the code window back?
Vic
...more >>
dts connections Posted by ChrisR at 12/3/2004 11:36:34 AM Is dts able to switch it's connections when you save your package to a new
box? What I mean is Im on a Development box:
1. I create a Packaage that Transforms data from Table1 to Table2 using a
Transform Data Task.
2. I move this Package to Production using the Save As tab in the Package
Desi...more >>
Creat your own DTS schedule Posted by Dave Williams at 12/3/2004 9:33:31 AM Is there any way of creating your own schedule?
Due to combining weekly invoicing with a month-end invoicing run there does
not appear to be a way of generating a combination of regular weekly dates
together with the exceptions that occur at month-end. Can the schedule
access a table of dates?...more >>
DTS - FTP Task Posted by Peter Newman at 12/3/2004 8:37:09 AM we currently have our SQL server do backups to a local directory. What id
like to do is to set a scheduled task to copy the files to another server,
whilst retaiing the sub directory structure. Ive looked at the FTP task but
dont know whats the best way to acomplish this. ...more >>
Beginner to vbscript question Posted by DBA72 at 12/3/2004 7:59:03 AM How would I go about telling the dts package to go to a certain step?
What I want to do is say "if condition A is true, then go to step A of the
package, otherwise go to step B"
I've got the if ... else part of it down but don't know how to say "go to
this step"...more >>
Executing Looping SP within DTS Posted by Jay at 12/3/2004 6:51:48 AM Hi
I'm running a stored procedure from DTS. The SP has got a WHILE LOOP that
should execute 3 times. When I execute it from QUERY ANALYSER it executes 3
times. However, when I execute it from DTS it only executes once. The SP
procedure doesn't take any parameters.
S/W: SQL Server ...more >>
DTS: exporting data to csv file Posted by X. Zhang at 12/3/2004 6:49:08 AM I got a very strange situation:
I wrote code to export data to csv file within ASP using VBScript. (My
VBScript code was based on the VB code that was created by "Save As" to
"Visual Basic File" in DTS Designer.) In debug mode, I had no problem to
export data. However, the Copy-data step fail...more >>
binary column in destination sqlserver table Posted by Andrew at 12/3/2004 5:15:14 AM I am importing data from a csv file into a SQLSERVER table
I am having problems with a field in the destination table which is of type
binary.
The source data in the csv file is a Hex representation of the binary data.
e.g.
0x000386006bc886a0
An exception is being raised - General conv...more >>
dts loop to change server connection not working Posted by DBA72 at 12/2/2004 11:39:03 PM I have a dts loop that is supposed to loop through a list of servers and then
change the connection in the dts package for each server in the list. The
loop seems to work fine but the server connection properties always stay on
whatever server is first in the list. Any ideas why this is not ch...more >>
Meta Data Services Posted by Irene Lim at 12/2/2004 5:31:21 PM DTS package is stored into sysdtspackages table in the
msdb database on any SQL Server 2000 instance. Do anyone
know which table in msdb database stored meta data
services? Or is it stored in MSDB like DTS packages?
...more >>
DTS import - all data not imported Posted by William Patterson at 12/2/2004 2:18:57 PM I am working with some financial data that has many, many observations, but
failrly small records. I an creating a comma separated variable (CSV) file
using a VB.NET program and then I use DTS Import to import the CSV file into
SQL Server 2000 via a file DSN.
This all works fine for the small...more >>
SQL Server DTS From Sybase Posted by shop NO[at]SPAM pacifictabla.com at 12/2/2004 1:31:36 PM Hi:
I want to import data from a Sybase database via a SQL Server DTS package.
The database views in Sybase I will be importing from all have different
names according to the date of the data in that view. For example:
database.dbo.SybaseView20041122
only has data for Nov. 22, 2004. I want ...more >>
Converting Decimal to interger within a tranformation Posted by Liz at 12/2/2004 12:59:05 PM In trying to convert decimal to integer within a transformation using below
code, I am getting error "Invalid Procedure call or argument: 'DTSSource'" at
execution. Can some point out how I can correct the error.
Dim newPRQtyPriceRecieved
newPRQtyPriceRecieved = DTSSource("cast(PRQtyPriceRe...more >>
Activex Scripting : Function Not found Error Posted by Help at 12/2/2004 12:40:46 PM I have a ActiveX Scripting in DTS package.
When i run the package it gives an error msg,
"Activex Scripting : Function Not found"
When i execute the same file from my local machine as a .vbs script, it
runs fine. I am puzzled.
Please help if i am neglecting something.
Thanks
*** S...more >>
calling an exec sql method from activex script Posted by gurumum NO[at]SPAM email.uc.edu at 12/2/2004 12:08:31 PM Is it possible to have exec sql's that are not included in the
workflow of the package that can be called from an activex script in
the workflow when needed?
I'm having trouble referencing the exec sql object from inside the
activex and using the execute method. can someone post a code snippet...more >>
DTS Error: Unable to enlist in the transaction Posted by jupiterdude NO[at]SPAM hotmail.com at 12/2/2004 11:17:51 AM I'm looking to use DTS to delete and reload some volatile data from
one of 40+ Informix DB's. For a number of reasons, DTS appears to be
the right choice for this exercise.
Running the DTS package designer locally, but connecting to a remote
server, any attempt to enable transactions on a pack...more >>
Help! Error when loading data from DBF table Posted by Marin at 12/2/2004 10:33:04 AM Hi all,
I have a DTS package that should load data from DBF file (saved on local
disk) into empty table on local SQL server. DBF file has about 8 million
records, it loads first 6200000 then it failed with error "Data for source
column xx (XXXX) is not available".
The size of DBF file is...more >>
First row Posted by nh at 12/2/2004 10:11:06 AM I have a load of dts packages written in SQL Server 7.0, all of which were
set to start the import process at at row 2 of each file.
Now I have moved them to SQL Server 2000, I get a message saysing that the
last row must be equal to or greater than the first row.
Is there another way of get...more >>
Missing Connection Objects Posted by Jason at 12/2/2004 9:23:08 AM Hello, I installed MS Office 2003 and SQL Server 2000. However, when I went
to create a DTS pkg, I found that the following connection objects are
missing:
Excel,
Access,
Dbase5,
HTML,
Paradox
Can someone please tell me what is going on? I am wondering if it has
something to with MDA...more >>
Run job from DTS package Posted by Sam at 12/2/2004 7:51:07 AM I'm looking for a simple way to run a Maintenance Plan's backup job from a
DTS package. I know I can use the sp_Start_Job, but this requires a jobname
or jobID. To get those I would need to parse through the output from a
sp_Help-Job & look for 'Backup' & 'databasename'.
Also, I want to use...more >>
import from MS Access Posted by Dmitry Islentiev at 12/2/2004 12:47:03 AM Hello,
As we know we can design package than does table->table conversion. But how
to get a conversion of all tables -> all tables?
thank you!...more >>
SQL DB to MySQL Posted by MTsang987 at 12/1/2004 5:25:03 PM We have SQL Server 2000 databases residing on one server, for reference I am
calling them DB1 and DB2. DB1 contains the main data,
DB2 contains data about the most recent changes to DB1, The key, table ID,
timestamp, and what action (insert, update, delete) occurred to DB1 is stored
in DB2....more >>
BCP csv file only required Rows Posted by Anon nymous at 12/1/2004 2:26:05 PM Hello folks,
I want to BCP a csv file in to a table.
1. The csv file has footer records. Theres a blank line after the data
itself and the footer records start.
The number of data records can vary everyday.
My question is
How can i BCP only upto the data records.
I am quite new to DTS. Any ...more >>
replacing the ? with prefixed parameter names Posted by gurumum NO[at]SPAM email.uc.edu at 12/1/2004 1:43:33 PM Hi,
i am using win 2000 client and sqlserver 2000
I have 3 questions:
1. i am using global variables to pass data to a query in an exec sql.
It works fine when i use the "?" placeholder for the parameters.
The problem is that when i am using like 20 parameters, it is a pain
to map globa...more >>
Add row numbers to Text file export Posted by Marinus Willemstijn at 12/1/2004 12:01:31 PM Is there a way to possibly add rown nr's to a Text file export using DTS.
The result in the text file should read
1,FieldNr1,FieldNr2,FieldNr3,
2,FieldNr1,FieldNr2,FieldNr3,
3,FieldNr1,FieldNr2,FieldNr3,
etc
instead of
FieldNr1,FieldNr2,FieldNr3,
FieldNr1,FieldNr2,FieldNr3,
FieldNr1,F...more >>
Launch DTS Package using preferred resources Posted by whornak at 12/1/2004 11:59:03 AM From my understanding, when a DTS Package is launched remotely the package is
run using the resources of the remote machine. Is there a way to launch a
DTS Package remotely and have it use the resources of the server?
The problem I am having is that the server has email recipients defined...more >>
Need Access To Data Pump Source Dropdown Posted by Jamie Carper at 12/1/2004 9:05:06 AM I am importing data from Excel files with multiple worksheets.
When you use the DTS dialog for the Data Pump object, the Source tab has a
dropdown box with all the available worksheets in a given Excel file.
I want to access this list of worksheet names without having to resort to
Office a...more >>
DTS Data Pump VBScript runtime error Type mismatch Posted by -=JLK=- at 12/1/2004 8:46:33 AM I have a strange problem. What was working fine on all machines, now does
not work at all on one of three machines. As far as I can tell all three
machines have exactly the same configuration and identical hardware. We are
running:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May ...more >>
Schedule DTS package fails Posted by Mike T at 12/1/2004 8:41:20 AM I have a number of DTS packages that execute over night to sent spreadsheets
to offices around the globe. The spreadsheet shows what has changed in the
area of the database that the office is concerned with. The first step in
the DTS package is to count the number of changes, if it is Zero an a...more >>
SQL2K to SQL7 Posted by Rob at 12/1/2004 7:52:50 AM Can you move a DTS package from SQL 2000 to SQL 7.0?
Thanks....more >>
dtsrun @ sql2k 64-bit Posted by Frank Mertens at 12/1/2004 1:23:04 AM Hi ng,
I've a problem with our SQL Server 2000 64-bit. I have to migrate from SQL
Server 7.0 to SQL Server 2000 64-bit.
While testing the planned tasks on the new server I've established that
dtsrun generates an error:
"'DTSRUN' is not recognized as an internal or external command, operabl...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |