Hi, I'm using SQL Server 2000 and created a simple DTS to append records from one table to another. The second table has got a composite primary key (col1 and col2). When I run the DTS is gives me this error: ---------- Violation of Primary key constraint "PK_Table2". Cannot insert duplicate k...more >>

Hi, I have BIN files that were supposed to be ready to transfer into SQL Server. These files are from MAPICS system. Is there a way to check or to open these BIN files? My boss believes all data couldn't be transfered. We would like to be sure. Every help has been greatly appreciated.. T...more >>

Hi all, I have two identical processes, one for Actuals data, the other for Plan data. I'd like to paramater drive a DTS package based on the value of a global variable to switch between the two. What I am looking for is 1) A way (probably through ActiveX) to read the current value of...more >>

I've read several posts out here and am at least finding some answers, but I'm new to DTS and am looking for some advice. I'm building a web app that will allow clients to upload Excel files ranging anywhere from 15000 to 30000 rows. This data then needs to be stored in a SQL Server 2k table ...more >>

Hi, I am facing a strange Problem The First row and second row of my excel are alpha numeric and the rest are numeric, yet when I dump the data in a text file its showing the data as null why? where as the numeric data is being ported correctly why? Thanks Ravi...more >>

I am attempting to use DTS from an Access 2002 database table to import data into a SQL Server 2000 table. PK entry in SQL Server table is created by a trigger. SELECT @maxc = (SELECT Max(TBL_ID) FROM SQL_ServerTable) SELECT @newc = (SELECT TBL_ID FROM inserted) IF @newc = 0 or @newc =...more >>

Can anyone point to some examples of populating Dynamic Properties task via query to sql server database? We have an admin database on each server and propose to allow all the DTS packages to collect the global variables required from a table in that database thus an example would be apprecia...more >>

I'm setting up a package with 15 or so steps. I want to set an error variable and then use a ActiveX script to email the value of the error variable (which step, etc) if the step fails. My plan was to do a process flow failure from each step to just one ActiveX task. My ActiveX task won't ...more >>

I am practicing using te DTS and set up a package to transfer a table from Access2002 to Sql Server 2000, using the Transfer Data Task tool. When I run the package I get this error: The number of failing rows exceeds the maximum specified. Insert error, column 40 ('DelDate',DBTYPE_DBTIMESTAM...more >>

Hi All, I setup a DTS package scheduled to run every 5:00PM. I don't have problem executing the package but the scheduled task always failed. I believe this is something about permission... what d' you think im missing??? thanks, joel ...more >>

Hello all, How can I determine what context a DTS package runs under when executed from a dll? I am attempting to execute a DTS package from a asp script. The COM+ component has the proper privileges, but the job is failing when executed from the web. When I run the job manually in D...more >>

Hi All When I run the Copy Databases wizard to copy databases between two servers, on the target and host servers all databases after MASTER & MSDB need to be reattached. We are running SQL 2000. Look forward to a tip cheers Paul ...more >>

Hello all, I created a DTS to import an ASCII-file. First task in the DTS is to create a new table. I use a few real data type fields as well. When I execute this DTS manualy, everything is working fine. But when I schedule this DTS, the job fails. When I change the specific fields from r...more >>

K i've tried some of the solutions that were simple that I found in other posts, but wasn't successful and performing what I wanted. Scenario: I have a form. In that form I have 2 textboxes. One box is called time The control source for time table1.datetime. The second box I have is called Name....more >>

I need to Merge some txt files, and I want to use DTS. It´s Possible? When I´ve tried it, I don´t Known where I set de Destination to be an "append" file. If i have some transformation, it´s always dlete de old file and create a new file with the lines of the transformation. Somone Known if me...more >>

Does anyone know of code that automates the process of saving your dts packages to files. So say I have 50 dts packages that I want to save to a file. I dont want to manually open each one up and save. I want to have some code that will take each package and save it to a file. I hope t...more >>

I'm not familiar with the procedures to copy a data model schema (cubes, dimensions, etc)with DTS. Anyone out there have any suggestions? Thanks...more >>

Hi , My Web server is not having any SQL server installed.But i want to run a DTS Package ..Is there any way to run a DTS Package without SQL server. Or else my SQL Server Provider doesnt allow me to store any file on their server.I can store only DTS Packages.But the package is using a tx...more >>

Hi, I have a strange problem, I am picking up data from a spread sheet 1)The first row has a 10 Cells merged into one column called 'BE', the next next 10 Cells merged into another called 'DR'and the next next 10 Cells merged into another called 'CR', So effectively I have 3 Columns 2)...more >>

