Can anyone tell me the recommended way to run a DTS job from a web application ? What would be the minimum priviledges that I'd have to give a user to run the package ? Could I just give a windows-authenticated user access over a stored procedure that can run a DTS package ? I'd like to use A...more >>

I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data source. I select the destination. I select 'Copy ...more >>

Using the Copy SQL Server Objects Task inside a DTS package - I am = attempting to refresh my DEV, TEST and Pre-Prod environments from my = Production environment. I only want to refresh the data. This task seems best suited once I = click off all the dependancies such as copying the accompan...more >>

Hi: Any help with this would be appreciated. Thanks in advance. Environment: SQL 2000 SP3 all up to date on Win2K Server SP4 all up to date. Issue: Trying to import a very large text file (12GB) into a db table where the data was originally from. The data was exported based on a...more >>

Dear SQL server gurus, I have created a job a year ago with more than 20 steps. Now when I check the job property, select Steps tab, the steps are now out of order. I have many jobs but only one job has its steps out of order. It does not effect its function - I guess - but I have no idea why...more >>

Hi, I am trying to programatically run a DTS package from .Net (C#) and and ideally would like to see the "Executing DTS Package" and "Package Execution Results" windows displayed. I've reviewed dtsrun, dtsrunui utilities and KB319985 articles. If the dtsrun utilitity had a argument...more >>

The destination dropdown does not autoexpand to show the entire table name when I try to pick the destination when creating a DTS package. Is there a setting for this or is this a bug in SQL 8? With the server.owner.table in the dropdown I only get to see around 3 characters of the table n...more >>

I have a Transform Data Task (TDT) in my package connecting to SQL Server, the SQL in the TDT is 'SELECT [PartNo], [Description], SUM([Qty]) AS Total FROM DailyProdTotals where ProdDate >= gsLastUploadDate GROUP BY [PartNo], [Description];', the gsLastUploadDate is a global var, that I retrieve be...more >>

Hi Have used DTS wizard before but now have to use DTS Designer for first time and need some assistance. I have a number of SQL updates that I have setup as Execute SQL Tasks. What I am trying to achieve is to output the number of records affected by the various updates to maybe a global variable ...more >>

We needed to replace our Motherboard on a server running win 2K Adv. Server with SQL server 2000. After replacing, we could not bring the system back with the previous OS. So, we have decided to migrate to Windows 2003 server and install SQL svr on it. On the old server, the SQL DB is resi...more >>

I have the following tables on a non-SQL database that I can access via ODBC: Updated OrderHeader OrderDetails InvoiceHeader InvoiceDetails When an order or an invoice is added/updated a record with the order number is added to the Updated table. I need to loop through the Updated table...more >>

Hello, All! As far as I can see, DTS Designer utilizes icons of different sizes for task pane (16x16) and for designer pane (32x32). But I can't use two icons for custom task. As result, only one icon looks well. Is there some trick with icons? Thanks. With best regards, Alexander Sin ...more >>

I have a dts package with an execute sql task containing the code below. DTS refuses to let me use ? following the FROM. Tried placing the code w/in a variable and executing. Still no go. Suggestions anyone? Thanks much. SET @Tri_Select = 'SELECT firstname, middleinitial, lastname, address1,a...more >>

Can anyone confirm this for me. If I were to run this script below. Will it reindex all tables indexes at one time as it goes through the cursor. Or will it reindex one table indexes at a time as it goes through the cursor. Basically will it pause each time the DBCC command is executed? If the f...more >>

I need to export some data to an Access2 DB. I have built a DTS package using the default JET4.0 OLEDB drivers, and it works how I want it to. Can I modify this package to create an Access2 compatible format DB? Are there any separate OLEDB/ODBC driver I can install that will allow me to ...more >>

Hello: I have an .NET application that has stored procedures in SQL and is interchanging information with AS400, bringing transactions that I use to update an inventory master and sending transactions to a table in AS400 (I am processing this trough schedule DTS packages). These packages h...more >>

Hi, Is there anyway to use the same SQL Server connection and create a transformation task between the two connection. What I'm trying to do is load data from a flat file into a staging table and transfer this data into the application tables, but I would like to use the activex scripting t...more >>

Hi, In DTS Lookup, I want to write a query as SELECT col1 FROM Table1 WHERE col2 like '%0001' ( this would be parameter) this returns one row. col2 is varchar column I wrote it as SELECT col1 FROM Table1 WHERE col2 like ? But it doesnt seems to work. Any idea what sho...more >>

ive got a sql 2000 db running on a remotely hosted server. im trying to take this db and export it and import it to my new web host. my problem is that I go to the db, select export, then select, copy objects to export. i keep getting an error that the export failed due to the fact that the user doe...more >>

I would like to run a package while passing it a variable from a stored procedure. The xp_cmdShell method isn't working because dtsrun is working from the command line. Is there another way? ...more >>

My DTS package fails on the first error. Where can I increase this, to say, accept the first 100 errors or accept all of them? Can I send the rejects to an error file? Thank you. Carl....more >>

I am new to DTS packages and not familiar with the object model. I want to simply pull the results of a query on one Server to another and save the results in a table based on the date. I have figured out a way to name a table I created based on a text and date combination (i.e. BR200407...more >>

Our DBA has left some DTS Packages floating around with some connections = using "sa" and the password is saved. =20 I'm trying to demonstrate to him the danger in allowing anybody to open = this package as we can add/change/modify the package to do things, using = SA credentials. =20 ...more >>

I have an asp page that enables users to write and run queries without knowing SQL. After running, the users often want to download the results to MS Excel. I have written VB code to create a DTS package. The package has a connection to my SQL database and an excel file. For now (test) I ha...more >>

Hi, i have a DTS job that transform records from one database to another. Works well. But for my own logging I want to know how many rows affected by the transformation job. Is there any global variable that contains this information ? I think there is one, because if I execute the DTS packe...more >>

Hi all, Sql server 7.0 I have a DTS replication which truncates the destination of one database and copies all the rows from the source table of another database of same server(1st server) in first step. in second step the rows are copied from destination table to another table of other ...more >>

I need to take one CSV file and import it into multiple tables in a database. What I'm not sure of how to do is specify which table the data should go into. I have successfully imported into one, but not sure how to do multiple tables. Just a point in a general direction or documentation would be he...more >>

I have SQL Server 2000 installed on a server that has WindowsServer 2003 installed. When I try to open DTS Designer, I get an error window that opens. The title for the window is "DTS Designer Error". The error message is "Error in the DLL". Has anyone run across this problem? If so, ...more >>

Please help me as I am new to DTS programming in SQL Server 2000. I am moving data between different servers in SQL 2000. I am running a visual basic 6.0 application and want to use a DTS package by passing a global variable (in DTS) to insert a complete recordset into another database (in...more >>

We would like to update the Customer Table in Northwind database with DTS (As a testing). We have created a DTS as follow but it doesn't run successfully. Is there anything wrong ? Function Main() DTSDestination("ContactName") = DTSSource ("ContactName") DTSDestination("CustomerID") ...more >>

I appeal to the bigger brains here... Short ActiveX Script below. Does not work. Keeps giving me: "Incorrect Syntax near ' ' '. " error, but there IS NO ' in the task! Anyone familiar with this error? Does anything stand out in this code that anyone notices that I may be missing? ***********...more >>

what is the easiest way to call a dts package from vb? tia, dk ...more >>

I received a file with extension dts. I'd like to open it and print the query it contains. Can someone give me instructions as to how I can move it to Data Transformation Services in a new database then open, print and edit the query it contains? Thanks for any help!...more >>

Hello, all. One more question: How do you change the owner of a DTS package -- can it be done from Query Analyser? Thanks. ...more >>

When I launch a package from the query analyzer, I receive a "text qualifier already exists in the collection" error. I get the error whether I have "none" or double quotes chosen for the text qualifier drop down within the package. I do pass it a global variable upon execution. here is what I h...more >>

Hi All, I have a text file script thats used in a batch process. I'm trying to have an element in that script be a variable. Furthermore, I'd like that variable to be populated from a DTS package. Does anyone have a suggestion/example of how to do this? Thanks in advance! Mark...more >>

Hello, all. We need to copy a DTS from one SQL Server 2K machine to another. What's the least painful way to do this? Thanks. ...more >>

This link http://www.sqldts.com/?234 references a method of tricking DTS into accepting both an input and output parameter using this code: SELECT id AS OutputTest FROM sysobjects where id = ? That line of code only works for 1 input and 1 output parameter. Anyone know a way to increase the ...more >>

i need your expertise help. i'm trying to export data by using dts package to an excel template. but the data must be exported to a specific cell of the excel sheet. for example, i have a tot_begin_amt and tot_end_amt and i want tot_beg_amt to export to cell a2 and tot_end_amt export to cell a3. i...more >>

Hi, We installed MDAC 2.8 over the weekend, and now all the DTS jobs that execute packages no longer run. Jobs that run SQL statements or execute Operating System commands have not been affected. I can't find any flaw the login / password. The SQL Server process is started by user SQ...more >>

Hi, I am having a problem here, since i am quite new to DTS programming. I have made a DTS package (stored in SQL Server, but that shouldn't matter) that basically takes an Excel file and impoprts the contents into a SQL Server. The location of the Excel file will vary, and I will eventuall...more >>

Hi, I created a DTS package wich runs a standard Stored Procedure in the master database. De stored procedure is called sp_makewebtask and it creates an HTML file with a grid of the data you query. I call the stored procedure by an Execute SQL Task object with all necesarry parameters fi...more >>

Hi, I updated our SQL server (SQL2000/SP3a) from Windows2000 server to Windows2003 server yesterday. Everything seemed to be fine, except that DTS packages are not running, and i got a error message: "Entry point not found The procedure entry point getTextExtentPointI could not be locat...more >>

Hello All, Access recently kicked me out of its domain (data warehouse too big too handle) and I landed in the beautiful SQL 2000. This is probably very basic but I need some guidance. Every week I have a csv file with over 7,500,000 records that I need to: 1-Import it to an existing SQL...more >>

I am using SQL Server 2000. If I can see a DTS package under Data Transformation Services/Local Packages, that means the package is saved in SQL Server. If I take master database backup, in case of disaster I can recover the master database and all these DTS packages are restored. Is i...more >>

I'm starting a new effort to move a import a huge CSV file. This begs the question: Which Bulk Import (bcp.exe, bcp task of DTS, BULK INSERT TSQL) is the best all around, when both speed and maintenance duties are considered? The medical vendor who provides the data and automated import facilit...more >>

Can anyone help? I have a package that imports two text files into a table in a Database. This works fine, however, I want to delete the information from the table before importing the new information, and I don't know how to do it. I have tried using a Data Driven Query task, and also ...more >>

Hi, Is it possible to execute a stored procedure in aa ActiveX Script task in DTS? If so, what's the syntax for this? I've looked in the books online and on the internet but can't find any examples or even topics about this. Thnx. Stanley...more >>