Rating Thread / Thread Starter	Last Post	Replies	Views
Creating/adding column description, not caption I originally created an SQL 2000 database from Access 2000. I stored the field descriptions in Access 2000 but they didn't transfer over during... R.V.	05-17-2005 07:04 AM Sue Hoegemeier	1	62
Need Example exec proc from VBScript ActiveX DTS. ( 1 2 ) I need to exec a stored proc with one int input param, one int output param, and a Return int from within an ActiveX VBScript. I have been working on... Snake	05-17-2005 06:20 AM Helge C. Rutz	13	285
execute DTS from a cube action User needs to export the result set from a cube to an excel sheet. I was hoping to use DTS to accomplish this by adding a DTS execution command as... rama via SQLMonster.com	05-17-2005 04:01 AM rama via SQLMonster.com	1	66
Different version of SQL Server (DTS) Can I get high confidence that DTS packages (Saved as a *.DTS File) using SQL Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP... Patrick	05-17-2005 02:17 AM Darren Green	3	66
Documentation template Hi, Does any one have a link to some good DTS documentation templates. ? I am looking for a template to document my packages cheers, siaj siaj	05-17-2005 01:02 AM Allan Mitchell	1	78
DTS export Hi, I have strange problem in that I'm exporting data into a text file - which works fine but it is generating an additional blank record at the... Harbinder Bansal	05-17-2005 12:58 AM Allan Mitchell	1	83
DTS Import Problem Hi Experts, Appreciate if someone can help me. I'm trying to import a text file mytable.txt delimeted with pipe(\|) and containing 300K of rows into... GW	05-17-2005 12:56 AM Allan Mitchell	7	89
Executin DTSrun Utility under the xp_cmdshell I am attempting to execute a DTS package from Query Analyzer using the DTSrun utility under xp_cmdshell. When I execute the package, I receive... rallbee	05-17-2005 12:54 AM Allan Mitchell	8	166
ActiveX Cannot Create Object I have a dts pacakge in which an ActiveX Script task probes outlook inbox saves the excel attachment. This runs fine when I execute the... Karunakaran	05-17-2005 12:48 AM Karunakaran	9	299
Preventing double-loading of input files I have a situation where I'm loading text files into a database. Filenames are reused, so two files with the same name might hold different data. ... DavidStallard	05-16-2005 05:22 PM Panch	5	70
Dynamic DTS ( 1 2 ) In am importing various delimited files in to different servers/databases. The DTS has dynamic properties, a execute SQL task to clear the tables,... goinesj@paec.org	05-16-2005 02:58 PM goinesj@paec.org	11	160
DTS Steps in wrong order I am trying to recreate the dialog that appears when you manually run a DTS package (DTS.Package2) in SQL Server 2000. To populate the list, I... Chris Lieb	05-16-2005 02:46 PM Chris Lieb	4	90
Aggregate Function in Set List of Update Statement I want to use an aggregate function (Count) to set a field value in an Update statement. I get an error that states this is not allowed. I could do... Robert Hamilton	05-16-2005 12:47 PM Robert Hamilton	3	55
How to use BCP with a transaction? Hi guys I have a small problem. I want to use BCP with in a transaction it's this first I execute a SQL Statement against the database and delete... Aruna Tennakoon	05-16-2005 12:17 PM Darren Green	1	81
Is this a job for DTS? Hello; First off, let me say that I'm not a DBA, I'm more of a web application developer that has to wear many hats (but I did pass the 70-229 test... Todd M. Taylor	05-16-2005 08:31 AM Todd M. Taylor	4	106
DTSRun.exe Application error Hi All, I have a DTS package that transfers data from a table into excel or text files based on the option specified. But every now and then,... cookiesncreamychoc@hotmail.com	05-15-2005 06:43 PM cookiesncreamychoc@hotmail.com	0	136
Architecture ( 1 2 ) Getting two tables from one base with 4 mio and 11 mio records. The 11 mio records are dimension specification on the 4 mio records so I need to put... Michael Vardinghus	05-15-2005 03:20 PM Allan Mitchell	15	131
Linked server Hi All I trying to pull data from another server by the use of linked server. On the server pulling the data I have views accessing the linked... Michael Vardinghus	05-14-2005 04:26 PM Michael Vardinghus	2	75
Problema con tarea "Ejecutar Paquete" Hola a todos. Tengo un servidor con SQL-Server 2000 y Analysis Services 2000. He diseñado una BD en estrella en SQL-Server y unos cubos en... indurain91	05-14-2005 04:07 PM indurain91	0	75
Problema con tarea "Ejecutar Paquete" Hola a todos. Tengo un servidor con SQL-Server 2000 y Analysis Services 2000. He diseñado una BD en estrella en SQL-Server y unos cubos en... indurain91	05-14-2005 04:06 PM indurain91	0	93
DTSrun package does not exist I'm running the following from the command line dtsrun /S"servername" /N"packagename" /U"username" /P"password" and receiving the following... TJA	05-14-2005 10:19 AM TJA	2	135
DTS Parameter Queries & Comments I get an error when I put comments at the top of my queries when trying to set them up to use parameters. Without the comments, I don't. Even if... Robert Hamilton	05-14-2005 10:12 AM Allan Mitchell	2	63
ActiveX task hangs in DTS Hi...... For some reason everytime I run a DTS package with an ActiveX Script Task it hangs. So I tried to create a test package with only an... Sam123	05-13-2005 09:41 PM Mike Gercevich via SQLMonster.com	5	76
How do you really get OUTPUT parameters to function? Yes, yes I have read the article on SQLDTS regarding output parameters in Execute SQL Task. Well, it aint so easy!! Since there is no visibility... Snake	05-13-2005 03:10 PM Helge C. Rutz	1	74
Can't exit from interactive DTS package under SP4 SQL Server 2000 Service Pack 4 When running a DTS package interactively in Enterprise Manager, there is no way to close the package when it... Jim Langley	05-13-2005 12:47 PM Jim Langley	4	77
Unknown UNC when DTS runs with ASP I have a DTS which that consist of 1. loading a .txt file 2. export table to .txt file For both steps the file is located via an UNC, so... Jeroen	05-13-2005 08:41 AM Jeroen	0	65
DTS export runs in Wizard, but not when saved and run in VB Hi Experts I have written a dts exporting data from SQL to Excel and the data is exported fine, however when I save the dts as VB and run it from... poppy	05-13-2005 08:09 AM Allan Mitchell	4	63
SQLDTS File Transfer Protocol Task Has anyone used this tool.. Having a bit of a hard time figuring out what exactly I need to setup to use it.... http://www.sqldts.com/default.aspx?302 Warren	05-13-2005 08:08 AM Darren Green	3	127
Fixed Field Columns Missing I finally got this package to work by chosing to transform information as it's copied to the destination via a VB script. Wanted to pass this along... Colette	05-13-2005 07:30 AM Colette	5	76
On Error Goto Label dosen't work in ActiveX script I'm trying to use On Error Goto Label in the main funtion of my ActiveX task,but it says syntax error.How can I use that? Thanks Ray5531	05-13-2005 06:50 AM Mike Gercevich via SQLMonster.com	7	94
Dynamically Changing Filepath? Hello, I have a dts package that pulls data from a .csv file and then scrubs and loads it into a table. Is there a way to change the file path... Mark	05-13-2005 06:40 AM Mike Gercevich via SQLMonster.com	4	69
Transform Data Task and RowCount delivered Hi, I have a task delivering every 15 minutes a number of lines from a database. Is it possible to store the number of selected rows in a global... Guntram Ulrich	05-13-2005 02:36 AM Allan Mitchell	6	82
ExecutePackageTask Filename property Hello All, I hope someone can help me with this, I couldn't find anything on the Internet. I have a master package that has to execute several... Gerhard Wessels	05-13-2005 02:35 AM Gerhard Wessels	5	88
Save DTS package with option /F I would like to save the definition of a DTS on a file. Besides I would like overwrite the file every time that the DTSRUN is performed, so that to... TerryMan	05-13-2005 02:31 AM TerryMan	2	75
DTSRun periodic problem Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL... James Wilman	05-13-2005 12:47 AM Michael Cheng [MSFT]	3	105
Documenting DTS Packages I have inherited fe DTS jobs without any documentation. Is there a way I can generate documentation or an easy way to document it? How do I figure... Satish Balusa	05-12-2005 10:21 PM Mike Gercevich via SQLMonster.com	2	81
data too large for specified buffer size I'm tring to import from Excel into SQL Server and get the dreaded "Data for source column...is too large for the specified buffer size." The... Dana	05-12-2005 12:21 PM Helge C. Rutz	2	126
Query Statement in Import Wizard I'm working on a DTS Package that will need to be scheduled to pull data from a table on remote server, which I know can mostly be done via... The Gekkster via SQLMonster.com	05-12-2005 10:58 AM The Gekkster via SQLMonster.com	1	64
Text file, SAP and multi language support problems???? I have been having difficulties for many months now when importing text data that is exported from SAP then FTP's from a UNIX server to my SQL... Gary	05-12-2005 10:54 AM Gary	0	65
xpsendmail task hangs...need to make it timeout I am using xp_sendmail to send emails during execution of package via an ActiveX task. On occasion, our mail server gets full causing the package to... Edgar	05-12-2005 10:44 AM Edgar	4	90
Executing a DTS package with "AT" command I'm using SQL Server 2000 SP4 and am trying to execute a DTS package using the DTSRUN utility using the "AT" scheduling command in Windows Server... Bill	05-12-2005 10:20 AM Bill	5	70
Transfering string data from Access We had a DTS package written by presious staff. which import data from MS Access database to SQL Server 2000. So basically what;s he'd done was like... erymuzuan	05-12-2005 09:16 AM Darren Green	1	56
Re: "FTP file using DTS" It's more secure than ftp. FTP will send credential in plain text. In a domain you should NOT use FTP. FTP is for Internet access as a... Jim Vierra	05-12-2005 08:43 AM Jim Vierra	3	66
Removing carriage returns and line feeds characters from a flat fi I'm getting a flat text file that I using in DTS. The files are fixed width but occasionally rows will have misplaced carraige return line feeds... LP	05-12-2005 07:40 AM LP	2	67
DTSRun Frequent Crashes Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL... James Wilman	05-11-2005 10:35 PM Michael Cheng [MSFT]	2	65
DTS periodic failures Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL... James Wilman	05-11-2005 10:34 PM Michael Cheng [MSFT]	1	75
Naming col001, etc of imported flat file for transformation How do you give user friendly name to columns from a text file connection? change col001 to AccountNbr, etc for use in script transformations. Zach.Baier	05-11-2005 07:44 PM Michael Evanchik	1	72
MSDTC ERROR-SQL SERVER Hi I'm setting up transactional replication between a windows XP machine(DEVFR), and a windows 2000 server machine(TESTING). I've setup the... Phill	05-11-2005 04:40 PM Phill	0	79
Re: Database Transfer Problem Most definitely you can take a backup with users in the DB. SQL Server will back up the log after the data file to capture changes made whilst the... Allan Mitchell	05-11-2005 04:12 PM Allan Mitchell	0	67
DTS Database Transfer Problem We're backing up our database by using DTS to transfer it to another server. The DTS package is very simple, it consists of one 'Copy SQL Server... Joseph Geretz	05-11-2005 02:55 PM Joseph Geretz	2	70

Page 130 of 258

130

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