Hi, I want to create a DTS package which can accept parameters and only import / export data based on the value of the parameter. can anyone please help on how to create such package and how to execute such package by passing parameter. Appreciate your help. Thank you, Ram. ...more >>

I have created a transform data task that inserts rows in SQL Server from Microsoft Access 2002. The Access source table has an Autonumber field (that I do not want to use) and the SQL Server destination table has an Identity field for the primary key. Everytime I run the package, regardless of ...more >>

I have approx. 20 jobs that run over the course of a day in my system (running 7.0) Occassionally, jobs begin to fail even prior to execution. This is the information in the 'show job steps' option in the job history: The step did not generate any output. Process Exit Code 128. The s...more >>

Someone has sent me an SQL Server 2000 database (e.g. DBMS.BAK). I want to "restore" it on my copy of SQL Server 2000. It isn't one of the databases listed in Enterprise Manager on my machine, obviously. How do I go about doing this? Many thanks ...more >>

Hello all, I've just discovered a significant flaw in a DTS design of mine and hope that someone can help. First, I have a DTS package that does a number of clean-up tasks when an error is encountered - send an email, move the current file to an error directory, write information to a ...more >>

In Sql Server 2000 - I am creating a DTS Package. I have a Transform Data Task going from a source to a destination. I want to duplicate this Task and have it go somewhere else as well, from the same source. Is there a way to copy and paste this task so I do not have to redo all of the transofrm...more >>

I'm trying to create a local package that will back a set of SQL Server tables up to a local Access file on a regular basis. The goal is to have the DTS job create a new access file each day, then backup the tables from SQL Server to Access. I used Enterprise Manager to Export the data from SQ...more >>

In trying to make some changes to a file extract (we are pulling a text file from another domain into the one our SQL server is in, and then loading a database from it), we will have the need to "bind" the sets of text files together. In other words, for me to know which orderfile goes with wh...more >>

I copied a diagram from one server to the another one. The tables in the diagram copied over, but not the relationships. Can you copy a diagram without using the relationships....more >>

Hello, I'm writing a DTS package to restore databases from backups, this would run everynight. These backups are often corrupted, which I don't want to try and restore anything if they are. I've trying to use the "RESTORE HEADERONLY" command to check if the backup is corrupted or not, this...more >>

In brief: We have an older, DOS-based billing system with the tables stored as .dbf files. We are currently building it's replacement with a VB6 front on a SQL database. The table structure has been completely changed for the new database; every night our server backs up the .dbf files ...more >>

I'm getting this error message when trying to save my DTS package: Error Source: Microsoft Data Transformation Services (DTS) Package Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION Can anybody help me with it? Cheers, Paulo...more >>

Hi I'm looking for a way to automatically import data into a database from text files. Normally I would just create a DTS package with a text file source. Unfortunately this won't work now because the text files are all named after the creation time and date (i.e. each text file is named...more >>

Some of us VB/SQL programmers have been trying to come up with a solution to find out when a table gets inserted. We figured out a nice theory to it where on insert a trigger is fired and then starts a DTS package. The DTS package would then get the new record and pass it through to a MSMQ. Grea...more >>

Hi, I'm new to DTS have used similar products in the past. I wish to use DTS run a query against an Oracle database and import the results into and SQL Server table. I use the wizard to create the DTS package and everything runs fine, connection work, parsing of SQL and testing works ...more >>

I have been trying to create a DTS package with a client's SQL table. When I try to open, I get Microsoft OLE DB Provider for SQL Server DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. The server does exist, (because I am on it at the time), but I cann...more >>

hi, I'm trying to import data from SQL Server to Excel. I've noticed that when designing my DTS package, my excel file should already have predefined columns for transformation. My problem is that, the number of columns i need to import to the excel file is dynamically changing depending o...more >>

Hi, When I execute the package manually it works fine, but when I schedule the package it fails. The error below is what I get viewed in the job history. Can someone please help? Thanks! Lee DTSStep_DTSDataPumpTask_5 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 ...more >>

I use a commen DMO script to do the table data export to txt file. in SQL 2000 DTS package ActiveX code as following: --------------------------------------------------------- Function Main() Dim oServer Dim oDatabase Dim oBCP Dim nRows Set oServer = CreateObject("SQLDMO.SQLServer")...more >>

I have a Simple XML File and I need to take this file and Import to my Database, but I looking for a Method to do that. Can someone help me? Thanks in Advance. ...more >>

Hi, I need to read in some text from a *.txt file on the sql server file system, replace a token within the text with the results of a select statement, and write the text out to a different file. Alternatively, I am willing to skip the "read" part, and hardcode this text in the activexscript...more >>

I am importing from a comma delimted file. One of the columns is my sort key, so it cannot be NULL. Apparently if line in the input file includes nothing between the delimters, that field is considered NULL. .e.g line:A,,B (2 field is considered NULL) Subsequently, I get errors...more >>

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 >>