I'm trying to transfer a Database to Production database, by using DTS I get the following error There is already an Object named "PK_Users" in the database Could not create constraint. see previous message. What I have to do to get rid of this error, any help would be appreciated. Than...more >>

Hi All, Is it possible for an ActiveX task (VBScript) in one DTS job to change something in another DTS Job? I would like to be able to have one DTS job that creates a new Access Database. It would then change the Connection information in the 2nd Job to it points to the new Access...more >>

Hello all, we have two database connections to two different data sources -- one SQL Server and one from the VAX. We need to take a global variable that is generated in an Execute SQL Task (SQL Server) and use it inside a Select statement's Where clause in the other Execute SQL Task (VAX). We've...more >>

Hi , I have a VB6 program that runs a DTS package. I addedd the WithEvents keyword to the declaration of DTS.Package, becuase I need to find out the status of my program while it is running. It works fine from within VB6, but it breaks down when I create a EXE file and run the EXE file. ...more >>

Hi all! I have a problem that I really need help with. I have got some advices before, but nothing has been helpful. So please, please, someone help me... Allright, enough with the begging. The unsolvebable problem: I am transfering data from a SQL table to an excel file. Nothing fu...more >>

Does anyone know if there is a way to move records from an Access database to SQL Server? (delete files after copy) I would prefer to do it with DTS, but I believe this will be a problem. Thanks ...more >>

Hello there I have some table that i need to create excel file that provide me the data inside of the table. How can i create DTS package and how can i run it using Store Procedure? any help would be useful ...more >>

I have a DTS package that first has a Connection to a Text File for Import. It then Transforms the data to a temp table using a second Connection. Upon success of that, I want to Connect (the third) to another Text File and then tranform that data to the same temp table. But everytime I tr...more >>

I have a cube that is based on a fact table whose records are deleted each night and again populated with over 200,000 records. Is it possible that I can retrieve the aggregate cube data each night after the above process runs and store that data in another table? This way I will have ag...more >>

Hi, I am importing from a text file. One of the fields contains (or should contain) integers so I am simply using "cast (field_name as int)" to convert it. All well and good!!! Data being data though there are erroneous values in there so I am using the following to check it: CASE ISN...more >>

I have a table in a mdb file, that have a table, that will split in two tables in a SQL Server database... Like that... In the mdb file, I have the table with clients regs, that have 4 booleans fields that indicate wich categories that the client belongs... Cause the categories are fixed in t...more >>

Client OS: Win2K Client Excel Version: 2000 SQL Server: Version 7.0 I'm attempting to populate an Excel 2000 spreadsheet with the results of an already created DTS package that uses a SQL script to generate the result set. The DTS package currently runs successfully, populating the targe...more >>

This is what I get: Step [DTSStep_DTSDataPumpTask_1] failed Task "Transform Data Task: undefined" Package [SQLtoMDB] failed SQL & IIS are on 2 different servers. When I run the dts package from enterprise manager - it works. It transfers data from sql table to access table. When I ...more >>

What could I do if the DTS package fails with the message:"Unable to create share <share name like OMZX..>" (the first step from the package). Is it an users right issue? - I'm login with admin rights. Thanks....more >>

Hi, I 've developed DTS packages on a SQL Server 2000 database. How to deply easely these package on other server, without enter in each package to record the nex ID on each sub package etc. Thank you for answers....more >>

Hi All, I'm new to the group and to SQL Server so bear with me. Here's a little about my situation... I have to create interface files for other programs that require dbf format files. All data is contained within a SQL Server DB. I can create the file, and work with the file but after d...more >>

Hi, I have developed a DTS package that uses 4 Global variables that set the name of the table, databasename, delimiter in the text file, a file name. The intent was to be able to load any of the tables in our Database using this package. This DTS package uses Stored Procedures to accep...more >>

Is it possible to transfer data, tables, and stored procedures from SQL 2000 Developer Edition to a live SQL Server? I've looked everywhere on the web and all of the overviews I found detailed availability with Enterprise and Standard versions....more >>

I am trying to import a fixed-width flat file to a table and i am getting: Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Error Description: Invalid Column Length. Any idea why? I tried importing to a new table, and an existing one - same error for both. ...more >>

Hi! I am porting some Access applications to SQL Server 7.0 and some of the queries use the IIF function. Is there any equivalent to IIF in T-SQL? I was looking in the OLAP services and it mentioned an IIf function, but after installing OLAP services, I was still unable to use the funct...more >>

