I want to use Script Component in DTS 2005 to transfer data. But I don't have any document or sample script to solve it. Pls send to me some. Very urgent, because my project maybe fail in next week. Thanks...more >>

If transferring multiple tables between source connection and destination connection I can create these connections once and then define multiple tasks between those two connections, but I don't appear to have any control over sequence or "only do this if this other has succeeded". If I create...more >>

Hello: I have a DTS package and it will call a .exe file in Execute Process Task. I need to catch the return code from the .exe after it executs. However, the Return Code in Execute Process Task is what the DTS step will return if it's successful. So how can I catch any retrun code from ..exe...more >>

I created a custom DTS object that does its work by calling a webservice. When you create the object in DTS, it lets you set the user/pw you want to use to authenticate to the webservice. The problem I am having is that once I authenticate to the webservice within DTS, it always uses the same ...more >>

Greetings from Serbia, as subject saids, does anyone had expirience with it? I need to find a way to export a database, with all tables, and relations if it is possible to a one or more txt files. This is my first task in this new company (http://www.netcomp.co.yu/) and only idea which I have ...more >>

I have to pull in some data from a huge table on another server. I have a local table containing the acctnumbers I need. But, I cannot figure out a way to bring in only the records having an acctnumber in the local table. I have tried to configure a lookup, but that doesn't work to filter t...more >>

I have 10 csv files with different names in c:\mydirectory\. I created global variable "ImportFolder" which has value "c:\mydirectory\ LDP_*.csv" files names are LDP_aaa.csv, Ldp_bbb.csv, LDP_ccc.csv ADP_aaa.csv, ADp_bbb.csv, ADp_cc.csv. .... My question here is i want to import onl...more >>

Hi gurus, When I try to use ActiveX script to load a DTS package from one server (package.LoadFromSQKServer) and then save to another server (package.SaveToSQLServer), I can succeed in doing this but the layout of the DTS package on the destination server is totally trashed. Anyone with excelle...more >>

I want 10 packages to run in sequence. I was told the Execute Package Task would do it but it looks like it can only call one other package. I want it to call all 10 in order. Am I missing something Thanks, LP...more >>

Hi, I'm new to DTS and am trying to work out the best way to approach a task. I was wondering if anyone could advise me? The situation is that we have a folder which, every few hours, will have a number of .csv files deposited into it, which will all have unique filenames. What I need to do...more >>

When i am importing a foxpro table, linked by ODBC, i have a problem with date field. The definition in foxpro is standard date. The program is from a third party, so everything is defined and we cannot change anything. We want to analyse a lot of data with crystal report in SQL server. ...more >>

Allan, I wanted to get definition of a table dynamically from source whenevr it runs, source is a file system , it has odbc driver to support the file system. when i run manually thru wizards it is creating table and loading data. when i save the package, create table script is saving as sql s...more >>

I'm trying to load data into an Access table that has an autonumber field. The message "There is no column object mapped to the non-nullable column CityID in the database". Is there a way to turn off this validation? ...more >>

I have an Oracle table which has about 30 millions rows on it. I have a SQL table which has about 20 thousand rows on it. I want to pull from the Oracle table the corresponding rows from the SQL table. Would I use DTS for this? Is there a way for me to join the information from these two t...more >>

Hello Friends, I have created a DTS package and created workflow connections between my different tasks. I also changed the default Task and Step names as per my conventions. All of the individual steps execute fine. However, when I try to run the package as a whole, it stops afer the fi...more >>

Hello All, I need to run an external command (secure ftp client) that will return a 0 if successful or 1-8 to signify different error conditions. My DTS job will need to branch according to the specific return code. I spoke to MS support and they tell me there is no functionality in DTS t...more >>

I am trying to import an Oracle table with CLOB datatype. The ODBC and OLEDB drivers does not provide this functionality. Is there any way to import the CLOB data? Are there any ODBC drivers(preferably free) that can provide this functionality? Thanks in advance. ...more >>

I'm wondering what the best approach to this would be.... I have an Excel spreadsheet that users update and then save to a common area on a network drive. I then need to get the data from the Excel spreadsheet into a SQL table. Once the data is in the table, I then use some matching softw...more >>

Hi, I'm trying to extract data from an Oracle 8i database to convert it to SQL Server and I'm having a problem with one table. This table has a CLOB column (text in SQL Server) and I believe that this is the problem. I'm using DTS and I've used both the ODBC provider and the OLE DB provider...more >>

I am pretty much a novice on DTS, I have used it on very simple extractions from Access to SQL. I am wanting to set an extract from an Oracle Table which has a very large number of rows (millions) and I want to set up a DTS package which will run weekly and pull 1 weeks worth of data and alwa...more >>

I have 10 csv files with different names in c:\mydirectory\. I created global variable "ImportFolder" which has value "c:\mydirectory\ LDP_*.csv" files names are LDP_aaa.csv, Ldp_bbb.csv, LDP_ccc.csv ADP_aaa.csv, ADp_bbb.csv, ADp_cc.csv. .... My question here is i want to import on...more >>

Hello, I want to create a DTS, it must import multiple csv files from the same Folder into two different tables. The files are "LDP_" + 3 letter code( like LDP_CCC,LDP_XXX) and "ADP_" +3 letter code (Like ADP_AKC,ADP_MEM) .. I know how to load it to the database, I am using looping method.I c...more >>

How can i query excel meta data. I need to know column name, datatype, maxcol size. I want to use this information in importing excel into SQL. Thanks PM ...more >>

Hi there, I have created a DTS package that copies data via an ODBC connection into a MSSQL 2000 Server + SP3 on a Win2000 server + SP4. The package runs as a scheduled job at 15 min intervals due to data volumes and network bandwidth to keep the transfers small. The package ran fine ...more >>

When i try to import from access, some date field fails with the following Messages (Date Returned, DBTYPE_DBTIMESTAMP) who can help me with this error? ...more >>

Hello there I've created dts that sends data from one server to another I got an error: BACKUP LOG permission denied in database 'destination database' Whad is wrong? Any help will be useful ...more >>

I want to get a file via ftp. Using the ftp control I connect to the remote server how ever I can not specify the file, because I can not change to the directory I need. The directory does not show up in the file list. The directory is hidden. How can I download the file? I can't unhide t...more >>

Hi, I have written an ETL application with SQL Server 2000 DTS that, among other thing, loads sequential files into an ODS database. I have used Data Driven Query component, with Data Pump Phases turned on, and Microsoft Data Link Component to insert or update rows in tables. When databa...more >>

I need to load various excel file into SQL server. For every excel file i have mapping table mapping excel column to SQL column. I am currently dynamically generating insert statement from this mapping table and then use to load records into sql server. For taking data from excel i am using dist...more >>

My DTS package contains Environment Variable assigned on local server. When manually run the DTS, it works fine. But when I schedule this DTS as SQL server job and run as job, I get error: "Environment Variable not found." Are there any recommendations to solve this ptoblem? Thanks in advance,...more >>

Hi All. I have an insert trigger into a table, but when I insert data using a DTS, the trigger is not shot. If I insert data manually, trigger works sucessfuly. There's any way to make trigger works using a DTS?? thansk for your help. ...more >>

Hi, I want to transfer some views from one server to another. But I want the views to be materialized into tables on the destination server. The views are different with different structures (different number of columns, name...etc). I have to materialize them as tables in order to improv...more >>

Maybe some one can help me... I have 2 tables with the following structure: CREATE TABLE [table1]( [GRID] [int] IDENTITY (1, 1) NOT NULL , [GID] [varchar] (10) NOT NULL , [RID] [int] NOT NULL ) On primary CREATE TABLE [table2] ( [RID] [int] IDENTITY (1, 1) NOT NULL , [RText] [varchar] (4...more >>

Hi I have the following code and I get an error. Propably syntax but I m new to DTS sql = "UPDATE Weeks SET WeekStart = '"& ww &"' FROM CurrentWeek WHERE Weeks.WkNo = CurrentWeek.Wkno + 1" ww is a global variable Can anyone help? Thanks in advance RIRI ...more >>

Hi, I would like to ask what is the syntax error in this: sql = "UPDATE Weeks SET WeekStart = "& ww &"" & vbCrLf & _ "FROM CurrentWeek WHERE Weeks.WkNo = CurrentWeek.Wkno + 1" ww is a global variable Thanks in advance Riri ...more >>

Good day, I hope someone can help. I am using the FTP task from SQL Server 2000 DTS. I have an application in place that every day creates a log file with the date as the file name, eg 20050209.txt Every day a new file is created. I need my FTP task to automatically pick up the lates...more >>

I build a fancy DTS package to migrate data from a source database S to a destination database D. But, I can't touch D right now, so I actually build the package to use destination X. Everything works. Now, I try to use a dynamic connection to set the destination initial catalog (aka databas...more >>

Hello Everyone - I'm new to DTS so I appreciate any help. So far I haven't been able to figure this out. I want to left join one table (TableA) to 3 other tables (TablesB, C, D) . (I need all the data in Table A returned). If there is a match between TableA and TableB, then I just want...more >>

I thought I knew a lot about DTS, but I realize what a novice I am after reading this news group. I am not new to DTS, but new to Global Variables. I am trying to loop through a global variable rowset and update data in a table. Here is what I am trying to do... I need to mark a Primary ...more >>

I've been googling around and haven't quite found what I need... I'm trying to DTS some tables from one database (Pervasive 8.50 wrapping Btrieve files) to another (SQL Server 2000), but not quite directly. The DTS is looping through a set of tables, creating them in SQLServer from CREATE TAB...more >>

We had some serious server problems and ultimately had to reinstall SQL Server 2000 on a Windows 2000 Server box. Initially, we installed SQL server under a domain account named srmsql. Under this installation we created everything, (DBs tables, DTS pkgs, jobs, etc.) Before we did our seco...more >>

In SQL Server Books Online, there is a great programming example where you can modify the properties of a data pump task to add new transformations. My question is how do you remove them when done? Those transformations stay saved so you cannot recreate them later. Here is the code I am usin...more >>

How to copy a excel file to Destination server while copying DTS package to different server? -- Message posted via http://www.sqlmonster.com...more >>

I have created a DTS where owner is the administrator of the SQL server. It import data from an access database sitting on a different server. When executed manually it works. When it's executed from an ASP page I get the following error in the log. How do I give the ASP page the right permissio...more >>

I have a DTS package that will run fine in almost every place except when it's scheduled. I can right-click on the package and select "Execute" and it runs ok. I can open the package in design view and run it, and it's ok. I can open up a command prompt on the server and run dtsrun and it ru...more >>

Is it possible to ftp to a remote UNIX site and execute a shell script at that site? -- Don ...more >>

Hello, I would like to take the next week's date( for example next Monday) from an ActiveX in a DTS package. Can I do that and how? Thanks in Advance Riri ...more >>

I have a DTS job which copies 20 tables from a Sybase database to Microsoft SQL Server database. The sybase connectivity is a ODBC Connection, and SQL server native connection. The tasks are deleting from the SQL Server tables, and then Copy from Sybase to SQL Server tables (select * f...more >>

I have a DTS package that is schedule to run daily. The DTS package was created and made the connection to the SQLServer using Windows authentication. When the package runs, it runs under the user/password of the SQLAgent. About every 3 months, we go through a security cycle in which the ...more >>

Hi there. I have a scheduled DTS package set up on my SQL Server with the following properties: Source: a stored procedure which can take a parameter Destination: a csv file on disk with a dynamic filename (each time the task is run, a new filename is generated from an SQL query using get...more >>

hi, I have a lot of packages executed from 1 package. when I execute the main package interactively, my 2 processors are used at 100% (execution directly from the DTS designer) when I schedule the same package using a .BAT file and executed from the SQL Server agent, the CPU usage is 50%...more >>