Hi. I'm transformating http logs. When setting up Transform Data Task to use SQL querry as source like: SELECT * FROM transacion ORDER BY IP It didn't sortking by IP ! But wen i use a view with this same SQL querry it is ok - it sorts. WHY ??? TomS ...more >>

I have a master DTS package that is made up of multiple other DTS packages. The process that we run nightly is something like: Step 1 (pull data) On Success Step 2 (aggregate data) On Success Step 3 (generate key in separate table) On Success Step 4 (push data into final table) It's im...more >>

I have several DTS packages scheduled to run twice a day. How many minutes apart to you need to schedule these packages? I.E. Should I have Package1 run a minute before Package2 and have Package2 scheduled to run a minute before Package3, etc? What happens if Package1 isn't done running by the...more >>

I have seen this question a few times in the past, but there has never been a good answer. I have a very large binary file that I want to read into a SQL Server table. Each record in the file is a fixed size. It seems like I should be able to use DTS to do this, or at the worst write some VB c...more >>

I am attempting to change the properties of a connection that is used by a generic sql task. I have coded to change the Database/Server as shown below. But the tasks that use this connection don't seem to recognize the change and run against the initial Databaser/Server. Is there something ...more >>

Hi, In my sql server 2000 i have the ID field set to identity. when converting sql server to Access database, i need to set as Auto number field. Currently its look like this. its createing a field as number. i need to generate as a auto number into access. "`ID` Decimal (18,0) NOT NULL"...more >>

Hi, I have created automated partitoned tables. When the DTS package runs a table is created automtaically with week# as extension. For example customers43 this week. And next week when the package runs customers44 is created. Now I want to insert the data in the partiotned table weekly....more >>

When I create an SQL task, then try to go into query builder, I get the above message. Can any of you kind people offer any suggestions?...more >>

If from a DTS package, you need to combine 2 files to make one, which is the better, more secure way to do it from the following 3 methods, and why? 1) Have an Sql Task that performs the following: exec master.dbo.xp_cmdshell 'copy c:\temp\file1.dat+c:\temp\file2.dat c:\temp\final.dat', NO_OUT...more >>

I executed a DTS that has a list of "Execute Package Task" to execute other DTS in sequence. Checking first if previous package has finished successfully. I do it using workflow. But it does not work when one of the called DTS fails in an "Execute SQL Task". How can I solve this probl...more >>

Hi there, I hope someone can help. I am trying to run a dts package in a stored procedure and check for the execution status of the package (whether it failed or succeeded). The dts package itself transfers data from Access to SQL server. Once this is done, I want to run a query used for a r...more >>

Hi, I'm trying to import an excell file into a file. I cannot get the first line. DTS considers the first line as the name of the columns. I am using a transform data task and even when I put the value 1 in the option "first row" he stil starts importing with second row. Has anyone got a s...more >>

Good Day All, I have successfully managed to write load packages for data from another source into SQL via DTS. I have one 'master' table which needs the following type of transformation though - and being very green, I am struggling to figure out how to accomplish this through DTS: Exam...more >>

Hi, Can I use Enterprize manager and DTS when I only have a professional MSDN subscription? I can't find information about that, and I can't find out how to find/start Enterprize manager. TIA /Daniel...more >>

Hi i was wodering how can i transfer a developed dts package from sqlserver to an installed MSDE2000....more >>

I have DTS package copying from Access 2000 database, from a linked table, to an SQL 2000 table. I can run the package independently, but when I schedule it, it is constantly failing. It is SQL server 2000, has service pack 3 installed. Anybody has some ideas. TIA...more >>

Hi, Can someone help me with the following I get a file each week with different name. Using Nothwind Example. Suppose I get a file CustomersA1. Next week I get the file with the name CustomersA8. This file that I get each week has to go in Customers table . How do I tell DTS that th...more >>

