• Enabling Profiles on AS/400 machine

    I have an IBM model 600 which has not been off for about 4 years. When I tried to bring it up, I had a fan assembly that was bad, replace the fan assemble. Then I had a bad disk drive, replaced disk drive. Now when I try to start the machine I get "disk drive missing from the configuration", I then...

    rhicksjhicks5 pointsBadges:
  • Tool for migrating DTS to SSIS

    What is the tool for migrating DTS to SSIS. And how effective it works. And I want migrate 500 DTS packages to SSIS. How much time it will take?

    Lingala5 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?

    JimmyIT1,725 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 pointsBadges:
  • Troubleshooting a DTS job failure on SQL Server

    I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Insert and update DB2 from SQL Server 2000 using OLEDB

    I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but...

    Sandy555 pointsBadges:
  • Error copying indexes in DTS package

    I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a...

    Bleeb45 pointsBadges:
  • Transform Data task properties not opening.

    In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

    Sinto5 pointsBadges:
  • Converting data to SQL Server data with the DTS wizard

    I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records. When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type "money" was not correctly transferred. For an example, the value...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • dtexec scripts just deleting data

    since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the import\export wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don't understand what this...

    John t5 pointsBadges:
  • How to move a DTS from sql 7 to a server running sql 2005?

    I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

    Bubbanm90 pointsBadges:
  • DTS of TEXT to BLOB or CLOB

    Is there a maximum size to DTS from text to a Blob or clob ?

    Donranny5 pointsBadges:
  • DTS Package Schedule runs only once, Status shows executing

    Hi, I have set up a DTS Package and schedule it to run every 2 minutes (to prove it will run regularly). Unfortunately the package only runs once. The process only takes a few seconds. The job status shows "Executing Job Step '1 DTS Package1'" Is there something I'm missing? Gabs

    Gabs15 pointsBadges:
  • Copying DTS packages from SQL Server 2000 to SQL Server 2005

    I am in the process of migrating from SQL Server 2000 to SQL Server 2005. We have several hundred DTS packages. Converting to SSIS will take many months, so we are planning to run the DTS packages under 2005. Is there an easy way, or a utility, to copy the DTS packages from one server to another?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using DTS objects for scripts to alter SQL Server password

    Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Scheduling a DTS Package

    Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

    Pmwhelan5 pointsBadges:
  • Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005

    I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DTS schedule package

    How can I see the scheduled run time of an existing DTS package?

    Hoverman5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.