I have imported the tables from excel to my database which does not have the FK relationships, Now i need to check the relation check in the imported database regarding this i have some queries, any help on this is appreciatable. 1. How can We check the Relational check(Checking child recor...more >>

I have one DTS Package say Package1 where i have most of the Lookups in one Transform Data Task. I would like to call these Package1->Transform Data Task ->Lookups in another dts packages say Package2 in Activx Script instead of writing lookups again. Any help appreciatable. ...more >>

I want to keep appending to an existing text file destination output file everytime I run a DTS Package. Unfortunately DTS keeps ovwerwriting what is in the file. How do I append into a text file destination. Thanks Karen ...more >>

Hi, I created a DTS package that creates an excel file and send via email. What I notice was everytime I run the package, instead of overwriting the file, it appand the new results to the file so I created an active x script task to delete the file after it is being emaild but next time I run...more >>

Hello All, I'm auditing my ETL processes and I want to get the following info about the currently running dts package from sysdtspackagelog. select [name], [description], [id], [versionid], [lineagefull], [starttime] from sysdtspackagelog Anyone else need this info during execution? ...more >>

While copying database I am getting object not found errors. I looked up the two tables that were cause of the error and they were missing from the tables, so I deleted all references to them in the database diagram, views and stored procedure. But still DTS continues to give the same error. A...more >>

I have a requirement for a DTS package to read mail from Exchange and process any file attachments. We receive data files from various vendors this way which today must be manually saved to a directory and their DTS load packages manually started, which is slow and error-prone. Any comment...more >>

I have added another Destination to my DTS package (it is a different table in the same database). Now the DTS package isn't working as expected. It now loops through the query, picks up the ExcelLink and executes the 1st transform, then loops back, when the loop is finished, then it execute...more >>

I have an issue where I cannot use input parameters in an Execute SQL task. I can write any query which will hold values or other variables eg @LogRecID = 23 or @LogRecID = @AnotherVariable, and when I hit the parse button the syntax is fine. Indeed I can cut and paste it into query analyser a...more >>

I'm using a Dynamic property to change my pump Task connection based on a global variable.The global variable specifies which database I'd like to use my DTS in.DestinationObjectName is something like [DatabaseName].[dbo].[TableName]. I don;t know how to change this portion only([DatabaseNam...more >>

I have been given the Administrator Role (in our server).In our server there are two databases.I'm in Public role for both databses .My DTS package works in one database in other database it gives me this error : Step 'DTSStep_DTSDataPumpTask_1' failed Step Error Source: Microsoft OLE DB Pro...more >>

After I restore a msdb database from a server to another, I like to modify my DTS with my user MYUSER : - I can create a new DTS, - I can open and save a DTS with another name, But - I can't open and save a DTS with his original name I don't like to change my user rights and adding this...more >>

Hi to everybody! On using the Build Query option from the Data Transformation task, I' ve realized that the update query only allows updating a field with a scalar value. However I'm trying to use the Data Transformation Task for these kind of queries: UPDATE TableToUpdate SET C_FI...more >>

I'm creating a package to import a set of 5 very large text tables, they all have the same structure (515 fileds). I would like to do it all in one single package running parallel tasks. However, I'm force to map, source and destination fields, for each of them !!! Does anybody knows of ...more >>

I got a problem to call my dts inside vb code. I can run my dts successfully in sql server enterprise manager or in the command line. but when I try to call it through stored prcedure, it fail and I even can't catch the error. my stored prcedure is like: CREATE PROCEDURE [dbo].[CSCDDTSRe...more >>

I have a large text file which has columns name in first row (column separated by "|" char). The file contains 125,000 records when I use DTS to import this file the DTS hangs after importing 61000 rows (as per progress bar showing). Is there is any limitation on maximum number of rows the "t...more >>

I need to backup a database on another server. And, unfortunately, I don't have permission to write to the hard drive on that server. The only way I can think to do it is table by table, using DTS. I would need to keep the DDL and sync and then for each table, truncate the destination and...more >>

I have a DTS package that basically does the following: 1) Truncates a table called MYDB.tblParameters 2) Reads a CSV file called tblParameters.csv under the C:\DEV\MyApp directory 3) Writes CSV information to SQL Server 2000 to database MYDB.tblParameters using a specific username/pass...more >>

