Hello Ng, I've a problem with a user defined DTS Task which is not self-developed. When I register the task, everthing is fine. I can use the task, and it works fine when it is executed in my package workflow. But when the task is part of a package that i want to execute with "Execute pack...more >>

Hi I'm trying to start a dts package from an active-x job in sql server agent (sql 2000). The script looks like this set oPKG = CreateObject("DTS.Package") oPKG.LoadFromSQLServer ".", , , 256, , , , "doimport" oPKG.Execute oPKG.Uninitialize() Set oPKG = Nothing ...more >>

Hi guys, I've been trying to load in fixed-width text data into my data warehouse, but the data occasionally has errors in one field. ( It's supposed to be an integer and the OS/400 system that generates the file randomly puts in alphabetic characters. This causes the load to fail as the stri...more >>

Is there a way to turn debugging off in an ActiveX script? I get an error when I run this job. I want to run it as a job and it hangs. I want it to fail and report an error. It runs ok sometimes. If fails when it tries to run the macro: A debug window appears. Can I turn that off in the ...more >>

I apologize if this question appears multiple times, but my posts do not seem to appear after I click Send. I have an existing SQL Server 7.0 and will be upgrading to SQL Server 2000 on a different box. I need to get the packages from 7.0 to 2000 without having to open each one manually a...more >>

I'm working on WIN 2000 - SQL SERVER 2000 I've to import some files that are uploaded into a folder These files comes from a UNIX machine and they are zipped I've tryed to do a dts package and tryed to launch a command line to unzip them with winzip, bzip2 and 7zip utility but I can't decompre...more >>

Hi, I've created a DTS package that reads data from a source text file and then a task inserts that data into a table within a SQL server 2k database. Now the name of the source will change daily, so I've written a little program in VB that changes the data source property of the source file co...more >>

Please help. I am trying to document set of processes that move data between data stores. Unlike a simple Dataflow diagram, I need to be able to show how a process maps fields in one data store to a calculation result or field in a separate data store. Does anyone know of a tool with this k...more >>

I have a strange situation: We have a number of DTS packages that run nightly on our server and two nights ago the 'Transform Data' tasks stopped working. They've been working fine before then - we haven't had a problem in months. We copy a number of DBaseIV tables into SQL using the ...more >>

I am trying to copy some database objects from one SQL Sever 7 database to another SQL Server 7 database on a remote host. I get the error message 15022 "The specified user name is already aliased". Can someone tell me how to find out which logins or users have aliases? Thank you. ...more >>

I have created a DTS package which copies data from a table on server1 to a table on server2. The data is being overwritten. If I execute the package everything works fine. However, if I try to schedule the package via a job the table is left empty, i.e., the old data is being deleted...more >>

Hi! I am getting an error while trying to run Active X script below is what I am have in code. I am trying to read weblogs and from Active X but it is erroring out at oTaskProps("SourceName").value = "BlankSite" oTaskProps("SourceType").value = 0 All it sayis is "not implemented". Can anyo...more >>

Hi! I am getting an error while trying to run Active X script below is what I am have in code. I am trying to read weblogs and from Active X but it is erroring out at oTaskProps("SourceName").value = "BlankSite" oTaskProps("SourceType").value = 0 All it sayis is "not implemented". Can anyo...more >>

Hi, I need to duplicate the data in MS SQL Server into IBM DB2. The first step is to export the SQL DDL from SQL Server and import the DDL into DB2. Of course, this does not work if I don't convert the exported DDL to be compliant with DB2. What's the easiest way for this DDL conversion? ...more >>

I have an w2ksql db running on a shared server,. I have been asked to use RPC calls into a NON MS server to Upload orders and download stock reports. I dont have a clue where to start, can anyone sugest some direction to go in either research or samples etc.. They will give me a login and passw...more >>

I am using SQL DTS Messge Queue Task to send data from ComputerA (Domain A in Forest A) and Computer B (Domain B in Forest B), even I've set the MQ in Computer B to let anonymous / everyone can get propertye/permission & write message, and Domain A & Domain B trust both, or even I set the MQ in ...more >>

