Somebody use ActiveX Script Reusable. Please tell me how do it. Thanks everyone. ...more >>

I've been reading post for about two days now, however I have not been able to find the solution. Issue: Dynamically create source and destination columns for DTS Transformations. I have a package that creates an Excel Workbook, and pushes data to each sheet. This issue is that when the...more >>

Hi, I develop a VB .NET application to call DTS COM to import text files into SQL Server 2000 EE SP4. We need import more than 60 files by a loop. When I tested in IDE sometimes it finished all files import successfully, sometime it hang random at some file and at oConnection = goPackage...more >>

Hi I'm having problems on create a loop package with dynamic data sources. I have 36 databases do connect and I want to create a loop to connect one by one and get the data (btw, all the 36 databases have the same structure). In the DTS I did this using "Dynamic Properties" component to c...more >>

Hi all, A developer deleted one of his DTS packages from a DEV server. Unfortunately we only backup DEV weekly and his creation and deletion happened between Backups. I see the job name in sysdtspackages, and there is a column called packagedata. Is there a way to restore the DTS packa...more >>

I have a DTS pacakge and am creating an excel file using an activeX task. That piece works fine. I am then using a number of data pump tasks to move the results of queries into the excel file. The data is moving into the file just fine, but it is not starting where I would expect it to. Th...more >>

When I open the DTS designer, I am getting the erro say "The extended attributes are not inconsistent". Can anybody help me out to resolve the issue, which i have mentioned over here. Thanks in advance, Belton...more >>

The purpose of using this custom task was to extract 100+ tables to text files for our data warehouse project; one table corresponds to one text file. How to do it with error handling? ...more >>

We have a schedule that was written in Excel. It tracks all of our direct card employees (250 +), they use Comments religously to note changes, call-ins, etc. Using DTS, How can I pull these comments into the SQL Server? Thanks! Drew Laing ...more >>

Using a DTS package, I want to use a global variable to concatinate a string for a table name I want to query. I then want to use the results as my source for a data transfer task. I'm trying to use something like.... declare @temp_id varchar(3) declare @qry varchar(3000) set @temp_id =...more >>

Can the installation and uninstallation/deletion of a DTS package be scripted? I want to include it as part of an automatic installation wizard. Thanks -- McGeeky http://mcgeeky.blogspot.com ...more >>

I am bringing in AS400 data into SQL. I found some data missing " hour:minute:second (AM or PM) " information. This data field is "smalldatetime." For example, 10/3/2005 12:00:00 PM 10/3/2005 12:00:00 PM 10/3/2005 12:00:00 PM 10/3/2005 10/3/2005 12:00:00 PM 10/3/2005 12:00:00 PM Any...more >>

I'm creating a DTS package which creates a temp table, insert some records in the temp table, export those records to an excel file and finally drop the table.. Everything is fine except the excel file: - 1. I am unable to do select statement against the temp table (from ActiveX Script). But ...more >>

I transform data from a DB2 table to a SQL tabel. The date format in the DB2 is in decimal 10 chr (and we need in taht format since a report generator uses that format). But I want to replicate data that is Today-10 days so my string is: select * from mvxbdtm.meslog where meslog.locono=1 an...more >>

Do you know how to execute DTS package in Store Procedure? -- shooi...more >>

I am wondering whether Trimming Varchar data is good for the space issue in database or overload (bad) for the I/O? Any suggestion? ...more >>

I am creating a DTS package in SQL 2000 with SP3. (Same issue in SP4) This package has one "Execute SQL task". The task calls a stored procedure which takes parameters. Using parameter mapping, I try to map the global variables already defined to the parameters for my procedure. No problems ...more >>

Hi, I am running a DTS package on the local SQL Server DB to insert data from an SQL Server table (remote DB) into an Oracle table (remote DB). The Oracle and SQL Server DBs are on different machines. During this process the special character (with a dash over 'e', ascii: 138) is getting ch...more >>

I have an activeX task that I am using and trying to write out to an Excel file. I run the task, and if I go into the file right away, it will say that another process still has it open and I can see that my values have been written to the file. If I close it and reopen it, the file is empty...more >>

Hi, I am using DTS to import an Excel spreadsheet into a Sql database table, but I am having trouble with one column. The table does not allow for any nulls, all data must be imported. Most of the time the column is alphanumeric, but occasionally it is numeric. I tried using "Copy Column"...more >>

Hi, I have a DTS package. When I run it from a DOS prompt as following, c:>dtsrun /S sql_server /U userid /P pwd /N dts_package_name Eveything is fine. I can see something like log messages output from the command. Then if I redirect output into a file like and run it again, c:>dtsrun /S...more >>

I am importing a csv file into my SQL server 2000 DB using DTS. Is there a way that I can have the file deleted or emptied after the import is complete. Thanks...more >>

Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why.....more >>

Hello, i use a CTP of Integration Services 2005 at the moment, to test one of our ole-db providers. This provider works almost perfectly in DTS within SQL-Server 2000, but if i try to create a named query in integration services, i get an error, that my provider-string doesn´t match the ole-d...more >>

