Hi Experts, Appreciate if someone can help me. I'm trying to import a text file mytable.txt delimeted with pipe(|) and containing 300K of rows into empty table that I've created earlier. While I'm executing the DTS got this message :- There is already an object named 'MYTABLE' in the data...more >>

Getting two tables from one base with 4 mio and 11 mio records. The 11 mio records are dimension specification on the 4 mio records so I need to put these 11 mio records alongsid the 4 mio in my fact table. -- Example table 1 create view trans1 as select 100 as beløb, 1 as linje union all ...more >>

Hello; First off, let me say that I'm not a DBA, I'm more of a web application developer that has to wear many hats (but I did pass the 70-229 test ;) So, that being said... My client has two databases: Database A and Database B Database B was built off of Database A, but has a few mor...more >>

I have a .dts file that I would like to open/setup within my SQL Server 2000 server. Does anyone know of a way I can insert the DTS package without using Enterprise Manager? I'm trying to automate via Inno Setup and can use OSQL. ...more >>

Yes, yes I have read the article on SQLDTS regarding output parameters in Execute SQL Task. Well, it aint so easy!! Since there is no visibility into the processes involved, I can not debug it. Here is what I am trying to do: Execute a proc with two input parameters, and return the ReturnStat...more >>

I get an error when I put comments at the top of my queries when trying to set them up to use parameters. Without the comments, I don't. Even if the comment is as simple as /* */, I get the error and it doesn't let me setup the parameters. I can put the comments below the query with out gettin...more >>

I'm running the following from the command line dtsrun /S"servername" /N"packagename" /U"username" /P"password" and receiving the following error Error: -2147217900 (80040E14); Provider Error: 14262 (37B6) Error string: The specified DTS Package ('Name = '"packagename" '; ID.VersionID = ...more >>

I am attempting to execute a DTS package from Query Analyzer using the DTSrun utility under xp_cmdshell. When I execute the package, I receive the following error: "DTSRun OnError: Copy Data from Results to J:\IDEAS40\TRISQL44\MJE\Data\MJE065d.txt Step, Error = -2147467259 (80004005) ...more >>

Hi Experts I have written a dts exporting data from SQL to Excel and the data is exported fine, however when I save the dts as VB and run it from VB, it just exports the headings of the table into Excel, but does not export the data in the table. What am I doing wrong? I know I have data...more >>

Hi All I trying to pull data from another server by the use of linked server. On the server pulling the data I have views accessing the linked server. My question relates to the remote user choice - when setting up linked server it seems as if I can only choose to connect using af databas...more >>

SQL Server 2000 Service Pack 4 When running a DTS package interactively in Enterprise Manager, there is no way to close the package when it completes. There is no OK or Close button on the form. Also Cancel does not work. The package remains open and you have to use task manager to kill Enter...more >>

I would like to save the definition of a DTS on a file. Besides I would like overwrite the file every time that the DTSRUN is performed, so that to contain the dimension of the file that grows always otherwise. Can you help me? Thanks ...more >>

Hello All, I hope someone can help me with this, I couldn't find anything on the Internet. I have a master package that has to execute several other sub packages. I am using a ActiveX Script Task to set the filename properties of the ExecutePackageTasks that execute the sub packages. The...more >>

We had a DTS package written by presious staff. which import data from MS Access database to SQL Server 2000. So basically what;s he'd done was like direct mapping from Access Columen to SQL Server column. and we have a new request to somehow do some kind of upfront processing to the data. ...more >>

We're backing up our database by using DTS to transfer it to another server. The DTS package is very simple, it consists of one 'Copy SQL Server Objects' task. This task is set to drop all objects, recreate them, transfer the data and then restore all constraints and relationships. We're se...more >>

How do you give user friendly name to columns from a text file connection? change col001 to AccountNbr, etc for use in script transformations....more >>

I have inherited fe DTS jobs without any documentation. Is there a way I can generate documentation or an easy way to document it? How do I figure out the starting point of a DTS package? Any pointers / info is appreciated. TIA ~Sat ...more >>

I want to use an aggregate function (Count) to set a field value in an Update statement. I get an error that states this is not allowed. I could do the aggregation in a view and then update the field value based on the view, but is there a better? Following is what I want to do: UPDATE PCP_...more >>

I'm using SQL Server 2000 SP4 and am trying to execute a DTS package using the DTSRUN utility using the "AT" scheduling command in Windows Server 2003. Unfortunately, the job fails and the reason is because the package is being executed by user SYSTEM. I can tell this by the log file. I've ...more >>

In am importing various delimited files in to different servers/databases. The DTS has dynamic properties, a execute SQL task to clear the tables, a text file source, a transform data task, a SQL server connection, and a execute SQL task to load the foriegn keys to the table. I have includ...more >>

Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL Server Agent. Periodically TDSRun will fail with the following message in a dialog box. The exception Illegal Instruction An attempt was made to...more >>

Hi, I have two servers (I logon locally, but both are in a domain). And I have to use DTS to transfer some zip files and after use ftp. Well, I don´t want to left map the another server. I wanna using in the box of the component of destination field : \\10.10.10.10\dts But when I close I am ...more >>

Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL Server Agent. Periodically TDSRun will fail with the following message in a dialog box. The exception Illegal Instruction An attempt was made to...more >>

Hi, I have a server running on Windows Server 2003 and SQL Server 2000 SP3a. It runs 16 DTS packages scheduled to run once per minute via SQL Server Agent. Periodically TDSRun will fail with the following message in a dialog box. The exception Illegal Instruction An attempt was made to...more >>

