I have mmc.exe application error "the instruction at "0x42d93767" references mempry at "0x00000000". etc in debugger Unhandled exception in mmc.exe (STARDDS.dll): 0xC0000005: Access Violation while I try to open new DTS package or any saved .dts files. All dts packages saved on server o...more >>

I am developing my first package and need load a .xls file into a table in an Informix database. Everything looks straightforward except one of the columns in the primary key of the table is not in the spreadsheet. I need to add a constant value (a date) in that column. I can not find a way t...more >>

Hi, When I try to create a new DTS package on a SQL 2000 Server, the VBScript Language is not available in the ActiveX Script tasks. I only get JScript Language. What should I do to get the VBScript Lanugage? Thanks in advance for any help. ...more >>

We are running Lotus Notes as our mail system. I want SQL Server to send emails to Notes users can somebody please explain how to setup a mail profile to send emails to Notes users. Many Thanks Karen...more >>

Hiya, What I want to do is be able to save over another users DTS package where their username is the owner. I dont want to have to 'save as' a different name then delete the original and rename my one, as there is quite a lot to do. Is there specific permissions I can get granted t...more >>

I'm seeing a strangeness with the DTS designer in SQL Server 2000 SP3a. I'm trying to import a Unicode (UTF-16) file. The file has pretty long lines with tab delimiters between columns and dos-style line termination (CR-LF). It has 100 rows. If I do the following: 1. Open the DTS Pack...more >>

Hi. Trying to find out if its possible to check whether any DTS packages are running via a query. The background is that we have a system which loads a lot of data in the morning and don't what users to be able to access the system until the data is loaded. So checking if any jobs are st...more >>

Hi All, I'm trying to write an Active X task that waits for 2 parallel data pump tasks or excute SQL task to finish before it goes to the next step. Just wonder if there's any site I can "copy" :-) the code from? Being new to SQL server and all, just wonder if there's any books you would ...more >>

I want install a mini SqlServer client to run DTS(run to other SQLSERVER) ? should I install complete SqlServer ? ...more >>

Hello, I' m Rodney and new using DTS and want to create a DTS, it must import everyday to a table a text file, this file is called "VE" + date of the day.txt. I know how to load it to the database, but I need to use vbscript to know which is the name of this file everyday, and change it automa...more >>

I've reviewed a couple of the posts @ sqldts.com and was wondering if it's possible to skip multiple tasks and jump directly to the end. I have something like this: Check for files Check size here for data in the file. If no data, skip to Logging step | V Import data & Other misc proc...more >>

I have written a whole series of DTS packages for a client that I wish to schedule though SQL Server Agent. However, they were written in my name, with my logon as the owner and I do not have the necessary permissions within Agent. Nor am I being given them. Instead of rewriting all the packages...more >>

I have a DTS package where I declare a date (variable) using Active X. I then call a table to be written to Excel. I want to pass the variable to Excel (Connection Properties) filname for output (dynamic file name based on date). I don't know how to escape this variable. Any help w...more >>

Hello, I've this textfile with a column separator. When i import this textfile there are over 1024 columns. Upon creating the table, i'm getting an message that it is exceeding the maximum columns in sql server. Now i probably need to transform the columns so that it can be normalized into ...more >>

I'm trying to get a bulk insert job to run from within a DTS task. When I run the DTS task "manually" by clicking Package/Execute from within the designer or by right clicking and choosing [execute package] from Enterprise manager, the package runs smoothly. When I try using a job to run the D...more >>

receiving the error "An unhandled exception of type 'System.ExecutionEngineException' occurred in SQLHelper.exe" at the end of the following lines in VB.NET (VS2003/1.1): Dim oTask As DTS.Task Dim oLookup As DTS.Lookup Dim oCustomTask3 As DTSCustTasks.DynamicProper...more >>

I'm ftp'ing a set of csv files from a unix workstation to a cache directory on the local SQL Server. The file names are unknown since the names contain an arbitrary time of when they are generated on the Unix station. I've created an ActiveX script task that searches the cache directory and ...more >>

