i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>

Hi, I am trying to create a DTS package that exports a table to a text file from a ASP or ASPX page. Every attempt has failed (copy failed). Currently I am trying to create this file in the directory that contains my .net application. Is there a better way to accomplish this task? Paul ...more >>

Hello every one ,, I have a DTS created by SA account , i want to give other users ( not in the SA role) the permission to run that job from thier clint tools at the same time they shouldn't modify it. Already i created the user ,but when he tryed to run it from his machine using EM ,he g...more >>

I would like to create a comma separated file with the data taken from sql server tables. Is there a wasy to use the dts tasks alone (data pump) from active server pages instead of creating a DTS package in the SQL Server....more >>

Hi, I just need to know if there's a way I can edit an existing DTS package. The package I'm dealing with right now has been written with a D partition in mind and I just need it to point to C. I've got the full version of SQL server 7 running. If I can make that change then I could easily ...more >>

I'm trying to run this activex script from a DTS package: option Explicit Function Main() Dim oFS Dim vFileList Set oFS = CreateObject ("Scripting.Filesystemobject") Dim sPath Dim oFiles sPath ="\\<ip-adress>\Folder\" set oFiles = oFS.GetFolder (sPath) set oFS = Nothing...more >>

My SQL Server is suffering from DTS jobs diappearing. I have 7 jobs that excute daily at 4am. Now the jobs do not appear in the designer and execute correctly except tehres nothing to execute. The KB article talks about paying for a fix, is that right? A SP created a bug I didnt have and ...more >>

Hi I am trying to use DTS to add a column to a text file. I created a DTS package with 1 text file as source and another text file as destination. I linked both text files with a Transform Data task, but I could not find how to add a column to the destination on the transformation. Is it po...more >>

I have a package that imports a text file to a table. Now I have to add a few columns to both the text file and destination table. The source file view seems to refresh automatically when selecting the new file in the source tab of the transfor data task properties but I can't make the new des...more >>

Hello, Anyone know how to export a SQL result set to CSV with SQL Server 7? We have a series of queries which run and produce unique result sets based on user's criteria. We then want to export these result sets to a CSV file on the server. Thank you, Mike...more >>

Visual Basic Transformation Script I'm having a problem with the code below in a DTS Transformation. It works fine with any numbers that are in the "Dial" table that it references - but if the dialing code is not there, and the telephone number is valid it bombs out. Ideally i would like it to...more >>

If someone can kick me in the right direction, that would be most helpful. I have a DTS task (Data driven Query Task) which simply transfers data from an Interbase database into SQL 2000 - This task works just fine. If I modify the Destination SQL 2000 table (Add a field) and run the task, I ...more >>

I am working on a project where I need to generate a flat file using sql data. The machine that I need to load the flat file on is remote relative to the location of the sql server. I am thinking about using dts (creating a dts package on the sql server) and running the package remotely from th...more >>

I am backing up 2 databases and sending the files/reports to another server. I have requested that backup files be deleted that are > 1 day, and report files > 1 week. Occasionally it fails with the following error, and I don't know why. Has anybody seen this before? BackupDiskFile::R...more >>

I am trying to figure out how to backup sql server. My company has been backing their database up to tape, but I found out that it actually hasn't been gettin backed up to the tape becuase the services for SQL Server had still been running and hence didn't get backed up becuase they are in...more >>

Hi, I'm pulling data from an access table and the column that i'm pulling from is a date/time column, but I want to represent it as numerical. The problem is, the numbers in the field represent time intervals. This is an example of the data.."12:01:06 AM" what that really means is 1 ...more >>

Does anyone know if you can modify the ActiveX Task script template that is displayed when you first create a new ActiveX task? -- ---------- R a y t h e o n C o m p a n y ---------- Michael Wilson Enterprise Applications mwilson@raytheon.com 972-344-9031 972-344-0406 fax...more >>

