Hi all, I'm not very familiar with SQL Server but I have a task I would like to implement. I am not sure if it is possible but any feedback would be good. I have a stored procedure which runs a simple query. I want to export the results of this query to a text/csv file as a job. The fre...more >>

I HAVE QUERY AS FOLLOW SELECT NAME+COST+ID FROM CUSTOMERS I am trying to design a package that will exort this info into a text file. But when I try to degin the package I get an error. "To Continue, define tranformations. You can make changes to the default transformations" Why do...more >>

hi, I would like to know if DTS is a good way to open EXCEL workbooks in a folder and refresh the workbooks (VBA code in WOrkbook to extract data from a SQL Server database) by running a macro. I need to do this because I need to schedule this refresh task on a weekly,monthly basis? I would ...more >>

The client I'm working at right now is currently moving from their current ERP contained on AS/400 to a MS SQL Server based ERP known as SYSPRO. In doing so they are migrating 2 physical AS/400's with 4 business units (2 on each 400) over to SYSPRO. They have moved one out of the four and a ...more >>

"Test" button inside DTS designer on any transformation is not appearing. I have Sql Server 2000 server installed in my system, running on Windows 2000 professional. Can anyone help me out to get "Test" button please. Thank you....more >>

Hi all I have to update an SQL Server DB Table with data from an iSeries DB Table with the same structure. I would like to import data everyday and i would like to update only the changed rows. Is there a way to do this? or is it only possible to update evertime all rows? thanks for ...more >>

I have been given the task of trying to correct some issues with some legacy code and I have a question. Is it possible to disable a task using SQL. For example, I have task A, B and C. Step A truncates a table, Step B checks to see if the table is loadable (from a control table). If the table...more >>

I am having a problem scheduling a DTS package. I can successfully execute the package from within Enterprise Manager or using the DTSrunui utility. I have tried right clicking on the package in Enterprise Manger to schedule the job. I have used the DTSrunui utility to schedule the job. An...more >>

Ok all: Quick performance questions... I have a client who does a lot of their email reporting out of SQL Server DTS(...yes I know, why not SRS...) They are building ADO recordsets in the ActiveX tasks. Would it be more efficient to use the SQL task to run the query and assign it to a ...more >>

Hi Everyone im using an active script to execute a query and loop to get the id for each row that return from the query 1- is it it possible in active x script to customize & send email during the loop??????? & if it isnt possible how to make the mail task to be send with the number of loop ...more >>

I'm attempting to execute several DELETE statements via an ExecuteSQL task. I need to access a global variable that's set earlier in the package. I've gotten this to work for simpler queries, but for this particular set of SQL statements, I'm getting the following errors: Error Source: Mic...more >>

I am having a problem scheduling a DTS package. I can successfully execute the package from within Enterprise Manager or using the DTSrunui utility. I have tried right clicking on the package in Enterprise Manger to schedule the job. I have used the DTSrunui utility to schedule the job. An...more >>

I'm having trouble getting a DTS package to run on a schedule. It's a job running a single DTS package. The package drops a table, recreates it, and loads data from a flat file. I can manually execute the package. But if I try to scheudle it, the job gets the following error: Executed...more >>

Good morning. I have a package in which I have three text files with three matching Transformation Tasks into my SQL Server database. My problem is that I may need to execute one transformation on a text file, then execute that same transformation on another text file, and skip the other t...more >>

hi, i'm accessing a dts-package via vb and try to read out the datatype of a global variable (type-property of the properties-collection of the global variable-object). nonetheless, i get everytime 8 as outcome no matter if the datatype is integer, string or datetime. has anyone got a hi...more >>

Hi, I have a foxpro database files created and used by the third party vendor application. Now I want to put some sort of replication between my SQL server and the foxpro. So that my application can use this data from the sql server. I need to update only sql server tables with the foxpro tables ...more >>

I have the following incoming data file with the following structure: Material Year Month Stock on Hand ------------------------------------------------------------------------------- 000000000103063768 2004 03 2.0 000000000103063768 2004 ...more >>

Hi, this is a problem I have some longer period, so I will rephrase my question. I have done lots of testing, learnt some things but still do not have a solution for my problem. Here it is: MS SQL server 2000 I have created DTS package to copy from MS Access 2000 database to SQL table...more >>

