Hello all! I am experiencing some performance problems when using Sybase Adaptive Server Anywhere with DTS. I am finding it 2-3 times slower in some cases. Here is some background: I am designing an application that will use DTS to move data between 2 databases. These two databases ar...more >>

Hello and Happy New Year! Has anyone out there successfully used the Adaptive Server Anywhere Provider 8.0 as a DTS Connection? I can get a connection via ODBC, but cannot seem to get one to work by using Sybase's provider (called ASAProv). I *thought* this would have been easy but I am f...more >>

Has anyone came across a condition in which the destination definitions for a file export package disappear when SQL Server SP3a has been applied to a Client SQL Server 2000 Personal Edition ? When the same package is viewed directly on the Server (W2K OS SP4 and SQL Server 2000 SP3a) ever...more >>

is it possible to export blob data from a database using the DTS. I have a table with two relatively small blob fields. I would like to export these using the dts and have then be saved as an external file. Is this possible?...more >>

From an excecute sql task I am placing the result into a global variable rowset. I then assign the global variable rowset to a adodb.recordset and want to loop through it and after checking further conditions require to delete the row if applicable. I will then be passing the remaining reco...more >>

I have a dts package in sql 2k that populates 5 worksheets in one excel file. I want to be able to attach the excel file to my email task and send it, but ONLY after all 5 worksheet tasks are complete. How can I do this? Thanks in advance... MIke ...more >>

Hello. I have a client who connects to our network and I want the client to be able run DTS package without SQL Server on his computer. Is it possible ? Happy New Year to everyone. ...more >>

I was thrown into admin for the SQL boxes here and had to move a database from onw box to another. Now I thought I had everything moved but I missed a DTS. I have the source and destination created, but what I need is the syntax for updating. What I am trying to do is create a DTS that ...more >>

note: I posted under Uri's thread too... Sorry, should've just posted here... Hey Allan, How 'bout some help with this one? Runs fine when I run manually from EM. When I schedule the job and assign it the svcSQL account it fails... What has me baffled is that it processes the datapum...more >>

I am using the following line to export data from SQL Server to a text file. This has been running without any problem for a couple of months. We had to reset the server the other day and since then the BCP fails with the error below any idea Command Used: SET @Qry = 'SELECT LineValue FROM myD...more >>

I am new to sql server. In oracle, one can export a binary file of the contents from one database and import it into another. Is there a similar utility program in sql server that can accomplish this type of task? If so, could anyone post some reference links for me follow up? Thanks! ...more >>

