Hi I have a local computer with a MSDE and a SQL Server PE installed. They both have SP 3 installed. I would like to import an Access database to my MSDE (or the PE if MSDE import is impossible). I use SQL Server Enterprise Manager When I rightclick on a database and select All Tasks-->Import ...more >>

Hello, I am receiving a text file that is produced from a mainframe that is out of my control. I am attempting to find a (hopefully clean) way to import it into a SQL Server database in an automated fashion. I am not really concerned about how many tables it requires or what the schema look...more >>

using sql 2k! I run a DTS job every night to load a table called "MISC" that brings over 30 millions records in the database A in server A. The job is taking over 5 hours. The probelm is the # of records are keep increasing. I am trying to minimizing the total execution time. Is that all pos...more >>

Hi, I need to change SA password programmatically for all of our SQL Servers and we think there are connections in some of our DTS packages that use SA as user name. If we change SA password, jobs that run these packages will fail. Is there any way that we find DTS packages with connections ...more >>

How do I generate a .txt file from a Stored Procedure. Something like this: select * from my_table into c:\temp\my_text_file.txt Thanks in advance for any help. Sandra...more >>

A daily export from an oracle instance has 360,000+ records in it - txt file ~ delimited. The data is loaded into a table (via DTS) that does NOT have straight column copies; some of the fields are using the activex to ensure length or other when it comes to zip or phone numbers. This is...more >>

Hi, I have a DTS package that exports SQL Server 2000 data into Oracle 9i database. The char(0) values from varchar columns are getting transformed as NULLs in the Oracle database. I have connected to the destination server using Oracle OLEDB provider. If someone have a resolution for th...more >>

Is there a way to call an "Execute SQL Task" from a Data Driven Query VB Transformation Script? Thanks ...more >>

Hi I have a dts with several steps, all of steps goes to "Error_Step" when fails, but this does not run because the logic precedence is and by default, I mean all steps must fails in order to run "Error_Step". Somebody kwnos how can I change the logic precedence in order to let dts run "...more >>

Hi, I am having a problem scheduling a DTS package via SQL Server Agent. I have created a DTS package that has 1 task in it which runs a VB6 program that copies a file to a specified folder and then uses the Shell command to run wzunzip.exe to unzip the file. My problem is that the packag...more >>

I have a DTS package that executes every 10 min. How can I create automated way to remove oldest PackageLogs from SQL server? Thank you, Yelena ...more >>

Hi, I've got a weird problem with SQL 7.0. I have to load several large textfiles into SQL 7.0. The files are 250 Megs +. I couldn't get the totals straight. If I summarize the CSV- files before I DTS the files to the SQL server I get a certain amount. If I then DTS the files to the SQL ...more >>

Dear techs, Ive been trying to look through the help menu, but I don't seem to be able to find the stuff related to "?"...using the "?" as a variable. What is this method actually called? zeallous...more >>

I created a schedule for a DTS package (daily, every two hours). How do cancel the schedule. I now just want to go in and execute as needed....more >>

I have an application that will be locked from time to time for data extraction, etc. So, I've created a table with only one column and one row to indicate when the application is locked (value 0) or unlocked(value 1). create table lock_tb ( col1 char(1) not null, default value 0) Now,...more >>

I have a couple of read-only tables that are modified once per week by a DTS job. I delete all the records (delete <tablename>) and I use DTS datapump to read fresh data from external sources into the tables. Then I let DTS run several stored procedures to update the data. One table has 1,2 mill...more >>

I need to execute a package based on the results of an if/then clause. I use an import step in my package and want to check the row count in the file. The file is a comma delimited file that we use to import. WE overwrite some existing sdata with the import each day. Normally ther are over 400,0...more >>

Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

Hi there, I try getting into the DTS secrets. After searching hours and finding very good stuff like www.sqldts.com which helped me a lot, I am getting into some problems. I have an ASP page with the lines ****************** ASP ****************** MyNumber = 388 Const DTSStepExecResul...more >>

Hi Folks, I have a challenge to perform using DTS. Every week I recieve a txt file with different structure, I need to import this file to sql, add some columns run couple store procedures and export the table in particular order using a query. I want to automate this process, how can I use din...more >>

