Hi, I have a DTS that checks to see if a file exists. The first ActiveX Script doe sthe initial check, and if not found reports failure. On...

Jon Derbyshire

10-21-2005 09:08 AM
SQL

I have a DTS package which exports data from SQL(2000 sp4) to Access 2000 all toll their are 40 Transform Data Tasks (each representing a table). 39...

scott.rick@cit-net.com

10-21-2005 09:03 AM
scott.rick@cit-net.com

I have a DTS package that is used to import a flat file into my database. This file is a rotating log file that could hold information that has...

Rob Booth via SQLMonster.com

10-21-2005 09:03 AM
Spaz

I am trying to execute a DTS package inside a windows service. The DTS is copying some data from an ODBC datasource to SQL Server. I think is a...

Marlene

10-20-2005 04:23 PM
Marlene

Hi I have a dts package that connects to an oracle database and an MSSQL database and moves some data from the MSSQL dbase to the Oracle dbase. I...

Paul

10-20-2005 04:10 PM
Paul

Hi Here is my Problem definition: I need to have capability to - import excel file with dynamic number of columns to sql server table - export to...

pm

10-20-2005 03:09 PM
Allan Mitchell

Im new to this and am having trouble with something that Im sure is simple. I am trying to Append data from one table in a Sql Server to anouther...

bob at zachys

10-20-2005 11:05 AM
bob at zachys

Hi NG We have a VB6 ActiveX DLL which we use from an ActiveX script in a DLL Set Obj = CreateObject("Library.Class") Obj.DoSomething Set Obj =...

Des Norton

10-20-2005 10:41 AM
Des Norton

Hi I need to execute DTS packages from a workstation within our LAN, and the prefered method is by using a cmd file that executes dtsrun.exe. How...

Andy

10-20-2005 08:24 AM
Darren Green

Hi, I'm "playing" around with SSIS and try to solve the following problem. I've an import folder which is filled with CSV - files from a legacy...

Uwe

10-20-2005 02:07 AM
Uwe Kuhne

Hello I created a DTS Package in my machine it runs fine on my machine (local). bt when i set up a job (to run on server) i get an error...

Fab

10-20-2005 01:00 AM
Allan Mitchell

Hi All, I have a DTS package that 1) Goes to an FTP site, 2) Copied a file to a directory, 3) Loads the file into a sql database. 4) renames the...

Warren

10-19-2005 05:47 PM
Warren

Hi, I have a DTS package which I am using to upload around 10,000 rows (using a DTS Transfer Objects Task). Our Internet connection only provides...

jensendarren@hotmail.com

10-19-2005 05:19 PM
Darren Green

Does anyone know how to stop a developer from creating a DTS package and/or a SQL Server Agent Job?

John Barr

10-19-2005 05:15 PM
Darren Green

Hi all, I am trying to run a DTS package from a Batcch file. I coded the batch file as follows: dtsrun /s sqlserver /e /n "currents_import" /U...

jaylou

10-19-2005 04:22 PM
jaylou

I am creating a DTS package in SQL 2000 with SP3. (Same issue in SP4) This package has one "Execute SQL task". The task calls a stored...

Rahul

10-19-2005 02:51 PM
Rahul

One of our former DBA's made some jobs with DTS-packages but I can't find the source for the packages. When I open the jobs I see DTS Run /~Z and a...

Zekske

10-19-2005 02:35 PM
Allan Mitchell

I have a loop that reads a text file and then archives it. I currently have it skip the first line of the text file because the first line...

AshleyT

10-19-2005 02:32 PM
Allan Mitchell

Hello- I am attempting to transfer stored procedures from a dev database to a production database. Using the DTS Import/Export Wizard, I select...

poul0004

10-19-2005 01:41 PM
poul0004

I have a tab delimited text file and I am trying to load that into a table with a real data type. Appears when it finds a value like 22,579.59 the...

karenmiddleol@yahoo.com

10-19-2005 11:16 AM
SQL

I've got some big flat files that need to go into a relational database. Some heavy scrubbing needs to be done for removal of duplicates, generation...

Joe

10-18-2005 11:37 PM
Sue Hoegemeier

I need to locate all date fields in all tables ... could that be done using some of this - or something...

michael v

10-18-2005 09:48 PM
Sue Hoegemeier

I am bringing in AS400 data into SQL. I found some data missing " hour:minute:second (AM or PM) " information. This data field is...

Justin Doh

10-18-2005 05:23 PM
Allan Mitchell

I work in DTS Package and this DTS insert fileds from TXT file into any table. I need control with ON ERROR RESUME NEXT the error "Violation of...

Luis Mena

10-18-2005 04:53 PM
Luis Mena