I have the stored procedure where i am accepting the date as input parameter for the previous month and current month. The stored Procedure is as follows : CREATE proc spDataTransfer_Monthly(@PrevStartDate char (20),@PrevEndDate char (20),@CurrStartDate char (20),@CurrEndDate char (20...more >>

Hi I have a DTS in which one of the steps runs a query to return a recordset. According to SQL Books Online you have to save this result rowset variable into a global variable of type <other>. However, when I declare a global variable of type "<other>", which displays "variant" afterwards I ge...more >>

hi..all i'm new in DTS...:( lots to catch up by my own... now..i'm facing problem when i wanna multiply values from 2 columns in same table in oracle database and save the result to the new table in SQL server..one of the column is NUMBER(20,0) and the other is NUMBER(5,0). I have creat...more >>

Hi All Iam using the DTS to transfer the tables from Sybase to Sql Server. = It is Running fine. But i have wnat to pass the connection to sybase = and Sql through the log. Because i don't want ot hardcode the = connections . Plz any body help me in passing the connection through the = lo...more >>

When I run a DTS Parent package from Enterprise Manager the DTS Child packages fail with this error: The execution of the following DTS Package failed: Error Source: Microsoft Data Transformation Services (DTS) Package Error Description:Execution was canceled by user. Error code: 80040427...more >>

I'm using a script that imports data from a csv file into SqlServer. When I run it on my machine and connect to server A, everything is imported correctly; however, when I run it on another machine and connect to server B, the rows are not in order anymore. Order is important! Is the issue w...more >>

I am loading from a flat file into a temp table. I have a text file connection and an OLE connection. I would like to be able to use a variable for the file name, then insert that file name into a column in my temp table. How can I do this with DTS?...more >>

I have a requirements to create different filename, everytime the export process runs. One requirement of concatenating date stamp is simple. I simply used DynamicProperties Task and this is working fine. Now, I also have to name file based on the option to be selected at run time. I am using global...more >>

I am trying to run a SQL script to select from tables in 2 differenct databases within an ActiveX script. I am having trouble with the connection settings. Anyone help. PS I was trying to perform this from within an Execute SQL task but I need to pass a parameter to a sub-query within the...more >>

I've created DTS script that out puts customer information to a excel spread sheet on a nightly basis. The file is then moved to another server for client use. The script runs find a creates the required excel document. But when the script is run as a job through SQL server agent the job fails with...more >>

Why are sysdts... tables not listed on any SQL Server 2000 System Table Map? Where can I find out information about the join properties and descriptions of these tables Thank you!...more >>

Hello: In a DTS package I have created, there is a copy database task. The package is failing with the following error: Microsoft SQL-DMO (ODBC SQLState: 42000) [Microsoft][ODBC SQL Server Driver][SQL Server]User or role 'NETTRANSIT' does not exist in this database. I'm assuming that ...more >>

I'm trying to use the T-SQL OLE Automation SPs to write SPs that dynamically create DTS packages. Everything works fine until I get to the connections.add method. The add method fails, and sp_OAGeterrorinfo doesn't return anything. EXEC @hr = sp_OACreate 'DTS.Package', @oPKG OUT EXEC @hr = sp...more >>

Hi I'm passing the following SQL statement to my SQLServer: RESTORE DATABASE myDB FROM DISK 'd:\mssql\backup2\myDB.bak' WITH MOVE 'myDB' TO 'd:\mssql\data\myDB.mdf', MOVE 'myDB_log' TO 'd:\mssql\data\myDB_log.ldf' However, when I run this, I get the following error: Server: Msg 3234, ...more >>

Hello, I have to export some data from SQL Server into a flat file (simple). However, the data will be exported based on date and document type (to be provided by the user at runtime). Based on some study done so far, I can define VB controls in ActiveX script and can also use global ...more >>

Hell Any idea how to get SQL server data in to Oracle(Unix based) database Any help is appreciate Thanks...more >>

I need to import a table every 6 minutes into SQL from an Access Database. I currently (Thru DTS): Drop the table Create the table Import the entire table every 6 minutes. Is there a way I could just import the new entries from the access table? There is an autonumber field in the access ...more >>

I have a dts package that does the following 1)Creates a table after deleting it if it exists 2)sucks data into that table using a transform data task 3)renames the table using the current date as part of the file name At times, the package locks up SQL server and shows that it is in spin ...more >>

Hi, As part of the deployment of our product we install our DB with all tables, stored procedures etc. For this we have a separate install project in VS.NET. Our DB, or better say, our development SQL Server 2000 contains also a number of DTS packages that are involved from within C#. However ...more >>

Hi, I am refreshing all the pivot tables in an excel spreadsheet with an activex script from the server. It works fine but when I open the .xls file, the file is hidden. I have to go into windows, unhide in excel and unhide it. This is the activex script I am using Function Main() dim xl...more >>

Are there any patches for DTS. I am running SQL2000 service pack 3. I try a export about 50 columns with 9 nine joins to a text file from SQL tables in DTS designer When I go to the connection arrow; properties; destination tab to define my cloumns- when the define columns button i...more >>

I'm creating a query to copy certain data from one DB to another. When I create the query and show the results - it works fine in the DTS package edit section. But when I close the Query creation window - the software puts some carriage returns (or something) in the middle of my criteria...more >>

