Hello everyone, I was asked to create some DTS package that transfer data from a Foxpro database to SQL Server, Everything works fine when I execute the task on my local machine but when I schedule the task on the server, I get this error message : "Executed as user: *******. DTSRun: L...more >>

Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I get this error: ActiveX Scripting encountered a Run Time error during the execution of the script. I have everything setup correctly ...more >>

Hi, I have task to automate for loading Excel files. In this excel file every time i get with diffrent name as well within excel every time different worksheet name. Good thing is format is static but I need to find out way to rename to common name for excel file and common name for work...more >>

Hi, I have the foll TEXT file id doc name 0 1 test 0 2 test2 I need to import it into a table with the same columns id,doc,name but I need to pass my own value for the ID instead of using the values from the textfile so is it possible to pass a parameter to the text file import...more >>

I am recieve this error when trying to design some of the packages on the SQL 2000 box running service pack 3. The diagram appears, but when trying to load "names" or descriptions in the diagrams the error pops up. I need to either get a copy of these on a server i can edit and delete the...more >>

Can I export a query to text file? I can't figure out how to make the destination. The data pump errors because there is no transformation and there is no transformation because the text file "connection" has no fields. Can you write a new file or only append to an existing? An odd lack o...more >>

Hello, I have a very big problem, and hope someone can help me... Iám calling a DTS from an ASP, these seem to work pretty fine when I have very easy DTS´s, but when it come to a DTS that calls 3 DTS-packages, only the fist task of the first Package is done. I have read that I should be usin...more >>

I have created a custom dts package that transfers about 80 tables to another db with different column names table name etc My question is I went through the EM export dts wizard and saved the package - but now when I transfer the data it gives me integrity violations as the steps dont foll...more >>

I have text file as source and destination will be sql server. I have a check a source column satisfied the given condition ie.,DTSSource("Col005") > 100.If satisfied i have to insert that row other wise rollback the earlier insertion and skip the further processing. Note: Check constraint is...more >>

I'm using DTS to import an Oracle DB to SQL server. Although I know I can specify a non-default datatype transformation on a column-by-column basis, I want to know if it is possible to globally transform from one datatype to another. Here is what the client is requesting: If DTS encounter...more >>

Hi I have text file as a source and I need to write a script (ActiveXScript) which will check which columns from this input file aren't used in transformations. I know how to get columns which are used in transformations, but I don't know how to get source columns list to compare t...more >>

