Rating Thread / Thread Starter	Last Post	Replies	Views
restoring the database from azip file 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 05:07 AM Allan Mitchell	3	56
Automating DTS testing 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 05:05 AM Allan Mitchell	1	62
Changing DTS Job owners 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 05:01 AM Allan Mitchell	4	67
Encrypt Password Field Using DTS? 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 04:56 AM Allan Mitchell	1	55
Create Excel From SQL Server I'm trying to create an easy way for end users to get an excel spreadsheet with data from a SQL Server database. I can easily do this myself with... Christian Duffett	10-14-2005 04:10 PM synopsis	5	79
DTS connection speed I have 4 dts's which transfer data from SQL Server (2000 SP4) to Oracle 8.1.4.7 The distance is large (Europe to Asia) so timing isn't great.... Ben Rum	10-14-2005 10:09 AM Ben Rum	4	73
Copying DTS Packages. Is there an easy way to move DTS packages between servers ? Simon	10-14-2005 06:15 AM Simon	2	75
FTP Put, rather than fetch Hi i need to put some files from a driectory on a sever across to a live web site on a regular basis. My problem is that the FTP task is set up to... tease	10-13-2005 11:24 PM Stacy McDaniel	3	84
DTS GUIDs? Does SQL Server store the GUIDs for DTS packages in a table anywhere? Something similar to sysobjects or sysjobs. StacyM	10-13-2005 11:20 PM Stacy McDaniel	2	80
Packaged Deleted But Still Running/Scheduled I created a few packages for DTS to export on a daily basis. For some reason, they have an error. So I deleted them. But they seem to be still... will	10-13-2005 11:17 PM will	2	50
ActiveX WorkFlow Problem I have and ActiveX Script Task that transferes a file over FTP. I then have an ActiveX WorkFlow script that checks to see whether the file has been... M Dodsworth	10-13-2005 02:06 PM Allan Mitchell	1	53
shecule job to run a dts package failed. I create a DTS package to transfer data between an oracle and a sql2000 servers. When I manually exute the package, it ran through... Fei	10-13-2005 12:36 PM Andrew J. Kelly	1	60
Encoding problem when trying to import from dBase files Hi, I'm trying to import data from dBase files, import is almost success, but occur problem with character encoding in string fields, dBase files are... mehal.box@gmail.com	10-13-2005 11:57 AM mehal.box@gmail.com	2	66
Dependencies of stored procedures in DTS packages I'm working on a little program to document all of my DTS packages using the DTS package library and vb6. I have written the code to enumerate all... Matt Williamson	10-13-2005 09:48 AM Jacco Schalkwijk	4	103
Ignore Duplicates Index fails DTS Job I have a series of DTS packages that execute on a scheduled requency. The various jobs import data from multiple data sources. In case the... MavRx	10-13-2005 02:52 AM MavRx	3	96
how to change the date format Hi, I have created a DTS to import a set of data from excel to SQL table. The date format in excel is dd/mm/yyyy HH:mm tt. I want to change to date... Tiffany	10-13-2005 12:45 AM Allan Mitchell	3	86
SQL 2000 SP4 - General network error?? Hi peeps, Wondering if anyone can help me. I have numerous SQL databases on a server which was SP4'd and then upgraded to windows 2003. Since then... techcs	10-13-2005 12:36 AM DKRReddy	2	53
AWE + dts = system unresponsive during loading... Hi, I have some DTS packages to execute, after I have activated the AWE option, the system become unresponsive for some seconds during loading. not... Jéjé	10-12-2005 09:12 PM Jéjé	0	59
Execute Proccess Hangs In SQL Server Agent Hi all, I have a SQL Server 2000 DTS that ends with an execute process task; it works fine when run from the designer in Enterprise Manager, but not... Matthew Brown	10-12-2005 05:40 PM Matthew Brown	2	91
one table corresponds to one text file The purpose of using this custom task was to extract 100+ tables to text files for our data warehouse project; one table corresponds to one... Johnson	10-12-2005 04:27 PM Darren Green	3	70
export XML to file I am trying to create a file from a sql statement that uses for XML. Using the DTS wizard the output is binary. I found the advance properties... DaveK	10-12-2005 03:49 PM Darren Green	1	93
New To DTS; Import many databases Hi Folks, I am pretty new to DTS so I am asking you for some hints. I need to import many Access databases (approx 90) to a new database on the... Stephan Zaubzer	10-12-2005 03:22 PM Allan Mitchell	3	56
Can SQL Server import with errors? Is there a way for SQL Server to complete or continue an import even though a row or two may have wrong/invalid data? With MS Access it would just... kenkrum@gmail.com	10-12-2005 03:11 PM kenkrum@gmail.com	2	50
Invalid transformations detected. Verify and retry your transformations. Dear all I'm using SQL Server 7 + SP4. When i edit a DTS and want to save it , "Invalid transformations detected. Verify and retry your... jeff	10-12-2005 03:02 PM Allan Mitchell	2	77
Exporting a table and importing it I want to export 3 tables in a SQL database with the table definition and want to then import from this dump into another SQL database where these... karenmiddleol@yahoo.com	10-12-2005 07:59 AM JT	3	69
Strange application pop-up error! I note many occurence of the following error on a Windows 2000 server with SP4, running SQL Server 2000 client: Event Type: Information Event... Patrick	10-11-2005 10:27 PM Sophie Guo [MSFT]	3	83
DTS Package Job Failure Below is the error message I am getting on my dts package - Any help will be appreaciated. Executed as user: BHCS\sqlsrv. DTSRun: Loading... ... Aboki	10-11-2005 02:51 PM Darren Green	1	76
Primary Key Constraints Hello, I am trying to do an insert from one db table to another. It works great until a record that is a dup of one that is already in the... gaiams via SQLMonster.com	10-11-2005 12:20 PM SQL	1	70
Creating DTS packages with VB.NET and DB2 Hello, I would like to use the DTS object model and VB .NET to create DTS packages to connect to DB2 and export data to CSV and XLS formats as well... Ric	10-11-2005 09:48 AM Darren Green	1	58
slow dts I'm exporting data from SQL 2000 to sybase 11. the dts is extremly slow (takes over 1 hour for 5000 rows.) the tables in sybase do not have any... zino	10-11-2005 05:03 AM Sophie Guo [MSFT]	4	95
Problems with Excel data pump I have a DTS pacakge and am creating an excel file using an activeX task. That piece works fine. I am then using a number of data pump tasks to... Andy	10-10-2005 07:37 PM Andy	2	64
Derived Column in SSIS I'm trying to author a .dts package that will combine two number fields (in my source MS Access database) to form a date, which would then be stored... rswolff@noemail.noemail	10-10-2005 04:19 PM Andrew Watt [MVP - InfoPath]	2	98
DTS job hang at ActiveX script steps Dear all, We have a set of scheduled DTS jobs which run OK for months on SQL2000 SP3. Recently (since mid July) we found them hang up and cannot... Eric Fung	10-10-2005 03:56 PM Spsk	7	100
smalldatetime When importing data from Microsoft Access, DTS automatically uses smalldatetime for the Access data type datetime. How can I change this to... Ferdinand Zaubzer	10-10-2005 03:35 PM Allan Mitchell	1	68
RE: DTS package that imports a CSV file from an URL Thank you, Name is always same. I am using SQl Server 2000. I see only FTP Task in it. No HTTP task. When I put URL it was asking User Credentials.... SivaRCherukupally	10-10-2005 11:36 AM SivaRCherukupally	0	85
New to DTS Hello, Im learning how to use DTS and currently just reading the MS sites trying to undersand...can some explain why is does not work? Function... Fab	10-09-2005 03:13 PM Allan Mitchell	3	61
ActiveX Script Reusable Somebody use ActiveX Script Reusable. Please tell me how do it. Thanks everyone. Luis Mena	10-08-2005 02:45 PM SQL	1	66
Importing Data from Excel file Hi All, I'm importing data from an Excel file, it works fine but when data like 32/40 comes it insert null into database, eventhough i declare... Manish Sukhija	10-08-2005 11:58 AM SQL	1	59
DTS Designer Error When I open the DTS designer, I am getting the erro say "The extended attributes are not inconsistent". Can anybody help me out to resolve the... Belton	10-07-2005 04:49 PM Allan Mitchell	1	78
Restoring a DTS Package Hi all, A developer deleted one of his DTS packages from a DEV server. Unfortunately we only backup DEV weekly and his creation and deletion happened... jaylou	10-07-2005 03:43 PM Allan Mitchell	1	84
SSIS - Dynamic Data Source Hi I'm having problems on create a loop package with dynamic data sources. I have 36 databases do connect and I want to create a loop to... CarlosR	10-07-2005 03:36 PM Allan Mitchell	2	98
DTS Transformations I've been reading post for about two days now, however I have not been able to find the solution. Issue: Dynamically create source and destination... Eli Lawson	10-07-2005 03:24 PM Allan Mitchell	4	69
SSIS - Programmatically add slowly changing dimension to data flow Hi! I have to create a lot of complex SSIS packages that should be created automatically to save time for mapping hundreds of columns in the... Wilfried Mausz	10-07-2005 02:26 PM Wilfried Mausz	0	334
Thread problem for DTS in VB .Net Hi, I develop a VB .NET application to call DTS COM to import text files into SQL Server 2000 EE SP4. We need import more than 60 files by a loop.... Bill Wang	10-07-2005 12:36 PM Bill Wang	1	61
DTS Excel Dynamic change Error I have a DTS that imports data from Excel into SQL. It only works if the file name and location are exactly the same every time. I tried using... bnhcomputing	10-07-2005 12:14 PM bnhcomputing	0	57
SQL -> Excel File I'm creating a DTS package which creates a temp table, insert some records in the temp table, export those records to an excel file and finally drop... No_Spam	10-07-2005 10:28 AM David J. Cartwright	2	80
Frozen Lineage Problem Hi, When I Try to run my DTS Package I get the error: "Error string: This version of the current DTSPackage is frozen in the Repository. Its... miguel.salles	10-07-2005 09:00 AM miguel.salles	2	67
Strange error when using named-query Hello, i use a CTP of Integration Services 2005 at the moment, to test one of our ole-db providers. This provider works almost perfectly in DTS... Max Berghammer	10-07-2005 03:02 AM Max Berghammer	2	68
how to Execute DTS package in Store Procedure Do you know how to execute DTS package in Store Procedure? -- shooi shooi	10-06-2005 11:47 PM Sue Hoegemeier	2	70
Using DTS global var in a concatinating string Using a DTS package, I want to use a global variable to concatinate a string for a table name I want to query. I then want to use the results as... Steve	10-06-2005 04:50 PM Allan Mitchell	1	53

Page 109 of 257

109

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