I've got a DTS package that imports a CSV file to a table. I'd like to be able to have it ask the location of the CSV file. Any ideas? I'd also like the DTS package to export a SQL script that is based on the data imported. -- Posted via http://dbforums.com...more >>

i have created a DTS pakcage in SQL 2000 which transfers datas between two sql servers and saved it as .bas file, while executing the package from within VB.NET i am getting "DTS the conversion of char data type to a datetime data type resulted in an out-of-range datetime values" error. ...more >>

Hi I had a file with delimited columns I only needed one column from this file I dts this into a tmp table and now have a column with text and custnos: ie custno:234567 I would like to delete the text and colon from the column...as it had over 8000 entries I couldnt separate the text in e...more >>

Howdy All, Thank again and in advance for your help... Having a problem executing a DTS task that involves running an decryption software process. The senerio: I receive encrypted files via FTP every night. I need to decrypt the file, then inport into a table. I'm running McAfee ...more >>

Hi All, I have a process that runs weekly. It has some 140-150 ish DTS packages. These are essentially run from one packages that calls a series of sub packages and the like. Not all the packages are always fired, dependant on certain criteria. Basically the issue I have is that I want to...more >>

Hi, I am working with VB code auto-generated by SQL 2000. Source: FoxPro database file Destination: SQL Server table The VB code works successfully but I now would to modify the code so that an extra column in the destination table is populated with a hardcoded value. This extra column i...more >>

Hi, I am calling a DTS package inside another DTS by setting the global variables. I am getting the following error Step 'DTSStep_DTSDataDrivenQueryTask_1' already exists in the collection. Any help to resolve this issue will be greatly appreciated. Thanks Souresh ...more >>

I have a simple question but I am new at this and am confused. I need to update data in an Access table from data in an SQL table. I have everything working except I am using a Transform Data Task and apparently that type of task just inserts, doesn't update. In Help I have read tha...more >>

I have a DTS package that takes a flat file and inserts the records into a MSSQL table. This package also derives the datasource name from the filename of the flat file, and inserts the datasource name along with the flat file rows, into the MSSQL table. The file name is structured so that ...more >>

