I have created a DTS package that basically copies tables from a Oracle server to MS SQL server. When I run the package manually using the Enterprise Manager, it runs file. But the when I schedule the package to run at a later time, it gives errors listed below. Step Error Source: Microsoft OL...more >>

Hi, the rs utility is good, but the script is compiled at every usage. does it possible to compile a script 1 time and keep the compiled version? for the moment I bypass this problem by creating my own program. any idea? thanks. Jerome. ...more >>

Hi there, I setup a DTS package to export a table from sql server to microsoft acess database stored on the network drive. Z:\(0) Payment Cosolidate\Payment_Transfer.MDB I can execute the DTS package from Enterprise Manager but I want to allow my boss to be able to export this table by h...more >>

I need to give the ability to only somewhat technically minded people to insert/ update into 1 SQL table. They have data that comes in frequently from Excel files that needs to be imported and we want to make it so they don't need IT. There's no way to install just DTS without installing Enterpr...more >>

Hi all ! I had a hard time to build a dts package which imports an excel sheet into a table inside sql server. The columns in the sheet hold mixed data ( numeric values and text ) and I struggled which estimation of the datatypes done excel and/or the jet driver ( I don't know ). To ake a l...more >>

I have set up a DTS transform from a flat file to a SQL table. I verified the transform works with a flat file of about 32,000 rows, no problems. When I tried the same transform with the full 6,100,000 row production file I got a message that the network connection was lost. I get the mess...more >>

Dear all, please forgive me if I'm posting this in the wrong group, I'm very new to SQL-server and DTS. The question is: Is it possible to delete files from a FTP-site after one has copied (using the FTP task in DTS) them to the local machine. It probably is, but how does one do this? ...more >>

Hi DTS gurus, I have two question : 1) How can I pass INI value to DTS Global Variable ? Can I use Dynamic Properties Task ? 2) I use Exedute SQL Task to exec SP, but how can I get the Error message if error happen in SP execution ? Thank you for your help, Trist ...more >>

I created a DTS to import a text that is FTP'd from a Unix server. I am not having the common problem with the carraige return character. Instead I am having a difficulty getting the text driver to recognize each column. The file is, from what i'm told, space delimited. The file only has 3...more >>

hi, Is it possible to to do an incremental update through DTS ? The database tables do not have a time stamp. My problem We have a production database wchich is backed up every night. What we need is an incremental backup everyday in addition to the full backup. How can I do this? Was think...more >>

Can I call a DTS package from inside an executable and return a datatable/dataset to the executable. Thanks, Jase...more >>

I have inherited several DTS packages that fast-load text files into Sql Server tables. When such steps run, EM indicates that Bulk Load" is running. There was a time when a failed bcp "bulk load" would leave a table in an unhappy state because it was being minimally-logged. I wonder if DTS u...more >>

I have a DTS which runs multiple queries pulling the same type of data from similar tables. One of the 'where' conditions is a date range but this date is going to change from month to month. To prevent me having to alter the where clause of each individual query to pull the current date range...more >>

Hi I have column FName of varchar type. FName ------ Mktg_2004_03_11Completed Fin_2004_03_10Test Acct_2004_03_09Failed I want to get get result set as FName ------ 20040311 20040310 20040309 I tried using replace, stuff but couldn't make it work. Plz. help Thanks...more >>

Hi, I'm looking for a good solution to remove unused records in my dimensions. My users dislike to see unused objects in cube's dimensions and other prompts in reports. But the delete command is very slow due to a ton of constraints (to insure good data quality). so, any idea? guide? ...more >>

Hi, We need to automate from DTS the execution of REPORTING SERVICES to run predefined reports against their Data Source (a SQL or OLAP DB). We are searching for simple methods to do it: - Stored Procedure - EXE command line (dynamic using DTS global variables) - simple script I think ...more >>

When I create a dts package with 2 access connections that use the same system.mdw I get an error when I try to save the 2nd connection. The error message is : Cannot start your application. The workgroup information file is missing or opened exclusively by another user. How do I create...more >>

Is there a performance difference between running a DTS package from a VBScript using DTSrun.exe opposed to directly executing the stored procedure within QA. I would assume that one the VBScript throws the request over the fence its all the same. Also, I am using a an OLE DB Connection within ...more >>

Hi, I need to automate the execution of REPORTING SERVICES from DTS in SQL Server 2000. As most REPORTING SERVICES are exposed via SOAP, I need a basic/simple/old fashion method to automate RS execution from DTS. It could be a T-SQL statement ideally or a EXE command line or a simple sc...more >>