I'm moving several packages from one server to another using structured storage files. When I open the packages on the second server and try to save them to Meta Data Services, I get the following error: Error Source: Microsoft OLE Database components Error Description: The system cannot find...more >>

I know this isn't a bcp group, but figured people using dts would know something about bcp. :) Ok, I learned how to use trusted login, LOL (see my isql login problem, newbie in the connect newsgroup). Now I have been working on this bcp import for 2 days (well, counting not being able to ...more >>

Hi, I've just built a few packages and then found out that I needed to fo through and change all of the task and step names which I have done through using disconnected edit. However this deleted all my precedents which I have re-created but now when I run the package only the first step runs...more >>

Greetings All, Problem: Data in an SQL Server 2000 database needs to be sent to a DB/2 database via a DTS [this part is easy]. However, the DTS needs to be executed/run via a custom, user-friendly user interface other than Enterprise Manager [e.g. the ole right-click, Execute package method]....more >>

Sounds like a very basic requirement of DTS. But can somebody let me know how to achieve the following? I have created a DTS package interactively to select data from a SQLSERVER view into a tab delimited text file and saved it to be executed periodically by the client. Currently the query for...more >>

Hi all, I'm running SQL2K (Avd Server sp3). Would anyone explain to me why I can run xp_cmdshell to copy files in DTS but when I run in Query Analyzer, it fails with a message saying: "Network Path not found". I'm using Domain Account to run sql services. I appriciate your help in advanc...more >>

Hi All, I am looking for an approach to error branching. I have a DTS package with 2 workflows. The primary workflow performs the required task. The first step of the second workflow, which acts as an error branch, has an ActiveX workflow script which checks the status of all steps for...more >>

Hello, I need to change, at runtime, a property (namely [DestinationObjectName]) for one of my data pump task objects. It won't let me do it though - I can't reference the property that I want to. Allow me to demonstrate: The following bit of simple code works fine: ======================...more >>

I wonder if I'm missing something simple. I can't figure out how to rename a DTS packages (and I have a number that I want to rename). I couldn't figure out how to do it in the Enterprise Manager interface, so I tried writing a program against SQLDMO object model, but I always get a COM err...more >>

Is there a way of calling other APIs in ActiveX script? I'm not a scripting expert so don't know the answer to this. If so, how do you do it? Is it something to do with CreateObject()? TIA cheers Jamie ...more >>

I have used VB program to transfer my DTS packages from one SQL Server to another SQL server. On doing this, the layout of DTS tasks designed is not maintained. Any clue why this happens, where as the layout is maintained when you open the packages and select save as. Cheers Yashwant ...more >>

Does anyone know the best way to transfer a large text file directly from a directory in a UNIX server into SQL Server 2000. The main issue here is not to transfer to the Win2k o/s but directly into SQL Server. So a straight direct transfer. Cheers....more >>

hai, I have DTS package, It work in Localhost. But when executing via ASP.NET from Webserver, I have the following error. Exception Details: System.Exception: Cannot create ActiveX component. my code is Dim objPack Const DTSSQLStgFlag_Default = 0 objPack = Createobject...more >>

Hi , Pls help me to find way to display Task Description instead of System assigned task name . DTS gives name to task when it is added to package but we can change this name . Even if we change name , it doesn't appear in log file . Log file always contain system define Task Name. H...more >>

Hi , Pls help me to find out the way to display Task description in DTS LOG File instead of system assigned task name . Find blow snapshot of DTS ...more >>

I want to transfer data from sql server 6.5 to sql server 2000. can DTS help me ? Or any other suggest ? Thanks! ...more >>

Hi, I am trying to execute a DTS package, that clears the contents of a table t_test, from ASP. The code looks as follows: '----------------------------------------------------------------------- -------------- dim objDTSPackage dim objDTSStep dim strResult dim blnSucceeded const DTSSQ...more >>