I have a DTS package scheduled to run by SQL Server. The scheduled job always fails but I can execute the package directly through Enterprise Manager perfectly 100% of the time. I look up the error in the application log and get: SQL Server Scheduled Job 'Transfer Sniper Statistics' (0xF...more >>

Buenas tardes Alguien sabe como hacer para enviar los datos de un archivo con extension XED que no tiene ninguna sepacion entre campos a una tabla en SQL por medio de una transformacion ????? Muchas Gracias ...more >>

Hi! i've got a problem while trying to load multiple xls files with an activeX task under DTS. My script language is VBS. I can parse all XLS file in a directory and get specific values i need. my XLS to SQL script works for 1 sheet of 1 file. But, i got problem to put those parts together. Ca...more >>

Greetings! I am trying to use DTS to import a CSV file into SQL Server 2000. The problem I experience is that it will not recognize my numeric fields as anything other than varchar (It will error out immediately after table creation if I use float for example -or int in the case of integer dat...more >>

Hi All, Guess I am little too greedy asking for this... But Anyways... Are there any sample code / DTS packages which would take care of refreshing the dimensions and Cubes and exporting them from Transformation Server to the production Server... (With the Server Names and Database nam...more >>

hello! I was pointing to a batch job to email me the errors if there are problems in any of the DTS stage. Apparently, the batch job was not triggered when errors occur. Does anyone know how can i trigger a batch job if it fails? I did not use "Send Mail task" because I do not use Microsof...more >>

Hi All, I am having serious problem since last couple of days with my SQL server 2000 version. on one of my table I have 1788653 records and I am unable to manipulate data into it. whenever i tried to insert any more record, SQL server will give me error: ------------------------------...more >>

I have a problem and I hope sombody could help me. I build a simple package using the Transform Data Task which takes some data from SQL Server and saves them to a text file using a stored procedure. I am getting "invalid pointer" error message. This is very simple sp with two insert and o...more >>

Hi I need to create a table in SQLServer Using the columns available in Excel. I am trying the following query in a "EXECUTE SQL TASK" SELECT * INTO tmp_lookup_codes FROM [Lookup Codes$] The "EXECUTE SQL TASK" is currently using the excel as its source of connection My quagmire is th...more >>

Hi I have a excel sheet where the format for a column is "Date mm/dd/yy" But the data the cell contains is "mm/dd/yyyy" I have some default dates like "01/01/1900" and "01/01/2999" these are getting intepreted as "01/01/2000" and "01/01/1999" Why? Thanks Ravi PS:I have set IMEX=1 ...more >>

Hi I have a excel sheet in which the header has two words with spaces in them Something like Business Events Now I want to use this in a select query something like SELECT BUSINESS EVENTS AS BE FROM [SHEET1$] The above query will result in a error because of the space between BU...more >>

Whenever i connect to a destination server using DTS, I get the following errors: [DBNETLIB][connectionOpen(connect())].SQL Server does not exist or access denied Context: error during the initialization of provider....more >>

I've got a SQL Server 2000 database on a remote server, at an internet hosting company. I can connect with it using TCP/IP and Enterprise Manager. It's a simple database, no transactions, or for that matter much activity at all. I want to copy the whole thing, i.e. tables and stored procedur...more >>

Hi, I've got a connection object which executes a view to populate a csv destination file. I have an activex script which is suppose to set the filename and path of the csv file on completion of the workflow. The format of the filename is ProcessLog_YYYYMMDD.csv. The problem I'm seeing is...more >>

The last page of the DTS Import/Export Wizard (Save, schedule, and replicate package) should allow a save to "SQL Server Meta Data Services". This radio button is ghosted. Why? We have verified SQL Server and SQL Agent have domain owners; checked database and role security; BOL says the...more >>

Hello, here's a strange one... I'm using SQL 2K and I set up a dts which imports data from a csv and inserts it into a table. The indexes/keys of the table is set with a UNIQUE key and with the IGNORE DUPLICATE KEY option ticked, because I don't want to insert duplicate rows. The dts works fin...more >>

I have a table in Sql Server 2000 with a text datatype. It is used to hold body text for physician dictation. I need to DTS this table to an Oracle database. Everything works fine except that the Text datatype field in Sql Server is created as a Long datatype field in Oracle. Is there ...more >>

Something happened with the thread to this message it broke. >Package 1 requires DELETE permissions on table >Package 2 requires INSERT and SELECT permissions >Package 3 requires Exec permissions on stored proc (providing ownership >chain is complete) >That should be that. >When the u...more >>

I am trying to write an ActriveX Script task inside an existing DTS package. In the code, I can see how to reference the package by its name using the LoadFromSQLServer method, but I don't like hard-coding the name of the parent package. Is there a way to reference the package more gener...more >>

Hello All: I am trying to copy tables from one sql server 2000 database to another but it errors out due to a column data coversion error. The source table has a column (birthday, nvarchar) in it, with example of data in it being 12121997. the destination column is (birthday, Datetime). I ge...more >>

Hi, We'd like to store our DTS packages in Sourcesafe. I understand we can save the package as VB or Structured storage files. Our problem is then restoring the file into the DTS Designer so that we can make amendments. I know versioning is available within SQL server but we prefer to kee...more >>

Hello, We are facing the following error when we try to import data from Pervasive SQL 2000 database server to MSSQL server 7.0. The source table in Pervasive contains a field with datatype 'notes'. We have the corresponding SQL table with field data type 'text'. 'ADDL_INFO' is the fiel...more >>

I have the following code where I am chechking the age of the file. If file more then 24 hours then DTSTaskExecResult_Failure. In a job it stated - fail but in reality it is not. How do I hadle this situation? Function Main() Dim fso, f, fc, f1, PName, FName Set fso=CreateObject("Scriptin...more >>

Does anyone know if there are worthwhile 3rd party add- ons, enhancements, etc. to SQL 2000 DTS? Examples include: - Mailing address transformation (converting to standard postal address) - Currency conversions from/to US Dollars (Using average daily rates.) If there is a 3rd party ...more >>

Hi, We'd like to add our DTS packages to sourcesafe. We've figured out we can do this by saving the package as a VB or Structured storage file. Our problem is how to recreate the packages from the files when we want to amend them in DTS Designer. Any ideas? Many Thanks, Paulie :)...more >>

I wish to import data from Excel File in SQL SERVER Table towards DTS Task. At the time of the importation I want to recover the data which could not be to import in a table of exception. Does anyone know how could i proceed. Thanks...more >>

Hello, How are you today? I wish to carry out the following: 1. Periodocally Import data from a csv file into a temp table. 2. Clean the data (which mainly would involve identifying values not present in a lookup table and cleaning Postal Code info.) 3. Report any errors found so these c...more >>