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