Hi: I trying to import data using DTS. The foreign key contraints are firing because data is being inserted into child tables before parent. When importing data, is there a way to turn the foreign key contraints off? This is big database, so it's not practical turn each off individually. ...more >>

I'm just learning about DTS Packages in my SQL Server Admin class, so please "dumb down" any responses :-D I'm experimenting with them at work hoping they will be very useful. From a Fixed-Width text file I'm trying to import a date field in the format of "yyyyMMdd" into a field formatted ...more >>

Hi My company has a small server cupboard and we have been having troubles with the air con unit that we have in the cupboard, the cupboard goes from nice and cool (21.5d/c) to very warm (30.0d/c) which as you can tell is a big problem. Does anyone have an idea for further vertilation, v...more >>

Hi, When I Try to run my DTS Package I get the error: "Error string: This version of the current DTSPackage is frozen in the Repository. Its Lineage cannot be written or removed." Any ideas on what is happening? Thanks a Lot ...more >>

I am trying to import a table into SQL server 2000 from Progress 9. I am getting an error when trying to execute the SQL statement in the DTS wizard. The error is: Table/View/Synonym not found (7519) Context: Error calling Prepare on command text I have gone through the progress knowledge ...more >>

Dear friends I have one question... I am trying to create a DTS or may be I can also create a job to be scheduled to append a table from an Excel Sheet available somewhere in the internet, for instance the client has given me an URL like http://###.##.##.##/something/excel.xls and I need to...more >>

Hi everyone, Can someone tell me how to design my DTS to import Reference Tables (those with Primary Keys) to run in parallel. Since each Ref. table is independent of each other, i figured that it's much more efficient to import them in parallel as appose to sequential. However, the question ...more >>

I have a completed DTS package in my SQL server. The examples talk about creating and executing a DTS from VB, but no connection information is ever provided. I just want to execute the already existing package, not create another. I would REALLY like to execute the package, that’s alread...more >>

Hello Gurus, Looking for help on a problem which i need to resolve immediatly..Any help is appreciated .. Sorry if this post is too long..Trying to put as much info I can. I have created a DTS package to export some data from SQL Server to an EXCEL file. The problem I face is that the DE...more >>

[SQL2000 Windows 2003 ] I have a package that exports a bunch of data files. For some reason, while I am in the DTS Designer, the package executes correctly - in that it creates files in the specified directory. However, if I run the same package from DTSRunUI, it appears to run fine, but t...more >>

How is it possible to run a job on the 1st and 15th of every month? thanks -doug-...more >>

Hello, I am trying to use DTS to download certain columns from a table into a text file. Currently, the package runs once per day and I am able to download the whole table into a text file. However, I only need certain columns of the original table. I see that the functioanlloty is ther...more >>

OK. I do realize this has been covered before for transforming from table to table. But in my case, I am parsing a text file and importing into SQL Server. I need to do this load repetitively with updated text files. Obviously, many rows in the file will NOT be new and just need to be update...more >>

Hi, I created a DTS package to do some ETL task between 2 SQL servers. I want to move this package to do a similar ETL task between another set of databases (the names of the databases are different however the table names are the same .. test and production databases) on another server. I foun...more >>

Hi All, Suddenly I am not able to run any DTS packages through my schedule jobs. I can run the jobs that does not have DTS package but if the job is DTS package I cannot run. I can go to DTS and execute the package and it works fine. Something is out of sink. I have been trying for over a w...more >>

Hi All, Suddenly I am not able to run any DTS packages through my schedule jobs. I can run the jobs that does not have DTS package but if the job is DTS package I cannot run. I can go to DTS and execute the package and it works fine. Something is out of sink. I have been trying for over a w...more >>

I am currently using SQL Server 2000 (sp3), I have created a DTS package which imports data from a Unix server, this works fine when I execute the package manually. The problem lies when I schedule the package to run automatically, it runs the DTS package but returns no data in the imported ...more >>

I am using sql query as the source of a Data Driven Query Task. I want to generate this query in an activex script task and set. but i couldn't find this property of the object. thanks ...more >>

Hi, I have created a DTS to import a set of data from excel to SQL table. The date format in excel is dd/mm/yyyy HH:mm tt. I want to change to date format in SQL to mm/dd/yyyy. May I know how to change. I tried to use the date time string transformation properties in dts but not successf...more >>

I want to run a DTS package and then a Stored Procedure in which i have to pass tw0 Parameters... How can i do this..?? separately i can run the DTS and Exec the Proc ...but how can we do this in one command or single click of a mouse.... any one can come up with a good solution for this... usi...more >>

I know how to download files from the internet via DTS but wish to know if it is possible to upload them as well. I have SQL Server Personal edition and I wish to automate a job that creates an Excel file then uploads it to a directory on my personal webspace with NTL World. I have a pac...more >>

I have a table with 3 TEXT fields. DTS doesn't seem to want to load into TEXT fields, as I get an error from DTS when trying to do this. Is there a way around this? For now, I use DTS to load into VARCHAR fields, then I do an ALTER statement to change to TEXT. Is that the best way to do th...more >>

Hi All, Is it possible to Append SQL data to a text or CSV fiel. In geeral case the data is replaced with new data and old data is lost. I am using Data pumping task for this. thanks ...more >>