Hello! I have this ActiveX script, I need to pass these two files names check and if they exist before I move onto a next dts task, but I am having trouble checking both within the Main function, is there a way to pass two file names as parameters to a function and have a the the functio...more >>

I have a job transforming a foxpro database into a sql server database. When I run it on our production SQL Server, it fails; when we run it on a user's local SQL Server, it runs with no errors. The job FTP's a file, unzips it, then executes a transformation task. We've had problems wit...more >>

I have seen many examples of ASP and DTS package, however once I try it from the web it is crashing , I am trying just a simple package that moves an excel doc to a Sql server table. Works thu enterprise but not thru web. Does Excel need to be installed on Web server, am I missing a ODBC or...more >>

I know i can use a DDQ to Inset and Update records in a table from a text file, but can i do both at the same time. Col 1 = Licence Col 2 = AccountId Col 3 = Company Name How can i Update the Company name if the Licence and AccountId are found and Insert Licence, AccountId and Company ...more >>

Hi - I am having a problem backing up my database on my host, onto my local instal of SQL Server 2000. I am using Enterprise Manager/DTS: I use "Copy objects and data between SQL Server databases" And on the next page I activate: Create destination objects + all 3 sub options + copy dat...more >>

hi, first, i apologize if this is not quite the correct newsgroup for this question (feel free to point me to another one.) I notice that databases seem to be stored in: C:\Program Files\Microsoft SQL Server\MSSQL\Data -- in two files, an MDF and an LDF. basic question. can i just copy th...more >>

I am using DTS to import csv files that I receive from a third party. Each day I receive many file which I import into many different SQL Server tables depending on the name of the file. I am doing this as part of a larger automation process written in C#. Due to the csv file names differing ...more >>

Why does DTS always break when copying all objects and data from one database to another? It doesn't seem to matter which version of SQL Server, which server, which server OS, which settings, which anything ... Title Bar: "DTS Import/Export Wizard" Message: "Failed to copy objects from ...more >>

The DTS program manager had this to say about the behavior back in July 2000. http://www.winnetmag.com/SQLServer/Article/ArticleID/8776/8776.html "The Microsoft DTS program manager says pVarPersistStgOfHost is a stream of the layout from Da Vinci (the graphical database viewer you see in A...more >>

I need to import any paradox tables in SQL Server 2000, but i'm having troubles with char conversion: Does anyone have any idea about why all accented chars in source paradox table turn into other chars in the new SQL Table: à in paradox turns into Ó in SQL è " " " " Þ ...more >>

I have a database with multiple tables. I perform 2 mass imports a day on the tables from a txt file. None of the columns are labeled or are in order so I cannot use any command line utitlies for the import. I have the import working in DTS, but I DO NOT WANT IT TO LOG THE TRANSACTION...more >>

Greetings, I'm trying to determine what the best way to go about the following would be: 1. After making modifications of structure and data to a production database, I want to make a backup of that db and copy it to multiple standalone machines to import for further use as part of a sample...more >>

Here is the situation I have: I am using DTS to convert a table T1 within a SQL database to another table T2 within the same database. I am using SQL Server 2000. Table T2 has a column t2_productid which has been specified as an index so that the values within this column are unique. N...more >>

We create lot of DTS in our server. Is it possible to make the DTS read only? Thanks for any advices...more >>

I have been searching for a method when using a data driven query that would enable me to insert multiple row from a single input record. Has anyone managed that process? TIA -- Ron ...more >>

(Type your message here) I have setup a DTS package that has 2 package tasks setup to run= one after another with the work process setup to do the next= package task only upon completion/success of the first package= task=2E Each package task has a SQL job to be executed that= basically exe...more >>

Hi All: I have a DTS package with a global variable. I was wondering what would happen if two different users run (VB.NET) the package at the same time and each sets the value of the Global Variable to a different value. Regards, Saeed ...more >>

Hi I am having trouble with a DTS package, it runs fine when I execute the package by right clicking on it in the enterprise manager under local packages and select execute. However if I schedule the report it always fails. Or if I run the schedule it also fails. I would have though it wa...more >>

Is it possible to interface DTS processes to pull data out of SQL Server and send it to Active Directory? ...more >>

Hi there, I am currently creating a DTS that will run another dts in a loop. I was surprised by the fact that i cant change the child global variable because it already exists in the child DTS. And thats true... when i created the dts i put a value for default into that global variable becaus...more >>

Hello All I have built a few custom DTS tasks in VB 6.0 and they all work well on Windows NT/Windows 2000 running SQL 2K. Now I have a SQL 2K system on a Windows 2003 with the .Net Framework. I did a regsvr32 on the same custom tasks and registered them within the register task and I drag and...more >>

I have the following setup: a) IIS, Sql Server 2000 all running on my laptop (WinXP). I am running ..net 1.1. b) I have a DTS package. I can execute the DTS package directly from within the Enterprise Manager. It works correctly. c) I have an ASP.net application which attempts to load...more >>

Hi there... I have uninstalled a MSDE version but there were some DTS packages on it. Anyway, the Data folder remains in my computer. Is there anyway to restore these packages in a another server/instance? Which databases are needed to recover them? Thank you very much... Eduardo ...more >>

I'm sure this can't be that difficult to answer, but how can you open a DTS package when the password has been forgotten. Extensive searccing of the Net has turned up plenty of suggestions, but still no joy. Any ideas, anyone? TIA Glen...more >>

I am extracting from Sybase into a SQLSERVER 2000 table. How do I goverride the sql governor within the pump step. The error I'm getting is Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): The query has been canceled because ...more >>

