Rating Thread / Thread Starter	Last Post	Replies	Views
DTS Takes forever to save Yes, just sent a response. Sorry for the delay on my end. "Michael Cheng " <v-mingqc (AT) online (DOT) microsoft.com> wrote Scott M	10-02-2005 02:33 PM Scott M	4	84
DTS as job hang on execute since SQL Server 2005 September CTP In order to run SSIS packages, I recently installed the following components of SQL Server 2005 September CTP on my SQL Server 2000... jberkson@gmail.com	10-02-2005 01:50 PM jberkson@gmail.com	0	97
Re: Uploading Files via DTS I have only ever used a GUI FTP client in Windows. In Unix/Oracle I have run FTP commands but only on a manual line by line basis. I am not sure... Dazza	10-02-2005 04:28 AM SQL	3	80
Is there a way to do a DTS load on type TEXT fields? I have a table with 3 TEXT fields. DTS doesn't seem to want to load into TEXT fields, as I get an error from DTS when trying to do this. Is there... Brian Kitt	10-01-2005 04:28 PM Allan Mitchell	1	80
DTS Error Hi , I created a DTS package and it running fine when I run in design view. But when I scheduled it , it fail to run and I get this kind of error... Travis	09-20-2005 10:26 PM Travis	0	79
Log Import Error I have a data warehouse that imports all of the required profile, transactions, logs, etc. on a daily basis and has been running fine. The other... RLanoue	09-20-2005 10:20 PM Peter Yang [MSFT]	1	106
Can change SourceObjectName of Data Pump Object? I am trying to change the SourceObjectName of a datapump which reads an Excel file. It poops on: tsk.SourceObjectName = "Sheet2$" saying... Snake	09-20-2005 06:02 PM Allan Mitchell	2	152
DTS Packages Not Saving Changes I am having a problem with DTS packages not saving changes. For example, this morning, I spent fours hours changing VBScript code and other things in... SJM	09-20-2005 02:40 PM SJM	4	78
How to schedule dts package through web browser? Hi all, DB: SQL Server 2000 Enterprise how can I schedule dts package through web browser? can I make it be possible by programming? thanks jxf	09-20-2005 02:30 PM Allan Mitchell	1	77
sp_OACreate Pls explain the ad's and disadv's of sp_OACreate. Sara	09-20-2005 02:23 PM Allan Mitchell	1	83
Can I run a Script at scheduled time? Hi all, I have to run a DTS on a remote server, which copies data from one DB to another on same server. The problem is, the connection is poor and... k_s	09-20-2005 02:14 PM Allan Mitchell	2	75
Use Insert Update Delete in DTS I have an Access table from which I have to get data periodically in 30 minutes everyday to an SQL server table. both have the same data structure.... Sudhir Krishnan	09-20-2005 09:01 AM Sudhir Krishnan	4	117
Distributing an application that leverages DTS I have the situation where I developed an application that mass converts databases using the Import/Export wizard. I exported the VB code and I... RSH	09-20-2005 08:15 AM RSH	0	67
ActiveX Script User ID/Name Does anyone know of a command or a way of extracting the User ID and/or Name during the ActiveX script to then use that value to load to the table... Jim	09-20-2005 07:37 AM Ilya Margolin	1	62
Free Evaluation of Database Administration Software AgileInfoSoftware DataStudio 4.2 is in beta and will soon be released, please download your free evaluation and provide us your feedback. Major... John King	09-20-2005 07:08 AM John King	0	61
.\Resources\2057\DTSRUN.RLL Hi, Im trying to find the .\Resources\2057\dtsrun.rll distributable files (and other associated resources in the same dir)- becuase some... JE	09-20-2005 05:59 AM JE	0	90
Max length of string global variable Is there a max length for DTS Global Variables of type string? I have a stored procedure that I am running using an Execute SQL Task and it... Andy	09-20-2005 05:23 AM mehdi	3	101
modift dynamicily a dynamic properties task Hi, I have a dynamic proprerties task wich have a .ini source type. I would like to modify dynamically the section of the .ini. I get the value of... mehdi	09-20-2005 02:55 AM mehdi	2	66
SSIS Data Flow Task Parameterized Query - Oracle Hi everyone, I have what seems to be a common problem. I'm using SSIS to pull data from Oracle. I have an Execute SQL Task that sets a variable... mark.dalton@ceridian.com	09-19-2005 02:43 PM Allan Mitchell	3	142
Exluding Row while insert Hello, Is it possible to exlude some rows during insert in DTS? or is it possible to exlude last row from insert batch Thx kailux4	09-19-2005 01:10 PM Tom Moreau	3	73
DTS Import from file split field create multiple records Hi guys, I am creating a DTS in SQL server by importing from a tab sep file, I realized that one field could contain multiple, comma... Paolo	09-19-2005 09:08 AM Paolo	2	79
How to import the following XML using Integration Services? Hi, I use the SQL Server 2005 June CTP and I need to import the following XML into a database table. I tried to generate a XSD out of it, but SQL... Sascha	09-19-2005 05:25 AM Sascha	0	56
Data Pump Task Error I have a data pump task in which I am pulling data from Oracle to SQL Server, so hopefully somebody in here can help me out. The data pump task is... Andy	09-19-2005 04:43 AM Rajesha	4	98
Which is better? Is it better to copy objects such as tables to a remote server or to us a datapump and push the data to another remote server? Shawn Ferguson	09-17-2005 02:56 PM Allan Mitchell	3	89
How to find the record # being processed I am loading a text file and I want to know if there is system global variable into which stores the current record # from the file... karenmiddleol@yahoo.com	09-17-2005 10:15 AM Allan Mitchell	6	65
How to skip after n records(tail of the file) I have a file which as the first 15 lines of header lines I can skip them in DTS file task. Then I want the next 10 records extracted and after that... karenmiddleol@yahoo.com	09-17-2005 05:42 AM karenmiddleol@yahoo.com	0	71
global variables with the utility DTSrun I am launching DTSrun using global variables with /A. I have to pass the parameter "col1=col2" I have a problem: it only passes col1. Everything... mehdi	09-17-2005 02:38 AM Allan Mitchell	1	86
DTS ERROR I am trying to schedule a DTS package but it is giving me a error when i tried using the execution steps..., the error message is "... richard s via SQLMonster.com	09-17-2005 02:30 AM Allan Mitchell	1	83
Load IBM MQ Messages I would like to which tool is best to Load in thousands of IBM MQ Messages super fast into SQL Server. I understand DTS has an MSMQ but I guess this... D1p4k	09-16-2005 01:41 PM D1p4k	0	66
Multiple delete statements in ExecuteSQL Task from VB. I'm having a problem with a couple of Execute SQL Tasks in my packages, with multiple DELETE statements. If I put a GO statement anywhere, between... mattdeubert@hotmail.com	09-16-2005 10:55 AM Doobs	2	68
Text Import using web address I'm using a DTS package to import a text file. Everything works properly locally during the testing using a text file on my desktop. But now I need... billyg@vicksburg.org	09-16-2005 10:54 AM David J. Cartwright	2	67
Text file with over 200000 records into SQL Server What is the best way to set up a DTS routine to input the textfile with over 200,000 records into a database table once every month. Currently... Shawn Ferguson	09-16-2005 08:55 AM Brian Lawton	3	69
MS JET database engine error: workgroup information file is missing or opened exclusively by another user Hi, I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget using Microsoft JET database engine, but it gives me an error saying "... Tina	09-16-2005 08:06 AM mcnewsxp	4	117
Dynamic DataBase Hi there, I built a new DTS using the Export Wizard and saved it. Now, in order to have the data base dynamic, my code (visual basic) goes like... Elizabeth	09-15-2005 03:18 PM Elizabeth	7	105
Query to determine which DTS have sa hardcoded I am looking for a query I can run that will tell me which DTS packages have sa and password hardcoded into them. I'm not sure what systems tables... Mitch	09-15-2005 11:31 AM David J. Cartwright	3	60
DTS Designer Error Server: Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition... DXC	09-15-2005 09:45 AM DXC	4	225
How to handle large number of attributes for a dimension I have a Product dimension on which I expect about 90 attributes mainly they are related to classifying the material. Can somebody please share... karenmiddleol@yahoo.com	09-15-2005 08:43 AM Peter Nolan	5	66
SP output to a text file using DTS I really need a solution a.s.a.p. so I am stating my case from the stand point of what it is I am trying to do and what I have done. Overview: When a... Gary	09-15-2005 12:30 AM Allan Mitchell	8	103
how to schedule dts packed? Hi All, I want to job schedule my dts packed everyday. When i right klik in dts schedule package is grey and can't be klik. how to make the schedule... Andry Cahyadi	09-14-2005 11:19 PM Andry Cahyadi	0	82
Merge 2 DB I need to merge 2 databases to 1. This will take some time, and I'm making a DTS package for it. Now I have 2 tables, Rooms and Departments. A... Stijn Verrept	09-14-2005 08:25 PM Stijn Verrept	0	103
How to execute a DTS package from within Access 2000 I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control... JDGUILTY	09-14-2005 03:00 PM Allan Mitchell	1	63
Newbie needs to create DTS using 3 DBs i need to create a DTS that operates as follows: Table A resides on server I, DB X, and receives the new rows and updates based on values found in... mcourter@mindspring.com	09-14-2005 01:40 PM Allan Mitchell	4	69
DTS transformation dynamic automatic matching columns Hi, I am copying about 100 tables from Base A to Base B and more exactly pat of tables from Base A to Base B example copy 50 first line from... mehdi	09-14-2005 01:30 PM Allan Mitchell	1	100
Active X and stored procedures Hello, I want to write the results of a stored procedure to a text file in active x task in dts. I have the code to write the text file but what I... Gary	09-14-2005 01:28 PM Allan Mitchell	4	78
"not enough storage is available to complete this operation" I have just installed SP4 and now when I try to create a new DTS package that imports data from a text file I get the error "not enough storage... A.B.	09-14-2005 08:08 AM Ilya Margolin	3	136
Transform Data Task - Fire Triggers Hi All! Hope someone can help me with this. I have a DTS package that loads my data warehouse, and the steps that actually load the sales data into... Nick Colebourn	09-14-2005 04:31 AM Nick Colebourn	0	77
Linked Server I am trying to set-up a Linked Server in SQL 2000 to AS400 iSeries. I would appreciate if anybody out there has the relevant syntax to facilitate... Allan.	09-13-2005 11:51 PM Allan.	2	100
SepCTP: Why can't I use the Reporting Services Web Service from SS I can download the WSDL file. But when on the Input screen I select the ReportingService as the Service I get the error message TITLE: Web Service... D. Greene	09-13-2005 09:29 PM D. Greene	0	78
Output parameters I have an "Execute SQL Task" that reads from a table like this: select top 1 company_id,filelocation, filename from... Gary	09-13-2005 04:49 PM Allan Mitchell	1	64
DTS Parameters I am using "Execute SQL Task" to execute the following statement: Select top 1 companyid from file_locations where statusid=0 I want to pass the... Gary	09-13-2005 04:41 PM Gary	2	86

Page 111 of 258

111

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