Rating Thread / Thread Starter	Last Post	Replies	Views
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	68
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	76
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	95
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	72
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	76
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	84
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	69
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	88
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	72
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	157
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	54
General problem with global variables Hi, I get rid of these global parameters. I've a simple SQL task : select lasttime from messagetrackingentry I store the value of lasttime... Niklas	07-27-2005 06:49 AM Niklas	0	82
Importing MS Access data Is there a way to run a DTS package to import Access data when the MDB has an associated MDW file? I have a valid username and password, but I... Ghost Dog	07-26-2005 03:30 PM Ghost Dog	2	73
FTP Problem Hi I created some FTP dts on a client machine using enterprise manager and the FTP task and they worked fine when I created them . Later I... Jonathan Crawford	07-26-2005 03:01 PM Jonathan Crawford	2	87
Import Error Using DTS, I imported a bunch of tables from Access to SQL. All the tables have been transferred except but two that are giving me similar... TS	07-26-2005 02:28 PM Allan Mitchell	3	85
File not found when renaming file using dts I am running this activex script on a server which searchers for a file b.txt and renames it as ba.txt on the c drive of a server.I get the error vb... AG	07-26-2005 02:13 PM Allan Mitchell	1	70
Insert data from an ActiveX script I need to insert data returned from an ActiveX vb script into a table. Can I do this w/o writing the data into a text file (inside the vbs),... cw	07-26-2005 02:08 PM Allan Mitchell	1	63
SQL Server -> MS Access Hello, i've created a sql task that reads a datetime value from an sql server table. I want to store it in an global parameter. In a follow up step... Niklas	07-26-2005 12:16 PM Niklas	0	69
How to launch a process synchronously in my DTS I am calling a WINZIP process to extract a zipped file using the code below : Set oShell = CreateObject("WScript.Shell") strCommand = "WZUNZIP.EXE"... J-T	07-26-2005 11:23 AM J-T	2	66
Net Work Print Question I am trying to print a document to a specific network printer in DTS using an ActiveX VB script. I found the code below in another group, however,... Leslie	07-26-2005 11:04 AM Leslie	2	79
Using a constant value in data transform task Hi. I have a dts package that loads data from a fixed length text file into a table. I would like to insert the filename into a column in the table... Terry via SQLMonster.com	07-26-2005 09:03 AM Terry via SQLMonster.com	2	67
Ignore relations on import? (or export) Is there a way to do that? TIA! Stanko. www.milosev.co.yu Stanko Milosev	07-26-2005 07:27 AM frank chang	7	67
where are my records? hi, i have a serious problem that when i use DTS to move my data into vfp9, my tables were in vfp tables, but all records were missing! who can help... Jason Felix	07-26-2005 06:00 AM Stanko Milosev	1	65
"Distributed Transaction Error" 2000 -> 2003 I am getting "Distributed Transaction Error" when connecting to SQL Server 2000 from my COM+ application via DSN. My SQLServer2000 is running on... irfan bashir	07-26-2005 05:57 AM irfan bashir	0	58
how to move data/objects faster with DTS Is it faster to move data between 2 tables using DTS or more of an insert <newtable> select * from <table> I would like to use DTS but it appears... Hassan	07-26-2005 03:14 AM Yogish	5	55
How can I copy a database diagram from one db to another The tables I need for the diagram have all been transferred using dts, Now I need a copy of the diagram using these tables in the new db, There... Bob	07-26-2005 02:30 AM Darren Green	3	95
Ability to see DTS code outside of the IDE? I just got a new gig and they are yelling that one job isn't running. I see that I'm suposed to pass data to a SERVER that nobody here knows about? ... Stephen	07-25-2005 02:29 PM Allan Mitchell	3	68
can't delete file from a job but succeeds from the dts Hi, I have a problem that I don't understand. I am trying to do a simple thing: Dim filesys Set filesys =... ia.zohar@gmail.com	07-25-2005 02:27 PM Allan Mitchell	2	78
Can DTS do this? I have a report which I have to complete every quarter. The report is done in Excel and is called, "Agency Training Metrics Report". There are... Drew	07-25-2005 09:45 AM Drew	2	94
Saving a dts package to sql server in a stored proceudre I m rtying to save a packahe from a COM structured file into sql server database *using a trusted connection" using the follwoing code: EXEC @rc =... J-T	07-23-2005 08:57 PM J-T	1	134
Table to CSV fails Hi I have a table which has about 60 fields(columns). When I create a DTS, in the destination tab after pressing Execute button, nothing happens. If... Panch	07-23-2005 02:44 PM Allan Mitchell	3	76
sp_helpuser for groups Dear gurus, I'm using sp_helpuser for obtain info about NT user. That's fine but i find a problem when I use with a group The name supplied... Enric	07-23-2005 02:01 AM Allan Mitchell	1	85
DTS crashes SQL Server 2000 DTS crashed before exporting; Its is happening only after installing Visual Studio 2005 Beta 2. Any clue ? After reinstalling it... Venu	07-23-2005 01:53 AM Allan Mitchell	1	90
DTS rollback ? Hello, I have a DTS package to replicate data from one site to another. The first step in the DTS is to delete data in the Destination, then it... Franky	07-23-2005 01:48 AM Allan Mitchell	1	89
Help! SP4 stopped script engine for non-admin user I have the following error message "tep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: ... Khone	07-22-2005 03:24 PM Khone	1	110
DTS Package fails on last step I am trying to run a 3 step DTS package from VB .NET. It exports a SQL 2000 table to a dBase IV file. Step 1: Drop table: succeeds Step 2: Create... Tyler	07-22-2005 02:30 PM Tyler	3	66
TEXT export Hi !! I am trying to export TEXT field to another ODBC Data source; and I get the following error.. "Query Based Insertion Updating of blob values... Venu	07-22-2005 01:29 PM Venu	0	89
dynamic properties task ini i wnat to use the dynamic properties task to fill in a value for the ftp task. i set it up to use an ini. when i execute the dts task i... Aron E. Tekulsky	07-22-2005 11:33 AM Darren Green	1	66
DTS and Transactions Hi, DTS and transactions seems to be an always recurring flaw in DTS. Is there some HTML page around giving a quick overview of which... Axel Dahmen	07-22-2005 10:26 AM Darren Green	5	95
Object level permissions for the role PUBLIC in SQL Server Hi, I am trying to determine a way (query) through which i can find all the objects and the kind of permissions (Select, Insert...) the role... sureshng1506@gmail.com	07-22-2005 07:43 AM Ilya Margolin	1	77
Issues autentification Dear fellows, I've got a DTS which create two plain files on a specified network path using FSO object through a ActiveX task. AS usual that DTS is... Enric	07-22-2005 05:44 AM Narayana Vyas Kondreddi	1	69
Re: Redistributing DTS on XP It is the same for XP. You have not registered the DLLs correctly, in particular dtspkg.dll -- Darren... Darren Green	07-22-2005 04:20 AM Darren Green	0	77
export a package to another server Hi there! I want to export a DTS package to another server. But consider that I am not connected in the same network. In this context, I need to... Eduardo Greco	07-22-2005 04:10 AM Enric	2	74
Redistributing DTS on XP Redistributing DTS is only documented (http://www.sqldts.com/default.aspx?225) for Windows other than XP. I can’t make it work on XP Pro SP2. I use... gabaug	07-21-2005 10:38 PM gabaug	0	82
Getting timestamp of flat files Hi there: I am going to be pumping data from text files via ODBC into SQL via DTS. Is it possible through something like an ActiveX script task... kayda	07-21-2005 05:20 PM Darren Green	1	67
Mailing from DTS I am sending two text files via FTP to a remote server in a DTS job. The filenames will vary in name each time they're created. They'll be named... Blasting Cap	07-21-2005 05:13 PM Darren Green	9	149
Default values How do you tell the script to set the default value for a boolean field to false? bit NOT NULL DEFAULT false, (doesn't work) Ghost Dog	07-21-2005 04:16 PM Ghost Dog	2	71
Accessing VFP 6 tables from SQL Server 2000 DTS on XPSP2 I am running SQL server 2K on XPSP2 and VFP 6. I downloaded and installed the vfp odbc driver available... Stewart Lane	07-21-2005 02:43 PM Cindy Winegarden	2	79
Converting formatting data FROM EXCEL to SQL Server Hi all, How to convert the field colomn value like 018.000 into SQL Sql server data in the same format.(The custom format in EXCEL is... Sivaraman.S	07-21-2005 01:20 PM Axel Dahmen	1	54
Crash DB everyday Hi, My DB crash everyday at the same time and I don't what's is happen in this time. How can I do to monitore my transaction and save the log in a... Catthy L via SQLMonster.com	07-21-2005 07:12 AM Narayana Vyas Kondreddi	1	67

Page 119 of 258

119

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