Created a DTS package and executed it successfully from a VB .Net program via the DTS Package Object. I then added a third party custom task to the package via the DTS designer. I can still run the package successfully from Enterprise Manager or DTSRun. However, running it in the VB .Net pr...more >>

Hello all, Sorry for the length of the post but I want to be thorough and not waste anyones time suggesting something I've already tried. I have an application that pulls data from an oracle (8i) db into SQL Server for processing. At the moment it copies all of the data from the oracle tab...more >>

Hi, I am getting frastrated by trying to call DTSrun inside the stored prcedure. I want to my DTS triggered by user interface clicking. So I wrote a stored procedure inside sql server and call DTS inside the stored procedure: CREATE PROCEDURE [dbo].[CSCDDTSRefresh] AS EXEC master..xp_cmdS...more >>

I have a DTS package scheduled to export data to a text file daily. Sometimes, on two consecutive days, the data exported are the same when the job runs as scheduled. If I run the job manually using the same parameters (date/time), the data are different. There is no particular pattern to it. ...more >>

Hi I have written a dts in SQL Server which uses the Send Mail task. I would like to log the details of a failure, if the mail fails to be delivered, ie if the email address is invalid. The problem is that the Workflow On Failure event will only fire if the mail fails to be sent, not if ...more >>

I am in the process of consolidating 17 SQL servers into 3 (yes they extremely under-utilized). I am trying to use the Copy Database Wizard to do this, mostly because there are a couple hundred databases that need to be moved and it would be very tedious to do each one via backup and restore ...more >>

When I set the destination column, SQL craches. Anybody can help me?...more >>

My DTS package was working great yesterday, so I closed Enterprise Manager and started working on "prettying" up the excel file. Not anything too drastic, just validating cells and the like. I just updated all my Excel files and ran the package. Now the DTS package is importing 499 record...more >>

Hello All, im am experiencing difficulty with automating a DTS package. if i try to run it manually it work, if i try to automate it with the scheduler it always fails. to debug it i executed it using dts run to gain more information and i got the following output below C:\Documents an...more >>

Description: We are using a DTS to build a table just for FT indexing. Basically we gather all of the words from the fields we'd like to search, and put them into a single table (moosejaw_tblFullText). Then we're using FormsOf (Inflecitonal...) to get results as the SQL below shows. For on...more >>

Hi, I have a package that starts and ends with ActiveX tasks. The first task locates a file and then enables the following step: Set stpStart = pkg.Steps("DTSStep_DTSDataPumpTask_1") stpStart.DisableStep=False stpStart.ExecutionStatus = DTSStepExecStat_Waiting The ending Active...more >>

Hi All is there a way to trace the DTS package. We use profiler to profile/trace the sql database. but is there a way to trace the dts package, each step of it. We have active x script and i need to trace thru each step as it executes. thanks in advance ...more >>

I have a number of packages that I need to move from one server to another. However, I also need to add owner and user passwords to each package. I am trying to find out if I can do this from the back end by select the records (DTS packages) and inserting them into the destination servers' sys...more >>

I have some code that I am using to import a flat file into a bunch of related tables. I am trying to make it so that new records are added to the related tables of a new value appears. However, my code thinks that every value is new and unique and creates a new entry for it. For example, o...more >>

I have a link server I'm trying to connect to in a DTS package. I'm not sure what connection to use and how to set it up. Any suggestions?? ...more >>