Can anyone tell me if there is a way to change a field in an Access database that is being transferred to SQL Server? I would like to change a field as each record is copied successfully. If there is a way, can you post an example? Please, this would be VERY beneficial to me. Thanks, ...more >>

I've got a COM+ component that is called by my ASP code. The COM+ component passes a global variable to a DTS package and executes the DTS package. I need to edit the COM+ component to get it to accept the global variable and to pass it on. Herein lies my problem. I am not savvy in the...more >>

Hi, Is it possible to concatenate data in every cell of the first row(Header excluded) with a space in order to covnert the data to Text Type? If yes how do we select only one row in Excel Cheers Sunny...more >>

When i try to update a AS400 file (using Client access 5.2 drivers) with DTS on SQL 2000 i get the following message: "Query cannot update because it contains no searchable columns to use as a key". The DTS transformation fails altough when i test the transformation, the test completes suc...more >>

I'm a novice SQL admin and I've been given the job of moving a database from a SQL 6.5 server to a SQL 7.0 server. I need help making this work. I created a new database on the 7.0 server then ran the DTS wizard. I select the source 6.5 server and database, select the local server and the ...more >>

Hi! How can i get the name of all obejcts (queries, tables) in an existing Access-Connection and their structure (for tables the fiieldnames and datatypes, for queries the SQL-statement). I want to do this via ActiveX-Script. Thanks! greets chris ...more >>

Hello all, How, from a SQL Task, can I assign the value to a global variable. I mean, in a SQL Task I execute a SQL that returns a date value, I need to assign this value to a global variable. I've tried this: select gv = mydate from my table. Here gv does not have value!! or selec...more >>

I added two tasks (ActiveX and Dynamic Properties) for debugging purposes which pop-up a few InputBoxes to enable me to test the rest of the DTS package easily by manually providing values normally passed to the DTS package by a VB application. Once I've finished testing I'd like the simplest ...more >>

While attempting to use DTS, to import an ASCII text file, comma delimited, I get this error. violation of primary key constraint I checked the file, it is perfect. The problem was, we had to restore a database to an earlier date, due to problems, we later found were caused by a user. ...more >>

How do I backup all the DTS packages in the server? And how can I restore them in case of failure or corruption? Thanks. Wendy...more >>

when should I split one large/complicated DTS package to serval DTSs that are called from the main DTS. should I split my DTS or it is Ok to keep most of our code in one big DTS. 10x in advance ran...more >>

I have some Views created in our SQL Server DB that use a linked server to fetch data from Tables in an Oracle database. I have built a very simple DTS packaged with some Execute SQL steps to copy the Oracle data to SQL Server tables. Each step just does an "Insert into select *" SQL. N...more >>

Hi, I'm trying to access a file from our shared SQL Server to our shared Web Server using a DTS Package. It's failing at the FileSystemObject here: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Set objFSO = CreateObject("Script...more >>

Hello I am a novice in using SQL Server 2000 enterprise edition I am trying to copy a Database (through scripting) which has relationships I created using Diagram. When take this generated script and run on destination server, I do NOT see any diagram under newly created DB. Is there a...more >>

Hi, I am having a DTS Package of extension .DTS. I want this to be saved as a DTS Package under Local Packages of my SQL Server.How to do it? Thanks in advance.. ...more >>

Hi All, Recently I am experiencing problem when in Enterprice Manager using import a new table from another SQL 2000 server. The task completed with no error, but the record count is different, the destination table is always has more records. Is anybody experience the same problem? Tha...more >>

Hello ! I have created VB script function that I would like to use in many Active Script tasks of the same package. Is there a way to make this function accessible everywhere within the same package ? I tries PUBLIC declaration but it doesn't...more >>

Hi. I have the following line of code in at sql task in my DTS package: msdb.dbo.sp_start_job @job_name='myJob' If this line returns an error (as it will if the job is already running) I would like to ignore the error and keep the package going. As it is, the entire task will fail if this on...more >>

How can I reset/remove password security from the DTS Pacakge. I have SA rights on the database/server....more >>

Hello, I have two mssql databases for a hotel booking engine, they have identical structures but both contain completely different data. I want to combine (or merge) the contents of both databases into one database. I have run into difficulties, however, due to issues with primary keys and...more >>

Hello all, I need to share the value of a variable between tasks inside of a DTS package. I mean, I have three systems (A.B.C.) represent in 3 tasks. From A system (SQL SERVER) I read a date value, then I need to select some rows from C (ORACLE) system having that date, and finally I must inser...more >>