Hi all, I want to import Data from my ACCESS Mdb (NULL allowed) to my new SQLServer 2000 Database (NULLs NOT allowed). The problem is that wenn my DTS-Packages is running I get an error that NULL Values can't be inserted in my table. Where can I place a Function or Script or something to conv...more >>

Hi to all, here are given two queries: 1) SELECT * FROM A INNER JOIN B ON A=B 2) SELECT * FROM A, B WHERE A=B I'd like to know the differences for the server to interpretate the one or the other and, over all, which offers greater performances. Thanks in advance, MadLuke. ...more >>

What is the best and safest way to copy about 55 Databases around 60 GB from a server running win2k to a new server running Win Server 2003 Ent. Ed. What are the different options do i have? Can I copy all the current Db plans, jobs, and Logins? What is a good practice for doing this? The w...more >>

PLEASE HELP!!!!! I have a custom DTS task that I'm trying to manipulate in an ActiveX script Data Transform task. I am grabbing the object correctly, I can modify the Description property fine, but when I try to call an extended method or property I get the above error everytime. I've done t...more >>

I need to move a DB from one server to another, and I'm trying to find all DTS packages that connect to it so they can be appropriately updated and moved. The box has hundreds of DTS packages (not to mention the possibility of DTS packages connecting to it from other servers). Can anybody ...more >>

I found the following comment on Microsoft's website in regards to scheduling a DTS package on a 64-bit SQL Server installation. My question is, do I need to buy a 32-bit copy of SQL Server to store my packages on to be able to schedule them? Currently, I have a 32-bit client installed on one ...more >>

I'm migrating an ACCESS DB to SQL server 2000. I've created the SQL2k DB structure and I have inserted some data. Now I'm migrating all the code, the query and the reports. How can I import the new data in the existing structure I made? I tried with DTS and import wizards but it seems unable...more >>

Need help!! How do I get to FTP AS400 data? My source table is called F091x. I'm really a AS400 newbie, so, what do I ask my AS400 administrator for? They are asking me if I want it exported to a text file now, Do I? Can I FTP the production File? Will it lock the table for other users acces...more >>

I am using a DTS package with quite a few steps to transfer data across the internet from Access to SQL Server. If one of the steps fail, I want all the previous steps to be rolled back. Does this happen automatcially or can I set this up to happen ?...more >>

Hi, I need to add a new managed .net provider to the list of available connection providers in DTS for SQL Server 2005. Is there a reference on how to do it?...more >>

I am using DTS to transfer data from 2 tables However on the destination table the primary key is a uniqueidentifier which is NOT created automatically. I need to create this in the transformation somehow. Is there any way of doing this other than writing a COM object? Cheers for any help...more >>

I get various material numbers like the following: 20890 138902 DEDKL2 XYFGAB Now what I mean by alpha conversion is if the string a purely numeric the left hand side must be padded with zeros if it is alpabetic or alphanumeric the left had side must be left as it is. In the above c...more >>

I have several scenarios whereby within a ActiveX script VB task script I want to open one of the SQL connections defined in the package and read from a table in the connection and also I want to be able to take a value and update into the SQL table. Can you kindly share the VB script code to ...more >>

In one of my ActiveX VB Scripts I want to store an array of values of the following type: 10,AL210,35KG 22,DK218,86KG 34,JK220,98TO I want to store the entire array in a DTS global variable is it possible ? Please provide a simple code segment to write this array into a global varia...more >>

Hello Hari, We are creating Data Warehouse. There are around 50 dimension tables and 9 fact tables. Structure of application is like - One DTS package for each dimension table. (Text file -> Bulk insert Task -> temp table - > Use transform to Load Dimension tables from temp table) - There...more >>

I have a load of VB script tasks that contain something like the following: '------------Connect and open pm table Set Cnn=CreateObject("ADODB.Connection") cnn.Provider = "sqloledb" Cnn.ConnectionString = "Provider=SQLOLEDB; Trusted_Connection=yes; Serv...more >>

