Hi all, I've seen this noted in many posts, but nothing I've checked out gives me any clue on how to do this. Basically as my topic says, I have a DTS and I simply need to export some data from a table in MS SQL 2000 to an Excel spreadsheet. I also need to automate this process so it can r...more >>

I'm just trying to get an overview of the new "DTS" of SQL Server 2005. I've tried to convert an old DTS 2000 package to SSIS Package. The package simply consist of a transformation from one file to another. The transformation has a Workflow ActiveX script task which says Main=DTSStepScriptR...more >>

I have a job set up to execute a local package automatically daily at a scheduled time. After the job fires, the status indicates it ran successfully but when you verify what it was supposed to do, it shows nothing happened. The job history step details show: Executed as user: (domain)\(a...more >>

I have an input file with date & time data in this format: yy mm dd hhmm.......... 99 12 7 1400 In an ActiveX script, I convert this to be mm/dd/yy hh:mm, and have tried using CDate() and FormatDateTime(), and when I use a MsgBox to display the value, it displays similar to '12/7/1999 2:...more >>

I want to import a text file into a table in SQL2000, this funcyion in SQL but in VB does not run and does not put any error message. Can anyone help me? Manuel...more >>

Hi there all, I'm trying to insert a number of rows into a table using the results of a sub-query to populate them. They're both on the same connection. When I parse this, it's fine. When I execute it, I get this message: "Error Source : Microsoft OLE DB Provider for SQL Server' Error D...more >>

I'm trying to change the datasource for a dts package inside of a loop. I've created a dyanmic proprety that is housed inside the looping steps that has the datasource = value of a global variable. In the workflow active x for the dynamic properties i add a msgbox(DTSGlobalVariables("CurrentDSN...more >>

Hello, I am trying to unzip zip files using DTS... Our file were compressed by using winzip software...If i use WZUNZIP then i am able to unzip file properly.But if i use PKUNZIP my unzip file name is being truncated.. i.e if i have abcdefghijk.zip file then after unzipping it becomes abc.z...more >>

Hello, I need to save DTS packages on other machine and other MS SQL server. Therefore at first I saved the DTS package like Structure Storage Files. Then I gave these files on the other machine and I wanted to open the .dts files there via the option Sql Server Enterprise Manager/Data Tr...more >>

Hi, I created dts package that basicaly copy data from query to text file and in next step removes this data from DB. Kind of backup to file dts. To make each backup file unique I used Dynamic Property Task with sql query that returns name of file based on date. Everything runs fine from d...more >>

Hi, I would like to use the FileSystemObject in ActiveX Script Task as in Visual Basic 6. But I think that the syntax is slightly different. Can someone advise me how to do the declaration of the object and the program syntax in ActiveX Script Task? Thanks in advance. Ivan ...more >>

Hi, I`ve studied the SendMailTask that comes with VS.NET 2005 available in integration services. I have startet on my own component inheriting from SqlServer.Dts.Runtime.Task + implementing some interfaces (ie. IDTSComponentPersist) . But in the lack of information I am stuck :-( Where c...more >>

Hello, i want to get data from a table, but only the data that is specified (dynamically) with a filter that is stored in a local table. SQL-Statement SELECT * FROM external_table1 INNER JOIN internal_table2 ON table1.datafield1 = table2.datafield2 How do I get this in my dts-package if i...more >>

Can step debug be done on an ActiveX code used in a package fron Visual Studio 2003 ? What file type advised for the code ? (e.g. *.vbs or *.vb or other). I expected that I could compile and step into the code from VS 2003 environment. All it does is compile and never breaks at a breakp...more >>

Hi! I am runnig a job which executes a DTS pkg name "TMP" which is stored as dts file in the C drive of server. declare @dtsrun varchar(1000) set @dtsrun = 'dtsrun /F d:\CM_DTS\TMP.dts /N TMP /E /AServerName:8=' set @dtsrun = @dtsrun + @@servername exec master.dbo.xp_cmdshell @dtsrun ...more >>

Is there a way to execute the DTS packages from ASP.NET (preferably asynchronously) ? what kind of permission should I give the web user ? from all those packages there I want to only list some them ,how should I control this? Thanks ...more >>

I have 2 tables DistinctVend and NonRefvend. Both of them have the VendorID column. The DistinctVend has 25000 records The NonRefvend table has 26000 records. I want to run a query that will select only the records from NonRefVend table where the Vendorid is also in the DistinctVend tab...more >>

Folks I am trying to setup an MS SQL server 2005 DTS package to import data from an As400 DB2 server. I have the choice between 3 different (managed ?) providers IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider IBM DB2 UDB for iSeries IBMDARLA OLE DB Provider IBM DB2 UDB for iSeries IBMD...more >>

After uninstalling SQL2005 from my server, which already has an instance of SQL2000 running sp4, I have problem with adding Send Mail Task into my package. The error is: Cannot load MAPI interface layer. Please make sure that semmap90.dll is installed. I think that dll is installed by SQL2...more >>

Hi, I'm making a datawarehouse, and I wrote DTS packages which includes several SQL execution tasks ; each of them include many SQL commands (insert, delete and update commands). There can be, let's say, between 10 and 40 SQL commands in a single task. The problem is, if one of these com...more >>

Hello, I have a connection object created called "connection 2" that connects with the user name and password to the proper database. I am tring to do the following: set objCnn = DTSGlobalVariables.Parent.Connections("Connection 2") Set objADORS = CreateObject("ADODB.Record...more >>

Dear all, We've created an specific user with Sysadmin role and after that, with that same user we build a DTS but once saved in the server, appeared as 'owner' the NT user. What's happening? Any help will be welcomed. Thanks in advance and regars,...more >>

Hi all, Is it possible to change the owner of a DTS package? The reason I ask is that I am trying to tighten security on our SQL Servers and have a problem with DTS. Our developers have a development SQL Server (2000) that they construct their DTS packages on. They then email the DBA (m...more >>

I have DTS package, which loads data from SQL Stored Proc into text file via Transformation task. How can I insert title as a first record in the text file? Thanks, Ilin -- Message posted via http://www.sqlmonster.com...more >>

I have a DTS job that is giving me fits wehn run from a scheduled job. Access denied to server. The DTS runs fine if executed directly, so I don't believe it's the connection in DTS (using SA account on both SQL Servers), the job fails on the first step which is the connection to the other serv...more >>

I'm considering using DTS packages for certain database tasks. I have a policy that most if not all database activity must use database code (stored procs, functions, etc). Currently, schema changes can be easily associated with code by searching Visual Source Safe files for anything that's ...more >>

Is it possible to running cursor query in Execute SQl Task? My Cursor query is simple, just disable all constraint in all tables at a database : declare @tablename varchar(30), @str varchar(80) declare c1 cursor for select name from sysobjects where type = 'U' open c1 fetch next ...more >>

Hi, I want to have your feedback on how to configure my drives to insure a good performance during loading process & transformation against a staging database. Image you have 4 drives available for the staging database & tempdb database... loosing these disk is not important, so no redu...more >>

Dear all, I am not sure if I am at the right place for my question. I have a SQL server table, I have to set the schedule (every morning at 8:00 a.m.) that the data from this table is automatically transferred to a specified Excel file. I know that there is an "Excel Connection" in DTS pac...more >>

Hi, I am still new to DTS and can't figure out how to do this. I have a two tables, Game and Game Detail joined by Game_ID, I need to set up a DTS package where I can export to different text files the Game Detail information for each game in the Game table. Each Text file will be the Game ...more >>

Hi I have a Platinum database which stores dates in integar form e.g the date is formatted as below: Column_name Type Length Precision ------------------------------ ------------------------------ from_date int ...more >>

Hello: I have the following table: CREATE TABLE LANGUAGE ( Language_ID_N smallint IDENTITY(1,1), Culture_Name_C varchar(20) NOT NULL, Culture_ID_C varchar(20) NULL, ISO_Language_CD_C varchar(3) NULL, Language_Country_Region_C varc...more >>

Hello, I've just discovered DTS and I'm very glad I did because I need to do some serious data transformation tricks! I realise that I will need to write some ActiveX scripts to convert my data, however, I am completely new to DTS and my VBScripting skills are limited. I've used PHP for ...more >>

Hello I need to define a user of SQL Server 2000 that could run jobs. At present time I succeeded only in the case that the user has rights of system administrator (in Enterprise Manager in Logins I click right on the user and in Properties/Server Roles I check box System administrator). B...more >>

I'm importing a text file into SQL table using DTS. The file(s) sometimes have formatting anomalies that are benign to me but DTS sees them and throws an error - and doesn't store anything into the DB. The file is comma-delimited and there are no errors in that area. The error appears when th...more >>

I would like to create a job from enterprise manager with 3 steps, each step execute a DTS package by order. Can I do that? Any help will be appreciated....more >>

I have DTS packages. I run them from a C#program. DTS packages run a query and exports results as txt files. I want to send export file name dynamically from my program. Is it possible?...more >>

Hi, I have a DTS package that will implemented on several network configurations and would like to use a 'path variable' to replace the string that is entered when defining the error text file. (depending on the implementation I am directed by the DBA or network admin to use specific locati...more >>

We use the DTS Transfer Database task to blast our live database to a standby server at regular intervals. The TD task is a monolithic task which transfers a complete database. Thus, as the database changes its structure, the TD task continues to work perfectly. It simply transfers the entire ...more >>

Hello there, I have a statement running in DTS. SELECT COALESCE( MAX(colID ), 0 ) AS LastID FROM TableName Output of this row is stored in Global variables; on successfully completion of this step; the next step a transformation task defined as select * From TableName where colId > ...more >>

Can anyone tell me how, I can execute a stored procedure in a DTS and depending on the output parameter execute the rest of the stored procedure or else write to a log file? ...more >>

I have to create a dts package which moves data for some tables from Server A to Server B and C. There is a flag in Server A in some lookup table which indicates whether Server B is available or not. Similarly there is a availability flag for Server C stored in Server A. Data should be moved fro...more >>

I am having problem with .DAT file. iwant to upload it to sql server. Do i need to choose Text type ? any help.. ...more >>

For SP3a and below, we have been installing the following files on a workstation to allow a user to run DTS packages without installing all the SQL tools: DTSRUN.exe dtsrun.rll axscphst.dll axscphst.rll custtask.dll custtask.rll dtsffile.dll dtsffile.rll dtspkg....more >>

What is the best way to save a DTS Package. I don't seem to be able to modify any of the different types, such as if you save it as a "SQL Server", how do you modify it? Then I saved it as a SQL file, a dts file, but now how do I open it so I can modify it? I would really like to save t...more >>

If I want to use DTS export table to Oracle from SQL Server, what all drivers I need. One is I believe MS ODBC Driver to connect to Oracle. Does any other Oracle client library required. ...more >>

I have a table with 2 columns that I am copying into 3, with the 3rd column being an identity column, and I have the Enable identity insert checked, with an "ignore" selected under the transformation columns. But I keep getting the error that it can't insert data because the ID field cannot b...more >>

I've created DTS packages to copy tables from SQL Anywhere version 2.5 (AKA Sybase) to SQL Server 2000 & am executing them from Visual BASIC .NET. I'd like to limit the data copied by the Transform Data Task by date like this: SELECT column1, column2 FROM tablename WHERE (column2 >= inputd...more >>

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect. The step failed. There are a few jobs that developers create and they run under there accounts, I do not want to give them sysadmin access, but they need permissions to CmdExec. I e...more >>

I have to write a job to bring in a text file into a sql database. We have a ftp server set up and a place to read the file from. I've been looking at this site: http://www.sqldts.com/default.aspx?292 trying to get some ideas as to how to do this piece of a project. What I need to do ...more >>