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 >>

The DTS service fetch 3 rows from a CSV file and insert to the tblTemp table. and in tblTemp there is a trigger which performs insert them to the tblMain. when I insert a row direct to the tblTemp the trigger works ok. but unfortunately when the DTS works the trigger is not working. Thi...more >>

Hello and Merry Christmas to all, I would like to execute a DTS from my ASP.NET web page written VB.NET. How can I do this? I have the following: Imports DTS.PackageClass Dim oDTS As New DTS.Package Try oDTS.LoadFromSQLServer(m_ServerName, m_UserName, m_Password , DTS.DTSSQLServe...more >>

I have a DTS package that has a scheduled job. It has been running fine for over 2 years now. I can execute the package on its own, but now the scheduled job creates this error: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSSt...more >>

I created a package that performs several data pump tasks loading data from a workbook to SQL Server tables. I have to run this package on several different servers and several different databases on each server. The data may be different for each database but the schema is the same. ...more >>

I have created a custom task in VB6 that captures error data and calls an error logging package. I have successfully registered the .DLL using regsvr32. I have successfully registered the task in DTS. The designer properties form works fine. The task executes properly when I run the ...more >>

Dear NGroup, I want my package to wait for certain files to show up in the folder before it could start executing the data transfer?? I have large number of sources (more than 150 or so) sending their data to me. My job is to absorb all the data from these sources into my DB. The tran...more >>

My company just got bought and I need to start exporting data daily from our SQL 2000 server to a comma delimitted text file. Is the following scenerio possible: *Export header infomration for one order (such as order, date, ship to) *then add a carriage return to leave a blank space....more >>

We are in a windows workgroup environment. No active directory. Therefore no domains. (netware network) I tried to use SQL server Copy database wizard to copy a database to a developer sql server, it failed and I checked the log find two error: 1. transfer login SQLserverPC\Administrator ...more >>

If i call a DTS from a VB program, is it possible to get a return code from it much the same as you would from calling a function ?...more >>

Does anyone know of any current ADO/RDS issues that could cause a connection to the database to fail? Any conflicts or problems with newer patches/service packs/updates? I have an application that has connectivity problems intermittently. It clears itself up after 3-5 minutes. The issue can...more >>

We have an existing database (dbFoo), with tables full of data. We'd like to create a new database (dbFoo2) with the tables minus the data, i.e. structure but no content. Help!...more >>

Anyone know of any good reference books on DTS and DTS Scripting? I've looked at the Microsoft Press book and it seemed kinda weak, and BOL is good, but seems to assume I'd already know what to do (which I will, at some point), but I'm, dare I say it, a newbie in the realm of DTS scriptin...more >>

Hi I created a simple stored procedure CREATE PROCEDURE testproc (@p1 int,@p2 int,@p3 int) AS BEGIN SET @P1=10+@P1 PRINT @P1 END Now In my DTS Pkg I have Execute SQL Task which has the following statment EXEC testproc ?,?,? And my parameter1 is assigned to p1 which is a global vari...more >>

Hi I have a XML Sheet , I need to load that data to SQL Table Thro DTS How do I do it ? In future release? Is microsoft planning a Direct connection to XML ? Thanks in Advance Sunny...more >>

The ActiveX Scripting support for my SQL Server has disappeared. If I open ActiveX Scripts in a DTS the code is gone and the function, etc for vbscript or whatever language was in that scripting windows are also gone. In the datapumps where ActiveX Scripts are used they are replaced by the...more >>

do you know where can i find more about ActiveX scripting? what is ActiveX scripting and where can be used? TIA ...more >>

Hello, Can some one help me to export all the tables and views, with the name of the columns, to txt file with the name of the table or view. NOTE I use bcp but it does not copy the columns names. ...more >>

First I read all the info on the newsgroup re: DTS Ownership and did not find the answer to the following question. How do I control what information is put into the Owner field for the DTS Package. Currently it is putting the local_machine_name\local_user_id in this column. This information i...more >>

Hi all, I am getting the following error from sqlagent log. My DTS package which was running fine so far for the past 6 months and at present generating an error saying the step did't provided any output. Please help me out what to do [000] Password verification of the 'SQLAgentCmdExec' ...more >>

I have a simple job that is giving me errors. Step (1) is selecting records and outputting the data to a .txt file. Step (2) is executing a SendMail DTS package that is supposed to email the .txt file to (3) known/working email addresses. My problem is that step 1 executes fine. Step 2 k...more >>

OK, I have SQL server 7 installed and have ScriptPkg. I've tweaked the source to point to the local server. When I run it and try to get it to convert the DTS job, it just gives me back the error: Unables to load WFLoadSick. Error: Unspecified error WFLoadSick is the name of the DTS job that...more >>

I have a job, with 2 simple steps. Step 1 is a select statement, which outputs data to a .txt file, this step works fine. The second step, I have a DTS SendMail package. I'm sending it to a known working email address, with the .txt attachment. I keep getting the error message below. I ap...more >>