I'm trying to convert the VB code auto generated by SQLServer Import/Export mod into valid VB.net code and am receiving error for the following line: oTask = goPackage.Tasks.New("DTSDataPumpTask") This returns a DTS.Task. Is there any other way to create this task? ...more >>

How do I register the DTSPKG.RLL on a client computer? Seems silly to install SQL Server Tools and such just to get this properly registered. REGMVR32 will not work. No entry point for RLL. Ken...more >>

We are using DTS package to upload data into Oracle DB server. Do we need any kind of MS SQL server license to use DTS component. Thanks in advance, - Manish ...more >>

Hello, I modified this script to run creat four tasks using customTasks. When I executed this script, task, I was expecting four "Hello World" messages to appear, why it did not? Ahmed. '********************************************************** ************ ' Visual Basic ActiveX...more >>

Hi Is it possible to create a user a interface for a DTS package? Kind Regards Rikesh (W2K-SP3 / SQL2K-SP3) ...more >>

Will the transfer manager copy all of the tables, etc from one db to another empty db? If so, does all of the source db info remain intact and able to be used as it was previous to the transfer?...more >>

Hi, I'm having this problem when running a query that contains a subquery with parameters. SELECT A.* FROM A (NOLOCK) WHERE columnA >= GETDATE() - ? UNION SELECT B.* FROM B (NOLOCK) WHERE columnB >= GETDATE() - ? AND columnB2 NOT IN (SELECT columnD FROM D (NOLOCK) WHERE columnD >= GET...more >>

Is anyone aware of a reference guide for ActiveX scripting within DTS, Specifically, creating and calling objects and any limitations thereof. ...more >>

My client wants me to create a OPERATIONAL DATA STORE(ODS) in SQL Server 2K fetching data from a variety data sources (which are also Sql Server 2K). Has anybody done this before. If you have can you please give me some inputs (both theoretical and practical) for creating a ODS in Sql Serve...more >>

Hi, I have a bunch of tasks, Which should be executed on failure of a certain task, For eg:If a task A fails I need TaskB,TaskC,TaskD and Taske to be executed So I set a on failure workflow between TaskA and TaskB and On success workflow between TaskB TaskC TaskD and TaskE Problem:- ...more >>

I got the following error when my scheduled DTS task run by SQL Agent in Server. But this package runs fine manually in my workstation via Enterprise Manager. Anyone know why ? DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DT...more >>

Hi all, I'm trying to transfer objects and data between SQL Server 7.0 databases, but it always fails with message stating that it can not find certain user or group while I've checked transfer database users and database roles option. Any help would be greatly appreciated. Thanks in adv...more >>

Hi there People, I was looking at a really good thread earlier which was dealing with the details of porting DTS packages from Dev to Prod and renaming connections programatically. This changed the name of the server in the dest connections. I have used this process and I think it works rea...more >>

We are still running on SQL 7 here. I built several dts packages that I start with a dtsrun command in a sql job. These have run just fine for several months with no failures. We now upgraded the server and went from MDAC 2.7 to MDAC 2.8. This change is described in Security Bulletin MS03-033...more >>

I have files that are dropped off at a certain folder all day long. They all have a .txt extension. All files have the same format. Does anyone have solution that processes all files in folder using BCP to a SQL table. Thanks. ...more >>

Hi All, I have a task I need to execute when a given condition in transformation1 is met. I don't know how to address the required task in the current instance of the package as there will be other instances being executed. Transformation1 logs custom exceptions using the a generic custom tas...more >>

Hi, is there anyway to view a table's activities history info like updates, deletes? Does it have to be in log somewhere or I can retrieve it somewhere else? Thank you in advance....more >>

I have a DTS where an Execute SQL task precedes an ActiveX Script task. The workflow between them indicates that the Execute SQL Task must complete successfully before proceeding to the ActiveX Script task. However, the Execute SQL task is not completing before the ActiveX Script task begins, ...more >>

