I have imported data through dts. But when viewing the data it is rounding. eg 0.10 is imported as 0 What has happened with the import....more >>

Does DTS support Multi-Byte and Unicode characters ?...more >>

I am executing a sql file through dts. Is is possible to get complete sql execution log (i.e. so many rows updated etc.) and not just step failure reason. Please help me with this. Thanks, pradeep...more >>

I am developing on a test system and I want to transfer several of my files to another test system (at home). Can you transfer a DTS Package from one server to another? Export does not have a utility to select a Package. Any assistance will be greatly appreciated. I would hate to have t...more >>

Hi guys, I wonder How can I build a Store Procedure with two connections? What I need is to develop a SP to backup the SQL DB that's on Internet (Hosting Company, and they do not replicate it, well, not without any more money). DTS does not have any tool to do that, just ADD, DE...more >>

Any idea how can I create a global variable to change the database name in the source and destination tab of the tranformation (the database name part only - my_db.table1 to my_other_db.table1)? I know I can create the global variable to change the name of the database in the tranformatio...more >>

I can create DTS packages on my PC to be stored on another server, but I then try to open it to edit it, the DTS Package editor opens, but with no toolbars, menus and DTS tasks - just an empty white box. My client PC is WinXP, the server is Win2k and the database SQL2000 SP3 Any ideas anyon...more >>

I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from the source...more >>

I have created a DTS Package with the following Lookup named LookupID: select ID from ut_TableName where (PersonName LIKE '%' + ? + '%') The code simply searches for a phrase (represented by '?') and gets all similar matches within the table ut_TableName. I have a transformation (VBScript) ...more >>

I have a package that performs a FTP task to download a file. The FTP step completes successfully but the file is immediately deleted. I can watch the file download, complete downloading and then it immediately disappears. It seems to be associated to one particular file. The file is a zip file...more >>

Hi Everyone, I am pretty new to DTS and am trying to setup a global variable. Basically I want to do the following: 1) Select Max(date) from table into global variable 2) Use global variable in the SQL portion of my transform data task to only select rows that have a date greater than my ...more >>

