Hi, I have to get some data in my Sql Server database and update one another table in my Oracle database with these data (using DTS). 1) What is the best Task should I use to build the package in DTS ? 2) I have the fields to avoid the relationship between those database, but I don´t know h...more >>

I know that I have to schedule a DTS package under an account which is in sysadmin role in order not to face security problems.Dose sysadmin role mean System administator? What type of account you guys use for you oleDBConnections insode the packages Sqlserver accoun or domain account? if s...more >>

I have two separate select statements to pull data. I want to load the raw data into one Excel spreadsheet, into two separate sheets. How can I do this in DTS? DTS doesn't appear to be able to transform data into the same connection object because of duplicate object names. Can DTS trans...more >>

Is there a max length for DTS Global Variables of type string? I have a stored procedure that I am running using an Execute SQL Task and it is outputting a paramater of type varchar. I would like to output that parameter to the DTS package. The output parameter is at least 500 characters ...more >>

need to SET CONCAT_NULL_YIELDS_NULL OFF, but while my query works fine in SQL Server 2005 Management Stuido, it does not work in Integrtattion Services. Any ideas? ...more >>

Hi, I have a source and destination connection and i want to be able to have multiple Transform tasks running between the 2 connections in parallel. I also need the destination connection to show a fail result if one or more of the tasks fails, but this currently doesn't seem to be the case...more >>

I'm stumped. I've ported the DTS library to my C# application (using the tips listed at http://SQLDev.Net/DTS/DotNETCookBook.htm) and rewrote my VB6 DTS package code in C#. However, when I execute it nothing happens. I turned on event log publishing with the "WriteCompletionStatusToNTEventL...more >>

The date in SQL shows up as 729089 Even in Excel the grid shows for eg. the data as 3/29/3896 when I format the date as a Date. I was provided the following information but I am not sure how to change the date to show correctly. ------------------- Platinum SQL Version 4.2 Date s...more >>