I need to copy the data in two spreadsheets into two tables in "SQL Server 2000". Below are the details: One spreadsheet contains the data that needs to be added to an existing table in SQL server. All field names in the spreadsheet match the DB table column names. Another spreadsheet c...more >>

Hi, does the "auto update stats" feature of statistics as an impact of the performance during bulk insert operation? Does it recommended to disable the auto update for the stats, and manually update these stats at the end of the loading process? I'll load 6millions of rows every day : ...more >>

Hi, Does it possible to load data directly into a partitioned view? or I must fill each table behind the partitioned view myself? For the moment I receive the error "partitioned view "myview" is not updatable as the target of a bulk operation" I've searched on google without any clear so...more >>

Hi, I have two questions that I have no idea how it works. 1. I created a stored procedure that returns a value after execution e.g. Create Procedure try @output nvarchar(50) output as .... return how am i able to get the output value from the stored procedure using DTS, I do it in Execute...more >>

Hello, I have to migrate database from one server to another, moving database is easy part and all set for that. I have about 40 DTS package running on server and wanted to migrate all DTS to new server .. My problem .. 1 ) Is there any way I can copy all DTS packahe to target server ...more >>

I have a table that I'm loading via .txt file input. One of the columns has a datatype of datetime. It does allow nulls which I've checked by simply adding 1 record via enterprise manager with no value in the field. When I execute the DTS package, I get "conversion error: Conversion inval...more >>

At least it is tricky for me. I am using DTS to import a csv file daily into a table. The only problem is that the csv file that is sent contains a bit of HTML at the beginning and end of the file. Example CVS file: Complete!<br><PRE>123, fish, paste 321, krabby, patty 987, conch, shell<PR...more >>

Hi, I've created a DTS package which opens a connection (Microsoft OLE DB Provider) and save a .txt log file (Text File(Destination)) using the Transform Data Task. On success it supposed to execute a VB.NET application (Execute Process Task) which is in the C:\ directory. So with in...more >>

Hey guys, I've got a table I want to import from a linked server along with all the data any idea how to do this. Also, is there a way to commit the transaction every 100,000 records during the dts process? Any help is appreciated....more >>

I want to set the current system date in a global variable and then user that variable in diiferent SQL Execute tasks. How can I do this ? My Database is basically the Oracle 9i and I am using DTS Packages for ETL. I am using Microsoft OLE DB provider for Oracle. How can I set the current sys...more >>

I am not able to create DTSLookup function. It gives me error as given below. -------------------- An unexpected error occurred. [MS Design Tools] - Unspecified error ---------------------- -- Regards, Satya spvedula@softhome.net ...more >>

Has anyone tried deleting an SQL Login that is the owner of one or more DTS packages ? Does this have any effect on those packages ? Like deleting them for example ? I want to do a cleanup of some unused SQL logins, but I really don't want to lose a bunch of packages especially on my pro...more >>

Hi, I'm trying to solve the distinct count problem, but don't know hoe to apply it to my cube. Basicly - [Fact Table] linked to a [link table] thats linked to a [Dimension] table like [Purchase] ------ [Purchase to Product link] ------- [Product] Is this way ok, or is there a be...more >>

All, Background: I have an MS Access 2000 DB that launches a DTS package in SQL Server via VBA code. (N.B. The SQL Server is the back end for the Access DB.) The two applications both sit on the same server and when the Access db code is run directly from the server the DTS will run fin...more >>

Good morning- I am trying to accomplish the following. In my lookup, I need to find a value in a column(Store) when either the Store_Code or Store_Code_Orig column value match the variable passed through the lookup. I have this and it works for one: SELECT STORE FROM K_Co...more >>

I am using SQL Server 2000. The local computer is XP the remote one is W2003. I am the admin of both machines. I want to move data from the local server to the remote server over the internet, using DTS. Where and in what format should I declare to DTS the remote server. Thanks, Dan ...more >>

Hello, All! I'm implement custom task on VB6. This task work well. But different users on the same server report errors concerned with this custom task. If user A register task, it can use it without problem. But user B on the same machine can see this task in package, but task raise e...more >>

I've been able to import tables successfully from Oracle to a SQL Server database. However, when I try to import views from Oracle it wants to import them as tables in SQL Server. Any ideas how I can import views as views from Oracle to SQL Server?...more >>

can i setup an ftp task to send data to an internet site? when i invoke the ftp task the only option for the 'to destination' is a directory?...more >>

A relative dts/sql newbie and just seeing if anyone has any ideas... Basically I need a task in my DTS package to check if there are any non-alphabetic (anything that's not a-z) characters in the first name and last name fields of a table, then bust off an email if there is. I'm not too ke...more >>

I wanted to know if there is a option in DTS where I can copy new data in a table from the source DB to the destination DB without haveing to set the "DropDestinationObjectsFirst = True"? What I want ideally to happen is for DTS to find the changes between the two tables and copy up only the ne...more >>

Can I use DTS to transfer data to another sql server 2k? During DTS transfer, can sql server allow user to insert data? If so, would the databased be crashed by DTS ?...more >>

Hi all I'm trying to get 3 single integer values into a datetime field on my sql server. I'm using DTS ActivX Script Transformation and Visual Basic. When I test the Script i get the correct datetime format. But when i then go to the table on the sql server my date is sometimes in the wro...more >>

Hello dts-world, i am using sql server 2000 and would like to send an=20 outlook appointment / outlook meeting request to a exchange server 5.5 mailling list (?distribution list).=20 Since I already have a DTS-Package which is able to send e-mail, i hope that sending an appointment request ...more >>

How do you implement data warehouse using DTS in SQL 2000 server? ...more >>