We have processes which load data collected from around the country in night time DTS processes. Tasks are loaded and run one on the heels of another. These have a pretty consistent performance profile most of the time. But sometimes, almost always at night, we see a 10 fold increase in the ...more >>

I am loading data from one table to another the structure of both the tables are the same. When I copy from the staging table to the main table I want the staging table records to overwrite the records with the same key in the main table. So for example the following are the keys in both ta...more >>

Which one does the work ? Both ? Isn't most work done on the one that pulls data out...? Can the one that pulls data out cause blocking on the other server ? /michael V. ...more >>

Hi all I have a very simple task to pass value which I retreive from execution task against MS SQL Server and using it as an input parameter to another sql task execution which happens to be an execution of procedure on Sybase. How do I do that?...more >>

I need to copy a file into another file. I use this code but I dont get any errors but I dont get the file copied neither. Private Function RenombrarArchivoPresupuesto() 'On Error Resume Next Dim archivo Dim f Dim f1 Dim fc Dim fso Set fso = CreateObject("Scripting.Fil...more >>

I have created a DTS that sends output to a text file. I want to be able to add a date/time stamp to the file name so I can save multiple copies of the file. Does anyone know how to do this ? Thanks much Otto...more >>

Hello, I would like to rename the step in the log file to have something more readable then the default name ?DTSStep_DTSDataPumpTask_xx? Do you have an idea? Thanks Benoit ***************************************** * This message was posted via http://www.sqlmonster.com * * Report s...more >>

Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic Props Task, assigns that file path and name to the Global Variable. Imports data from a .txt file into an SQL table. So in this particular...more >>

I have created a DTS package that writes data to a text file. I want to be able to place a timestamp in the filename so I can keep multiple copies of the file. Does anyone know how to place the timestamp in the filename? Thanks much Otto...more >>

I am trying to automate the rollout of new objects in my production environment in such a way in that a DBA does not have to be on hand to add the objects to the database. I think I have everything covered with the exception of DTS packages. Is there a way to add these files to the sql ser...more >>

I have a database that I normalized to 3N. Now I have a large amount of data from a 3rd party that is in a flat file that I wish to bring into the normalized (but empty) database. If I simply needed to split the data up into the appropriate tables, I can see to build multiple inserts using a ...more >>

Hi, how can I know or log the volume loaded by my DTS packages? I need to evaluate the traffic and the bandwidth required. Does the profiler can provide enough info? For the moment I work on a copy of the production database. so all is local on my server. Thanks for your help Jerom...more >>

I had exported data between SQLServer2000 by Source server was SQL Server 2000 any version Destination server was SQL Server 2000 SP3a I had data of 120,000 rows to export. Between I was exporting data. An error occur and the message was "Error at Destination for Row number 28649. Errors enc...more >>

Hi, I have two questions: 1) I have the same databases on two different servers. I modified, added and dropped indexes on one of the databases and I need to transfere only the index changes to the other database. Is it possible to use Copy Objects Task? I tried but it affects the tables too. ...more >>

Is it possible to email the contents of a directory as part of this task? Thanks....more >>

When creating a new package under Data Transformation Services with the following information, you get the error message of “Invalid delimited data”. Row one will import correctly. Row two will fail. “0035”,”C”,”525 W DAVIS RD”,”ANYCITY”,”FL”,”12345” “0036”,...more >>

Hi, I want to schedule a package to import access database to sql2000 server (sp3). The pkg fail with permissions error... what do I neet to have in mine for schedule pkg? Do I need to install access in my sql2000 server? The pkg is running ok manually. Tks in advance JFB ...more >>

Hi there, I just created a DTS package to copy data from an oracle system to MS SQL 2000 Server. However when I try to edit the data within my table on MS SQL 2000 after been exported, I get the error messsage "Transaction cannot start while in firehouse mode" any idea whats causing this ? ...more >>

I have a DTS package that reads a text file. The delimiters are tab for columns and {CR} for rows. When I import the file with the DTS, the job seems to run successfully but no rows are added to the table. I have checked the text file and they are rows in the text file. There are no indexes...more >>

I am trying to call a DTS package from a VB.Net application. If my application is on the DB server it works correctly. If I move the application to another server the DTS packge is not run and no errors are reported. Any ideas ? pkg = New DTS.Package 'Begin - set ...more >>

Hi, I have to call a DTS package from ASP, for this I have created a stored procedure that calls DTS package. I am calling that stored procedure from ASP, now the problem is that DTS package is executing two times. But If I am executing the stored procedure that calls DTS package, from Q...more >>