Hello. I need a way for a portable computer to access an sql database while not connected to the network. Could SQL Personal Edition be the solution? How can I get it? Thanks....more >>

I created a DTS package which imports a csv file. The file will reside on another machine in our network. I have changed my active script page to look for the file using the UNC path name: \\server_name\share_name\file_name How do I ensure the shared directory allows the proper permissi...more >>

I am importing a vertical bar delimited file and it seems to go so much slower then if I used a fixed field file. Is that normal or is there something I am doing wrong. (Ex. importing the same file in both bar delimited and Fixed length. Fixed length takes about 1 minute and bar delimited file t...more >>

I need a step by step on how to take a .mdf file and import it into an existing SQL database. Any pointers would be greatly appreciated. Sincerely, Dwight...more >>

i inherited a pretty horrible access db that i am trying to move to sql server. the import fails on two tables with a nondescript error: Invalid character error for cast specification. i removed the row in question, as well as rows before and after it. i still get the same error for the same...more >>

Hi All, Using: DTSBulkInsertTask with VB6 This seems to be the right place to ask... I have two different ASCII flat files I need to import into an MSSQL table (actually the same table) via a VB application. I've been attempting to run a sample provided with MSSQL (C:\Program Files\Micro...more >>

I am using SQL 7 I created a DTS package, and when I execute it through enterprise manager it runs with no errors. But when I try to run it through query analyzer using a stored procedure it does not work. Any clue where I can start to debug this issue? Thanks....more >>

In DTS designer, I get an abend when trying to define the destination fuile format for an export file in cvs format. The column list appears empty after defining the query. When I click on the Define columns Button, I get a mmc.exe application error. The message is {"The instructio...more >>

I am having trouble with a scheduled job. The job is a two step job. Step 1 does a T-SQL statement to check a log table for a value, and if it is 1, execute a meaningless statement guaranteed to succeed that simply allows the job to go to the next step. If the value is 0, it executes a mea...more >>

I get this error when i try to schedule a DTS with a proxi account that is member of the local "power users" group: ---------------------------------------------------------- DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnFinish: DTS...more >>

Hi, I am looking for some help with putting a solution together that will poll for a file say between 7am and 9 am once the file is available it will trigger a DTS job. I am unsure as to how I should go about this, Any help would be much appreciated. Thanks Patrick...more >>

As the title says, I've been wandering in the land of Why Not. I can dos copy, move etc.. but cannot get the same results in DTS. So, let's not fix what I have tried. I'd like to find the basic steps to do a test copy from my laptop to my desktop over the lan. If that is successful, I'd...more >>

How do I properly report a bug in SQL Server 2000 software? The issues (which I have concluded are actual bugs) both occur in the DTS wizard, rather than the database engine itself. I have searched the Microsoft web site for a bug- reporting form, but have not found anything yet. T...more >>

Hi, I'm updating tables in SQL2k using DTS. One of the fields i'm pulling from Oracle [via 9i OLEDB provider, LOBs enabled, Forced Longs] is a CLOB. It needs to fill a Text field but fails around 1024 characters and gives me <Long Text> instead. How do I get my SQL table to give me al...more >>

Hi NG, i got problems to enumerate the available connections from the whole DTSpackage inside a custom task . I can't get the reference of the package into the UI of my custom task. Any code snippets available? Kind regards Frank ...more >>

Hi, I just wonder what data Type should I use if I assign a memo field data from MS-Access ?? thanks ---------------------------- Ginola...more >>

I have created a DTS package that pulls data in from Oracle into SQL Server. When I run it directly on the server (from Enterprise Manager), it works fine. When I run it from Enterprise Manager on a client machine that does not have the Oracle client software, it does not run, giving me the erro...more >>

I have a DTS package that selects from Oracle and inserts over a million records into SQL Server. Is there a way using DTS to commit after every 10,000 records or so? thanks in advance...more >>

Hi, Does anyone know how to install the DTS utility with installing Enterprise Manager. Thank you...more >>

Hi I want to create a Text file in runtime , load data from excel sheet into this file and then pick up data from it and load data into a Table? Thanks in Advance Cheers Ravi ...more >>

I am trying to connect to an FTP site. I can establish the connection but the file host type is incorrect so the data is unusable. Any ideas?...more >>

Problem: Users are not able to see the DTS packages until they are present as users in MSDB database. Question: a) Is it necessary for users to be present in MSDB database to be able to see all packages. All users are non sysadmin users on SQL 2000. b) Is there a workaround to remove ...more >>

Hi, I have already posted this question, but maybe I was not clear enough. I have the following dts package: succ succ StepA(ActiveX)----->StepB(Data transf)----->StepC(ExecSQl) StepD(ExecuteSQl) StepD should be executed ONLY if any one of other jobs fa...more >>

I am running on Windows 2000 server. I have a backup maintenance plan scheduled to run periodically during the day. Intermittently, the jobs fail with the following: The job failed. The Job was invoked by Schedule 16 (Schedule 1). The last step to run was step 1 (Step 1). The job sch...more >>