I'm trying to migrate DTS Packages from our Development environment up to Test and then Production. The goal is a one-click solution for the person doing the deployment, at the expense of [limited] extra work by the developer (me). I thought I had the answer in saving the package as a VB ...more >>

Hi, I have a task to perform that will export data from a single table and create a .csv file. Not a problem I hear - thing is 1 of the columns has HTML code within a product description. However the .csv export requires that this HTML code is stripped. Is it possible to achieve this throug...more >>

Hi I'm picking up where a coder left off. I've got to modify a dts package. When I look at the job scheduler, it has one step. In the step it has the command under the General Tab like this DTSRun /~Z0x3E2E704F212E29DDC0F6931......... My question is, how do I figure out what the above c...more >>

Hi I am using an application (Robocopy) to copy a series of database back-ups (*.bak) from one machine to another. What I then want to do is to go through the folder containing these back-up files and restore databases from them. However, I don't know in advance the names of the files, bu...more >>

We have several DTS packages set up to move file data from a Cobol/Unix environment through Liant's Relativity ODBC into SQL Server. Our process fails often with a message EXCEPTION_ACCESS_VIOLATION, but not always at the same time or on the same table so there is nothing consistant to identify a p...more >>

Here is a breif description of my situation: I have a table called UserGroup with three columns: Action (ADD or DEL) UserID Associated Group I also have a component that adds or deletes users from Active Directory based on Action Code. Can I call this componnent from within a DTS...more >>

Hi I have set an excel spreadsheet with sheet1. It has 3 columns week, return_qty and ship_qty. This data I am getting it from a sqlserver database. Next to it are a bunch of columns that are calculated. I would like to refresh (clear and update with the new data) this sheet once a week from t...more >>

Hi, Having created multiple packages for a similar function, I wanted to group them together in the same job.... When I created a meta package to call the sub-packages, I found an error in one of the sub-packages failed to propogate up to the job, and was not made aware of the problem until...more >>

I have a table with all the header information for an order. All that is not included in this table is information pertaiining to order lines of the order. The tables are relational so the header table has all numbers in it. I need to export this information for a non relational databas...more >>

I have a dts package created through a wizard exporting about 50 columns of data to a text file. I am using a query as my source. The query pulls 2 records in SQL Analyzer. When sucessfully completing the export the text file is empty. I then tried exporting to excel and the 2 record...more >>

Is there any way to expand the default buffer size so that I can import an Excel 2002 spreadsheet with very large cells (500+ bytes) into a SQL Server 2000 table? I've tried importing from Enterprise Manager as well as using DTS to import. Both get the same message saying "data for sourc...more >>

Hi, all! When I'm trying to import data from Excel using DTS object in VB one of the params specified are: oCustomTask1.SourceSQLStatement = "select `F1` from `'Sheet1$'`" What is F1? Actually what I need is to specify a range of cells in the Excel to import into SQL tables. This could be a ...more >>

Dear all, I have one DTS for order downloading from web to unix. the dts runs for every 5 min. In the dts it creates 4 files. after 2 min of the scheduled time one cron runs at unix server and it takes the output files. the dts should not take more than 1 min to run. But daily atleast 2/3 times i...more >>

Hi, I have dumped a very large database from mysql (using mysqldump program) as a raw sql file. The reason was, convert this database to a MSSQL database. Since mysqldump creates the file as raw sql file with the database-table structures and the data in it, I thought using OSQL command li...more >>

Dear all I want to know if sql server 2000 supports 2-bytes language, say Chinese? I have an Excel file with Chinese characters in it, after imported into sql server table using dts, all Chinese become question mark(?). How should I do? -- Best regards, Richard ...more >>

HI all, I am trying to migrate a database from mysql to mssql2k. I use myODBC to connect to mysql server to pull the database from DTS and insert in to sql server. But in mysql server, there is one huge table. Size of it is 1.3 GB and more than 12 million rows. While I try with DTS, i...more >>

Hi all I have a table in sql server 2000 with an image column,whose type is Binary.How can I export it to ORACLE correctly....more >>