Hi, I have a DTS package which pulls data from One Sql Server to another through the Data Transform Task. When I run the task, I get an error which states: Error Source: Microsoft OLE DB Provider For SQL Server Error Description: Multi-Step OLE-DB operation Generated errors. Check Each OL...more >>

Hi! I use a insert in a DTS package. After extending the table with a field (NOT NULL) with default, I get an error inserting data without specifing explicit data for the new field. What's wrong? ...more >>

Dear All, Is it possible to set up DTS timeout property ? -- Paul ...more >>

Is there backward-compatibility? I am supporting a legacy Access 97 database and need to do a lot of data manipulation I'd like to automate in MS SQL 2000. If I export the DB to SQL 2000 and run my changes there, can I send the tables back into Access 97 with the inserted/updated values?...more >>

Hi, I have a DTS Package (.bas) that I run from VB 6.0. So, after many loads successfully. Now I'm receiving a follow message: CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after t...more >>

I'm trying to migrate database from its current location Windows 2003/SQL Server 2000 Ent Ed. to its new location a W2k Advance/SQL Server 2000 Ent. Ed. Should I use the sa login for the source and sa login for the destination. Or create a login account in each box. If i use sa, will it e...more >>

SQL2000 SP3 (DTS) has a custom task which allows for the automation of incremental update of OLAP cubes. If this is paired with a 'Dynamic Property' task on a 'fact' table which has a key field which is a incremented txn id - then you have a nice solution for scheduling a regular drip fee...more >>

SQL 7.0 Trying to load data from Excel (Office 2000) to a table. In 'Transform Data' Task, when clicking Tab 'Transformations' - ERROR Error source : Microsoft JET Database Engine Error Description : System resource exceeded Pls Help Thanks In Advance Shamim ...more >>

Hi.. i have a table with 3 columns: Name, Service, and Date. I want to know for each name, wich is the last service that used. i would do: select Name, Last(Date), Last(Service) from ( select top 100 percent Name, Date, Service from dbo.aTable order by Name, Date ) q gro...more >>

I'm having problem importing acess 2000 tables to sql 2000. I get following message: Error source: Microsoft JET Database Engine Error description:Record(s) cannot be read;no read premissions on (table name) Contex: Error calling Openrowset on the provider I can export tables from access...more >>

This one has me stumped. Please respond if you have any ideas on resolving this strange behavior.... I am getting weird errors when opening DTS packages or when saving a database maintenance plan in Enterprise Manager. We are running SQL Server 2000 with SP3. I created a DTS package with no...more >>

Hi, I need help on how to view the job history for a dts package for like one month ago? I know how to view the job history by right click on the job and view job history. But that only shows the history of two weeks from now. How do I view the earlier history before two weeks ago say o...more >>

I am getting a deadlock error message that is perplexing me. Our scenario is like this; separate applications using ADO and ADO.NET with EnterpriseServices are coexisting in this project. The database and stored procedures are what we have in common. We are doing some testing now to see how we...more >>

Is there any I can have a task in my dts package that will not get executed when I run the package (if I don't want too)? It would be the equivalent of having the -- in the begining of a sql statement line. ...more >>

Hello! How can i start an ExecuteSQLTask? greets chris ...more >>

Is it possible to add a header column to a DTS Destination file? I am able to output the row by row transformations, but what a bout adding a one time header row to the out put? Tahnks for the help! Stever...more >>

Hello, I'm in a quandry as to what to do? I have a remote ORACLE production database and a local SQL reporting and Data entry database. I don't have permissions to write Store Procedures on the ORACLE server so I need to copy the data and put it on the SQL server. I have come up with t...more >>

I am doing record maintenance on dBase IV files using DTS packages. (We are updating workstation software package files with mainframe transactions.) The insert package works fine, and I have an extract package that reads the records in the dBase files. My problem is with the delete pac...more >>

Hi, Is it possible using the DTS to monitor a CSV file and import it into a table only when it has changed, i.e. the date and time stamp. Any help greatly appreciated Martin...more >>