I have a text file with a date column (hh:mm). This column I want to import as a time field. I wrote this VB script: ***** Function Main() DTSDestination("time_demand") = timedem(DTSSource("Col001")) Main = DTSTransformStat_OK End Function Function timedem(Col023) TimeSerial( Leftl...more >>

Can I delete a .txt file from the server using DTS? Can I append to a .txt file in the server using DTS? Thanks in advance for any help. Sandra...more >>

We have a large website of around 100,000 users. The site is in english. We are trying to 1 more language to the site, ie: users can browse the website either in English or Arabic. So, in our development enviroment (Our local mirror of the database which we work on), we added extra fields ...more >>

Hello All, I have a comma delimited text file, which I would like to move into a SQL 2000 table . I created a DTS package in SQL Server and saved it as a VB.bas . I am writting the code in C# and I though that I might be able to change a few lines and keep the bulk of the code. However , it se...more >>

Hi I am trying to do some error handling in Sql Server DTS. The problem is if i try to insert lets say 10,000 rows in a table. And out of those rows only 1 row violates some constraint in the table. Then all the remaining rows will not be inserted in the table rather the step will fail. W...more >>

Hello DTS Group, I love dts. but, how can I easily copy dts packages from on server to another? I tried using DTS Transformation and selecting the msdb database source, and destination (on a diff server), but non of the sys tables show up?? sysdtspackages is the table I would like to copy ov...more >>

Hi everyone, How can one find a DTS step description from within a child package knowing the calling package's name and step name? Can the calling package object be accessed from the child package? Thank you in advance. ...more >>

Using SQL Standard or Developer 2000, version 8.00.818. Windows Adv Server 2000 sp4, current with windowsupdate. Intel (2) CPU 2.40GHz 523,764 RAM Mcafee virus scan 4.5 2nd": server with Intel (4) CPU 700Mhz 2gig RAM We are loading into a warehouse (no OLAP) several tables. We are runni...more >>

I am trying to transfer a txt file into a new SQL table so that all of the columns in my file automatically populate into the SQL table...how do I do this without having to specify an existing table?...more >>

Is there a way to execute a DTS package through a stored procedure? Or is it possible to create a stored procedure that will execute a DTS Package? I would like to be able to execute a DTS Package from a website built in ColdFusion. I would greatly appreciate any help. Thanks. Derek...more >>

I am attempting my first try at Executing a DTS Package from an aspx page. I get the error below when I try to load the package. I get the same error when loading from SQL server and from a storage file. It seems creating the DTS object goes OK - I just can't open a package. Is the error I sho...more >>

When I link to an Excel file using a LinkServer, TESTXLS, I get the following error: Server: Msg 7356, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata information was changed at execution time. The XLS file is as follows: col1, co...more >>

I have created a linkedserver, TESTXLS, to an Excel file which carries the following data col1, col2, col3, col4, col5 1,2,3,4,aaa 2,2,2,4,bbb 3,2,1,3,ddd and when I try to query the file using the following syntax: select * from TESTXLS.[D:\mydocs\files\Issues\Book1].. [Sheet1$] ...more >>

Please help! I have a SQL DTS Package with two tasks. One is an Active X script which creates text files from several sql tables. The other is a Win 32 Process which takes the text file created and zips it up. The problem i am having is that I want to be able to call the second task after eac...more >>

Where can I find resources on creating custom transformations in vb.net or c#? Is it possible to create custom transformation in vb.net or c#? ...more >>

Can I use DTS to copy zip files from one network drive to another? I need to supply userid/pwd to host server all the time. ...more >>

Is it possible to detect (from within a package) if it's running on a client or as a scheduled job on the server. Thanks Serge...more >>

Hello, I have a number of DTS packages that pump data from a Staging area database to an Enterprise area database on the same server. I also need to move these packages from our Development Server (SQLDEV)to our Live server (SQLLIVE), so the first task within these packages is a Dynamic Prop...more >>

This is probably very simple but I can't seem to figure out what I'm doing wrong. I would like to transfer only stored procs from one server to another but DTS still migrates all objects even though I turn off the copy all objects option and select just the stored procs I want to migrate....more >>

Sorry to post another, but the solutions to everyone elses problems don't appear to be fixing mine: Have a very simple package with only one object, and ActiveX script. That script outputs a line to a text file then tries to open a COM object (of my own design), then outputs another debug lin...more >>

Hi, I'm hoping someone could help me. I have a DTS package that exports data from a SQL Server into a CSV file. One of the fields that i'm exporting is a varchar(1500). What seems to be happening though is that when I populate the DTSDestination field, it cuts the string down to 255 ch...more >>

Hi All Please let me know how to pass parameter to DTS package when Execute DTS package from Front Ends like VC# or VB.NET. regards Raghu. ...more >>

hello! Any idea? The problem: DTS package hangs while running data transformation task, which is based on SQL query. Noticed that if it is run based on table, there is no problem. Currently SQL server 2000 has SP 3a. Transformation takes place between Sybase - -> SQL Server Past experienc...more >>

Hi all I am trying to convert a recordset to xml, but can not get the following lines of code to work in vbscript from within a dts package. I have tried them in an ActiveX Script Task (Language VBScript) and in a transformation in a Transform Data Task. When I try them in VB they work fine...more >>

Hi Could anyone tell me how you would get VB to call a DTS package (as DB object, not VB module or structured storage file) and pass it the filename of the text file to be used as the source? (The destination is a table that is known and never changes; only the source is dynamic.) Thanks i...more >>

Can anyone offer any insight on an issue I am having. I have an Access database with three tables, each with 800,000 records in them. I am using a DTS Package to port them into SQL Server tables. The data load takes over an hour. This has become unacceptable. Any suggestions would be ...more >>

I am working on adding functionality to an application we have that is a SQL 2k back end with IIS 5.0 front end. I am adding the capability to transfer information using the MQSeries queueing software. To do this, I have written a DLL that is called from a DTS package which is in turn fired fro...more >>

Hi, Is there any way to take backup of DTS packages ? Thanks, ...more >>

Hi guys, I need help about run DTS Package via Web. I´m create a simple package to Drop a Database just to test. But this package fail when I call in browser IE 6 SP1. I using ASP code not ASP.NET. See attached. Could you help me? ...more >>

hi..all The problem is tryin' to export txt divided by rows, where my inf. are there (in the rows), sql needs another data type more powerpuff (char(7000)), oh come'n! sql broke the field and continue in the next row (lookin' this up n' down)...really is the worst road using (windows ansi...more >>