I'd like to keep some settings for my DTS packages like the name of the server ,the name of database and also some other settings.I'd like to use a table.How should the table look like ,shall I use one Table for keeping categories and the other one for settings in that category? My DTS package...more >>

Simple portion of an active x script in SQL Server 2000 is failing on "mm" and "dd". It works with m and d DTSGlobalVariables("gstrToday").Value = DatePart("yyyy", Now()) & DatePart("mm", Now()) & DatePart("dd", Now()) tia Moe ...more >>

I have a Date type of Global variable, I would like to set system date as default value of globle variable. Any help will be appreciated. ...more >>

Hi, I'm trying to perform an INSERT that I can do currently using osql, but I need to make some changes and thought that putting into a DTS would be a good idea (instead of a scheduled task like the osql is now). What I like about the osql is I connect to various servers using variables, how ...more >>

This issue has persisted following a full uninstall and reinstall of SQL 2000 and all components. I get the error ONLY when I try to schedule the SQL Agent to process a DTS package containing an OLAP processing task; (DSO (80004005): Automation error The specified module could not be found....more >>

Hi folks, hope somebody can help me out since I am running mad on this and no book can help! I want to consolidate 8 adress db´s (Access,Paradox, txt ,Sybase SQL.etc) to one big address DB on SQL Server using DTS After importing my Source Tables look like this tblSource: Name First...more >>

If you have a package with analysis services tasks, do the analysis services client tools need to be installed on the server? We have a package that we were able to run from a client that had analysis services installed, but doesn't execute when logged into the server. ...more >>

I have a DTS package that I created using the DTS Wizard. I've tested it and it works. Now I want to execute that package from a VB.Net program. I downloaded the code example from the MSDN Website and am trying to follow it - so far with no success. My code looks like this... Privat...more >>

Hi there, I hope anyone can help me.. Im trying to work this thing out for days with no result. When i execute a package on the server, logged as Administrator, it works fine. But when i execute it from a DTSRUN or from a JOB that was created from the same administrator it gives me a Jmail er...more >>

Hello there I need to build scipt that runs DTS Package on sql server Is there a way to do this? ...more >>

Hi, I know a DTS package can be executed from various technologies - .NET, VB etc. But is it possible to execute this using winAPI at all? If so can some one point me to the correct resource please. Thanks, Harish Mohanbabu http://www.harishm.com/...more >>

Does anybody know if is still possible to run SSIS packages (DTS packages) with a free version of SQL Server? I'd like to continue to develop DTS packages with my developer version and to redistribute its to my costomer that are using MSDE. Is it still possible? Because I'm afraid the answe...more >>

I have a strange problem. I have built a DTS which runs fine when each step is executed individually, but when the DTS is run as a whole, the last step fails. I have checked the workflow and nothing seems amiss there. Now I'm stumped and don't know what else could be the problem. The DTS ...more >>

Is there a way I can pass on variables from a stored procedure to a DTS-package. I prefer to run this DTS-package as a job because of policy's by the customer. Thanks in advance....more >>

I am creating a DTS package with a select query that retrives information between Date1 and Date2. Instead of changing the Dates in the underlying query, is it possible to set the parameters when running a DTS query ? Thanks...more >>

I attempt to export data from a query via DTS to an excel spreadsheet. When I select the option: "Create Destination Table" and "Drop and Recreate Destination Table", I find that whenever I run the DTS, rows are appended to the Destination Table. In this way, I just create a dumm...more >>

Hi, I need to know where can I edit the source code/script of a DTS package saved on the sql server. It was not saved on a VB file or structured storage file. I am running SQL 2000. TIA. ...more >>

I have a Parent package which call different child packages.I have schaduled the Parent package to be executed evey 3 minutes and I'm using a Table in which I insert the name of the child package which is working and when it is done I delete the row,by this mechanism I control not 2 child pack...more >>

Is it possible to add an owner password to a package without opening it in the package designer and choosing Save As? ...more >>

Hi, I am doing a DTS transformation from SQL Server table to Access table in my ASP page. When the DTS Package runs from ASP Page, I get the following error: Microsoft Data Transformation Services (DTS) Data Pump error '80042025' DTSTransformCopy: Schema validation failed; see Extended Er...more >>

Hi have a DTS package that runs daily. It first FTPs a .CSV file from a remote server locally. It reads a .CSV file and writes out to a SQL Server. There are about 10 or so Transformation tasks for processing the rows. I have about 8 other packages that are designed exactly the same way ...more >>

Hello, I have a DTS package that import AS400 data to SQL Server. I have to transform some data. So I have data like 20053453 that I need to transform to 2053453. How can I remove the second character ? Thanks for your help. Gael...more >>

Hi, I am wondering if anyone can tell me how to convert a datetime field to smalldatetime field in a dts transformation script? In particular I want to do this: DTSDestination("DATE_OF_BIRTH") =DTSSource("birth date") where source is in datetime, dest is in smalldatetime? If I don't ...more >>

Please don't redirect me to KB269074. I've read it and either I am missing something vital, or my problem really isn't covered by it! I have a simple DTS package: a single execute process command that tries to launch MS Access.Exe so that it can in-turn open a DB automatically, run some cod...more >>

I have exported data from table T (target table) to Excel and manually changed some columns. Now I want to persist those values back into table T. So I import the csv file into a staging table S that has the same structure as T, let's say both look like key (INT) name (CHA...more >>

I have to move data from 2000 tables from one Server to another (total 10 million records). The Servers are physically in different locations. Is there an easy way to create a DTS package to do the same? I have tried the import/export and if I pick up more than 25 tables at a time, it takes ...more >>

Hi All, We require to move rows from source table to target table i.e the rows in the source table should get deleted. Is there a way in DTS so that while copying it also deletes the rows in source table? Thanks in advance, Sachin...more >>

Dear All, While Updating/Deleteing input parameter will take only corresponding Table.filed. My prob is I would like to pass other tables.filed as input parameter. Detals in Example CREATE TABLE [StageTable] ( [DateExtracted] [datetime] NOT NULL CONSTRAINT [DF_StageTable_DateExtracted...more >>

Simply reregister the dtspkg.dll and dtspump.dll using regsvr32.exe program....more >>

This is caused by invalid dtspump.dll. simply reregister using regsvr32.exe....more >>

Greetings, I am trying get my head around this Transform Data Task regarding Error Processing. What I have set up is a simple 3 row XLS spreadsheet with column names as the first and 3 "records" to be imported as rows 2-4. I have a package that goes like this: Step1: ExecuteSQLTask - crea...more >>

I am using SQL to extract data to a text file(and I'm new to this). I want to end up with one row from a table that stores data in two rows: Table looks like this: Location LocationTYpe Product 1111 Bottle AAA 2222 Case AAA I want my file to l...more >>

I'm doing some dynamic assignments of a datapumps SourceObject, which happens to be a file. Here is some background. My process uses activeX to look at the file contents of a folder and assigns a file as the datasource of a text connection. This connection feeds a datapump that has been set...more >>

Hi, I can't seem to execute a saved SSIS package in either the Management Studio or the Business Intelligence Development Studio. I am running SQL Server 2005 CTP. The package is a simple table import which I had saved to a file. (Attempts to save it to SQL Server, resulted in SSL errors...more >>

Hi, I have a simple SQL Server DTS package with a Send Mail task. The package executes successfully when I manually run the package. However, when I access the package through a VB.NET app, it fails at "MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed". The package runs successf...more >>

In MSDE sql server 2000 dtsrun was available to execute the dts packages but now with sql server 2005 express edition integration service is not part of express/workgroup edition and the dtsexec run time is also not available. Can anyone tell me what my options are other than using different ed...more >>

Hi, How can I execute a mail task on when a package fail. Currently I have a package that imports a file into my database. I have an activex script task that chacks if the file exists, It has the foll code Function Main() Dim oFSO, sFileName ' Get the name of the file from...more >>

I'm having to retrofit some of my SQL 2000 DTS packages back to SQL 7.0 for a different environment. In SQL 7.0 Is there any way to get values from the database into Global Variables? In 2000 I would just use output parameters in an Execute SQL task, but obviously this is not possible in 7....more >>