|
|
|
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 One Source, two destination, and with lookup Posted by RL at 4/28/2004 9:41:01 PM Hello Everyone
I have this situation,
1. Read from Order file (txt approx 100 records
2. Look for the Customer Code in the Customer Table
3. If you find the record insert into Order tabl
4. Else Insert into Order Reject tabl
Can any one guide me what's the best way to handle this. Because t...more >>
Connections in DTS Package Posted by Joan Brown at 4/28/2004 8:33:18 PM We are using three servers (development, test/qa, and
production). How can I code a connection in a package to
reference the local server?
We are using 'save as' to migrate from one server to
another but we still have to modify the package on the
destination server to have the correct...more >>
parameter based on a query Posted by Dean at 4/28/2004 6:16:58 PM I need to create this Transform Data Task:
SELECT ...
FROM <TeradataDB>
WHERE <TeradataDB>.customer IN (?)
The parameter needs to be: SELECT DISTINCT customer FROM <localDB>
The first problem is that the TeradataDB driver is ODBC, which does support
parameters. The second problem is that...more >>
help! scheduled package does nothing... Posted by Rea Peleg at 4/28/2004 4:53:20 PM I am totally lost on this one:
I have a dts package which transforms data from tabula database into sql
server through a propriatary odbc driver.
When executed manually (through 'execute package') all is well, connection
is made to both sides
and data flows nicely.
When I schedule this package...more >>
DTS--> xp_cmdshell permission error Posted by Mohamadi at 4/28/2004 10:11:53 AM Hi All,
I have several DTS jobs owned by several users. Now i am
trying to put all the jobs in a procedure and schedule the
same thru SQL-Agent. But it fails giving error --> EXECUTE
permission denied on object 'xp_cmdshell',
database 'master', owner 'dbo'.
Any idea why is it happening...more >>
Data from Oracle Posted by Michael V at 4/28/2004 5:41:03 AM Need to have access to data in an oracle base from visual basic. Ideally I would just connect to
a database and get records from an oracle table using some kind of connection string
However - I dont' think this can be done without the oracle client installed on the machine fro
which i'm running ...more >>
HELP! Running DTS in a batch file with multiple files Posted by troubleD at 4/27/2004 9:01:05 PM I have a command batch file that reads the names of csv files in a text file and then calls the DTS package every csv file..
My problem is that the loop on the batch file wont work... can you tell what is wrong with this code?
csv files in DirList.txt:
a.cs
b.cs
c.cs
for /f "tokens=1,2,3" ...more >>
Run VBA code Posted by Mtz at 4/27/2004 5:51:03 PM Hi
Need to run VBA procedures as part of an ETL process (DTS). Can this be done? How
Thansk in advance
Regards
MTZ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Loading nullable data from fixed-width flat file Posted by no5pam NO[at]SPAM hotmail.com at 4/27/2004 3:26:21 PM I am getting the following error when attempting to CopyColumn between
a fixed-width flat file and a nullable decimal column:
"Error Source : Microsoft Data Transformation Services (DTS) Data Pump
Error Description : The number of failing rows exceeds the maximum
specified.
TransformCopy 'D...more >>
Importing a SQL7 Database Posted by jlc at 4/27/2004 2:32:55 PM I have a SQL MDF and LDF file I need to import into an existing instance of
SQL7 server along with all stored procedures, etc. What is the best way to
do that through DTF?
...more >>
Assign SQL Script to global variable Posted by Ron Sissons at 4/27/2004 12:32:42 PM How do I assign the contents of a script.sql file to a global variable?
Do I have to read it in line by line? Can you show me the code to do it?
Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone...more >>
Failing VB Commands For DTS Posted by Johnmichael Monteith at 4/27/2004 11:36:32 AM I am using a DTS import, and trying to get the sucker to determine which is
the later date and use that for importing. I know I successfully did this
before, but now can not re-create it.
The error I get is:
"Error Description: Invalid procedure call or argument: 'DTSSource' Error
on Line 6...more >>
Changing the SqlTask Via ActiveX Posted by Ron Sissons at 4/27/2004 8:26:05 AM Hi,
I have a dts package that has 23 ExecuteSqlTasks.
I know how to loop through each task. What I want to do
is change the Sql Statement. The problem is the sql script I have is about
800 lines long. How do I assign the script.sql file into a global variable
and then assign it to "oTask.custo...more >>
DTS and DBF's Posted by Steve at 4/27/2004 8:12:45 AM I am using a DBF as a staging table in a DTS package. At
the end (or anywhere in the package after the records have
been imported into SQL) I need to delete all records from
the DBF to ready the table for the next use. I cannot
figure out how to do this.
Any help would be appreciated....more >>
DTS Error EXCEPTION_ACCESS_VIOLATION Posted by Sandeep at 4/27/2004 6:41:43 AM We have some DTS jobs that runs every night called via a
batch file. But since the past few days we are getting the
following error.
Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Need to run the object to perform this
operation
Error source: Microsoft Dat...more >>
changing package owner Posted by jill johnson at 4/27/2004 6:41:03 AM Hi, I am a system administrator and I tried using sp_changeobjectowner to change the owner of a local dts package and it won't let me. Is there another way to change a local package owner in EM or QA? Thanks!...more >>
Passing parameters in front-end Posted by Kaspian at 4/26/2004 11:31:03 PM Hi
I am a newbie to DTS. What I am doing now is I have created a set of DTS packages, which are executed one from another. I am now preparing a frontend for the users to run the packages for themselves. I found examples on how to do that, but what I need to do is make the users pass parameters to ...more >>
Order of Steps Posted by Ananth at 4/26/2004 9:06:03 PM Hello
I have a DTS package with several steps and am trying to provide a front-end for the user which wil
list the steps and show a progress bar on executing each step (very similar to the one provided by SQL Serve
itself)...however, I do not seem to get the steps IN ORDER..FYI, I am using C# (W...more >>
FTP using DTS disables line break in fixed format files?? Posted by cgseenu NO[at]SPAM rediffmail.com at 4/26/2004 5:39:59 PM Hi,
I have been trying to ftp a fixed format file using DTS (SQL Server 2000).
The file gets through, but the format of the file changes.
If i have 30 records on the original file,
The line break seems to disappear and the whole text appears in one line.
If FTP the file using command prompt an...more >>
Check if cancelled Posted by Brandon Lilly at 4/26/2004 12:49:34 PM Is there a way to check inside of an ActiveX task whether or not someone is
trying to cancel the execution of the package? I noticed that the package
doesn't actually cancel until a step completes.
Thanks,
Brandon
...more >>
how to pass parameters to DTS from vbcode Posted by aparna at 4/26/2004 12:40:36 PM
...more >>
PROBLEMS SCHEDULING DTS-PACKAGE Posted by Peter Häggmyr at 4/26/2004 9:34:13 AM I have an interesting poblem on a SQL Server.
I right-click on a DTS-package and schedules it to run at a specific time.
Normally the DTS-package appears in SQL Agent/Jobs, but on this server it
does not.
Does someone know how to schedule this package?
//Peter
...more >>
"Type Mismatch" calling GetExecutionErrorInfo Method from VBscript Posted by Niels Belonje at 4/26/2004 7:46:07 AM While looping trough te "Steps" collection of a 'Package-object' with the variable "objStep" the call in VBscript o
"objStep.GetExecutionErrorInfo lngErrorCode , ErrSource, ErrDescription" results in an error message
" Type mismatch: 'objStep.GetExecutionErrorInfo'
Does anybody know what i...more >>
Drivers doesn't appear in win2003 Posted by sch at 4/26/2004 7:46:04 AM Hello
We just upgraded from win2k to win2003 on our sql server 2000 and we can't see the other drivers like excel,access conncetions in DTS packages is there a way we can load them how do they come they used to come default in win 2k
all the packages which have connections to excel and access fai...more >>
removing checks for DTS package Posted by werner kempler at 4/26/2004 6:31:07 AM We have a package that a few different people will be modifying. I don't want to make them all SA so is there a way to remove the ownership check so that they can all save their changes? ...more >>
Passing a db name as a variable Posted by Peter at 4/26/2004 4:56:06 AM Is there a method for passing the database name as a variable to a DTS package
We have all item databases named as the business date i.e. 20040426AllItem and I'm manually having to re-select the database to run the DTS packages as I haven't found a way of passing the db name (I've also tried to inc...more >>
DTS Global Variable types Posted by mndr at 4/26/2004 3:26:07 AM Please, could anyone tell me how to pass NULL to the global variable of data type Date
I need to start my DTS package from EM, but when i enter NULL into the window with global variable i receive error message "Could not convert variable startDate from type BSTR to type Date.
What should i put the...more >>
How to execute vb.net function in a dll file from DTS ? Posted by sadmick NO[at]SPAM hotmail.com at 4/26/2004 2:14:38 AM Hi,
i want execute in my DTS a function .NET that has been define in a dll file !
Thanks
Mick...more >>
Import XML file into SQL Server Posted by Lena M at 4/25/2004 4:51:02 AM Hi
Help Needed!!!!!!!!!! ASAP!!!!!!!!
I need to import data from XML file into SQL Server Table
Is there any way to do via DTS or Bulk Insert?
May be something else. So far I find nothing. :
Thanks!...more >>
import excel spreadsheet to sql via vb or java script Posted by Fred at 4/24/2004 8:45:07 PM
All,
I am looking for a vb or java script that will delete an sql table named
Daily_List, then import an excel spreadsheet from a network share (in a
public folder) into sql server 2000 and name it Daily_List.
a few things to note, the excel spreadsheet name changes daily based on
the d...more >>
Green Transfor Data Task Line Posted by anonymous NO[at]SPAM discussions.microsoft.com at 4/23/2004 10:16:10 PM Hi
I have recently inherited a number of DTS packages. One
of the packages contains a Transfer Data Task that has a
Green arrow instead of the usual Grey one. Can anyone
advise what the Green arrow indicates?
Thanks
...more >>
Workflow for a Transform Data Posted by anonymous NO[at]SPAM discussions.microsoft.com at 4/23/2004 10:14:07 PM All
How do I error handle a Transform Data Task by using the
worflow on failure goto as I would with any other step.
Thansk...more >>
Linked Server or DTS Package? Posted by Admin at 4/23/2004 7:44:02 PM Hi,
I have a question? Linked Server or DTS Package? Which is
more advantageous while importing data from one SQL Srver
to another SQL Server?. If available please direct me to
any article available on the internet.
...more >>
Building DTS package through scripts? Posted by Kasp at 4/23/2004 5:17:33 PM Hello,
I have made some DTS package that I need to replicate my DTS packages at
another machine.
How can I do this?
I created these packages using Enterprise Manager of SQL Server 2000
Enterprise Edition. I understand that you can save the DTS packages a VB
..bas file, Structure file or in...more >>
Data Transformation Posted by Simon Whale at 4/23/2004 3:08:15 PM All,
what i am trying to do is as follows, i wish to import over 100 files into a
database. i have decided to try this through DTS, but i need each file in
their own table but i'll only know the names of the files on import.
is there a way through DTS Data pump that i can dynamically supply...more >>
Triggering a DTS job Posted by willa at 4/23/2004 3:05:12 PM I have a dts job that runs on my MSSQL2000 win2K box.
But i want to be able to trigger this dts job to run when
a three files are loaded into a certian directory.
I can have trigger files uploaded at the same time but
am just wondering what ways their are to acchive my goal?
I dont wa...more >>
DTS Package Reusability Posted by mike.schiewer NO[at]SPAM ssfhs.org at 4/23/2004 1:37:37 PM I am new to DTS. I have created a package containing several steps
using Oracle as the source db. The database contains several
instances of the same schema with different owners. A sample of a
source query follows:
SELECT HA.DEFENDANT.UID, HA.DEFENDANT.SEQUENCE,
H...more >>
Job status on Mainfram Posted by Obaid at 4/23/2004 10:58:10 AM We have this situation where we are trying to get a status
from Mainframe/DB2 replication (copy) in order to start
the load for SQL Server 2000. What it will do, it will
provide us the green signal that load was successful
(between MF and staging area) before next load.
Using DataJoiner f...more >>
Managing DTS layout Posted by rosdav007 NO[at]SPAM hotmail.com at 4/23/2004 7:48:49 AM Does someone know how to manage DTS layout (stpe
postion,coordinates,...)? Obviously without using DTS designer..
Bye...more >>
DTS / Interbase / Firebrid - Schedule Issue Posted by Neil at 4/23/2004 7:37:41 AM Has anyone ever successfully scheduled a DTS package to
connect and extract data from an Interbase/Firebird
database?
My DTS package will run under SEM but fails when
scheduled. Most of the time this would be linked to
permissions in some way but I have very carefully setup a
test envir...more >>
Saving DTS package to Visual Basic File Posted by Stuart Hearn at 4/23/2004 4:36:02 AM I'm trying to save a DTS package i've created in DTS Designer to a Visual Basic File. The DTS package contains a 'Transfer Databases Task' which copies a database from one server to another. This tasks runs fine if i save it to SQL Server, but i need to save to VB
If i try and save it to a VB file...more >>
How to ... dynamic 'delta-upload' ? Posted by rholling at 4/23/2004 2:41:02 AM Hi there
i want to implement a dynamic delta-upload
Source is Oracle, Target SQL2000; I want to extract data from Oracle only for a couples of days - perhaps the last 3 days and not a full upload of the whole table. The starting date and the ending date of this range are stored in a table in the ...more >>
How to call Webervice from DTS Posted by omg at 4/22/2004 3:56:07 PM What would be the best way to call a web service "http://MyServer/LoadData" from a DTS package. I started to look at the VBScript and JScript but couldn't find a solution
Any help would be appreciated. Thanks...more >>
DTS and Stored Procedures with # tables Posted by shyam venkatram at 4/22/2004 2:52:11 PM Hello,
I have a Stored Procedure that returns data from a # temp table. This proc
works fine with query analyzer. When I try to run this query from a DTS
package exporting the data to an excel , I cant seem to parse the query in
the "Transform Data Task Properties" as it cannot find the #tempt...more >>
Renaming DTS connnections via SQL Posted by Beema at 4/22/2004 11:54:20 AM I have numerous DTS's which import data from text files - there are around
30-40 text files sources.
I have named them all with all capitals and would like to change them to all
lowercase via an update statement in msdb, rather than doing them all one by
one.
Is this possible my running an ...more >>
Rename DTS Package Posted by Zaki Baig at 4/22/2004 10:34:10 AM Hi!
Can I rename a DTS Package. I have a big list of Packages
with indisciplined naming convention. I am planning to
rename all these packages by applying a proper naming
convention.
Can someone explain me how to rename the packages. I would
not like to use the Save As option as it is ...more >>
Error DTSRun.exe "Memory could not be written" Posted by Caro B at 4/22/2004 10:31:02 AM Hello, I've this problem (SQL2K SP3a)
A DTS process that has been running for 3 o 4 month, yertarday didn't run. It invokes OLAP tasks, such the process of dimensions
In the event log there was this message
"dtsrun.exe - Application error : The instruction at XXXXX referenced memory at YYYYYY. T...more >>
SQL Server Agent warning 208 Posted by Bob at 4/22/2004 10:16:27 AM I have a DTS package that suddenly failed after running
successfully for over a month. SQL SP3 is installed for
all instances. Any ideas would be helpful. Thanks Bob...more >>
Error Handling in DTS Package - Overwrite log file? Posted by ktgillen at 4/22/2004 7:41:02 AM Hello
I'm trying to perform package-level error handling within DTS. I would like to generate a log file when an error occurs within the package. I have been successful doing so, but do not like the fact that each time the package runs the file is appended to rather than being overwritten. Is ther...more >>
Log Shipping for Developer Edition Posted by Lalit at 4/22/2004 12:06:02 AM Hi Friends
I am having the Developer edition of SQL Server 2000. I need Log Shipping. From the books online i tried the procedures but could not configure. There is no proper sequence for configuration using T-SQL in books online
Can any one please tell me how to configure the Log Shipping
Wi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |