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 >>

I have taken over an app and the previous developer sent me his DTS packages ... no problem ... however, there is one that references a file on a local disk, and with my current setup I have to use a network drive for that file? Will this be a problem? When I execute the package manually it ...more >>

I need to satisfy a file import requirement for an outside agency and I'm needing to do some special things on a couple of the columns. I'm using DTS to pull the data out of our ODBC database and it's default data type to assign some of the columns is char. The agency requires Numeric, Zero-...more >>

Hello, I have created a dts for import a file txt, but when i run it (after 1200000 of records imported) I recived an error "NOT enough space is avaible" I set the DB (Data Files and Transaction log) on Automatically grow file and I have more of 30 Gb free. The Transaction log is truncate and I have...more >>

Hi all, When running a package in msql 7.0 I got the below error but the error only pops out from the scheduler if I run it manually it has no problem. How can i fix this? one more question, What would the most effcient way to copy all tables (data and ddl) from one database to another? DTSRun: ...more >>

All Local DTS Packages were deleted by someone. Can they be restoed? It's a SQL Server 2000. There are a few different databases. All of the databases (including master) are backed up each night to files. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate i...more >>

Is there a way to pass a file path to a DTS Package... I have created a DTS Package that is importing records from a text file into a table. The issue is that the file name will change every day and I want to be able to allow the user to specify the file path.. Thanks in advance...more >>

Hello All Gurus, This is the error message we keep getting on a dts package we are running. This module is in the middle of the package and it has not happened before, we have run this pakcage repeatedly and never have seen this message before. Server: Msg 823, Level 24, State 2, Procedur...more >>

A client is receiving the following error: "[Microsoft][ODBC SQL Server Driver][SQL Server]Server 'MyServer' is not configured for DATA ACCESS." When using functionality of an in house system, which inserts data using an 'Insert Into Select' sql statement. i.e. “Insert into users ...more >>

Hi I cant get the FTP task in DTS to work. I'm attempting to use the task to download a zip file from an ftp site into my database. I've tried doing this directly from the server machine and also remotely. I'm connecting to the ftp site OK becuase I can view and select the files ok. ...more >>

Hi guys, every other night my transform falls over with this error. I understand it means that the data types are not compatible, but I know that can't be the real reason as I just restart the job manually and it works. What's more the transfer is failing in the middle of the table (usually ab...more >>

I need to execute oracle stored procedure from DTS task (EXEC spOracle_Name). The task fail. How to solve this problem ? Thanks....more >>

Hi, I have a database that I was using a very long time ago. All I saved was the .MDF file. I am trying to import this into a new installation of sql server 7.0 using DTS but see no way to do it? How to I get it into my new server? I copied it to the data directory but it doesn't see it. thanx...more >>

i was trying to transfer data from a couple of sql2k tables into oracle 8i database. the process is extremely slow. total 30mb of data transfer was running for 2 or more days, there was no locking problems, servers are pretty good too...etc.... has anybody encountered problem with such slo...more >>

I am attempting to export many tables from one database and import them into another using DTS. Everything went well until I attempted to do this with a table that has a datetime field. I attempted to use the default settings. It failed, "Syntax error converting datetime from character ...more >>

We're looking at undertaking a data migration task that could involve a single table in the source provoding data to two or more tables in the destination as in a master and detail situation. Is it possible to use DTS to do this? From what I've read you can use multiple sources to a single des...more >>

Hi, could i send a filename parameter to a dts via a stored proc and that dts save the result of transformation with the filename i passed via this parameter? Example: I execute spExecutePKGGlobalVariables stored proc and i pass parameter "logFileName = c:\test\test.txt" to my dts. M...more >>

I have this DTS package with several ActiveX scripts. It has been running for a year now on daily basis. Suddenly, 2 days ago, it stopped running. After detailed drill down. I found out that any package on this server with an ActiveX script will not run. To confirm this, I took the same package to a...more >>

I need to create a package that select some data. Puts this data in a flat file then FTP to a server on the internet. I can't find how to get dts to upload a file. Is this doable or do I need to write a scripting option? Thanks Mike ...more >>

Hi I am trying to create a work flow application, where we need to read the data from a database table and push that data into text file. While writing to text file, I need to insert some d4eault values (which are not in my table). I am using a SQL statement given below to select the ...more >>

Hello, someone knows whats happen with this issue please. I have created a DTS package. It just was: Existing connection_1: MySQL ODBC 3.51 DSN: MovingFilesMySQLtoSQL Existing connection_2: Microsoft OLE DB Provider for SQL Server Sql Server Authentication username/password a...more >>

Hi there, How can Execute a stored procedure from DTS, Suppose that my Stored Procedure has some input parameters?And how can I pass SP parameters to DTS through executing DTS? Thanks Elham...more >>

How do i access the DTS global variables value from store procedure ? -- Posted via http://dbforums.com...more >>

I am building a package to move data from SQL 7.0 to an Oracle 9i database. It works, the data gets there but every characted is paded with a leading space. DATAITEM gets inserted like D A T A I T E M. This won't work so well. Any ideas? ...more >>

I have to import a list of contacts for a web project. The table that the program installs allows for nulls in many fields, however, when I import from an Excel or Access DB, it imports a <null> value instead of a blank cell. The program will error on <null> but not blank cells. So, how do I get...more >>

I built & used a dts package to import txt files into existing SQL tables. I ran the package from within DotNet with great success. Now I wish to use this package to perform the same task but allow the end user to: 1) change the path of the source tables 2) change the ServerID, i.e. (l...more >>

Hi there I get in 4 different directories 1..12 Foxpro 7.0 tables (.dbf) which I try to import in 4 different SQL tables . I defined 4 ODBC entries for the 4 different Foxpro free table directories. In the DTS I can define the source via File DSN the specific diectory ( 1 of the 4 ODBC's ) an...more >>

I created a DTS package. The DTS package runs error-free from the SQL Server Enterprise Manager, but the DTS package fails when it is scheduled to run as a job of sql server agent. Error message: c:\test.mdb is not a valid path. Make sure the path name is corrected..... I find in Article...more >>

How can I have a DTS pkg kick off based on a change in the .txt file modify date property. Just like a trigger event. Each time the file modify date change will trigger the package to execute. Please note, I know I can use the activeXscript task to check for the .txt file property such as...more >>

I am currently running DTS packages on two separate SQL 2000 SP3A Server Installations on different machines - one is a NT 4.0 and the other is on windows Server 2000. The DTS packages copy the same Foxpro tables with memo fields. The DTS package running on the NT machine truncates the ...more >>

Hi there. is there a way to change the following DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 2000 Rows have be...more >>

When attempting to execute an Active X component in a package, I get the following error: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Illegal Assignment: 'Main' Error on Line 9 This component is set up to check for a file (wmszz.lgx) and if it exists, p...more >>

Can I run a stored procedure from DTS on shedule. Any hints on how to acheive this. Don ...more >>

Hello, I have a source text file which contains first row header. So in source text file properties i set the skip rows=1. Then i using the transform data task to transform the data into SQL table. But the result is the second row of data was skipped. What was happenned...more >>

Can I have a DTS with the destination being txt and location to save it being a website? I tried this, I found the web site but I was not able to save it? I kept getting an error saying that file coulf not be saved in this location? Thanks. Pat...more >>

Hi There, Can anyone advise me how I can change the password of the owner within a DTS package. I have created one which is owned by 'sa'. Since creating it I have had to change the 'sa' password and I cant get back into my package. If I switch the password back to what it was when I creat...more >>

I intend to run a DTS task from a client machine.. the SQL Server resides on a machine on my LAN. The following are the options that I see: 1. Use the DTS COM library to start DTS at remote SQL Server. 2. Use DTSRUN command line utility 3. Create a job in SQL Server and run the job usin...more >>

Hi, My SAS program creates some tab delimited text files. Can SQL Server 2000 append them into to an existing table with same table structure automatically? Can I set up a schedule to run this task routinely, like the schedule task in Windows environment? Thanks. Mindy ...more >>

Im a biginner at this so please exuse my lack of knowledge. I have a vbs script that works from the folder I have saved it in on server when I click on it but wont run from within a dts package when I try to execute it. Comes back with line 30 the system cannot find the path specified, but if ...more >>

I have three tasks in my DTS package. Let's call them TaskA which on success calls TaskB and TaskC I want to execute if TaskA has failed OR TaskB was successful. The problem is TaskC only kicks off if TaskA has failed AND TaskB was successful which is impossible with my current workflow de...more >>

Hello All, I have a very simple question: I need to produce a CSV file from a database table. The database table has a string field containing 1000 characters. I need to produce the csv file containing this 1000 character field, however there seems to be a 256 character limit per field on...more >>

I am getting this error message from dts when I try to create a new package. Error Source: Microsoft OLE DB Provider for SQL Server Error Description: Unspecified error Invalid column name 'Usertype' Thanks, Aboki....more >>

I am working with SQL 7. I want to transfer sysdtspackages from one server to another. Can someone tell me what the deal is with the Destination tab in the Data Pump Task? I have seen a ton of threads saying that the table name dropdown can be manually typed into, but that doesnt seem to be the c...more >>

I am trying to copy an entire table from one server.database to another. The package completes with zero errors. There is only one problem. The source table has 618,133 rows and the target table has 355,491 rows after a successful completion. (The target table is truncated prior to each ...more >>

I need some guidance with using a fake email address to avoid the viruses and spam I am getting but when I change it in the account settings I can no longer post. How do I do this? Brent ...more >>

Hi, The job which backs up the live database fails everyday. I'm using TSQL to do the backup. I'm not able to figure out the reason why it fails. Please help!!!!!!!!...more >>

Hi, Can I change the schedule of a package I've in the Sql server, using asp / vbscript code? If possible, can you give me some pointers (or a sample code) for the same. Thanks. ...more >>

Hi I have to import a large amount of data from US to UK to update a database daily between sql 2000 server boxes..which method do you think would be best for this thankyou for any suggestions Shaun...more >>

I am reading up on log shipping and failover clustering, and if I understand correctly, for BOTH only SQL Server Enterprise Edition supports these features. I knew this to be the case for failover clustering, but it shocked me to read this to be a requirement for log shipping. Can anyone tell wh...more >>

I'm working on project that need to pass global variables from the main DTS to the sub DTS. I have try to dynamically populate the declared variables. I have used the Inner GV in Execute Package task and also, I have used a VBX script to declare all of the variables. But they came out different ...more >>

Hello: I need to create a package that will take data from my local server Sql2000 and copy it off site to another server. I have looked at DTS but how do I refer to a destination server that is not local? Do I put an IP address? Any suggestions would be helpful....more >>

Hi all I have read in many posts that DTS is not usually used for doing backups (a scheduled job is preferred). However if I want to dynamically change the name of the backup file depending on the date e.g. mydata_september.bak during the month of september and then mydata_november.bak in nove...more >>

It seems the length of the resultant query from a Dynamic Properties Task is limited to 75 characters? Does that sound right to anyone? I am setting a path and file name for a connection via a query in a Dynamic Properties Task. If the resultant path is over 75 chars, the "Display" button in t...more >>

Folks: I have an ORACLE table call SL_SQL_CRSR with the following structure: FIELD1 NOT NULL VARCHAR2(30 FIELD2 NOT NULL VARCHAR2 (100) FIELD3 LONG FIELD4 DATE I am using DTS to get this table into a SQL Server 2000 database. However, during the data transfer, I am getting...more >>

Does any one know how to make LoadFromSQLServer work with packages containing Analysis Services tasks? I have used Windows Authentication, SQL Server Authentication, Power User, ... with no avail. Any hint would be greatly appreciated. ...more >>

I am trying to move data from one database to another (Same server, same database structure) but I get an error both from a DTS Local Package and an 'Table Export'. I have run the query (used to select a subset of the data in the table based on date) with out trouble. When it runs, I get...more >>

Hi, i have a problem. I have a DTS that imports data from an Excel file. The problem is that not all the records are imported. For instance, if i have in the same column 3 numbers and 1 text. The cell with the text cames with a datatype diferente from text and the value is lost (he considers that ...more >>

This is a very basic VB syntax question. How do I add another condition in my IF clause - "AND TABLE1.COL1=X" in the following script? Thanks in advance for your help. Function Main() Dim oFSO Dim oFile Dim sSourceFile Set oFSO = CreateObject ("Scripting.FileSystemObject") sS...more >>

Hello, I am using SQL Server 2000 SP3 on Win2000. From Enterprise Manager, with the DTS import/export Wizard, I have created a dts which copy a table to text file (csv). After the text file has been generated, I want to modify the transform data task (formatting of some fields). As soo...more >>

I have a schedule DTS that will extract data from the Sybase database (ODBC driver) to the SQL Server 2000, here the volume of the data is too high and it will come more than 100,000 records for a single transaction. This is a scheduled task which used to execute at 6.00 PM .. The problem which...more >>