I have several dts packages that import data into the same table. I want to add a 'type' flag to my import table, then in each of my dts packages somehow populate the 'type' column during the transformation. I don't see a way of populating a field in my table unless I choose a column from my...more >>

I want to trigger the start of another DTS package at the completion of the current DTS package run. How can I use an event to triigger one DTS package from another please note I do not want to embed the package to be triggered in the triggering package as the run of the first package will not...more >>

Greetings. I have a DTS Package that has the sole purpose of grabbing a set data from an Oracle database and putting that set into a table within a SQL Server db. The package contains two connections (obviously), and one data pump task with a very straightforward SELECT statement (no JOINs, n...more >>

Due to circumstances out with my control we have an application which writes data to an access database by dropping the table and rewriting it. I need to create a DTS which would check to see if the Access db tables exists and if it does I would like to replace the current data in a SQL server t...more >>

I've got some logic (vbs) that changes the constrainst of a step so that I can branch from a prior step and bring the two branches back together. I can't find any documentation for the value 'complete', only for success and fail. Anyone know what the value is? thanks bill page ...more >>

I am using asp.net and sql 2000. In my program I am doing a lot of data manipulations and before I do this I would like to copy my table to another table, just in case I need to put the data back to its original state. I would like to do this in the asp.net program. Can anyone help? Thank...more >>

Dear Custom DTS Task Writers: If you have written a Custom DTS Task in .Net, please attempt to modify your custom task within an ActiveX script. To do so, add your Custom DTS Task to a new package, add an ActiveX Script Task, and set its code to similar to below: Dim oPackage Dim oCusto...more >>

Hello, Quick question. I have a dts package that has a Execute Process Task step in the workflow that call a batch job (win32 process). Sometimes this step completes successfully and sometimes it does not. The return code is set to the default value of 0. When it fails, the error messa...more >>

Wir müssen Datena us einer MySQL übernehmen. Wir wollen dafür einen MySQL - Oledb Treiner aus dem Jahr 2001 nutzen. MYOleDB 3.0. Weiss jemand ob der Treiber zuverlässig arbeitet. Ich hoffe es mal oder gibt es Alternativen dazu ? Uwe ...more >>

When I try to create a new local package under dts, I receive a box that says DTS Designer Error, with a bunch of black lines in the message box. When I click OK, the connection icons dispay, but the icons under task are missing. Has anyone seen this and how do I fix it? Please help.... ...more >>

Normally this would be last night but what if you want it to be more often....have someone tried this - and if so - how ? a) real time olap b) be sure to filter records so only new records is being pullled out .. and scheduling this package more often than once a day .... how often ? per hour ...more >>