Currently I've constructed a job that selects values from a table and in an activeX script take the recordset and constructs a comma delimited string of integers. I'm then putting it into a global DTS variable of type string. I'm trying to use the string as a parameter in a subsequent DT...more >>

In a bit of a n00b jam. I need to get 5 variables from an html document to a text file. The variables come in through VBScript, and are then handed over to JavaScript for some processing (I can't change the processing). Since JavaScript won't output to the file, I'll probably have to hand the va...more >>

I'm working with SQL Server 2000 I have a folder on a webserver containing some files (the names of these files are unknown) I need to created a DTS package that retrives all the files contained in this folder and put them in local folder I've saw that FTP Task let me specify a list of f...more >>

I'm trying to import about 2 milion records to a database,=20 but the transaction log grows a lot(1 gigabyte as least). Is there anyway for me to import that amount of records=20 and truncate the log at some point, so that it doesn't=20 grow bigger then 300 mgbytes. In the database properties, ...more >>

Hello. I have a DTS. I execute this and this is OK. But whe I create a job with this DTS, this don't Work The message is: DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147221499 (80040005)...more >>

First I'm VERY green with DTS. Second SQLDTS.COM kicks butt, I've been able to use their examples to get close to what want. The problem that I have is that there is a potential for a client to drop multiple files per day in a directory for me to process. file name is like: <client_ID>_<yyy...more >>

Hi, I am trying to transfer records from 6 tables to another server. The second server has same table structure as source server. The number of records to transfer will be around 100,000 per table. So I want to write a DTS in VB.NET. Can anyone provide sugestion on how to do it. Th...more >>

I am getting the following error message during vb.net (I believe the DTS package is written in VB6) execution of a DTS reference object: An unhandled exception of type 'System.InvalidCastException' occurred in Deployment.exe Additional information: Specified cast is not valid. Here...more >>

I try to import database from one 7.0 server to another using Import/Export Wizard and I'm getting error message: "the license for the installation of SQL server on your destination connections does not permit the use of DTS to Transform data. See your license agreement for more informat...more >>

Hi, I have a job, and execute exec sp_start_job @job_name = 'CARGA AVIATUR' this generate a error Server: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'sp_start_job'. My SQL is 2000 Why Thanks for help ...more >>

Hi, I have to migrate a project with back-end in Access 2000 to SQL server 2000. I am using the Upsizing wizard in MS Access 2000 to convert the tables in Access to SQL and the Import and Export Data wizard in SQL to convert the queries in Access as Stored Procedures in SQL....more >>

Following is the script I need to write and I don't know how to do create the global variable and set whatever I need to have to make this script run. I haven't even been able to parse it. What i want to accomplish is very simple: if my_table.col1='X' the execution is successfull otherwise...more >>

Which is most effective (consider the query below for an example)? Please give me some explanation (FMI:) as to why one is faster over the other. --Both Queries are designed to get the users information of users that received passes in the Year of 2003 --** *************** --** Q...more >>

Using SQL 7. Attempting to run DTS Wizard. I right-click on a database, click on 'Import Data', get following message: DTS Wizard error: cocreateinstance. The specified module could not be found. I can then start the wizard, but after I've selected SQL ODBC and click on the down arrow...more >>

How I could solve this issue We would like to configure only administrator to view site settings, and manage all the services, and view other users folders The issue is that all users have those privileges and they are not administrators...more >>

I have a column that requires a transformation that strips out the dashes in an account number if they are present. So if it's a number like 200-01-00 it will convert to 2000100. I'm already using Cast to Zero fill and right justify this column. Help appreciated. Thanks Frank *** Sent...more >>

I'm working on this DTS package and one of the columns requires length 10, Numeric, Zero-Filled, Right Justified and no decimal point. I have the zero-filled, right justified stuff down with the cast function, but how do I trick the data into displaying without a decimal point? Help appreciate...more >>

I have a DDQ where I am transfering the data from SQL to AS400. After the DDQ is exists I am updating flag to as success. If row fails I need to change flag to diference value then if row get transfer suceesufuly. how do I do this?...more >>

I have just added a W2K server running SQL 7.0 to a domain. The domain already has 1 W2K server also running SQL 7.0. There is a database on this first server that I am trying to export over to the new server. I am running the DTS wizard to export but am failing miserably. I am using the...more >>

I have a DTS package where I execute sp in Execute SQL Task Properties and then on sucess I have execute process task. When I run this DTS manually it executes fine, but on a schedule it fails with the following error: Step Error Source: Microsoft Data Transformation Services (DTS) Package...more >>

Hello there, I have designed a package that retrieves data from an Oracle 9i database and inserts it into a SQL Server 2000 database. The package contains 12 Tasks/Steps, 6 of these drop and create the destination tables in the SQL Server database, the other 6 transfer the data from Oracl...more >>

When opening a DTS packahe in design view I am getting an error " The Parameter is Incorrect". I am connecting to SWL Server remotley. Any help/ideas appreciated. Thx...more >>

I have a DTS that has workflow paths for "on failure" to take certain actions. When I run it from the DTS designer it works correctly. When I have the SQLagent run it, it always stop executing the DTS package when it hits a "on failure" workflow path. Is there some setting I am missing so tha...more >>

I executed the sp in execute SQL task and would like to store the output parameter values into global variables but it didn't work. But if i run in Query Analyzer, i returned the correct values. Why it didn't store to GV ? My SQL statement in Execute SQL Task: DECLARE @AccountBatchLog bigi...more >>

SQL 2K Using Active X script , created the source SQL statement for data-pump task and it worked. Inside Active X script I am looping thru to change the source SQL statements, how can I again execute this data-pump task. When I look the source SQL in data-pump task it got changed , but data-p...more >>

SQL 2K DTS is in ServerA Using Active X script, I changed the source for my DataPump Task. Now the source SQL is 'Select * from ServerB.mydb.dbo.mytable' , When I click transformations tab, error message "Login failed for user '\'" From ServerA, I could successfully able to execute Sel...more >>

Hello, I have a package that I start by deleting all of the rows from a bunch of different tables. Is there a good way to roll all of the SQL statements into one icon? I'm tired of having a dozen ExecuteSQL tasks cluttering up the beginning of my package. Thanks in advance, Sean ***...more >>

Hello: I am trying to run the following query: SELECT tblBids_JobID, tblBids_BidDate AS BidYear, Sum (tblBids_BidAmount) AS BidSum FROM tblBids INNER JOIN (Select tblBids_1_JobID, tblBids_1_EstimatorID, Min(tblBids_1_BidAmount) as MinBid FROM tblBids_1 Group By tblBids_1_JobID, tblBi...more >>

We have a package running in one of our servers, when ever I try to save to other linked proofs server, using the Save as... option, it is succesfully saved, but when I want to open it in the new server, I receive the following error: Error Description: The DTS host failed to load or save the pa...more >>

I have a DTS program that updates a table inside a AS400 system, this program runs from 3 machines on my lan. For a unknown reason teh program deos not function properly. It starts and does nothing, it does not fail nor end, it just stays running. The 3 machines run SQL server 2K on Win 2k server, ...more >>

Hello, I have created a trace file using sp_trace* procedures, and the trace file is created and logs the relevant events. What I now want to do is to create a DTS package to read this file and export trace data to a table in a SqlServer database. I then want to filter the data in the trace...more >>

Hello wise ones, I am engaged in a (perhaps misguided) attempt to use DTS to do some complicated data compilation, calculation, and processing. I have made a DTS Package that has about 20 simple queries and a few simple ActiveX scripts. The process loops many times, or at least it trys to. ...more >>

Hi, When I execute DTS from a COM component, it is giving an error "Cannot open database in requested Login. '<not displayable>'. Login Fails" Any reasons why ?? The COM component is run in the context of administrator. Deepu ...more >>

Hi I am using workflow desiger to create a DTS package, wich reads the data from a database table and stores it into a text file. Its working fine, but each time, it overwrites the existing text file. But I need to add an additional condition, where I have to check for the existence of text file an...more >>