I 'm try to write a large package. It has several sub packages. Mostly this works ok as I'm passing down global parameters. The latest one I have written needs to pass back an internal database id (from an insert) to be used several tasks later. I have debugging output that suggests that I am...more >>

Hi there, I tried this question in several groups, but can't find an answer. When I create a Analysis Services Processing Task I can't see my Analysis server in de server list. server_1: sql server server_2: testOlap server server_3: liveOlap server dts on server_1: can select server_...more >>

I am having a problem in the Enterprise Manager while trying to use DTS to convert my database into a warehouse. I was following a tutorial for building warehouses, and reached the point in which I dragged the OLAP cube into the Analysis Services Processing Task window. When I attempt to...more >>

How can I import text data from IBM DBI file with leading zeros? Once this data is imported into SQL, datatype will not convert from char to money, maybe because of the hyphen that represents a negative number. example of data: Payment remit date patient name 000000-124...more >>

I'm attempting to use DTS Import/Export wizard to copy data from one table column to another table column within the same database. So far I have..... select [Customer].[CompanyName] from [Customer] order by [Customer].[CompanyName] How can I modify this query string to include the sy...more >>

On the destination tab of the DataPump task there are a list of columns at design-time. I programatically want to add/remove columns to this list. What property of the DTSDataPump task can I access to modify the list of columns? I thought it might be DestinationColumnDefinitions, but there don...more >>

We created a dts to create a table from our Sybase DB and when we run the dts everything is ok but when we check the data we found that the numeric columns had been created with a 0 value instead of their original value. What may be wrong? Thanks, JR...more >>

Hi Whats the best way to move DTS packages between diff env. We have approximately 28 to 30 DTS packages. Every time we move it is difficult to open each and save as on a different server. Is there a script kind of thing for them. I tried the export option, but it just seems to generate a li...more >>

Can anyone tell me if it is possible to migrate a DTS package from one server to another, ie. test to prod, prod to test. I haven't found any method to do so! Thanks, Tom...more >>