Using SQL Server 2000 i export the access db values to SQL Server and i save the DTS package as vb module. then i have modified the module for sql server 7.0 version. and when executing its stoped on this line and there is no error message. Set oTransProps = oTransformation.TransformServe...more >>

I have two seperate databases with different table names and column names. One database runs a client's internal office functions. The other database contains the clients e-store. When an order is entered/modified/ deleted it needs to copy this change to the internal server and vice versa. I c...more >>

Hi, I want to know why after I import a file in a table with 99 rows, I run a query in query analizer and it shows me the columns mount one to another and I can't read anything. I have to move with the bottom scroll a go back and then I can read good. It's a problem with memory? If someone could...more >>

Hi, I have a DTS package that runs and executable after a table copy has finished, the executable opens some spreadsheets and executes macros in them that refresh querytables that rely on the table. I have created the DTS package and it executes fine. However, when i schedule it the packa...more >>

i have a DTS package that executes a JScript using the ActiveX Script task. but how do i pass a value to this script (from SQL) and then view the return value? or is this even possible? basically, this JScript will encrypt a given string using MD5 encryption - so i want to be able to pass a s...more >>

Dear Experts, This is my scenario: an excel file gets mailed to me every morning with transactions from a fuel dispencing unit. This file has the following fields: Record Date Time Hose No. Fuel Type Volume Vehicle User No. User O...more >>

If I have several dts packages(150) I want to run in one job how do I get them into a job manually using their package name instead of the long id number which is generate when you created the job from ...more >>

