Rating Thread / Thread Starter	Last Post	Replies	Views
DTS Package Environment Promotions Anyone come up with good Environment controls inside DTS to migrate a DTS package from Dev-->Test-->Pre-Prod-->Prod? What I want is the package to... Joe	02-03-2004 02:11 PM Allan Mitchell	1	64
Import/export error Hi All, Please help me, i am in a nice mess due to a problem in dts export/import. When i try to export tables from my local server to remote it... Ritesh	02-03-2004 10:42 AM Rand Boyd [MSFT]	2	52
DTS execution error My DTS excution failed because one of my ActiveX script got timed out. I run the same epackage again and it run just fine including this particular... Olivia	02-03-2004 09:59 AM Lee Gillie	3	257
Scheduling a Job Against AS/400, DB2 I set up a DTS to transform data from an AS/400 DB2 file to SQL server. I can run the package fine manually; however, if I try to schedule it, it... Brett Ossman	02-03-2004 09:15 AM Allan Mitchell	3	55
DTS Designer Error; Missing Task Controls Upon opening the DTS Designer, I get a missing file error and all the DTS task controls are gone. Apparently, this is not an uncommon problem, as... Greg	02-03-2004 08:44 AM Greg	4	56
Data Source Driver Language Hi, We are using SQL 2000 Server as we are mystified why the 'Data Source Drivers' when performing a DTS, for instance, contain German, Portugese... skc	02-03-2004 08:01 AM Allan Mitchell	1	53
VB Code it generates I noticed that you can save the dts package as a visual basic module. If you do that, how can you execute the code? Do you have to do additional... Mike	02-03-2004 07:17 AM Noah Ganter	2	65
Setting SQL parameters in subqueries Hi all I would like to know what the easiest way is to set a SQL-parameter (prepar it?) in a DTS ExecuteSQLtask Normally when programming in Delphi... francis	02-03-2004 05:06 AM Francis	2	56
Data I am in the planning process of upgrading the hardware on our cluster. I need info/advice/suggestions on how to go about this. I am running an...	02-03-2004 01:27 AM Allan Mitchell	1	64
DTS transform limits I am trying to dump a table with > 32 columns to a text file. I am emphasizing "> 32 columns" because through some basic testing it appears that when... James Lochte	02-03-2004 01:22 AM Allan Mitchell	2	60
DTS error not enough storage for this operation Hello I have a DTS that loads data from a CSV file to a SQL database. The CSV file has about 65k rows of data. While it is about 1/3 of the way... Quin Kan	02-03-2004 01:19 AM Allan Mitchell	1	64
Using VB.net to execute DTS Hi, I found a lot of resources on the internet to execute a DTS package from VB.net. I tested my code on a test DTS package to make sure it worked... sltech	02-03-2004 01:16 AM Allan Mitchell	2	168
Importing Excel-XP data from a workbook with a password Does anyone know how to import data from a workbook that has read and write passwords on it ? If I attempt to open it using DTS without specifying... Stephen	02-03-2004 01:10 AM Allan Mitchell	1	63
Only User tables and Views displayed For auditing purposes, I would like to keep a record of all the logins from all the SQL servers on one central administration server. This way if I... dschrier13	02-02-2004 08:11 PM Russel Loski, MCSD	1	52
Failing to register custom dts job correctly? I have made å custom DTS job in visual basic. I started with the dts export wizard to save visual basic code for a simple export to excel... Tore Gylver	02-02-2004 04:23 PM Tore Gylver	2	78
Transfer DTS Package Help I am developing on a test system and I want to transfer several of my files to another test system (at home). Can you transfer a DTS Package from... Doug Gifford	02-02-2004 02:20 PM James Lochte	5	55
Transfer Data I am pretty new to SQL database maintenance and am running into a problem, here's my scenario: 1) I have a "production" SQL server which holds the... Ryan Moore	02-02-2004 02:03 PM Andrew J. Kelly	3	70
Working with SQL2k VB6 DTS Packages in VB.Net Hi! Anybody done this? (topic) I have started to manually convert the VB6 to .Net code. While i wait for the VS.Net IDE to complete a... lover	02-02-2004 10:36 AM lover	2	48
Rowset Fields properties I'm trying to return the column names of my query results. In ADO, I can simply do this: objResults.Fields.Name That code throws an error in an... RB	02-02-2004 07:36 AM Russel Loski, MCSD	2	59
Transfer Data From one DB to Other DB Hi All I want to transfer the data from one db to the other db for the same table which exists on both the sides. Can one please let me know about... Roopesh	02-02-2004 03:35 AM Hari Prasad	3	50
DTS Questions I created a new connection, however, I get the same result. If an empty string is sent to the lookup would that cause it to hang? What about the... Unsure	02-01-2004 04:47 PM Allan Mitchell	5	79
CDO script in DTS Hi, I have created a VBScript in an ActiveX object using CDO 1.21 to connect to our Exchange server, look for an email with a specific Subject Line... Perry Provost	02-01-2004 03:26 PM Perry Provost	2	55
FTP task I have a DTS package that creates a weekly text file on the desktop (e.g. WeekEndingYYYYMMDD.txt). I want the package to upload that file to an FTP... Al Cadalzo	02-01-2004 11:21 AM Darren Green	3	57
automate ftp download .dat file Hi, Can anyone tell me what the best way to automatically download a .dat file from an ftp site and import into sql server? Should I use ftp.exe? ... Buttercup	02-01-2004 10:45 AM Allan Mitchell	1	67
DTS Questions I have created a DTS Package with the following Lookup named LookupID: select ID from ut_TableName where (PersonName LIKE '%' + ? + '%') The code... Unsure	02-01-2004 09:06 AM Unsure	6	51
importing and maintaining identity columns I'm would like to import records I select with a SELECT from one database to another but maintain the identity column values. I've read where I can... Glenn Carr	02-01-2004 02:17 AM Glenn Carr	2	42
2 questions about programatically package execution... Hi all !!! I need to execute a DTS package from a Visual Basic program. the questions are: Q1) it it possible to make the packages run... Antonio Lopez Arredondo	01-31-2004 02:43 PM Allan Mitchell	2	40
Environment variables Hi, What's the best way to have a single point of config for my databasenames? I use the dynamic property task in all packages to set the UDL path... Spike	01-31-2004 10:58 AM Allan Mitchell	1	69
Seeking simple way to limit access to production server. The scenario is probably pretty common. There is a lot of new DTS package development work by a number of people at our location, and others. The... Lee Gillie	01-31-2004 01:51 AM Allan Mitchell	3	49
Active x Script for data copy from source to destination Hello, I'm dumping data into the database by 1. FTP the text files from unix server to windows. 2. Load the data into the temp table and wrote the... desperate	01-31-2004 01:38 AM Allan Mitchell	1	38
Importing mixed text from Excel I'm trying to import a column of mixed data from Excel to SQL Server. This column contains some numeric values and some alphanumeric. I was getting... Sondra	01-31-2004 01:30 AM Allan Mitchell	1	42
Executing DTS from Stored Procedure Hi all, I am getting this error message when executing a DTS from a Stored Procedure. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: ... Yama	01-31-2004 01:27 AM Allan Mitchell	2	57
Proccessing a row more than once with intel I am a newbie to active-x and am trying to use the code at http://www.sqldts.com/default.aspx?266 but to do something a little different. I have a... Ray Higdon	01-30-2004 05:27 PM Ray Higdon	5	44
Is there a way to call DTS Designer programmatically ? I found a few entry points in dtsui.dll which look like they may do the job. ActivateDesignerWindow, CloseDesignerWindow, CreateDesignSurface,... Lee Gillie	01-30-2004 04:20 PM Lee Gillie	2	40
DTS Package Stays Connected I use a Transform Data Task to copy several tables from a Progress database to a SQL Server database. Durring this process each table being copied... Mike	01-30-2004 03:53 PM Mike	4	51
The Analysis Services Processing Task I am trying to execute a sub package that contains the Analysis Services Processing Task. For some reason the package will not execute. For example:... Renita	01-30-2004 03:38 PM Renita	2	46
Activex DLL Task scheduled problem Why, when i scheduled a dts package containing an ActiveX Dll Task, the job doesn't enter in the ActiveX? gorack	01-30-2004 02:37 PM Darren Green	2	42
Add own messages to DTS Package status messages? Does anyone know if it is possible to add your own custom messages to the DTS Package status messages from within an ActiveX script task in the... Ray Rankins	01-30-2004 02:36 PM Darren Green	1	42
Dynamic Properties Task & SourceSQLStatement I'm trying to import from a dBase table whose name changes every day based on the date. So I add a Dynamic Property Task, select the copy data task... Patrick Huffer	01-30-2004 02:32 PM Darren Green	2	51
How to store huge Data & also its pros and cons Hello SQL Gurus, I had a strange Requirement The end users of our system want to store as much data as they can i.e., from getting text from the... Venkata	01-30-2004 10:49 AM Venkata	0	53
DTS Automation How reliable is DTS? I use the DTS utility at work a great deal and often either save the package to SQLServer or complile the package as a... Noah Ganter	01-30-2004 10:34 AM Allan Mitchell	1	48
DTS - Skip errors, log them and continue running the package Is it possible creating a DTS package that in case of error, the record is logged and the package continue to run? Thanks IS Izidro Sousa	01-30-2004 10:05 AM Ray Rankins	5	108
DTS data type conversion error from excel to SQL 2000 hello! I was trying to use DTS to copy data from excel to SQL2000. In the spreadsheet, it seems like if it is blank or empty values, it is... Sam	01-30-2004 10:01 AM Rand Boyd [MSFT]	1	54
Re: FTP in DTS how flexible is it? In message <6168E0A5-8A20-4319-81C1-7AD2E7C4DB44 (AT) microsoft (DOT) com>, Lenny <lp (AT) TNSIntersearch (DOT) com> writes You can do this, but you... Darren Green	01-30-2004 09:08 AM Jacco Schalkwijk	3	68
How to Install DTS Package in Client Machine Hi All I want to install the DTS package in client machine which is not located in my LAN. Upto now iam saving the DTS package as .dts file and... vasu	01-30-2004 04:35 AM Allan Mitchell	1	39
DTS Copy SQL Server Objects Task Hi All I'm looking for some information on how the 'Copy SQL Server Objects' task works. We do a nightly copy of 50+ tables from one database to... Phill	01-30-2004 01:40 AM Allan Mitchell	3	51
DTS Source Column Size Error I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I... Unsure	01-30-2004 01:38 AM Allan Mitchell	5	53
Re: using transaction on DTS package Seems like SQL Server is running under local account, try to run SQL Server/SQL Server agent services under domain account which should... ashish	01-29-2004 09:40 PM ashish	0	48
Eliminate Duplicates while Bulk Loading Is there any way we can eliminate duplicates while bulk loading the data from a text file to a Sql server Database Thank Reddy Reddy	01-29-2004 09:27 PM ashish	1	36
Trigger and DTS Hi there, The insert trigger that I created on a table does not fire when I DTS data into the table. Is this by desgin or is there a way/switch to... Danny Mansour	01-29-2004 05:02 PM	2	49

Page 208 of 257

208

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