Hi all I ahve a weird one here (Arn't they always) I have a Dts and one of the steps calls a batch file. When I run the DTS it fails at the batch step. If however I click on the properties of the batch file and refresh it to say where it is (Its on a local Drive E:) then run it again it runs ...more >>

There is a simple task: Download file via predefined HTTP URL and save it to predefined location on disk. What is the simplest and fastest way to do this? By the way why there is an option to download file with standard component - "File Transfer Protocol Task" and there is no standard comp...more >>

I have a CSV file with the first row in the CSV file to be the column headers. The file is as follows: Material, Customer, month,qty, sales 10000,19ABC, 122004, 90.5, 10000 20000,20ABC, 122004, 80.5, 12000 30000,21ABC, 122004, 70.5, 14000 40000,22ABC, 122004, 60.5, 16000 50000,23ABC, 1...more >>

In DTS, i would like to identify whether the Alliance table has data, if has data, then i want to extract the relevant data from another table called Boolean. After i run the following code, it will return an error message : Invalid pointer. if not exists (select * from Alliance) SELECT cat...more >>

Hi All I have a DTS storage file (*.dts) with no network connectivity to another SQL server (I have to mail the storage file there). How do I import the *.dts file into the msdb database so that I can edit it from the DTS package designer? Thanks Jono...more >>

Strange problem guys. I need the help of an expert to solve this. This is for SQLserver 2000 only. with latest service pack. The DTS package execute by itself just fine. But when its scheduled it fails with the following error message. " Executed as user: Server1\Administrator. ...QL ...more >>

Newbie question. I've managed to create a SQL db, have a MS access front end for running query/reports. Currently I manually download data from source system to .txt file and run a DTS to import into SQL. Is is possible to run the DTS from Access? I'm just beginning to understand the ba...more >>

As part of a much larger DTS package, I am needing to copy a large quantity of data from an Oracle source to a flat text file. I originally intended to use the datapump object to do this, but I am not needing to do any transformations, I simply want to copy the data to a file. If this were one ...more >>

I am going to import a textfile from a mainframe system that is formatted with fields in fixed column positions. But there is another thing that bothers me, every record in the file is split up on four rows in the file. I want to use fields from the 4 lines and compose input for a single row i...more >>

i'm calling a stored procedure to generate a dataset for importation across sql servers. the stored procedure uses a temp table. when trying to set up the dts package, i get an error message "invalid object #temptablename" what's going on here? can i just not use temp tables in sp's that g...more >>

I have a comment field with data or no data. The problem is when I transfer the data into AS400 if field is empty it translates to end of record, however in reality it is not. How do I fix this issue?...more >>

We have a contract programmer who is writing an application using VB and DTS to hit a SQL database. He states that DTS allows us to have up to five (5) concurrent connections to the database without any SQL licenses. My understanding was that no matter how we hit the database (DTS or not...more >>

I have an application that helps the client retrieve data from the DB. It allows the client to enter parameters for us to create the sql. and the client doesn't have to understand the data model. The request that came in recently has thrown me for a loop. The client want to be able to custo...more >>

We have a dozen or so DTS jobs that run on our SQL Server. They run independently and sometimes a particular combination occurs that causes a deadlock. Our biggest problem is that we don't know why SQL Server is locking the tables at all. In some cases we're doing a data driven query and ...more >>

Is it possible to create DTS connection(s) in C# and add them to a DTS package created at run time in code? // Something like this DTS.Package pkg = new DTS.Package(); DTS.Connection con = new DTS.Connection(); con.DataSource = ... pkg.Connections.Add(con);...more >>

Can't copy objects with DTS I'm trying to copy everything from one database to another using DTS. I'm connecting using SQL SERver authentication and I choose Copy objects and data between SQL Server databases then Create destination objects Drop destination objects first Include al...more >>

Dear All, I am new in using the DTS and is learning by reading the "MS SQL Server 2000 DTS SBS." While I am impressed with the DTS Designer in creating a new package, I am wondering when do I need to save a package and re-execute it gain? Similar to running a VB,ASP,or JSP script? U...more >>

I am new to DTS. I have 2 problems I am running into right now. 1. I need to upload a file to a FTP site and I can't seem to figure out how to do it. 2. I am trying to download the entire contents of a folder from a FTP site. I can download single files without a problem but I need t...more >>

Hi, I'm just starting out with dts. 1. I would like to know how to assign the result of an sql statement to a variable in an activex vbs script. (Assume the select statement returns only one value). 2. What is the maximum value that can be returned when checking the string length using...more >>

Hi everyone, I have some problem,I'm trying to import data using sql statements into SQL Server,because I have 2124 columns,so I have to devide it into 3 sql statements. When I'm trying to execute DTS package,I got some error. So I'm trying to import only one record into sql server,but it tak...more >>

Hi experts... I'm trying to schedule a DTS package (import some tables from Mysql database) but there is an error and I don't know how to resolve it. The error is always the same... "The job failed. The Job was invoked by Schedule 24 (Import RT data). The last step to run was step 1 ...more >>

Hi I have a DTS Package that transforms Data from My SQL Table to a csv flat file. The problem i am having is that i have to copy this data over the internet. When extracting the data to the csv file the file size is 176mb after manually compressing(zip) the file I compress it to about 1...more >>

One of my DTS package only runs a third of the way and report successfully finished. The last step it ran was a task an execute SQLtask and 3 parallel steps upon successful execution of this task. Recently, I have other packages periodically does similar things which has been running smoothl...more >>

Sometimes our DTS package are returning an error, Timeout expired - Error code: 80004005, even though we have set the Timeout options=0 and all other options we could think of. Are there any options you could think of, that we might have missed or any other solution we might try? It is rea...more >>

It appears that I'm not the only one to report this problem now. I'm hoping that my subject will raise some attention from people who care (MS). In any case, since installing XP-SP2, we've had a number of DTS packages start failing, with no change to the data or DB structures. If fact, ...more >>

Hi! I'm currently designing a DTS package with parameters - I call the DTS package from my C# application after I've defined the global variables (also in C#). In the DTS package, I've mapped the global variables directly to parameters in my SQL query (by using question marks in the quer...more >>

I have a DTS package generated by a wizard (for export data). When I execute the package by right clicking and executing, it runs fine. But I scheduled the package as a SQL Server agent job and it keeps on failing. The Job has just one step that executes the package with DTSRun. It seems to ...more >>

Hi All, I'm trying to load data into my account table that has the PK as AccountId however, this is how my data looks like AccountId AccountDescription 1 This is the right description 1 Wrong description 1 Wrong description2 2 This is the ...more >>

hi, I have a dts package on sql server 2000 server, that populate an excel file and send it out to users as attachment. lately, users were able to received the file through email, and when I try to modified the user list in 'send mail task', I receive this error: 'error source: micr...more >>

Hi, I want to do run a very large UPDATE Statement covering millions of records. I saw some material in the web that shows how to acheive this using SET ROWCOUNT, Infinite WHILE LOOP and @@ROWCOUNT. I am not getting the approach. How can i write a update statement to UPDATE records batch by b...more >>

Hi I am using DTS Bulk Insert task to load the data from flat files to SQL Server tables. How can i get the no. of records that is inserted from the Bulk Insert task? I can get the record count using count(*) but i should be getting it from Bulk Insert task also. The problem with Select co...more >>

I am frequently getting the following error running scheduled DTS packages. Re-running it usually works the second time. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147218481 (8004...more >>

Hi there, I'm probaly doing something stupid here but.... I am trying to import data into a table "ImportJuliSingle" which includes the primary key ("UserLogInName" varchar (35)) from a third party tab delimited text file downloaded from a website on which the primary key can appear several...more >>

I am developing my first package and need transform data from an Informix database into a table in a SQL database. So I created connection to both database and Transform Data Task between these database sources. Everything looks straightforward except that, I need update another data in tabl...more >>

Hi, I was wondering what is the best practices for migrating existing DTS packages over to Beta 2 of SQL Server 2005. I am going to do "sandbox install" of SQL Server 2005 on Virtual PC 2004 and since I will have a clean install Im after ideas? Thanks in advance Dave...more >>

I have a DTS package which transfers information from a dbase file into a SQL table and this worked fine until I installed SP2 for XP onto my PC. I can now no longer do transfers from dbase file, excel files and even from access databses. Has anyone seen this problem and do you know how I ...more >>

Hi, I'd like to set up a button in a VB.net web application which, when clicked, will run a DTS package to import data from an Excel file into an SQL Server database. I've created the DTS package using the Wizard and chose to save it as a Visual Basic file. This leaves me with a .bas file but I'm...more >>

The prestigious Intelligent Enterprise Readers Choice awards for 24 strategic business applications was announced last week. Apparently Microsoft SQL Server BI seems to swept all the BI readers choice awards beating longtime industry BI heavy weights like Cognos & Business Objects. Amazingly, re...more >>

Hi All If I need to update sevel fields on all recordes in a table how would go about doing that with one update sentence - is that possible ? Or do I have to make an update statement for each field...? --Michael V. ...more >>

I am using a Text File (source) connection and the input is a CSV file and the first row of the file as column headers. When I try to create a destination table DTS interprets columns which are numbers as a varchar (255) column but when I save the same .csv file from Excel as a .xls file and use...more >>

Dear all, I encountered a problem regarding the captioned issue. The situation is that I am importing data from a data file (either in txt, dat or xls format) to SQL server 2000, using both bcp utility and DTS Import/Export Wizard. Error messages received when i use the 2 methods to impor...more >>

Hello to all I want to import excel file to sql server 2000 as table without using Export/Import utility. I have to use only asp/asp.net/vb. Any help will be welcome. Thanx in advance. Dilip Singh Dodiyaa ...more >>

hi, another question about sql server 2000 dts. before we drop an employee's account, we would want to make sure that his accounts won't be used in any dts package connections on all of our sql servers. is there an automated way (by code) that I can change this employee's account into...more >>

Hi Folks I have a 'File Grabber' DTS I'm working on that's written in ActiveX. It crawls directories based on file patterns and does the appropriate processing for possibly dozens of files and of various types. For some reason, executing Shell is blowing up with object required (sample ...more >>

I get a type mismatch when trying to save my dts when I create a second variable with type <other>. Any suggestions? Renae hilary321@yahoo.com The situation is that I'm trying to break 1 table into 3....more >>

I have a database at mysql over a different host. In DSN connection I am providing all necessary information to connect to that database. The connection is verified too. Now when I do Import/Export wizard for data import I select MySQL as my source and SQL Server as my destination table. Now...more >>

I have two basically identical sql 7 servers and two basically identical sql 2000 servers. We are moving from sql 7 on old boxes to sql 2000 on the new boxes. The DTS wizard works fine export/importing from one of the sql 2000 boxes to either of the sql 7 servers. However, the other cant ...more >>

I am creating an ActiveX VBScript to run in my DTS package. Is it possible to create a function that returns a value? Here is an example: Function WhoIsIt(strText, strText2) AS Boolean .. .. .. (some processing) WhoIsIt = False End Function Thank you, JLFelming...more >>