Hi All, I am doing ETL using DTS I have two servers : Server_1 : OLTP Server (SQL2k) Server_2 : OLAP Server (SQL2k) my biggest dimension tables could be 5000 rows and my Fact tables could be 300.000 - 400.000 records. Which one from these two options will be better for ETL (e.g : table S...more >>

(SQL Server 2000, SP3a) Hello all! I've been wrestling with a bear of a problem with my DTS Package. It has a sub-package (several of them, actually), and when I run the package in the DTS "designer" (from Enterprise Manager) or DTSRUN.exe, everything works splendidly! I have since made ...more >>

How would one go about doing this: Table 1: DimA Type FromDimB ToDimB 123 A 1 2 456 B 1 2 789 C 3 8 Table 2: DimB Type DimA 1...more >>

Hi, I have a DTS that is scheduled. The package it runs will run perfectly while running manually but when scheduled, it appears to get stuck on the first step till i manually stop it. then in the job history i would see 'job was canceled' help? ...more >>

Can anyone suggest how I go about using the FTP task to download the contents of a directory on an FTP server when the filenames are always different. The legacy software in our organisation will output x amount of dat files all with unique name. They will sit on an FTP server. I need to copy th...more >>

this name is used anywhere - in scripting, logs and i wonder that there's no obvious way to set it for dts task/step in dts designer. anybody knows solution? ...more >>

I have a DTS package that I have written to has a SQL task that runs some code simular to the following code. The problem is that I have been running into is that when the cursor is going though the email addresses, sometimes it will just error out. I put an audit insert statement on the script...more >>

Is there a way to change the owner of all of my DTS packages saved to SQL Server? Thanks!...more >>

My table looks like this: 1 A B 6 C 8 2 A B 6 C 8 3 A B 6 C 9 4 A B 7 C 9 5 A B 7 C 9 I want to get just the first record (1 A B 6 C 8) based on the second colunm. Thanks...more >>

I have a Windows command file which ftp's data from the mainframe to a text file, then uses dts to insert the data into a SQL 2000 database. This procedure works without a hitch when I execute it from the command prompt, or from within Windows Explorer. My problem is, when I had this scheduled t...more >>

(SQL Server 2000, SP3a) Hello all! I've got a package that has several "Execute Package Task" elements. I'd like to make the sub-packages version-independent. I ran across this blurb: http://www.sqldts.com/default.aspx?216 Which talks about blanking the PackageID. I've done exactly a...more >>

I've made a DTS-Package that first delete rows from a tabel and then put new rows in that table. This package runs by a batch-file (ISQL; dtsrun /s database /e /n Batchname). Since a few weeks the batch runs with error's Step Error Source: Microsoft Data Transformation Services (DTS) Data Pum S...more >>

(SQL Server 2000, SP3a) Hello all! I have a DTS package, that I'll call "A", which calls another package "B". In A's Global Variable (GV) space, I'm defining the following variables: SourceServer SourceDatabase SourceUser SourcePassword DestinationServer DestinationDatabase Destinat...more >>

Hi All, I need to do ETL to pull data from 10 OLTP database into one Olap database. I do it by creating stored proc and call it from 'Execute SQL Task'. from 'Execute SQL Task' => EXEC SP_UpdSalesman_Dim => Create Proc SP_UpdSalesman_Dim AS Insert into Salesman_Dim Select ...more >>

I would like to create DTS for Importing from CSV using store procedure, = in which I would like to update fields conditionally. Anyone can help in this matter or let me know url/tutorial on this. Thanks in advance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus sy...more >>

(SQL Server 2000, SP3a) Hello all! I have a DTS package that I'm working with, in which I have a query that I want to invoke on a target SQL Server that will return a handful of rows. For each row, I want to set some package properties (on another object in the package). What would be the ...more >>

Hi, I am getting the following error when I try to export a table to an text file: The instruction at 0x77bd4d30 referenced memory at 0x00000000. The memory could not be read and then a second one The instruction at 0x4173d23a referenced memory at 0x01d71e90. The memory could not be ...more >>

Hi I need to import data from Excel 2003 to SQl Server I could see that the first row is always treated as the column headers and the data from the second row is assumed to be the real data Actually in my Excel File, we have some author and File information in the first two lines The column h...more >>

In running a specific task in DTS, I get the following error for SQL 2000 on Windows 2000 "The DTS cannot copy or transform data from a desktop or MSDE Server to a standard, Enterprise of small business version of SQL SERVER unless your destination server is per user licensing mode. I thought it...more >>

Hi all experts, One of our customers lost its transaction data during one period, say April 1 to april 30, in live MSSQL 2000 database, and those data can be found back in backup performed manually one week ago. Anyone out there can help me get lost data back from backup and merge into its ...more >>

Is there a way for a Web interface to execute a DTS package and pass a parameter to the package?...more >>

Is there a way to output header and trailer info when exporting a text file when using a DTS package? Any suggestions? Has anyone done this before ...more >>

What are the requirements for the SQL server to be able to send e-mail. Will I be able to send e-mail if I do not have an Exchange server? Thanks ...more >>

Is there another way to get input from the user other than the Input statement. I would like to use something a little more graceful. I don't want to have to use a front end to my dts package if possible. Thanks ...more >>

I want to develop some custom DTS tasks in VB .Net and C# can somebody point me where I can get some simple sample custom DTS tasks source code that I can have a look at. Also, I am planning to use some ActiveX controls which I was using on Vstudio 6.0 in the new .Net VB.Net and C# custom task...more >>

DTS Designer error: Class not registered. Thanks all reply....more >>

hi sql experts! my PC has been reformatted. i am accessing a SQL7.0 databases. before my PC is reformatted i can view and edit all DTS packages. and now, i have SQL7.0 back installed on it but now it cannot open any dts and gives me an error something like 'the parameter is incorrect'. what...more >>

Hey folks, I'm pretty much a newbie as it comes to doing any DBA-type work on S2K servers, so hence this message. I'm in a position at work where everyone has to chip in as best he/she can, and since I know about some databases (mainly MySQL and Oracle), guess who got volunteered for this?...more >>

I am transforming my dbaseIII database into a SQL. My Source Database has a field with Identity set to "Yes". I want to convert my dbaseIII format dbase getting only two fields and perform my autonumbering in source database. How can I do that? ...more >>

hi I would like to transfer data from one database on a server to another server. I need to transfer only some tables . (100 out of the 200 tables that the database has.) But i want to specify the order of the tables that are to be transfered. like table a before table b and so on. wha...more >>

What is the best way to rename columns when creating tables using DTS? Our application field names (data source) are not user friendly and we wish to rename them in our sql server database. Please advise. Thanks....more >>

I have a send mail task that is not immediately sending the e-mail. What happens is the e-mail doesn't go out until I open Outlook 2003 (on XP) and hit Send/Receive I even see it saying "sending 1 message" when there is nothing in my outbox. The profile in the send mail task is 'Outlook'. T...more >>

Below you will see a section of fixed width data that I need to import into SQL server. When all the data is on one line, I have no problem, but as you can see below, each record has multiple parts to it. How can I get the 4 subsequent lines imported in the same record with the demographic data...more >>

Hi all you Experts! I have an SQL-8 running smoothly. I've created few local packages that transform data from a server in a different domain running Tabula Database. i have no problem running the packages manually and getting all the data i need I do have a problem scheduling t...more >>

In trying to open a DTS package from SQL Enterprise Manager, I am getting an error: "Package Error" in title bar of the error pop-up and the error message: "Error Source : Microsoft Data Transformation Services (DTS) Package" with the second line of the error message: "Error Description: The sys...more >>

DTS consistently fails on my SQL Server 2K database upsized from Access. Whether I upsize to an existing SQL database or create a new one, DTS fails with the following error when I try to copy SQL Server objects from that database to another database (both on the same server): "Need to run the...more >>

Hi al How do i run a DTS package from a SP, passing a Parameter Thank Brian MCSE AACS ...more >>

Hi all, I am trying to schedule a DTS package which does some deletion, insertion and updating in a DB2 database. It always fails. However, when I run the package stand alone it works fine. My SQL Server agent is started and using the correct service account (other jobs process when ru...more >>

Hi all, I need to do ETL/ data movement from sales data and some dimension tables located on 10 database into OLAP database. The databases are located in two servers. (e.g: Server_1 : 5 databases, Server_2 : 5 databases) They are actually same tables name on each databases. I am looking fo...more >>

Hi all I'm working with SQL2000, i'm trying to write a table (2'000.000 registers estimated )using a DTS but every time that I try to run it i receive this error msg Error Source: Microsoft OLE DB Provider for SQL Error Description: The Log File for Database 'My_DataBase' is Full, Back ...more >>

Hello, What is the easiest way to avoid constraint check problems when using DTS? Is there a way to disable constraints temporarily to allow DTS to run smoothly? With constraints enabled, I have to export / import tables at a hierarchical order. This could be a pain...Obviously, this will g...more >>

Anyone know how to have a DTS Datapump fire off a Trigger (stored procedure)? I have a trigger that will send off an email any time data is "inserted" into a table. However the method I use for insertion each day is a DTS package that transforms the data from the datawarehouse into my local app. ...more >>

I've exported one table using DTS to *.txt file: "id","name","calories" {F5F781EF-4270-4D8C-B5E0-A968F45FF771},"Ananas frisch",60 {CA0E96D8-9017-4DDD-BF29-B78D3DC8180D},"Ananas Fruchtnektar",70 {A1777D54-9303-4AF5-A721-250A39BA731C},"Ananas Fruchtsaft",60 {DACC2063-0985-41EB-9A33-B4D8A10F1C79...more >>

Any comments about AdeptSQL vs Red Gate as data base compare tools?...more >>

Hello, I am using SQL Server 2000 sp3a. I have a DTS package that has been running fine every day for over a year. Today I opened the package in the DTS Designer and modified one query in an Execute SQL Task. When I clicked the Save button, I got the following error: Package Error Error ...more >>

Hi NG I read a lot of articles about "DTS and functions/SPs" but i guess i didn't get it at all. So, here's my code with which i tried to integrate a function call inside a data transformation. And it doesn't work. '********************************************************************** ' Vi...more >>

I have an Active Task in a DTS which uses CDONTS to send an email. When I execute the package manually it works. The schedule doesn't. It says in the job list that it has been successful. The email does not, however, get sent. The job, server agent and task scheduler are all enabled. I have even ...more >>

Is there a known way of restoring individual DTS packages from backup? Thanx for your help, ...more >>

Hi all, I am currently facing a problem structured like this: Our Server can not send mails due to some configurations applied by our firewall. To work around that I created a StoredProcedure which is using CDO to archive the same goal. ....so far, the SP works as expected and sends mails. ...more >>

I have couple of VB6 based custom DTS tasks how can I upgrade them to VB .Net custom tasks is it straightforward without lot of changes. Where are some samples of custom VB .Net custom tasks. Is creating custom VB .Net tasks programming much easier than the old VB6 based custom tasks. Tha...more >>

Hi, I m working on a dts package, and it seems there is a limit with the field lengths.. When I use several long field names like IdCompanyNameTemp, the dts failed. I have to convert them into small name like IdCompanyNameTemp as expr1, etc..... The limit seems to be 235 (when I add each c...more >>

On my SQL 2K development system when I open the DTS package I get a DTS designer error. Further, all tasks in DTS are totally missing and further even the transform task does not work. I tried completely uninstalling SQL and reinstalling SQL still the same problem. Is there a good free unin...more >>

Hello All I had built a couple of custom DTS tasks in VB 6.0 and they were all working well on Windows NT and Windows 2000 running SQL 2K at SP1. Now I have a SQL 2K system on a Windows 2003 with the .Net Framework. I did a regsvr32 on the same custom tasks and registered them within the regi...more >>

One of my local DTS Packages is giving this error: Error string: 'G:\FolderName1\FolderName2' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. I've also tried the UNC path with the same error. Th...more >>

Can anyone give me a clue of how to easily and simply populate gif files into a blob field?...more >>