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