I had created a package with Two Execute Process Tasks (Each execute Process task bcps the data into separate table) One Activex script Task. Overall the Package Behaviour is Whenever the Activex Script Task is sucessful automatically Two Execute Process Tasks should run in Parallel (...more >>

I noticed that you can save the dts package as a visual basic module. If you do that, how can you execute the code? Do you have to do additional programming or is it a plug-and-play type of scenario. I made a form and included the references for DTS using VB6, but it did not work. In f...more >>

Hi, Do the users have to be OFF the database system when DTS jobs are executed? Please let me know. Thanks...more >>

Hi Everyone Is it possible to execute MS Access Query from within a DTS package. In the connection to the Access database the queries within the .mdb don't seem to be exposed Many thanks geoff ...more >>

Hi I am trying to use transfer database task to move/copy some database from A server(sql 2000 server) to B server (sql 2000 name instance which has SQL 7 as default instance). But, the task failed with "unspecified error" message. I couldn't find more information other than "unspecified error...more >>

--SQL SERVER 2000-- I created a DTS Package to export to a text file and when i execute it on the SQL server itself it works fine. But if i execute it from a sql client workstation it gives me an error that say's "Error Opening Data File: The Device is Not Ready". Hmmmm having trouble fi...more >>

Please let me know how to create comma delimited file and comma tab delimited file from database table. Which components i should use in DTS. Thanks...more >>

Hello, I am new to MS-SQL server and am trying to do something some of you have done before. I am attempting to build a DTC that will run two sql statements in one transaction. First SQL statement-clear the table I am working with delete from APPDEV.IVRtrst Second SQL statement-grab data f...more >>

How does DTS manage large transactions with Oracle? I do understand the isolation levels provided by DTS. But if you are doing a data transformation for a large database, you might end up filling the log space. On way to get around this is to do partail commits. But I was not able to come up with a ...more >>

I need to pull records from a linked server based on values in my local tables. For example I have a table with employee numbers on my local server. These numbers are a very small subset of the linked servers records. I also need to filter on Fiscal_Year, Accounting Period and Cycle. All thes...more >>

Hi All, I have a DTS package that failed on a step that contain the ONLY following SQL command: select idDataSource = cast(1 as smallint) The above select command failed and give me the following error: Syntax error converting from a character string to uniqueidentifier In ...more >>

What is the best way to trace a DTS pkg execution so I can see the code/script for every single step?...more >>

Our production DTS environment includes hundreds-and-hundreds of packages across dozens of servers. We need to be able to do where-used/impact analysis before making a fairly significant business change (a division is splitting in two) Outside opening EVERY package, is there a way to do things li...more >>

Hi, How i can excute a DTS PackPage from a VB application, and also, i have a result in a MDB file, can i change the path of this file from VB?? Is general line, i can change the propreties and excute the DTS From Vb Appication?? Thanks, Diego...more >>

Is there an easy way to grab the number of rows exported from a stored procedure into a text file via DTS & insert the rowcount into a table --- Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/...more >>

Hi All, How can I check that a package exists in SQLServer from vbscript before issuing a LoadFromSQLServer method call? --- my code that doesn't work!! --- Set oPkg = CreateObject("DTS.Package") 'Try to Load Package from SQL Server oPkg.LoadFromSQLServer DTSPackageSQLServer, , , DTSS...more >>

...more >>

Production: SQL 7.0 sp4 Dev: SQL 2000 sp? I want either my named range a.k.a. table or my entire file name to be dynamic via UI prompt. How can I get either from the global vars? I'm sure there must be an asp for this, but I'm too tired to sift through all the material, I'd rather find a...more >>

Hi I'm trying to export a file from a query into a .txt file. This is a 150 character fixed width file. That part works fine but the file is being sent to a bank and they need the first row to be a string of characters that have nothing to do with the data being pulled from the quer...more >>

I'm running a basic DTS of a view, exporting to CSV format. I have several fields that are bit (1) which convert themselves to False/True instead of remaining 0/1. How can I keep the field bit(1) and display the 0/1 instead of text?...more >>

Sqler's I am using SQL 7 and have been for about 3 years. DTS is common practice in what I do. I have experienced an anomoly with DTS. I have a DTS job that runs M-F for the past 3 years. It runs a stored procedure that inserts data into about 12 tables. The stored procedure is wrapped with...more >>

I am using SQL2000. I create a bulk insert task. I tell it to use a format file, click generate, and define the structure of the file. I close the wizard and run the step, and it fails telling me that the format file doesn't exist. I was under the assumption that I was creating one when I pr...more >>

Hi guys how can i open password protected excel files, with a DTS? Can someone give a clue? Thanks Ricardo...more >>

Hi, Any one imported data from Adaptive Server Enterprise version Thanks and Regards Sachi...more >>

Hello SQL Gurus, There are 3 tables x ,Y AND XY i.e., X is one Dimenstion table Y is another Dimension table By Joining the Row and the Column dimension table we get the cell which we need to check in the XY table whether that data exists or not If it exists then display the descript...more >>

Hello, What is the diference between calling the DTS library from VS .NET by addinga a reference to the COM object and creating a RCW yourself and then reffering to that? DOes .NET build a RCW for you behind the scenes when you select the COM object in the references? What are tbe benefits a...more >>

I am new to DTS, and I want to use DTS to schedule a simple task: every 1 hour, insert a record (empid, name) to the database. I just try to get a feel how DTS scheduling works. For example, 1001, E1 1002, E2 1003, E3 //etc... I open Enterprise Manager, and click DTS, and right click Loc...more >>

Hi, I have created some DTS Packages in the SQL Server. The SQL Server is shared between two projects. I need to give access to DTS packages of Project A for only Project A users and similarly for Project B Users. Please let us know how can i give partial access rights. Regards, Sanka...more >>

Managing Multiple Excel incoming files? I have this situation. I have a client which have several locations they work primary with excel forms and they are thinking in doing reports with them. What they want is to import those Excel files into SQL Server for later using crystal reports or...more >>

In a dtsrun command, is it possible to encrypt only some of the dtsrun parameters, but not others? I can only figure out how to do the entire command. I'd like to generate a command that contains explicit values for the server name and the DTS package name, but encrypted values for the u...more >>

HI, I'm not able to run my package when I prepare it for transactions. Case: I have 5 packages and each of them have some 6 to 15 Tasks and each package has 'Use Transactions' property checked and each task has 'Join transaction' property checked. I run all these packages in a mother pack...more >>

a file that runs a series of FTP commands. I created a textfile that has a series of FTP commands in it and I would like to know how I can use DTS to run the commands in the batch file. To run from a command prompt, ftp -s:filename but how from dts and using what object or process?...more >>

I have a list of job numbers in a SQL table. I want to write a SQL statement that can be dropped into a DTS component that will use the job numbers in the SQL table to down load data from DBII. How can I accomplish this? Can I create a "Join" between the two tables? Do I need to do a transaction...more >>

1. A Package Object Browser that truly allows you to browse objects to the same degree as disconnected edit. It is a real pain to have to jump out of an ActiveX script editor to check properties and values. 2. Speaking of the ActiveX script editor, it sucks. It needs to have the features of an...more >>

I'd like to generate a "partially encrypted" dtsrun command (only the user name and password). We want to end up being able to specify something like: dtsrun /S ServerName /~U encryption /~P encryption /N DTSPackageName If this is possible, how is it done? Thank you! Susan Jones...more >>

Problem: When trying to load a large text string > 250 characters into a varchar(5000) field in my SQL Server 2000 destination database (using either an Active X transformation or copy column transformation) from an Excel or flat-file data source my data is being truncated. Only the first 248 chara...more >>

Hi to all I'm relatively new to DTS. How can I call a DTS from another DTS I'm running SQ Server 2000 Thanx in advance ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collec...more >>

Hi, We are getting the following error when our users try to generate a report- that makes a call to a DLL whose function calls a stored procedure to retrieve the results. The DLL is a componenet registered with MTS and called at the end of a trigger in a MSMQ Error: [Microsoft][ODBC SQ...more >>

I need to migrate (or export and then import) a db from Lotus Notes to Sql... Please, help me !!!!...more >>

Hi there Is it possible to reference global variables in an 'execute SQL task' in SQL Server 7? I know you can use parameters in SQL 2000, but is there another way round this in SQL 7? Thanks a lot Lewis Veale lewisdotvealeatpdms.com www.pdms.com *** Sent via Developersdex http://www...more >>

OK here's the situation: A file is created by Paradox and exported into a text (.txt) file. The text file get's uploaded to a remote server on the Internet. The text file is then FTP'd to my local computer. From the text file (50-100MB) of raw data which is separated by a pipe (|) w...more >>

Hi, Can anybody help me with this: - I have DTS package that processes a cube, I added a Dynamic Properties task in order to set the TreeKey property of the DTSOlapProcess. When I run the package I get: - Need to run the object to perform this operation code execution exception: EXCE...more >>

Hi, I am executing a DTS package from asp.net. It works successfully when the code and PackageEventsSink class declaration is in the aspx file however when the code is compilied into a dll I get the error 'Execution was canceled by user'. Does anyone have any ideas as to what the problem co...more >>

I would like to set up a send mail task in DTS which will send out an email notification after certain step in the DTS has been processed successfully. I am not using Microsoft Exchange Server and I don't have the Outlook client installed on the server. I would like to send the email out from an ...more >>

Hello, One of our 'clients' needs data in FoxPro readable format. They insist it has to be .dbf file. I am trying export one table to a new .dbf file. I don't have FoxPro installed on my machine nor Server, but I do see a few FoxPro drivers including MS .dbf driver. I wasn't successful with any ...more >>

Hello, I have installed a Unidata ODBC driver on a machine that is running SQL Server 2000. I'm able to use the driver without any problems when using Access. However, when I try to create DTS package in SQL Server that uses the driver, I receive the following error: [MS Design Tools] ...more >>

I have a process where I need to create a fixed length text file with a header section, details section, and a trailer section. I created a DTS package that created the individual sections, then from a job created for the DTS concatenated the three files together and ftp'd it to a mainframe. T...more >>

Can Analysis Manager register a server if it is a workstation?...more >>

How do you print the fieldnames and datatypes in a table? I know there's a way because I've done it...but can't remember and don't see an option in the menu choices...thanks...Jan ...more >>

Can anyone help I am trying to perform a select query from within VB connecting to a SQL Server 2000 database. I am trying to select and in the where clause i want to search for a date. The field 'MyField' in the database is set up as a datetime data type. See code below. --- dim rs as ...more >>

Does anyone know how SQL server generates this? DTSRun /~Z0xADB5ACC91DC1EB08C959BF14EE8478FD732FF12B2A60317 E5EDD8B399B79B6BAA4609F7E63EC647194E7997D96F8644B5FEDD91679 FC7BC079F528FD40405E194771E38C8D1B576C3F982A78C2CBFB6833396 2569C5681C800B4B72F23409447F047EAFF8865C3A875948A ...more >>

Hello. I am a newbie to XML. I have been given a large xml file that I need to import into sql server. I have access to sql 7 and sql 2000. This file is in a format I have never seen before, and do not know where to begin. Here is a sample of the file. I have removed the values f...more >>

how i set the schedule job to run dts job ??? i 'm the beginner of sql server please help me ...more >>

Can anyone show me how to perform a DTS.TransferObjectsTask which does not strip white space from stored procedures? When we move the tables, structures, indices from an init db to a dev db all white space (blank lines) are lost. We end up having to use SQL Programmer to copy/paste the sp's. We ...more >>

We are trying to access some AS400/DB2 tables using Link-Server o SQL-Server 2003. The actual query is part of a DTS package. For accessin the tables 'DB2OLEDB' driver is used, this driver is available as part o the Host Integration Server - 2000. Following are the versions of all the drivers e...more >>

I have found very strange problem - it seems that if you create a table in the Enterprise Manager (for example, in my case the table name is MyTbl) and accept default primary key name (which in my case is PK_MyTbl and I like it), when you try to generate a script for this table, the script...more >>