We have a column in a Access table defined as datetime, but it only holds the time value. When we try and uplodad the table to SQL Server via DTS, we error: Conversion invalid for datatypes on column pair 4 (source column 'ReportTime'(DBTYPE_DATE), destination column 'ReportTime' (DBTYPE_...more >>

Hello! I am using a DTS-packet to read several tab-notated files into MSSQL. These files lay in a folder, say "C:\DTSSource". When my package is run, it goes through all the files in this directory and loads them into SQL. All this is done very similar to the example I found on SQLDTS.com. Lin...more >>

Hi All, I have an issue with sql 2k on win 2k Server platform. when I run a simple DTS Package for copying some(not all) tables from one sql server to another, the wrong tables get copied. The first time this happened, i thought maybe i was careless in selecting the tables. but this ha...more >>

When opening up the ActiveX Script editor in a transformation task I get a msgbox exclaming DTS Designer Error and the message is made up of 10 box shapes. I can still get into the editor, but there are no script languages or functions. I am on SQL2000 SP2. Any help appreciated. Ia...more >>

Dear Freind(s) I searching for any individual or institution who can furnish me with sample test on Database Design using Sql 7.0. ...more >>

How do I created a DTS or TSQL package that automatically copy tables starting with [DG*], there will be 100 tables starting with DG. I don't want to manually select the tables with their checkboxes. What I want is a script that will copy the tables based on the first 2letters of their name (D...more >>

I have a DTS package that opens an Excel File (Local to Server) and Runs a macro. This DTS package runs fine on the server. However when I installed it on the Client it needed Excel installed. To execute the package I use the DTSRun Util. How can I make this Package run on the Server but trigge...more >>

I'm trying to migrate/copy a database from our 7.0 server to our new SQL Server 2000 box using a DTS package I created (using the export wizard thing). When I execute the package, it gets to a certain point then fails with the message "there is already an object named 'Test' in the database". ...more >>

I have a DTS package and sometimes a certain step (Execute SQL Task) which executes a store proc is returning an error (in this case an insert into a table fails because of a null value for a not null attribute). When I execute the same procedure manually (in Query Analyzer) it is OK, no e...more >>

I have a package that has 4 steps: a,b,c, and d. Step d should be executed only if any of other steps (a,b, or c) fails. I cannot use clasic workflow (On Success, On Failure) constraints, so I have to use ActiveX workflow defined on Step D (At least I think so)... I developed following Ac...more >>

Hi experts, I have a DTS that has about 6 steps in its execution... lets say: Step A -> Step B -> Step C -> Step D -> Step E -> Step F Step A checks for a file, if the file doesn't exist then I want to skip, Steps B and C, and execute Steps D, E and F. How to do this? Tnk in advance...more >>

Hi folks, I am new to this news group so sorry if that kind of question has already been asked. I would like to have an idea of the time it would take to transfer a database of about 15 gigas between two sqlserver 2000 using DTS without data transformation or any kind of filtering, knowing ...more >>

Is it possible to insert multiple rows in the destination table based on one row in the source? My destination table is keyed on an eight character code. The source file has a seven character code in one field and a string of modifiers for that code in another field. For example, the sou...more >>

Is there anyway to run dtsrun without getting any output? Many thanks in advance! Bob Martin ...more >>

I created a DTS package that extracts data from a SQL table to an output text file. I need to define a variable output file name. For example AUDITLOG_yyyymmdd where yyyymmdd is the run date. The DTS package is schedule to run quarterly. How do I do this in DTS. I searched the k...more >>

I have 2 SQL servers: SQL1=prod box SQL2=backup/recovery box The idea is that I would like to use SQL2 to backup SQL1 daily. Now I've run the import routine and created a DTS package that seems to do the trick and I have added a daily job to run it. No problem. The issue I have is that s...more >>

In DTS data transformation task 1.input file -- text file with varaible number of column 2.and data has to be copied to a single database table As one user 'allan' in this group suggested I have used multiple execution path as solution. I am ending up with too many execution path here. is...more >>

Whenever I try to use DTS to refresh a test database from a production database I get an error meesage during object copying that says that object could not be copied because there is a foreign key constraints and the DTS package will fail. Any help on how to turnoff the contraints at on...more >>

Hi experts, Im getting a permission error when I schedule my DTS Package. Basically I need to use a text file which sits in a different server. Can someone help me understand what user login does the SQL Agent run under, and is there a way to change it? This is the error message the JOB giv...more >>

Hi there, I have created a DTS package with SQL Server as the source and Excel as the destination. I have obtained the Data from SQL Server in a clumsy fashion (I mean I would like to format this data in a nicer way). Is there anyway of implementing the ActiveX script to get a good looking ...more >>

we had 2 fresh windows 2003 boxes. On both boxes we intalled sql 2000 and sp3 for the sql 2000. After that i configured linked servers in both SQL servers, 1. with server type as "SQL" , 2. Security as "Be made using this security context" and i used "sa" user of the remote servers. ...more >>