Seeking example of DTS script to consume a csv file, rename & copy it to an imported folder. TIA JeffP....

JDP@Work

10-18-2005 04:23 PM
Allan Mitchell

I am using DTS on SQL Server 2000 SP4 to get ~100K rows from an Oracle 9i db, it is slow. Anyone know of any articles with info on how to optimize...

David J. Cartwright

10-18-2005 04:14 PM
Allan Mitchell

Magnus Österberg wrote: This is not a backup job, and neither is it saved. This is an interactive dialog to execute a backup process immediately you...

Darren Green

10-18-2005 04:03 PM
Darren Green

There is a server here running Windows 2000 and SQL Server 7.0 Now, someone accidentally installed SQL Server 2000 Developer tools onto that server...

Ajay Odedra

10-18-2005 04:01 PM
Darren Green

Hi ALL, When i am passing global parameters for sql query (subquery) in Transform Data Task getting error For Example : SELECT * FROM (SELECT *...

Soma

10-18-2005 12:37 PM
Soma

Hi, I have a package (created using Enterprise manager IDE) with a DTSTransferObjectsTask. What I would like to do is to be able to modify the list...

Phil

10-18-2005 11:51 AM
Phil

I have the following keys in Consumption: - Plant - Material - Month - Year The above are the primary keys in the table and the following...

karenmiddleol@yahoo.com

10-18-2005 11:43 AM
Rebecca York

Hi, I am trying to work out how to pass parameters from an execute process task to a vb .exe and then return a code so that the package knows if that...

MJS

10-18-2005 11:24 AM
MJS

I got an error while trying to DTS a large text file 13GB large- the error message is "Error at Destination Row Number 20331257. Errors encountered...

SJ

10-18-2005 11:17 AM
SJ

First I am trying to use DTS for purging data. The first thing I want to do is export the data to be purged to a csv file. I am using parameters to...

Chris

10-18-2005 10:39 AM
Chris

Sorry if this is inappropriate in DTS ... this was the closest I could find for 2005 and SSIS. I'm trying to create a single, all-purpose SSIS...

Doug

10-18-2005 07:07 AM
Doug

I have a table that has about 250 fields in it, many with text fields where the sum of bytes for all fields is about 6000. This table is in SQL...

WayneM

10-18-2005 01:47 AM
Allan Mitchell

I need to create a text file from data in sql server, then ftp the file to a UNIX server on the same network. Creating the text file is no problem,...

Rebecca

10-18-2005 01:44 AM
Allan Mitchell

I was just wondering of a good method of releasing a DTS from a test server to Production. Are there any tried & tested methodologies for doing...

Ben Rum

10-17-2005 09:08 PM
Sue Hoegemeier

Also check out www.sqldts.com "SQL" <SQL (AT) discussions (DOT) microsoft.com> wrote

partha

10-17-2005 01:39 PM
partha

The text source connection does not show up as an icon in my connection box when i start a new package. How do i get it there? Thanks Chris

CJMONGO

10-17-2005 09:38 AM
CJMONGO

Hello, I have an issue with DTS. I have had a package that has run for several month without issues. But all of a sudden, the package is creating...

David Eaton

10-17-2005 09:03 AM
David Eaton

Hi, I need to upload data from multiple excel files and in each files there are bound to be more than one worksheet. I came across a very...

Jordan

10-17-2005 05:16 AM
Jordan

hi ! i have this VERY weird DTS problem with csv. everything works fine until a certain record was entered in the data. for example, the new member...

troubleD

10-17-2005 02:00 AM
Allan Mitchell

hi : How to set up password for existing DTS? thx nick

nick

10-16-2005 04:53 PM
nick

Hi, I'm importing a space delimited text file into a table that has specified data types of int and smalldatetime -- which is throwing the error,...

vesta

10-15-2005 06:19 AM
SQL

Hi guys, a stupid question, is ETL part of DTS? if it's not, how do I learn it?

Kevin

10-15-2005 06:11 AM
Allan Mitchell

Here is my requirement. I need to copy the zip file from one domain to another using DTS package. The zip file has a .bak file which then needs to...

GS

10-15-2005 06:07 AM
Allan Mitchell

Hi all, In my project we are writing around 150 DTS package. Everytime we make any small modification to any of these DTS package, we have to test...

GS

10-15-2005 06:05 AM
Allan Mitchell

Hi all, We reoved a user from our database, but there were a few DTS jobs that had that user as the owner. Is there a way to change the ownership of...

jaylou

10-15-2005 06:01 AM
Allan Mitchell

Hi, I have a user table that's now storing username and password in clear text. I'd like to replace the current password field with a new field that...

WB

10-15-2005 05:56 AM
Allan Mitchell