I am a DTS newbie. I created a DTS package in which i import a MS Excel file. the first time the package runs properly. After 2 days i executed the same package. It gave me two errors 1. Create table (error: the table already exists) 2 Copy data (error: no value given for one or more required...more >>

Hi.. We have somo DTS on Server, but usually users need to run DTS for can retrive data from other source, this step is very slow and server lost performance.. How can i increase server performance??.. May be if i run DTS on Other Server can be helfull?? The Data Pump run in the server...more >>

Hi, I am new to DTS and having some problem transferring Data from one server to another using stored proc in DTS. Stored proc takes around 11 parameters and does bunch of update statements and in the end it has select statement. The data return by this stored proc need to be transfered to a...more >>

How do I go about restoring the DTS package from a backup copy of the database from a month ago??...more >>

Hi, I have a problem with one of our SQL Servers. I was loading a text file (w/DTS) that has 7903 records. Exactly half way through it stops without warning and no indication that anything went wrong. The resulting table always has either 3952 or 7903 records. I've done this several times...more >>

Hello Everyone i have an ActiveX Script that returns with a global variable then in the workflow i have an sql task that insert this global variable in a table so i write in the sql task : insert into Table values (DTSGlobalVariables("id").value) It gives me an error "Incorrect Syntax Near DTSG...more >>

Hi, If there a method to format the bcp out so that it handles both commas and double quotes? To explain: I have the same problem with dts that I have with bcp. When I try to import descriptions that contain either double quotes or commas, I receive a SQLState = 22001 Sting data, right tru...more >>

Hi, I have an ActiveX script as the following: As you can see, it is calling another 14 DTS packages and How am I pass the two GlobalVariables (gMonth and gYear) into those 14 DTS packages??? Thanks a lot Ed Function Main() const DTSSQLStgFlag_UseTrustedConnection = 256 Dim myNum, g...more >>

I'm uploading data from staging tables on an as400 to staging tables on MSSQL. I want to set a status field in the source record to show whether the upload was successful or not. I think the multiphase data pump is the way to go, but I don't want to keep opening connections to the as400 wit...more >>

hi, i'm accessing a dts-package via vb and try to read out the datatype of a global variable (type-property of the properties-collection of the global variable-object). nontheless, i get everytime 8 as outcome no matter if the datatype is integer, string or datetime. has anyone got a hin...more >>

Hi Everyone! I have some strange problem, I'm creating DTS packeage that will create text file (vertical bar delimited) I need to specify 26 columns in select statement.And here I found the problem: When I'm trying to execute this query or populate from source button,it doesn't work,it won'...more >>

Does anybody know what rights a user need to execute jobs running DTS package ? Without being sys admin. Thanks...more >>

It appears that our current DTS packages can't work under 2005, I'm looking for a definitive list of what must be changed so that I can start looking at what we have to do to our DTS packages in SQL 2000 to make them compatible with Yukon. Is there such a list ? So far I have found vague h...more >>

Hi Everyone Im a Beginner in using DTS i m using a package in SQL Server That execute an sql query: & i want to write the query in ActiveX Script so if it returns rows , i want it to keep the first field for each row as a global variable and call another task that send email to send email as...more >>

I just saw some sample code: Function Main() DTSDestination("AccountID") = DTSSource("CUSTOMER__") DTSDestination("AccountName") = DTSSource("CUSTOMER_N") DTSDestination("GPO") = DTSSource("NATIONAL_C") DTSDestination("Address1") = DTSSource("ADDRESS_1") DTSDestination("Address2") = DTSSourc...more >>

Part of my DTS Package needs to take a flat file and transform 40 of the columns to 1 staging table, and 10 columns to another staging table. How do I do this so that I can see if BOTH transactions were Successul? I have this now TXT------(40cols)------SQL Table:StagingAsset | | (10c...more >>

I want to access a web site like www.oanda.com and on this web site there is a currency exchange rates table I want to parse this into a VB array to be later used within for currency conversion. Can somebody please clarify I am able to get the web page into a VB script and later do not know ho...more >>

Can I implement this logic in my DTS package? IF GlobalVariable1 = '0000' THEN do transfromation1 (parameter1) ELSE do transformation2 (parameter1,parametyer2) END IF...more >>

The following statement works when the "?"s are replaced with hardcoded values. It fails with "Invalid object name 'n'." with the prompt "?"s. update n set n.description = isnull(e.description, n.description) from dbo.ltd_service_type_description n inner join dbo.ltd_service_type_descri...more >>

Hello. I have a large daily interface that I decided to break down into multiple packages for ease of understanding. There's one package for each system I extract from. Is there a way to have a package scheduled in the database return a value (true or false for success) to the calling pac...more >>

I have a site where user register Club and team related to the club. My solution is to send the user a excel spreedsheet with the right ClubId and the right TeamId. The user register some info (playername, playerpicture) and send it back to me and then I will push excelinfo into a SQLServer. The...more >>

where is the actual physical location of views, sp's and dts packages?...more >>

Ì have a requirement to write a email handler that can receive a incoming email and do parsing and based on some of the keywords to perform a appropriate task handler and reply to the email or action the email. Can somebody please share the code and how to implement a process by which a DTS A...more >>

HAllo I have a ASP.Net application and a want that the user of my registersite to: 1. HAve a excelfile download to his computer with information that he hade register on my site. ex. ClubId and TeamId from sqlserver table 2 The User then register more information in the excelfile ex. pla...more >>

Hello, I try to import data from a stored procedure on another server. I can execute de SP and get results but when I try to make it work in a Data Pump task, the wizard seem to be unable to guess the sources columns and so I can't define the relations. It's very odd because I can import data...more >>