Hello! I am having a bit of difficulty. I need some help. My question may be slightly off topic, but anything that comes to your mind would do just fine. I am trying to use DTS to copy down tables from an IBM Universe database into the Sequel server (please don't ask me why!) Using the ...more >>

Hello all, I am running MS SQL Server 2000 - I think service pack 3 - (how can i find that out) I am trying to use the export wizrd to copy certain fields from a SQL table called opportunity. Using the DTS wizard, I choose text file as my destination type. Then I choose to query the ta...more >>

I currently have a DTS package that used to work on our server. The ActiveX task hangs on one server, runs on a different server and will execute locally. Is there something I need to be looking for on the server where the hanging occurs. If I reboot the server, it will work for a short time ...more >>

Hello Everyone, I have a excel file with variable column header information and one of the column header has some data which needs to be read. I couldn't find a way to read the column header information. Does anyone know how to read the column name? The data under the column can read as DTS...more >>

Trying to import a excel spreadsheet and I have setup the transform as such... Function Main() DTSDestination("id")= DTSDestination("fn") = DTSSource("First") DTSDestination("ln") = DTSSource("Last") DTSDestination("uid") = DTSSource("Nalphakey") DTSDestination("bldg") = DTSSource(...more >>

I have a job that has a number of steps of which the last two are to be executed only if certain conditions are met. In the workflow properties/activex script for these last two steps I have the following: IF DTSGlobalVariables("SkipEndTasks").Value then Main = DTSStepScriptResult_DontExec...more >>

I have a package that run a number of other packages When the package is run in full the whole process works correctly, but when each step of the header package is run the above error is returned. Most of the time the package seems to complete successfully, but does sometimes fail (Again o...more >>

Hi, I have a CSV file (24,584 recs, ~230-240) fields that fails DTS on data insert with "not enough storage to complete operation" listed twice in the message box. Although I have numeric data in many fields, I am importing all as text because the text fields are not delimited with quotes or ...more >>

Hi, I'm having trouble calling an Execute Package Task from within my DTS job. I want to be able to take different routes in the Parent job depending on the Success or Failure of the Child job. I can get things to work correctly if i select the option in the child DTS job for a step to fail...more >>

Hi, I have an Email Task in my DTS package which has a number of 'Failure' workflows running into it from different parts of my DTS package. I want the email task to execute if any one of the Failure workflows fires. I think currently that if you have multiple workflows pointing to a task ...more >>

Hello, I have a excel and CSV file which has data exported from a table in SQl databse. I want to progrmatically using VB.Net transfer the data from excel/csv file to this table. But I have to verify if the record already exist in table, if yes then use Updated query and If no then use I...more >>

Hello, I'm calling a DTS package from my asp.net application.Apparently because of permission issue I canot run the package within the sql server ,because when I set it to call a package from my local host it can execute te package.one step before calling the package I get the IDENTITY of t...more >>

Hi, I have a DTS that transform data between two databases on the same SQL Server, as shows below: table A ====> table B (database_1) (database_2) Using Dynamic property of DTS, I can set up the source and destination of the transformation dynamically via "global variable". I also n...more >>

Does anyone know how to write to or modify the log output of dts? Currently the output looks something like this.. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_2 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_2 DTSRun OnStart: DTSStep_DTS...more >>

SQL 7.0 Can you use DTS to insert a CSV file into a SQL table that has an identity field? Without the identity field, data imports fine. Thanks, Don ...more >>

Hi NG, I have a problem with delay when executing packages. I have 4 packages which are actual "clones" of the first package; I only changed connections, then "Saved as...". They import data from an UNIX-System into SQL. Very first task is an ActiveXSkript (VB) to set Variables and Trans...more >>

I have built a package of 9 transformations in SS2K. I am doing a couple of tasks up-front, naming variables, etc., and then I want the transforms to fire afterward (once I've provided the filenames to each transform). When I go to set up my workflows, I can set them up between my ActiveX ...more >>

Will I be able to run SSIS packages on a computer with SQL Express, or will they only work with SQL Server 2005? - Kristoffer - ...more >>

I had written an earlier question about how to do a "where" clause inside an Execute SQL Task properties. I thought that I might be able to create a global variable in script that'd have the where part of it in there, and would fill in the part of the where clause that I was wanting to use....more >>

Hi, I have a custom program which create an in memory DTS package. The program works fine and has been deployed in several computers. But on 1 computer I receive a general network error when I write the table in the destination (which is SQL Server) this error appear on some tables, but no...more >>

I read the artical "Looping, Importing and Archiving" by Allan Mitchell and "Import all files in a directory (Multi Step) By Darren Green". It is very helpful! I can even import directory of text files with DTS package successfully. But when i I try to import the directory of excel files to sql ...more >>

All, Is it possible to execute task in a task. For example my ActiveX Task sets global variable in a loop and other task (in the same package) reads the environment variable (server name) and queries the server for specific data. My problem is I'm not able to execute the DynamicPropertiesT...more >>

I have a DTS package that takes a simple select statement and outputs it to a text file. The SQL references several columns whose value is 1 or 0. For some of these fields, the preview in the DTS as well as the output has a "true" as a value in place of the "1". How do I stop this?...more >>

Hi everyone. I'm wondering if any one can help me. I'm fairly new to DTS and made a blindingly obvious mistake the other day. I currently have to SQL 2k servers, one in our business premises and the other is running on a shared web server. The web server database is used to power our commerical...more >>

Hi, I hope someone can help. I have a dts package in SQL Server 2000 with 2 connections. table A in database 1, table A in database 2. Basically I want to update table A in db1 with the data in db2 because db2 is more recent. I want to pick the max date (from the date field) from table A ...more >>

Hi All, My DTS Package was working fine. I need to add 4 new task into DTS. These new 4 task suppose to run first. So I added new task and setup work flow properties. here is my problem Before changing DTS On Sucess on Sucess Truncate table...more >>

I am working on a DTS job to do some file manipulation and renaming and so on in preparation for picking up a file from an FTP source. Based on a suggestion in this forum (thank you Allen Mitchell), I do a count in a sql task: select count(*) as amount from mytablename where filedate = ? w...more >>

Is is possible to catch up with the status of steps when you execute a package using stored procedures? What 's the best way of executing DTS packages in your application? Thanks ...more >>

Hello, I have a dts package (DTS1) that is fixed to process a text file with a specific name and load it into my database. I have several files that need to be loaded by this dts, so I was wondering how I could do this. I programmed a separate DTS that has an activex script that runs in a...more >>

Hi, I have a windows 2003 server, which have those installed applications : sql server 2000 SP4, backup exec 10, office 2003. I have installed it from scratch 3 week ago. I got a problem, in a DTS, when I drag'n drop the "send mail task" object, I got the following error : "Cannot loa...more >>

Dear All, in our currwent software project we use lots of DTSRun commands to start several DTS packages that have been created by several developers. All packages follow some guidelines, including: Never hard-code any server-names or stored-proc parameters, use global variables instead. ...more >>

Hi folks, I need to send a text file from SQL Server box to a FTP file server using DTS. Pls help me to get this job done. Thanks in advance. ----- *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I am using C# to execute a stored procedure to execute a DTS. The DTS executes alright. It is a simple DTS to do a direct copy from excel to SQL table. The problem is when I attempt to retrieved the data inserted, it returns nothing. After some extensive testing, I found out that I had ...more >>

Hi, Has anybody made use of grouping together a set of tasks into a single transaction in DTS? I suppose, by default, the transaction gets committed per task. Is it advisable to use a single transaction for a group of tasks? In what scenarios is this useful? Is there any concept of Co...more >>

Hi All, I have a package with a ActiveX transform data task that sucks a csv file into a mssql 2000 table. The issue is that the CSV file may have either 10 (File A) or 20 (File B) columns. What I really want to do is say: If FileHeaderInfo = 10 Columns Then DTSDestination(001) = DTSS...more >>

Hi I have a series of DTS packages whgich were running ok as jobs on tyhe server. Something went wrong on friday and now I can't open/run them from the server. I have tried from enterprise manager a client and they run fine. From the servewr I get "[dbnetlib] [(Connection open())] SQL Serv...more >>

Hi, I have created my own application and I'm using DTS. I have an installation package to automatically install the application. but the installation failed on new computer (installation from scratch) The system can't register any DTS DLL files!!! the manual regsvr32 dtsffile.dll comman...more >>

I have a DTS import that imports a text file into a sql server table. The file is around 650MB and contains about 1.5 million rows. I tried importing it 3 times and each time it would import around 790,000 records and say it was complete!!! So I split the file into 3 separate files thinking...more >>

Hi, I am working on migrating many Oracle tables to SQL server 2000 and performing column level transformations for most the tables. I am first planning to export all the Oracle tables to a staging database in the SQL server 2000. Then apply transforms for the tables and export it onto the ...more >>

Hi I am trying to import some 490 tables from Sybase to SQL Server. I just want the first 10 records of each table to be imported , can we do that using DTS wizard.... or is there some other method plz help Thanks. ...more >>

I am getting the error message "Not enough storage available to complete operation" when trying to use the lookup feature in a DTS package. Article 889170 indicates that this should be fixed in SQL Server 2000 SP4. So, I installed SP4, but i'm still getting this error. I really need to use ...more >>

Is there a sample code or document which can giude me to the executing DTS packages from an ASP.NET page. Thanks ...more >>

Hi All, I want to rename table automatically .How can i do this ? from example table name is Customer --> wants to rename every day as Customer --> Customer_20050708 on next day Customer --> Customer_20050709 any help .. Thanks ...more >>

Hi All, I want to create DTS package in which i will have source is MS Access file. and import the data to my SQL Server Database. Now i want to pass full qualified path of ..mdb file thru SP parameter and then execute the package thru SP itself. How can i do this ? If any code sample i...more >>

Hi, could you tell me how can I do the "migration Wizard" for import data from Access MDB to SQL 2005 ? Thanks Javier -- I am using the free version of SPAMfighter for private users. It has removed 9800 spam emails to date. Paying users do not have this message in their emails. Try w...more >>