Hi All, Are there anyway to import the DTS struture storage file without user interaction? Cheers Good. ...more >>

...more >>

Hi, I need to export from couple table data to a csv file. But I don't know how to do the following. The table will, OrderID, no of item, item no, qualtity description. 5020023, 2 , 1 , 1 , Cable 5020023, 2 , 2...more >>

Hello Friends, I have a data file containing Purchase Orders coming in from a proprietary ERP system. The file contents can be divided into 3 parts: Header, Lines and Notes. These 3 parts need to go into three different SQL Server Tables for my custom application. Is it possible in D...more >>

Hello, I face this problem hope some body can help me to solve this, TQ I create one local DTS and can run properly, after that, i try to create a trigger to call the DTS, the trigger are like below CREATE Trigger TR_UpdXML On MBBSales.dbo.c_ExceptionAct For Update As if update(Sta...more >>

Is there a documented/safe way to programmatically delete a DTS package? OK then, how about an undocumented way? Thanks. Josh ...more >>

I'm transforming a 9 character field in a flat file that represents a dollar amount. The decimal is implied inbetween the 7 and 8 characters. Also, if the record payment status is "X", then the last digit is an alpha character that represents that 1) the amount is negative, and 2) the value of...more >>

There must be some way to loop through all the files within a given folder and load / transform them into a single DB table.... can anyone suggest a solution using DTS or do I really have to code all this? -- Michael Calvin...more >>

I want to use DTS to add records to a Lotus Notes Address book from a SQL Server table. I have downloaded the NotesSQL 3.02g ODBC driver and installed it successfully. I am able to view the Notes address book data and delete from the Person table in the Notes address book. When I try to...more >>

Hi to Everybody, I've read about DTSRunUI for executing DTS at night. After some testing I'm sure it does what I expected for. I'd like to know the way I can edit/delete Scheduled Jobs once they have been created by DTSRunUI. I've read about the info of these jobs stored in the msdb databas...more >>

Hi All, Now, I am facing a problem that related to remote execute the DTS package. The situation is as follows :- First , I create a local package and it could execute successfully in its own machine. Then, I export it to a structure file package and copy it to another machine. After, I ...more >>

I have an Access frontend that controls the running of several MS SQL Server DTS packages (among other things). I dynamically build a command line for dtsrun, and then use the ShellWait command from here: http://www.mvps.org/access/api/api0004.htm The problem is that some of the packages tak...more >>

Hi all, Is there a way to schedule a DTS pacakge to run on the 3rd working day of every month? TIA, Joe ...more >>

How do I determine whether or not a specific DTS Package (I know the name of the package) exists on the Server? Thanks for your help, - Joe Geretz - ...more >>

I have a scenario where the data to be loaded into SQL comes in a email. The business is asking me to build a package that will enable the email to trigger a DTS package which must be able to take the attachment coming as part of the email and process the file. Kindly advice how this can be d...more >>

I have a given data file to be loaded into a SQL table. I want a sample vbscript that shows how I can do processing record by record. What I am looking for is a mechanism that enables me to process the incoming record by record for various checks and if a check is not satisfied to reject or skip...more >>

We have tried to use the FTP task within the DTS package to pull information from a particular web site but have seen erratic behaviour in the past due the task completing but NOT ALL the files making it over to the destination. The process stops pulling without producing an error message or...more >>

Hi, I have a VB.NET application that call a SQL 2000 DTS package. This worked fine when running the client application from my machine but as soon as the client application was moved to a production machine I get the following error when trying to run the DTS package. [DBNETLIB][Connecti...more >>

Hi I have a DTS package where in i am pushing data from Excel to Sql server database. When i look at preview of the source (i.e Excel ) in Transform Data link , the data from the excel is not shown in VIEW DATA grid. What could be the reason ? Regards Guru...more >>

G'day all, I'm trying to use an Exec SQL task (SQL Server 2000) to run a stored procedure and assign a message string returned by the proc to a global variable. Here's the code: DECLARE @master_message VARCHAR(5000) SET @master_message = '' EXEC dbo.udp_IP_Update_Master @ov_output_m...more >>

I was wondering if anyone knew how to resolve a certain problem I have. When I set up a DTS package, and do straight column-copy transformations, I have no problem doing so. However, when I need to do an ActiveX script transformation, I keep getting an error afterwards. When I look at the erro...more >>

Does anyone has any experience with exporting data from SQL Server 2000 to MySQL. When I try to export using ODBC it gives an error because mySQL engine is 4.1 while the ODBC driver provided is 3.51 and it says upgrade the driver. Any workaround for this ? Best Regards Roshan Jayalath...more >>

Hello I hace creatre a dts package that uses an ActiveX script to either insert or update existing records in an Oracle RDB database. The script fails on an duplicate key value on the index on the vendor_number field. The Vendor_number field is the field I am using in a lookup (which works) to...more >>

Ive beeb trying unsucseffully to use a dts to import this file into two tables "200001" "999999" "75" "999999" "004" "24/03/2005" "001" "Fhead@office.com" "me@anywhere.com" "200001 DebBacsFM Serial: 4 AuthCode: 9999" ---- bank records "12345612345678ANYPERSON REFERENCE ...more >>

Hi Gurus, Is there any automated way to compare the contents of TWO rows in the same table of SQL Server ? Thanks in advance. Regards, Yog...more >>

Hello, I'm trying to parse for a numeric string from a column in a table. What I'm looking for is a numeric string of a fixed length of 8. The column is a comments field and can contain the numeric string in any position. I'm not familiar with ActiveX, so any suggestions will be useful. Th...more >>

Hello. I'm fairly new to programming and have what is probably a simple question. I have the following code which displays a message box on the screen with a yes,no, and cancel button. If I click yes it returns vbYes. If I click no or cancel it returns nothing for the IResult value and run...more >>

I have a static data in my database table with five level hierarchy. something like this. 10 countries |___Every country having 10 states |____every state having 10 cities |___every city have 10 bank branches |__every branch providing 10 types of acc...more >>

Thanks to help from here i can use the folliing axtive x code to dynamicly set the source filename Dim Oconn Set oPkg = DTSGlobalVariables.Parent Set Oconn = DTSGlobalVariables.Parent.Connections("Text File (Source) Copy") OConn.DataSource = DTSGlobalVariables("gv_FileFullName"...more >>

Hello All I get the following data file which as some page headers and column headers I need to get rid of the page headers and column headers and read only the columns of data please provide me with a sample VB script code that can accomplish the cleaning. The file structure is as follows:...more >>

Hello All The text file containing weekly sales comes from a legacy system which reports negative numbers with the negative sign in postfix form rather than prefix form as follows: customer Sales Qty 1000000 100 220 1909110 82- 430 2010102 125 98- Can ...more >>

Hi, Could someone help me with the Datetime DTS Transformation? I try to import the Text (fixed length) file into the SQL table and having problem when the date from the Text file is blank. I have two columns (from text file) with the dates in format yyyyMMdd. One of them always have valid ...more >>

hi, I have a DTS package for selecting data and updating data in a loop , and set ths DTS a job starting at 8:00 Am every day . There are 5 similar background job running until 6:00 PM. I take some test and find every job consumes a lot of CPU resource. Is it suitable to let DTS become back...more >>

What is preferred ? If sql I need to store the name and password somewhere - that could be a problem - if windows I have yet to see it work the whole way around - both in the dts package and when executing the job in Agent. Isn't there a way to store a username and an encrypted password in a...more >>

Using native DTS, can you expose the DataSource "source" and "destination" properties? I've noticed the connections are not listed when you open the DynamicPropertiesTask. doug ...more >>

Okay - Here's the situation, and let me know what you think is the best approach, all ye SQL gurus. ;-) - Our Clients have requested a feature that allows them to get all their data in SQL Server format (as SQL Data files). - We're trying to figure out the best way to do this. We'...more >>

I have a dts package with 30+ steps. Sometimes an exec sql task will fail (and this is correct). I use the workflow to control how the tasks are executed. It works fine. Here's the problem. A job executes the dts package, using dtsrun, and if a task in the dts package has failed the job status s...more >>

We are migrating a few application off the DB2 OS/390 to SQL server 2000. There are millions of records in DB2 that I want to move to SQL server. I tried DTS (importing to sqlserver), its taking lot of time for each tables. Is there any faster way that anybody know to move large volume of data t...more >>

I am creating a DTS package to import from a txt file (YYYYMMDD.TXT) to a table in SQL 2000 Database. Here are the steps I am using: 1. I create my package using file 20050314.txt as source. It works fine. 2. Next, I add global variable "MYFile". 3. I add Dynamic Property task and assi...more >>

I am trying to import a text file via DTS that has an unusual delimiter. I am used to files like this A,B,C D,E,F This file is like this A,B,C There is a square here D,E,F How do I handle a file like this that has more than one record per line and has a s...more >>

if i have a Text file Source object, can i set the 'import File Name' from an activex script ?...more >>

Have a SQL server on inside interface of Cisco PIX firewall and have a SQL server on a webserver on DMZ interface of the PIX. Opened port 1433 between all inside PCs and webserver. Created a DTS package using SQL logins and passwords to update webserver with tables from inside server. B...more >>

Dear all, I'm trying to export five millions of rows to .CSV file from a DTS of a remotely way, i.e, database is allocated in Buenos Aires and the file resulted is dumped in a spanish server. Just a drawback with this is the performance but I don't mind at all, of fact the problem on the ori...more >>

Hi, I have developped a lot of DTS packages on an SQL Server database. 1 of our client use Oracle instead-of SQL server for the same database (same schema) I want to use a linked server + views in an SQL Server database: create view MyTable as select * from ORACLESERVER...MyTable So...more >>

Hi I'm trying to use Dynamic Property Task to set SQL Statment for a transformation. I'm assuming this is possible by going into the Disconnect Edit properties of the package. I have a DTS job set up and it also runs successfully, but the sql statment associated the the transformation d...more >>

Joe, The script you provided below worked like a champ, sorry for the long delay, another project came up. One last question. Now that i have seperated the date & time fields, I need to remove the time portion of the date/time field. So, instead of 2005-03-15 09:56:34, i want 2005-03-...more >>

Problem: Need to get information from either a table directly or a sql statement to a fixed width txt file (no headers) . Every time I click the "Define Columns..." it shuts down Enterprise Manager with no error message. I try to execute the job but it fails due to "Invalid Column Length"...more >>