I am having trouble executing a DTS package from a SQL Job. It works OK for a while but then starts failing with the following error message: Executed as user: domain\SQLSvcAccount. DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize...more >>

Hi, I have a task delivering every 15 minutes a number of lines from a database. Is it possible to store the number of selected rows in a global variable for further use in the package? I don´t like to send two statements, one for the count and the next one for the resultset because of ...more >>

I'm working on a DTS Package that will need to be scheduled to pull data from a table on remote server, which I know can mostly be done via wizard. My question concerns the query statement used to select data within the wizard. The basic remote table (tblDealer) structure is this: DealerID...more >>

Hi All When I reimport a DTS from a Structured Storage file all the layout is screwed up. Is there any way to stop this happening? Thanks Pete...more >>

I'm getting a flat text file that I using in DTS. The files are fixed width but occasionally rows will have misplaced carraige return line feeds <cr><lf> embedded in them. I planing on using FileSystemObject to exam the rows and then Replace(sReadLine, chr(10) chr(13), chr(40)chr(40),,0) ...more >>

I need to make a decision whether to store a DTS package on the SQL Server or on the File system. Can the group please fill in Advantages and Disadvantages on either side. Thank you all in Advance ~Sat ...more >>

Hello, I have a dts package that pulls data from a .csv file and then scrubs and loads it into a table. Is there a way to change the file path and/or name using t-sql prior to executing the package? Any help would be greatly appreciated! Thanks in advance....more >>

In SQL 2000, is it possible to edit or create DTS packages without Enterprise Manager? I know I can create a temporay package with the Import/Export wizard and then save the package. But I would like to edit a package without using Enterprise Manager to launch the tool. Currently, I launch the...more >>

How can I get the detailed step errors I see in the DTS wizard -- the information which row is failing and why via the DTS APIs in C++ application? I can get the very general high level error with GetExecutionErrorInfo. Thanks! Elizabeth ...more >>

I am fairly new to DB management. One of the things I have to work with is a DTS Package that simply copies a database. One thing that I have noticed is that every time this runs the transaction log increases and doesn't seem to clean itself out even when I shrink the database. Is there som...more >>

I need to exec a stored proc with one int input param, one int output param, and a Return int from within an ActiveX VBScript. I have been working on this for two days and am stumped using an ADO connection. Can't find much on MSDN for VBScript. Thanks, Michael...more >>

I have a dts pacakge in which an ActiveX Script task probes outlook inbox saves the excel attachment. This runs fine when I execute the package manually, when I put the package on scheduler I get an error stating ActiveX cannot create object(Outlook.Application) Access Denied. What could be...more >>

Hi all, I'm trying to load a couple of terabytes of data from an Oracle server onto a SQL 2000 box. The Oracle data comes from 616 different RDB files, each requiring a different "Attach" statement in the ODBC connection. To implement this, I have a worker package that copies all the table...more >>

I am using xp_sendmail to send emails during execution of package via an ActiveX task. On occasion, our mail server gets full causing the package to hang. Is it possible to make an ActiveX task timeout like you can an ExecuteProcess Task? I'm looking to be able to cancel the xp_sendmail task ...more >>

Hi I'm migrating data from the old schema to the new schema using DTS. The old and new schema are different. In the new schema we have identity columns as Primary keys and referred as foreign keys in the child tables. In the old schema Primary keys are not identity columns. So when I migrat...more >>

Hi I have csv file which has about 150 records, I need to load this into a table. csv file look like this pen,80,90 1- record cup,60,100 Ineed to store into a sql sever table like this pen 80 pen 90 as 2 records cup 60 cup 100 I thought of using DDQ. I am really stuck... n...more >>

This has happened a few times, and sometimes it fixes itself, but this time it didn't. Not sure how i did it, but does anyone know how i can get the designer to display my code? Here's the problem: when i open the activexscript task, it opens the scripting window. It usually shows 2 frame...more >>

I have a DTS package in visual basic that was created via the DTS wizard and it rolls back or empties the SQL table when a laod failure is encountered even though I have the following property set: oStep.RollbackFailure = False This doesn't happen in the DTS wizard, I get a partial load on t...more >>

I'm tring to import from Excel into SQL Server and get the dreaded "Data for source column...is too large for the specified buffer size." The source value > 255 bytes, destination column datatype is ntext. Per KB281517 I changed the registry entry TypeGuestRows = 0, even rebooted, but the pr...more >>

Hi...... For some reason everytime I run a DTS package with an ActiveX Script Task it hangs. So I tried to create a test package with only an ActiveX Script Task and it still hangs. The code in the task does only 2 things (for testing), reads a variable and assigns a number to it. I tried reb...more >>

Hello everybody, I have one XML file whcih is a zip file, which i do want to unzip using DTS and then want to load XML into SQL SERVER table, so can u pls let me know, how can i unzip file using DTS. thx...more >>

Hi All, I need ideas on how to improve a process that can generate a terabyte of data in a week. Our company produces software that analyzes code and one of the things we do is Code Duplication. We're processing hundreds of millions of lines against each other and generate gigabytes of resu...more >>

We're planning to use SSMA tool to migrate Oracle DB Objects/data to SQL Server 2000. I presume that this tool is not available in the market. In case if I need to use this tool, how should I go about the same? this is extremely URGENT!....more >>