Rating Thread / Thread Starter	Last Post	Replies	Views
Import DTS Structure storage file Hi All, Are there anyway to import the DTS struture storage file without user interaction? Cheers Good. Good	03-21-2005 01:19 PM Allan Mitchell	1	62
DTS remote run problem Hi All, Now, I am facing a problem that related to remote execute the DTS package. The situation is as follows :- First , I create a local package... Good	03-20-2005 02:48 PM Allan Mitchell	3	70
3rd working day Hi all, Is there a way to schedule a DTS pacakge to run on the 3rd working day of every month? TIA, Joe jaylou	03-20-2005 11:29 AM jaylou	7	62
moving large volume of data from db2 os/390 to sqlserver 2000 We are migrating a few application off the DB2 OS/390 to SQL server 2000. There are millions of records in DB2 that I want to move to SQL server. I... sql rookie	03-20-2005 01:24 AM DB2	2	67
Shelled Command Line Not Visible I have an Access frontend that controls the running of several MS SQL Server DTS packages (among other things). I dynamically build a command line... John Baker	03-19-2005 03:13 PM ByteMyzer	1	60
Re: Linked SQL Server to Access Sorry for the late reply...I've been out of town. Anyhow, if you use this code: --Everyone connects via Admin Access db user EXEC... oj	03-19-2005 12:15 PM oj	3	66
Help needed with ActiveX script Hello I hace creatre a dts package that uses an ActiveX script to either insert or update existing records in an Oracle RDB database. The script... Jim Wile	03-19-2005 07:59 AM Tom Moreau	9	111
How to do processing of a load file record by record I have a given data file to be loaded into a SQL table. I want a sample vbscript that shows how I can do processing record by record. What I am... Karen Middleton	03-19-2005 07:54 AM John Baker	2	86
How do I determine if DTS Package exists on Server? How do I determine whether or not a specific DTS Package (I know the name of the package) exists on the Server? Thanks for your help, - Joe Geretz - Joseph Geretz	03-18-2005 04:37 PM Darren Green	4	108
DTS & FTP: Missing all the files We have tried to use the FTP task within the DTS package to pull information from a particular web site but have seen erratic behaviour in the past... dabroc	03-18-2005 04:33 PM Darren Green	1	62
Can't run DTS Package in production environment Hi, I have a VB.NET application that call a SQL 2000 DTS package. This worked fine when running the client application from my machine but as soon... Chris Lane	03-18-2005 03:35 PM Chris Lane	1	68
How to get a DTS package run to be triggered by a email I have a scenario where the data to be loaded into SQL comes in a email. The business is asking me to build a package that will enable the email to... Karen Middleton	03-18-2005 11:53 AM Francesco Anti	1	77
Error Modifying Package I am having some problem creating a new DTS task or modifying an existing one. My goal is to transfer data from a table (tableX) to a text... Emma	03-18-2005 11:47 AM Emma	0	60
Excel Data not seen in Source Preview Hi I have a DTS package where in i am pushing data from Excel to Sql server database. When i look at preview of the source (i.e Excel ) in... System.Xml.XmlDocument	03-18-2005 09:22 AM Simon Worth	1	63
bulk export task (sqldts.com darren green) how to export column header Hi, I am using the wonderful DTS Bulk Export Task (www.sqldts.com/default.aspx?237) How do I export the column header (names of columns) into the... vchakravarthy@datalabusa.com	03-18-2005 08:16 AM Darren Green	8	95
Help with text file Connection Ive beeb trying unsucseffully to use a dts to import this file into two tables "200001" "999999" "75" "999999" "004" "24/03/2005" "001" "Fhead (AT)... Peter Newman	03-18-2005 06:31 AM Peter Newman	7	86
First row of the text file Hi! I need to import a text file that has the date in the first row, and some data columns in other rows. That date I need to insert in the same... Yuliaan	03-18-2005 04:00 AM Darren Green	4	87
How to change the Postfix -ve sign to prefix sign Hello All The text file containing weekly sales comes from a legacy system which reports negative numbers with the negative sign in postfix form... Karen Middleton	03-18-2005 02:48 AM Darren Green	3	75
vbNo or vbCancel not working Hello. I'm fairly new to programming and have what is probably a simple question. I have the following code which displays a message box on... ddobier	03-18-2005 02:30 AM Darren Green	3	79
Comparing two rows in a Table Hi Gurus, Is there any automated way to compare the contents of TWO rows in the same table of SQL Server ? Thanks in advance. Regards, Yog Yog	03-18-2005 01:41 AM Yog	2	65
Copy SQL Server Objects Task & Dynamic Properties Task Using native DTS, can you expose the DataSource "source" and "destination" properties? I've noticed the connections are not listed when you open... doug	03-17-2005 11:27 PM doug	2	65
Stored procedure in Exec SQL Task G'day all, I'm trying to use an Exec SQL task (SQL Server 2000) to run a stored procedure and assign a message string returned by the proc to a... peterDavey	03-17-2005 07:13 PM peterDavey	2	51
Please help on Datetime DTS Transformation Hi, Could someone help me with the Datetime DTS Transformation? I try to import the Text (fixed length) file into the SQL table and having problem... T Tran via SQLMonster.com	03-17-2005 05:24 PM T Tran via SQLMonster.com	4	74
Running external program in scheduled DTS package I'm trying to schedule a DTS package that generates a flat file and then does an SFTP upload of that file. The package runs a batch file (using... Dave B	03-17-2005 04:37 PM GMRDev4	2	70
Converting data from Unidata into SQL I'm trying to convert data from an IBM.Unidata file system; I have the file structure, I have the installation disk(s) for the Unidata server; I... Ovi Mine via SQLMonster.com	03-17-2005 03:55 PM Ovi Mine via SQLMonster.com	0	68
How to cleanse a data file like this in DTS Hello All I get the following data file which as some page headers and column headers I need to get rid of the page headers and column headers... Karen Middleton	03-17-2005 03:44 PM Karen Middleton	2	67
Parse for a numeric string using ActiveX in DTS Hello, I'm trying to parse for a numeric string from a column in a table. What I'm looking for is a numeric string of a fixed length of 8. The... SQL_developer	03-17-2005 03:04 PM Allan Mitchell	7	72
DTS package for getting all Client info Okay - Here's the situation, and let me know what you think is the best approach, all ye SQL gurus. ;-) - Our Clients have requested a feature... Aaron Longnion - Cosential	03-17-2005 02:01 PM Aaron Longnion - hotmail	9	68
Anomalous Behavior in DTS Has anyone else seen this type of behavior? I have a DTS package. The first thing that it does is it checks for the existence of the import files... anrwlias	03-17-2005 01:58 PM anrwlias	0	70
Exporting data to mySQL Does anyone has any experience with exporting data from SQL Server 2000 to MySQL. When I try to export using ODBC it gives an error because mySQL... Roshan Jayalath	03-17-2005 01:29 PM Allan Mitchell	1	68
dynamically populating cell drop down based on more than two cell values I have a static data in my database table with five level hierarchy. something like this. 10 countries something like this. So basically i have... pm	03-17-2005 01:26 PM Allan Mitchell	1	57
ActiveX to find files containing an specific word ( 1 2 ) Hi All, Sorry if this question is more VBScriptish one. I' trying to find an specifc file on my computer through my DTS package .I'd like to give my... RayAll	03-17-2005 10:54 AM RayAll	10	109
DTS Dynamic Property Task and Query Option Hi I'm trying to use Dynamic Property Task to set SQL Statment for a transformation. I'm assuming this is possible by going into the Disconnect Edit... Rashmi Jagadish	03-17-2005 08:37 AM Simon Worth	3	81
Dev to prod switch with ORacle database... Hi, I have developped a lot of DTS packages on an SQL Server database. 1 of our client use Oracle instead-of SQL server for the same database... Jéjé	03-17-2005 07:32 AM Jéjé	2	50
Text File (Source) Connection Thanks to help from here i can use the folliing axtive x code to dynamicly set the source filename Dim Oconn Set oPkg =... Peter Newman	03-17-2005 07:10 AM Darren Green	1	70
DTS Package Class Not Registered Error From C++ Application Hello. I have a Windows service written in C++ that imports a text file to a SQL 2000 SP3 database using a DTS package. It has been running fine on a... wcmsuser	03-16-2005 07:39 PM wcmsuser	0	81
Tumbleweed All, Our Network guys purchased Tumbleweed hoping that will help us filter out any email with an attachment sent via mail task (DTS) to our clients... Li Kuan Yew	03-16-2005 04:03 PM Li Kuan Yew	0	68
Sending mail on Package Failure I'm new to DTS and I would like to know how to send an emai notification, that is, execute an activex script if any of the task in the package... anotherfinemess	03-16-2005 03:44 PM Kathy FM	5	79
package error Hi, I'm new to MS SQL. We're trying to get data from data warehouse to our MS SQL 7.0 server database. I got a package error when I tried to update... lan	03-16-2005 01:45 PM lan	0	64
DTS Question hi, I have a DTS package for selecting data and updating data in a loop , and set ths DTS a job starting at 8:00 Am every day . There are 5 similar... Steffi	03-16-2005 01:28 PM Allan Mitchell	1	67
Exporting to a text file (no headers)...Define Column Crash Problem: Need to get information from either a table directly or a sql statement to a fixed width txt file (no headers) . Every time I click... dabroc	03-16-2005 01:26 PM Allan Mitchell	3	84
Text File Source if i have a Text file Source object, can i set the 'import File Name' from an activex script ? Peter Newman	03-16-2005 01:25 PM Allan Mitchell	1	79
Assign value to Global Variable I am creating a DTS package to import from a txt file (YYYYMMDD.TXT) to a table in SQL 2000 Database. Here are the steps I am using: 1. I create my... Jayesh Shah	03-16-2005 01:24 PM Allan Mitchell	1	61
DTS bug? Dear all, I'm trying to export five millions of rows to .CSV file from a DTS of a remotely way, i.e, database is allocated in Buenos Aires and the... Enric	03-16-2005 01:23 PM Allan Mitchell	2	92
DTS user choise (Windows / SQL) What is preferred ? If sql I need to store the name and password somewhere - that could be a problem - if windows I have yet to see it work the... Michael Vardinghus	03-16-2005 01:21 PM Allan Mitchell	1	54
Error I have a DTS package where I execute sp in Execute SQL Task Properties and then on sucess I have execute process task. When I run this DTS manually... anonymous	03-16-2005 01:15 PM lan	3	93
Importing file with unusual delimiter I am trying to import a text file via DTS that has an unusual delimiter. I am used to files like this A,B,C D,E,F This file is like this A,B,C ... Andy	03-16-2005 01:11 PM Andy	3	65
Cannot create COM Server to load and execute DTS Package I am now suddenly plagued by this problem. Stopping and re-starting Sql Server and the Agent service allows the jobs to run successfully again,... Brennan	03-16-2005 12:56 PM Brennan	0	171
Importing text file I am trying to import a text file and am having problems. The file is not setup where each record is on a line. It contains numerous records on a... Andy	03-16-2005 12:25 PM Ilya Margolin	1	60
DTS custom task Have a SQL server on inside interface of Cisco PIX firewall and have a SQL server on a webserver on DMZ interface of the PIX. Opened port 1433... RH	03-16-2005 08:47 AM RH	2	77

Page 139 of 258

139

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off