OK, wrote a DTS package that has multiple ActiveX steps. In an early step I create and populate a dictionary object, create a new global variable on the fly and set its value to the dict, and then fetch the value from the global in later steps and use the values. It all worked fine until ......more >>

I have a requirement to populate a table from a file whose name changes every time it is run. I can determine the file name using an ActiveX VBScript and would like to then point the Text File Connection to it. How would I do this? Or is this the best way to do this? I am learning but my ...more >>

Please help: I am trying to create a piple delimited text file through a DTS export which consists of about 93 different fields. However, there is one data field that is populated from a list of options. The user is allowed to choose one, click an add button, choose another, click add, et...more >>

Can someone please tell me how/where is the log file when I am scheduling an Export from one database to another. I would like to see the details of the success or failure of that job. Thank you. ...more >>

I'm running EM on my local box and sql server on a remote interne accessed box. How do I specify a file path for a DTS package to access files on th remote box For example, to run a local dts package the path i c:\filepath\file.txt How would I change the file name to allow the remote dts p...more >>

I have a DTS package that is used to import a flat file into my database. This file is a rotating log file that could hold information that has been imported previously so I was testing running the import multiple times when I ran into this COMExcpetion (I'm calling the DTS package from a C# app...more >>

I have to create a DTS package that will import a file into my database. This file can come from a Unix machine or a DOS machine so the row delimiter will be either {LF} or {CR}{LF}. I know I can write my package to handle either of these row delimiters, but can I write it so that it will handl...more >>

Hi, As a beginner with DTS, I'd like to know if it's possible to export data from a sqlserver with a package, but without predefined tablecolumns to export. I want to build an export module from C# that exports columns the user has selected (thus at runtime). The DTS packages I have tried to ...more >>

Ok, I am getting this project pinned down, just need some more help. My SQL Task uses a simple query, SELECT ExcelLink FROM Cardholder I would like to know if it would be possible to return 2 columns of data, SELECT CardholderID, ExcelLink FROM Cardholder and then use the ExcelLink ...more >>

Hi All, I have to create a report text file but in special format base on information from a tables data. The text file I need to create it in a particular folder with this format: Report Date 5/24/2005 Batch: 001 From position: 532 To position: 543 Descri...more >>

Hi , I am having probelm with Global Variables in my DTS Package. Data Transform Task is defiend between 2 SQL Server. I have defined Global variable in my Package and trying to pass variable value to SQL Statement defined in Data Transform Task. For Example 1) Gloabal Var : OrderNo,...more >>

I am beyond my capability in trying to move MS CRM accountbase data via the CRM Data Migration utility. My difficulty is in handling the Uniqueidentifier Primary Key "AccountId" guid from the originating table and passing that 16 character GUID to an intermediate table which has a Primary Key "...more >>

I would like to create a DTS package that will accomplish the following: Check if a database table A has records. If Yes go Else Stop. Erase Replica table B. Copy Database table A to replica table B. I'm able to copy all records from one table to another automatically. I would like some ...more >>

My individual steps all work fine. If you click on each step with the mouse the whole DTS package will run fine. If you execute the DTS package, it will run with all success messages, however some blocks of code wont run, you'll have to click on them to execute even though messages say they ex...more >>

Hi. I'm using SQL Enterprise Manager 8.0 and importing a text file into a SQL table using a DTS package. The text file has rows with 542 characters in each row and a CR LF (0D 0A) at the end of each row in position 543. Using a Hex editor (Ultra-Edit) I was able to confirm the CR LF at the...more >>

I'm importing from Text (file) into a table that consists of 83 varchar fields, then an Identity field. The source file has no ID field, just CSV data ( max 83 fields ). In the Import Wizard as soon as I specify the field delimiter ( comma ) the display shows that all unspecified ( in the in...more >>

Ok... I know this is probably a VERY dumb question, but how can I install the sample files (*.dts) into SQL Server? I searched the server for *.dts, with no results. Thanks, Drew ...more >>