Hi folks, I created a DTS package on a SQL Server and Scheduled it by right clicking on that package. After that I have changed the owner of the job to 'sa'. The job fails with error: DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 14(E) Error string: [DBNETLIB][ConnectionO...more >>

I am a newbie at SQL Server, but I do have a little experience from Coldfusion. Here's my Question. We have a database for our business. We sell products. and we get price lists in excel format all the time. I am working with DTS and I would like to set it up, so that I can format the sprea...more >>

I'm interested in doing the following thing: I have this stored procedure: CREATE PROCEDURE usp_sequence @idseq int OUTPUT AS BEGIN TRAN SET @idseq = (SELECT idSequence FROM tblSEQUENCE) SET @idseq = @idseq + 1 UPDATE tblSEQUENCE SET idSequence = @idseq COMMIT TRAN GO ...more >>

I have a text file with 300 rows and try to transform into sql server 2000 using DTS. Suppose i got a integrity in 250 rows. I want to roll back the inserted data. Can any one give me suggestion. Expecting ASAP. ...more >>

I receive a -2147467259 error when attempting to execute a DTS package in a VB.Net routine. The client is running Windows XP and ther SQL Server 2000 (with SP3) is running on Windows Server 2000. I am able to execute the DTS package manually and, from the VB app, I can read, write, delete records...more >>

Hi All, I am trying to make an Access Project using SQL Server 2000 DTS functionalities. I have to import selective columns from a table of dbase5 database into SQL Server table. Every day, the dbase5 table will have some new rows. For the first time, I want to import all rows (abt 50K r...more >>

All, I'm in the midst of a project and trying to understand SQL at the same time. Normally I could get a database up and operational in a relatively short period of time, but in this case I'm running into a problem and need some help. Here's the situation. I've got about 300 lines of inf...more >>

I successfully installed the 1.1.0.0 (May 31 2005) version of the SMTP Mail Task (available at www.sqldev.net). But when I try to add this task to a new DTS 2000 package, an "mmc.exe - Entry Point Not Found" error pops up. The detailed message is: "The procedure entry point GetAddrInfoW could no...more >>

Hello All, I have run into a small issue with the Data Pump Task (or Data transformation Task). The issue is the data pump appears to be creating a deadlock. I am running SQL Server 2000 developer edition Service pack 3a on a dual 3.ghz 4 gig byte server. At the time of running this task t...more >>

Please help at our site we have the crazy Business Objects salesman who are trying to convince our Managers to convert from SQL Server DTS to Business Objects Integrator ETL tool. We have quite a many DTS packages used on a day to day basis and they process quite a volume of data. The BO Sales...more >>

Hi All, Let me start by saying I have 0, nada, zilch, zip experience with DTS, so be gentle ;-) We have this guy who, as part of his job, maintains an Access database, and we need this data in an SQL Server DB. Permanently converting the Access DB to SQL Service is not an option so I figure...more >>

This works: cREATE TABLE #test ( [Testløbenr] [int] IDENTITY (5000,1) NOT NULL , [Indhold] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) insert into #test (Indhold) select 'def' .....and t...more >>

I am running SQL Server 2000 on Windows 2003. I have several jobs that run, and I have noticed two issues. First of all, some of my scheduled jobs appear to be running twice as I receive two email notifications for each job. However I also notice in my logs that jobs seem to execute only on...more >>

I have strored procedures which sometimes start and end with something like "SELECT 'pgmname:', getdate() as 'started'". Sometimes row counts are included and other important stuff. Anyway, when I run these same procs from DTS I lose this information as the package log does not capture it. ...more >>

on my company's developement sql server, I created a DTS package with a global variable. Then from an ASP page I pass a value to a stored procedure which sets a global variable in the DTS package and then the stored procedure executes the DTS package. It all works on the development server! ...more >>

Hi: we have a lot of DTS Packages in SQL Server 7.0. We are moving all databases to a new server in 2000. What is the best way to Script and save these packages with out us going to create form scratch. any Ideas will be greatly appreciated. Thank you all in advance, Q ...more >>

Hi, I have 2 DTS Packages, one is a child which is run by the other the parent using the execute DTS task. The child has logging configured to point to a particular server, also the child has a dynamic properties task which uses a global variable to set the logging server. If I execute the ...more >>

Hi, How can we see the DTS error log file after executing the DTS package? Thanks in advance Regards Satish...more >>

Hello, Does anyone know how to open and save the excel file without the full version of excel installed? Our requirement is, the VBScript code in the DTS package task should change the sheet name of the excel file to "Sheet1". We do not want to install full version of Excel in the server ju...more >>

I am a complete rookie when it comes to DTS so please forgive my ignorance! Is there a way to run a VB6 application from within a DTS Package? If so, how is it done? Thanks in advance to anyone that can help!...more >>

I am experiencing problem discussed in this article: http://support.microsoft.com/?kbid=818540 (DTS Designer blows up and crashes EM when modifying dts task that uses SQL Calculated Columns as source) I need a work around as this is on a system where I cannot install SP4 any thoughts...more >>

Hello everyone, I am facing a situation, and your help would be really appreciated. I have created a view in SQL server that I need to export to an excel file on a monthly basis. However, what I want to do is give the exported file a dynamic name with a date or some other identifier in the...more >>

Hi, I have to create a DTS package for loading some ftp-based files to our SQL Server tables. For this, I plan to use file transfer protocol task. But, the filename creates a problem. Because it changes every day. It has a formal naming convention including the day of creation. So, filename...more >>

I have an existing database in SQL 2000 with tables, stored procedures, UDT's triggers relations indexes, packages, logins, users etc. I want to port the existing database in SQL 2000 to SQL 2005 beta version. What is the best feature available to do the same in the best way, so that the datab...more >>

I am importing a text file with a date field in a non-standard date format: In other words, it's in YYYYMMDD, without quotes. I've been unsuccessful in using DTS transformation using the dateserial function. The dateserial function recognizes the YYYY portion as a string; however, this func...more >>

I changed the host name of the server and now any data connections in my DTS' s that use the host name do not work when accessing Enterprise manager remotely. If I work directly on the server, they work just fine. ??? ...more >>

All, i have a question with regards to DTSRUN. i have a package on my server that is a hybrid from an example taken from http://www.sqldts.com/default.aspx?246, which isn't my problem. this work fine. i want to set this up so that one of my users can fire this from her machine. if i...more >>

I am having an issue with exporting a multiple sheet workbook created through the DTS wizard, and getting it to attach to an email. The DTS will export successfully. When it comes to the send mail function, I receive an error associated with the file is not at the location specified. The ...more >>

Is it possible to import from SQL Server or text file, to version 7, and turn off transaction logging? I'm failing for full tlog due to no drive space. thx md *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi to everybody Does anybody know how can I bypass an Execute SQL Task in a DTS Workflow? The bypass must be decided by the user in every execution. I've designed the following workflow: [ExecuteSQLTask] [tasks]-[ActiveX Task For Path Decision] / ...more >>