I believe there a way to do dynamic transformation mapping. I have source file as text file (two different text files), delimited pipe. Iam exporting data from text file to Sqlserver database using DTS. 1st type of text file has - 32 columns 2nd type of text file has - 21 columns (both...more >>

Hi, I can't find my DTS icons anymore! Data can be found in the MSDB/sysdtspackages, but I can't see the icon .... and I can't access the dts editor anymore! Help anyone!??!?...more >>

When I try to execute the DTS package from ASP Page , it gives the follwing error: 0-2147220440Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed. But it runs fine from EM Thanks in advance. ...more >>

Hi, I have a DTS in SQL 2000. It has two steps. One is to delete all the records in a table. On sucess it then copies the data from a table on a linked server into a local table. The DTS runs fine when executed. However when scheduled it only runs the first step to delete the files and ...more >>

Hello I am having the following problem: I have to collect the same data from multiple data sources into the same table in SQL server. Instead of writing possibly 150 identical packages where the only difference is the ODBC connection i am using, I have set up a generic package which i call...more >>

I have a pretty simple DTS package that has 2 transformations, batch and detail records from one database to another on the same server. It's failing on the detail transformation with the error 'Transaction context in use by another session' in the error log. It's only failing if the rowcount is ...more >>

Hi, Is there any way to take the result set of a query, run excel, and create = pivot table from the results for a user to manipulate and save? I have been looking for a solution like this.... Ron Sissons, DBA Information Technology Services Riverside County Office of Education 3939 T...more >>

I've taken over some work that includes a few DTS packages. One of them generates an xml file and mails it to it's destination. Now they want it posted to an http site. It looks like I can do this but I get an error saying that the the object doesn't have a method 'open' The existing pack...more >>

Any ideas? ...more >>

Hello, I have to export data from one table to a file (any type) in order to = import it after to another sql server database. The table has one nvarchar column of 2000 possible size. If i export it = to a text file with delimited format my column is cut off to 255 = characters, if i export it ...more >>

I am faceing problem while export data using DTS in Visual basic after installing service pack 2 on window XP. Before installation of service pack 2 on window XP DTS exporting successfulling in VB. I am exporting 20 tables using DTS in VB. This problem come 11th table which contain larger data...more >>

I want to launch a dts package from query analyzer. I'm using code like the code below and am getting the error below. It works just fine if I use the same exact code that is in @strsql from a command prompt. Any ideas? Thanks, Andre DECLARE @strCommand VARCHAR(8000) DECLARE @nCubeID IN...more >>

I am experiencing exactly the behaviour in KB818540. However, when I try to e-mail MS Tech support it asks for a product ID but I bought it on licensing and don't have a product ID. The eOpen website will not expand the product (so I can't see what it says in there). The find product ID...more >>

I have a DTS package that just started doing this and hopefully someone can point me in a right direction to troubleshoot: I have a package that has a transform data task. This task uses activeX to copy from a flat file to a temporary DB. I have a flat file with 170k rows. It precesses...more >>

I've copied the table structures of a replicated DB from another SQL Server. I have no need to use replication with this new DB. When attempting to add a record to any of the tables, I receive the following error: "Invalid object name 'dbo.sysmergearticles'". How can I tell the new DB t...more >>

Im try to run a .bat file using DTS. It works if I execute form within Local Packages, However when I try to schedule it fails with a 'specified file not found'. All the .bat does is rename a file on C:\. Has anyone had this problem before?...more >>

Simple question : How can I find out when a dts job last ran? ...more >>

Hello, I am running an extract and need to be able to specify that if the Source field is Null it picks up another field. For Example: SOURCE DESTINATION --------- ---------------- FieldA FieldC FieldB If Field A is Nu...more >>

Hi, I am newbie in Oracle, for using DTS between MSSQL I am familiar but even to connect to Oracle, it doesn't work. The error is, Error source: MS OLE DB Provider for ODBC Drivers Error desc: Driver's SQLAllocHandle on SQL_Handle_ENV failed. Context: Error during initialization of the provi...more >>

This problem is a bit beyond the normal permissions problem of a scheduled DTS package failing, when it works in the designer. We have a DTS package that copies a file between servers in different domains - I believe crossing domains is the source of the problem. This is done in a batch file ...more >>

Hi All, Here's a simple question (with probably a simple answer): I will be reformatting one of my SQL boxes this weekend, but I need to move all databases, jobs and DTS packages from it to the other SQL box. Is there any way to export or move a DTS package from one SQL server to another? ...more >>

I have a DTS package that is run from a web UI via xp_cmdshell and DTSRUN, I'm getting an Active X script error on one of my steps only when run through the web app, running from QA works fine... TREAD report generation failed. DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482...more >>