Hi I am using SQL Server 2000. In SQl Server 2000 and it saves the package to a VB module file. i try to execute the VB module on using sql server 7.0. it wont execute and its not return any error also. The idea is from my vb program the user can able to export all the values (access to ...more >>

I have a package with a data pump task that uses an alias set up in the Client Network Utility to a remote server. The package runs just fine when executed interactively from the DTS Designer. However, when I run this very same package as a scheduled job, it fails on the step that utilizes...more >>

Hi I am using a vb program to Open a package from a SQl Server(obj.LoadFromSQLServer) and then save it back to another server. The only problem with that is that the format of the package(layout) gets disturbed on the new server. I know the thing happening here is that the package is saved...more >>

I have inherited a system that has quite a bit of ActiveX VB script, and I have not worked with it before. Can you suggest a good book/web site that I can use to learn VB script within the Sql Server context? Thanks, Michael...more >>

How can I download Files form http: by DTS (not with ftp) ??...more >>

If I export out a table to a (Text) output file called xxxx.csv and some of the fields are defined dec(13,2). If you open this file in Xcel will that formatting still hold over or will it resort to a text output field. How can I make those fields keep the 13,2 decimal formatting. any t...more >>

In a DTS, I would like to pass a global varible value "TestDdate" to a Execute Process Task(win32 process)as a parameter, then the task call a batch file which rename a file name to Testdate+2004.txt. Testdate is a gloable variable, data format like 1019. How can I achieve this? Is it...more >>

I've converted a dts package saved as a visual basic file into a vb.net project and receive the following error when trying to execute: 'Copy Data from Sheet1$ to [database].[dbo].[table] Step failed. Microsoft JET Database Engine Cannot start your application. The workgroup information file...more >>

A clients SQL Server DTS designer is doing some strange things. When a text file destination icon is added to the designer window and the pump task is added to it, things get strange. When I go to define the columns of the text file nothing shows in the column def area. If I try to clic...more >>

I have a cube with two partitions. One partition is updated daily (once a day) and the other hourly (24 hours a day). There are two separate DTS packages which do the processing. I'd like to be able to process the two partitions in parallel across the two different DTS jobs. It's possible t...more >>

I have a large library of DTS packages (as *.dts files) in a folder. I'm trying to determine which of the "n" files in the folder reference a line of ActiveX code or variable. Clearly, I cant do a search thru Windows as the DTS packages are encrypted. But, does Enterprise Manager have ...more >>

how do i tell my dts package transform data task to overwrite already existing records with new ones? I already truncated the table and am inserting about 80000 records, but maybe 63 of them are duplicates. I get a primary key contraint violation, but i need to have the primary key. On re...more >>

Hi I am using sql server version 8.0 and vb6. From sql serveri have exported access db to SQL Server and i saved the file as Visual basic module file (DTS). then from my program (vb6) i am try to export the data from access db to SQL server its working fine. but my client using sql serve...more >>

Hi, Is it possible to modify the destination table of a data transform task? (to copy table from production environment to pre-production environment) In my development environment, i use databseName.user.table as destination but, i need to change it in databaseNameProduction.userProducti...more >>

After install Windows XP service pack 2, I cannot run the package in the local package. Double click on the package, DLL error is prompt. How can I solve the problem? Regards, Rex...more >>

Hi, Can someone help me with the following I have to automate the process of loading the files from source to target. I have to use partitioned tables which should be created automatically to load the data. These tables should have different name each week(for e.g customers40, customers4...more >>

Friends, My instance of SQL Server 2000 comprises 2 databases (db_1 and db_2). From db_1 how do I link to a table in db_2 so that I can create a View in db_1 that joins the two tables? For example, through an MS-Access ODBC connection to SQL Server, I can choose File / Get External Dat...more >>

Friends, My instance of SQL Server 2000 comprises 2 databases (db_1 and db_2). From db_1 how do I link to a table in db_2 so that I can create a View in db_1 that joins a db_2 table to a db_1 table? For example, through an MS-Access ODBC connection to SQL Server, I can choose File / Ge...more >>

Friends, Our company is running two databases in one instance of SQL Server 2000 (db_1 and db_2). QUESTION: From db_1, how do I link to a table in db_2 so that I can create a db_1 View that is a join between a table in db_1 and a table in db_2? For example, from an MS-Access ODBC link to...more >>

1.In strore procedure: SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="\\10.100.111.111\dd\phoneex.mdb";User ID=Admin;Password=')...CallFlow 2.the system show me information: Mine failed with error: "Server: Msg 7399, Level 16, State 1, Line 1 OLE DB ...more >>

Hi, Can someone please help me with the following I have to create a table & it should have get date() with it. For example Table Nmae: CustomersOct16. I am building a DTS package. Due to large volume of data I am partitoning the Table on weekly basis. Data load comes in each week theref...more >>

hi, I follow www.sqldts.com/default.aspx?225 to setup my client environment. And I use DTSBulkExport that I download from www.sqldts.com to export data , it looks fine when I execute my package within a SQL SERVER and AS environment. But I got below error while executing the same package. ...more >>

Can anybody guide me regarding how should i start going about with DTS ? I mean what should i do first and the corresponding next steps towards learning or mastering DTS ? How many days is needed to completely learn DTS ? Thanks ...more >>

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...more >>

It is easy to create a data source of text file. But when I try to create one in DTS project in DTS 2005 beta 2, there is no proper provider for text file. Could anyone help ? ...more >>

I scheduled a DTS package to run nightly. For some reason, after the package ran and did all it was supposed to do, it just hand there and did not stop. I scheduled the same package on development server. It worked fine. What do I need to check to find out what the problem is? Thanks Lis...more >>

I have 6 database instances across 4 servers running NT Server and SQL 6.5. All instances have the same table design, columns, etc. I would like to dump these databases (should I use a .dmp file?) and import them into 1 instance/ 1 database using SQL 2000 Enterprise. Where would I start? H...more >>

I have exported DTS packages to load onto another network. How do I load th packages into another SQLServer. I can run them against the another system, but (DTSRUN) not load them for modification or see them visually through EM. I'm running SQL 2000...more >>

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...more >>

i have set up a dts to bulk load a xml file from the loacl drive this works fine is it posssible to set the dts to get the xml from a url i.e objXBulkLoad.Execute "e:\xml\saleschema.xml", "http://website/sale.xml" if so what do i need to do in the dts if not if is there a diffent op...more >>