Rating Thread / Thread Starter	Last Post	Replies	Views
ActiveX Script with CDOEX problem Working on an automation of MS Exchane Server 2003, I have to create appointments (with CDOEX) in a DTS ActiveX Script (see below). Do Until...	08-04-2005 08:25 AM Ilya Margolin	1	90
Reference an existing connection in my DTS package All, please may I have your assistance with the following? I'm trying to reference an existing DTS connection in my activeX script task rather than... John Shiangoli via SQLMonster.com	08-04-2005 03:57 AM John Shiangoli via SQLMonster.com	2	64
"How to" on Datapump error handling Need to handle errors coming out of a datapump step. Any references out there? Thanks George. George Morton	08-04-2005 01:48 AM Gopalan	1	60
DTS issue....please help!! I have a stored procedure that does a qc check on 2 tables. It contains a case statement that checks to see if a value falls in a certain range. If... Andy	08-03-2005 04:28 PM Andy	6	79
DTS Windows Scheduling error only when logged off Ok, I am using Windows Server 2003, Sql Server 2000 version 8.00.760 I have a batch file that runs a DTS package using DTSrun as follows : DTSRUN... Brian Beck	08-03-2005 04:15 PM Brian Beck	1	63
Disable DTS 2005 tasks dynamically at run time. Hi, I'm trying to disable DTS 2005 tasks at run time using an expression to set the task's "Disabled" property. The expression I use is "(DT_BOOL)... Eric V via SQLMonster.com	08-03-2005 01:31 PM Jamie Thomson	4	69
Lots of Ports What is going on with SQL and ports below? Below is a portion of what I get when I run netstat. SQL Server is taking up an enormous number of... CR	08-03-2005 12:16 PM CR	0	72
SQL Server Agent and Analysis Services (DSO) I have an ActiveX VB script in a DTS package that simply connects to a server and populates a table with a list of all the Analysis Services... Paul	08-03-2005 10:26 AM Paul	0	56
return code from execute process task How does one catch the return code from batch or exe the 'Execute Process' task runs? thanks, tjk tjk	08-03-2005 10:09 AM tjk	0	64
Not enough storage is available to complete this operation Hi, The following error message is received during the transformation of data from a text file (262 columns) into SQL database. "Not enough storage... John Jayaseelan	08-03-2005 01:53 AM John Jayaseelan	3	92
Not enough storage is available to complete this operation I have received the "Not enough storage is available to complete this operation" message from a DataPumpTask that has been running correctly on... John Kotuby	08-02-2005 07:14 PM John Kotuby	0	136
How to open sql 2000 DTS package in sql 7? Hi All, Our partner created a DTS package in sql 2000. However, we are still running sql 7 and can't upgrade in the short term. Is there anyway... bluemug	08-02-2005 05:52 PM Peter A. Schott	2	71
DTS.Task We had a program running perfectly fine and one of our users upgraded to sql sp4 and now we get an error that o.task can not be initialized . first... DebS	08-02-2005 05:01 PM DebS	0	85
Best way to integrate all filenames in a directory with SQL Recordset? I have a need to use some pieces of a SQL Recordset and combine those with each filename in a folder. I then need to output each of those... Peter A. Schott	08-02-2005 04:46 PM Peter A. Schott	2	69
Renaming all DTS pacakges on a server Hi, Is there any way to programatically rename all DTS packages on a server to 'New_'+ old_name or save them all as 'New_'+ old_name (and then I can... polinaskulski@aol.com	08-02-2005 04:38 PM Darren Green	5	73
How To Read the Contents of a Directory I would like to write a DTS package to import a number of Excel files from a network directory to a single SQL Server table. Assumptions: I am... Paul Backer	08-02-2005 03:12 PM Allan Mitchell	1	116
Update the Paradox table Hello, I have a DTS Process in which I read the text file and based on certain data, I need to update some information in Paradox table. Can... Yunus's Group	08-02-2005 02:33 PM Yunus's Group	0	59
DTS Hell I have an update statement that I run as follows from a SQL Task... UPDATE "AS400Machine"."AS400DevLibrary"."FileName" SET FLAG01 = 'N' There is... marcmc	08-02-2005 01:51 PM Allan Mitchell	1	114
Alternate to SQL Replication First off, I'm an ASP.Net developer and not a SQL DB admin. One of my clients uses a program that uses a SQL Server database. They want to run... jjbutera@hotmail.com	08-02-2005 08:42 AM Paul Ibison	6	66
Want to Load Data MS Access Sql Server 2000 I already have tables in my SQL Server 2000 database. I have several things that I need to do - (import sql server 2000 tables into MS Access... Mike Moore	08-02-2005 08:40 AM Mike Moore	2	72
DTSOlapProcess Hi all, My problem is quite simple. I have a small c# application accessing a DTS package to read and display info about it. I can access any type... Luc Bolly	08-02-2005 07:30 AM Luc Bolly	2	188
CSV Pre-reader I have a .csv output from a database which does not use text qualifier. any commas or backslashes in the data are 'escaped' I.e. Field1 Field2 ... NH	08-01-2005 04:56 PM Rick Gittins	1	64
DTS Constant Dear all, Is there any constant which be able to stop the DTS and return OK? Does anyone knows if such constant is available? Regards, Enric	08-01-2005 02:09 PM Darren Green	3	63
Running a DTS Package in C# App with Process Cube Task I'm creating an application that runs a DTS package with an "Analysis Services Processing Task" in the package. When I run the package in the... jgharper	08-01-2005 01:37 PM Darren Green	1	86
Relational to datawarehouse Can sombeody point me in the right direction. How can I convert a relational database to a datawarehouse? Thanks Luis Esteban Valencia	08-01-2005 03:50 AM Michael Vardinghus	2	55
How should I debug my DTS packages in the production server? How should I debug my DTS packages in the production server where there is no script debugger. Thanks J-T	07-31-2005 10:22 PM Sue Hoegemeier	5	77
Is this possible I have never done a DTS package. I need to be able to look for a tab delimiler file at a specific time, say 2 am, parse threw it and replace records... Dave	07-31-2005 06:11 PM Allan Mitchell	1	53
Read File Transformation Am I missing something? The BOL doc seems to imply that the DTS read file transform will read a file name from a source column and direct that... BootieDay	07-29-2005 04:10 PM BootieDay	0	67
Transaction Issue Hi, I have two SQL Execute Tasks and when I go to the Workflow Properties and check on the "Join transaction if present", everytime when i run it,... Ed	07-29-2005 10:09 AM Ed	0	52
Printing in DTS Activex script I have a package that runs every day and prints out a series of reports. The reports are generated into text files and printed by feeding the file... etcarine via SQLMonster.com	07-29-2005 10:00 AM etcarine via SQLMonster.com	6	97
DTS parameter with Integer data type Is there a way to pass a users input through a DTS parameter that has a integer data type without puting a constant in the value column. Ex A string... eam	07-29-2005 01:19 AM Darren Green	1	47
SQL2000 DTS help SQL Server 2000 DTS Questions 1. In a DTS package, I am using an ODBC connection as a destination for a transformation task. The... Paul M	07-28-2005 09:24 PM Smith	2	74
Tranfering tables from one database to another Hi there Please forgive the very basic question. I have two SQL Server 2000 databases. The source database contains data I need to port, and the... postings@alexshirley.com	07-28-2005 02:03 PM Allan Mitchell	1	63
Export To Excel Using DTS - Please Help I have a table in Excel with about 4000 records which I need exported to an Excel Spreadsheet. This has to be triggered via an ASP.NET app via the... Chris van den Heuvel	07-28-2005 12:52 PM Douglas Laudenschlager [MS]	5	108
Generic DTS Package for emailing excel Hello, I have a need for a web application to request a stored procedure to be run and then the results emailed to the user in Excel. My web... blarfoc@yahoo.com	07-28-2005 12:50 PM Douglas Laudenschlager [MS]	1	47
Tranfering tables from one database to another Hi there Please forgive the very basic question. I have two SQL Server 2000 databases. The source database contains data I need to port, and the... postings@alexshirley.com	07-28-2005 11:13 AM postings@alexshirley.com	0	68
Parsing a text file Hi: I have setup DSNs before to text files with some success. I am having problems with a file I have to parse to pump into SQL Server via DTS. It... kayda	07-28-2005 10:41 AM Scot T Brennecke	2	68
Leading Zero Is Dropped I have a DTS package that has an Excel spreadsheet as the source and SQL Server database table as the destination. Some zip codes have leading zeros... WhiskyRomeo	07-28-2005 09:41 AM WhiskyRomeo	0	71
where is my DTS package? i can't find out where does the sql server save my DTS packages. i have seen that there is something in the msdb DATABASE about DTS but i couldn't... Oren101	07-28-2005 09:37 AM Narayana Vyas Kondreddi	1	82
Icons for tasks in tool box Hi, Can anyone tell me why there are no icons for me to use in the Tasks toolbox, even when I open a package that has constraints and a data... Gary Spence	07-28-2005 06:30 AM Gary Spence	0	61
shrink dts step log Hey eb My dts step log is growing to much. I want to add a step to this dts which will shrink it by deleting records from table... Rea	07-28-2005 02:22 AM Rea	2	72
Sleep() in JScript under DTS. Hello! Is there any way to pause execution (Sleep) in java script under DTS? WScript.Sleep() doesn't work. As I understand sure workaround is to... Mike	07-27-2005 11:21 PM Mike	2	89
Recover DTS Hello, my sql instance stopped working! I was able to save all the mdf and ldf files, but have no idea where the dts are. Please any help will do!!! Guido Schauwecker	07-27-2005 10:35 PM Arnold Lo	2	63
Multiplying Grouped Columns I have a query, which selects three columns from an inner join. The last two columns are SUM and the first one is GROUP BY. Now, I would like to... HLong	07-27-2005 05:21 PM HLong	2	70
Recover DTS How can I recover a DTS without recover a old msdb database over current msdb ? Shima	07-27-2005 04:26 PM Allan Mitchell	1	78
Alerts - MSDTC Service Can you guide me how to set up alert for MSDTC service, My goal is to get notification when MSDTC is failed. thanks kalyan Kalyan	07-27-2005 02:03 PM Darren Green	1	57
DTSRun of "SQL Server Objects Task" has "OLEVERB failure" Run package to execute the 'CopyProcedures' proc as follows: exec master.dbo.xp_cmdshell 'dtsrun /S (local) /E /N CopyProcedures '... Sparky	07-27-2005 01:15 PM Sparky	0	77
DTS Extraction? I had the following request given to me by my boss and am coming up empty on finding an application or script that will do this for us any help would... mlangworthy@gmail.com	07-27-2005 12:53 PM MCL	6	67
Executing DTS C# I have a little problem with a small C# Applikation that executes DTS. I don't know if this is the right Newsgroup. First of all here is what... Karpo	07-27-2005 10:05 AM Karpo	4	148
VB Printer Collection in DTS ActiveX VB Script I'm trying to print a job to a specific network printer. I'm using an ActiveX Script Task to execute to execute the print job. However, when... Leslie	07-27-2005 08:41 AM Ilya Margolin	1	48

Page 118 of 257

118

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