Hi, We are trying to execute a dts package as a job. The package excecutes fine when run manually, however fails when run under a job. All our tests have been done on the physical server itself. Here is the resulting error: ------------------- DTSRun: Loading... DTSRun: Executing... ...more >>

Hi All, If I have a stored procedure that is being run by a DTS which is scheduled to run by SQLSERVERAGENT. From that stored procedure, can I retrieve the job id, task id, step id of the DTS package? Thanks. ...more >>

I am trying to create a package that performs a query on a SQL table and writes out to a fixed length text file. My problem is that I do not want a column-for-column transformation. Some columns will be written. Some will be ignored. And others will be broken apart. The only columns listed (unde...more >>

I have seem to have extra Connections that are visible in Drop-downs, etc, and although no tasks are using these connections, I can't seem to get rid of them. An easy way to duplicate this is to 'Copy/Paste' a connection in the designer. You'll end up with 'Connection 1 Copy' or something sim...more >>

I am trying to get business days using datedif function. I get the difference in days, but do not know how to account for Saturday and Sunday. Can you help?...more >>

I am new to DTS. I want to do below task with DTS any help will be very much appreciated, I want to map network drive with DTS and then create directory on that drive and after successful execution of this task run other DTS which I have created and after successful execution of called DTS dis...more >>

hi all ! I would like the last task of my package workflow to send an email with the package log. the problem is that the email is sent, but the attachment contains the package log "before" the package started. so the question is: how would you do to send the package log, as soon as poss...more >>

Hi I created a DTS package and saved using an owner and user password. I own the package and saved it using Windows authentication. Both user and owner passwords are the same. When trying to open the package I'm prompted to enter the 'package password' so I type it (and it's definitely the right o...more >>

Hi, I have a problem with a Query in my Package. It works fine with a stored procedure but it quits SQL Enterprise when I use it into a DataPumpTask. It seems it's the Count function. It bugs when I use the ? as parameter with memory read error, but if I set a fixed value, it works. Thanks ...more >>

Hi All, I'm not able to transfer stored procedures through DTS. I'm transferring from one db to another db on the same SQL Server. It looks like everything fine but the SPs are not getting transferred. I've SQL 2K with SP3. Please throw any ideas.. Thanks......more >>

I'm trying to copy stored procedures from one database to another db on the same server through DTS. Everything goes fine but the stored procedures are not getting transferred. Am I missing anything I've SQL 2K with SP3 Please throw some ideas.... Thanks John...more >>

Hi I have a DTS package which contains Execute Package Task. The package works smoothly on SQL Server A Consider following scenario 1. I save main and inner DTS package on Server 2. When I try to execute main DTS package, I get an error that the Package Version ID of inner package is not correc...more >>

Hi there I have created a DTS package which; Drops a table Creates it again Copies data from a text file into the table (simply using the 'copy column' transformation) However, my transaction log fills up, and I get an error - 'log file for database XXXX is full' etc. I am already l...more >>

A cube is fully processed, but can not browse data. Screen shows "Unspecified error." What possible problems can be? Thanks for suggestions. -Tom ...more >>

Here is a quick question, I know it is quicker to load data with out any indexes, but if there NEEDS to be indexes on the table is it quicker to load data with the index there, OR drop the indexes, Load the Data, and then create the indexes. Thanks in advance JPO...more >>

I get the following error code when I run the job from the SQL Admin Interface or when it runs from the schedule. I can run it from the command line with no problem. I have no idea what this error is and can find no reference on Microsoft.com. Can anyone help? DTSRun: Loading... DTSRun:...more >>

Hi, I m near to end my package.. I have a problem with the Loop I add my script at the end. It exports the first file but ignore the others rows. It seems after the first export process, it doesn't go back to the oRS.MoveNext Line. Any idea ? Stan Function Main() dim pkg dim...more >>

Hello, all. Have 2 questions. 1. In creating an ActiveX Script Task, on the ActiveX Script Task properties screen, only the JScript Language shows as an available language. I'm using EM on my laptop, but connected to our server. But, when using EM from the server itself, when I go into...more >>

Hey All, When i try to use the copy database wizard, i get the following error message. Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000) Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Step Error code: ...more >>

To let a user view other people's DTS package (readonly), what permission should give to the user? Thanks for help. -Tom ...more >>

I need to send email out regularly and they don't allow me to use SQL Mail or use sp_OACreate. So, the only option I can see is to have the web page to send email. How do I create a job to call that web page? The last option I can do is using the Window scheduler which I don't want to use....more >>

Please place comments above.... My error: Unknown token received from SQL server Protocol error in TDS stream What is this and how/if can/it be corrected???? Details... DTS Pkg w/a connection to a Linked Excel spreadsheet with a range web In QA: select * from openquery(WebImport,'sele...more >>

When adding Send Mail task to a DTS package, I receive the following error message: "Unable to get MAPI profiles" This is received before the display of the mail configuration screen. SQL Mail is running and jobs are sending e-mail messages successfully to defined operators. I would a...more >>

from the solution at http://www.sqldts.com/default.aspx?254 i must go to dts window designer but i don't have it on my notebook, i use sql server enterprise edition, how can i do...more >>

hi all, I'm getting crazy with the above error! Pls help me! I'm trying to export data from an Informix db (IDS7.31) to an Excel file using DTS. This is because the Informix is working on a server where also is a MSDE (Sql Server 7.0 sp4) db I create the DTS and manually it works properly,...more >>

Hi, I tried to import a CSV file (8M rows) into SQL2K (with sp3), but the import stops after 2M rows with the strange message above. Platform: Win2K sp3 I'm not sure, but it might be an issue with special characters like =E4 etc. Any suggestion for this problem? Thx, Wilfred van Dijk...more >>

First, I would like to thank Allan and Darren for their contribution. I start understanding dts ;-) My question and I think it will be the last, is how to dynamically change the filename for an export file. Stan ...more >>

How to I get proper case for the first name field? With the value: Mary Ellen, or mary ellen, or Mary ellen, or mary Ellen, strFirstName = RTrim(DTSSource("First_Name") strFirstName = UCase(Left(strFirstName,1)) & LCase(StrFirstName) I get Mary ellen TIA JeffP... ...more >>

I have less fields in my flat file: 1> select * from test1 2> name1 name2 ---------- ---------- aaa aaa ccc ccc bbb bbb which can be gathered in data file using bcp in process I need to import this to a table having more...more >>

I have this error "Duplicate column name resolution could not be done because the ordinal specified a column of a different name" when i try to execute my dts package. I have already check my script. None of the column is duplicating. Could someone help me on this??? Thanks..........more >>

On about 8 hours of this issue....and not getting very far, just short of calling MS...: DTS Works with the following: IIS 5.0 > SQL 2kSp3 (on diff. boxes) DTS is set in EM to run under SQL authentication. Code on IIS box: ============ ''STEP 3 execute package that inserts data from flat ...more >>

I know this question could have a real complicated answer, but I need some direction. I am building a data warehouse and bringing data in from another sql database. In the past, I have utilized the following technique: - DTS - Step 1 - drop table "ProductLines" - Step 2 - Import Table Product...more >>

Hi people, I need to extract 6 views to the same Excel file. I have to extract many times. So I think: create a DTS package and create a Global Variable with the name of the file, so I can run the package passing the name of the file. Does anyone have any example of this kind of configu...more >>

I have three local packages on my server. But when I select Package Logs... from context menu for a package it doesn't any available packages for the server. I have one package schedule to execute every day I want to know if it was executes. I thought to use Logs, but I can't find them. Thanks,...more >>

Hi Guys, I need to move a SQL2000 database to an overseas location. What would be the best way to do this, bearing in mind that the database will be transported on a CD. Thanks ...more >>

Hi I still have problems with a DTS package. I have a Table A, where I have the path file to save the file and the ID company I need to generate a csv files from a table B for each ID company using its Path file. and this job must be scheduled. Of course, the goal is to use a unique DTS p...more >>

I have data from table product to import to sql server but it failed, because product_code field ( data format in sql is varchar ) the example for product code - if i have 2 data records , the first one, product code is 8790, and the second ,product code is A249 , when i import ,it fail ho...more >>

what is DTS Lookup. Can anybody pls give a quick example. Any comments is appreciated. ...more >>

I have a DTS package that has a scheduled job. It has been running fine for over 2 years now from a scheduled job. The scheduled job will not run now. I can execute the package on its own in Enterprise Manager, but now the scheduled job creates this error DTSRun: Loading... DTSRun: Executin...more >>

I'm running SQL Server 7.0 on Windows XP. And I get the error "The procedure entry point GetIUMS could not be located in the dynamic link library MSDART.DLL" when I try to import a file into the server. Any idea on how to fix this? Thanks, Jim ...more >>

Hi there, I have MS SQL server 2000 with SP3 installed. I have installed MyODBC driver, because I want to export a table from my MSSSQL to my MySQL webserver every day. Everything is going ok, until I get to where I can choose to transform the output, when I click the buttom with the "..." sign...more >>

Hi , I am using a query for a transform data task.The inner query takes 2 parameters but when i am trying to set parameters it is saying access voilation.I do not want to create stored procedure although it is working .Can anyone tell me the way how to pass parameters to a inner query or i...more >>

I'm using DDQ for my DTS package. I have already set 3 connections which point to different database. 2 are source and the other 1 is the destination. How can I select the source from 2 different database and put them into 1 destination database??? Thanks...........more >>

Hi, I have created a DTS package that needs to be run multiple times with a single column's data changed. Rather than create multiple DTS packages for each, is there a way I can easily change this column's value when I run the package? Ie. have 1 or more options that I set when I run the pa...more >>

This is probably a really simple problem, but here goes: I have a stored procedure. Within this stored procedure I am executing another stored procedure for the purpose of retrieving data from 2 output variables. The trouble is, it also returns a resultset which I would like to ignore as I wis...more >>

I need to import some data into an existing table from a spreadsheet. I right click the table to import, and walk through most of the steps, but I'm stumped because I need to map the fieldname in excel to the fieldname in the table, and also because I want to just update the records that are alre...more >>

Hello My package is supposed transfer data from table to text file. I read that I can use Dynamic Properties Task to make the package portable. I added the Dynamic Properties Task and created global variable to SERVER_B (My original package is on SERVER_A) then I saved the package as my_pack...more >>

Can a same dts package be run by multiple user's or only a user can execute a DTS at a time only. Thanks a lot. ...more >>

what are scenario's we should use dtsrun. ...more >>

hi all !!! this is my scenario (simplified for this post): Source: Informix database with single table with more than 100 hundred MILLIONS of records Destination: SQL2000 with two tables (A and B) Requirement: write a task that reads from the huge Informix table and, depending on condition...more >>

Hi, I have a question. Can ActiveX scripting process the DOS command? If so, could you please provide me an example? Thank you...more >>

On one of 3 tested SQL7 servers, a plain vanilla BULK INSERT query that's importing a simple tab-tab-return text file says that the query completed successfully, but doesn't import any rows. The failure happens when running the query via Query Analyzer running on the same machine, on and also th...more >>

I have a DTS package that when I run it from the management console, inside the designer, it does not appear to be logging... I have an asp.net based utility that allows me to drill into the log for the DTS package using these procs in the msdb database. sp_enum_dtspackages sp_enum_dtspackage...more >>

Hi Could anyone please show me some sample code on how to insert a record into a table via vbscript in an activex module. Cheers ...more >>

G'day I have a DTS package that has been running in production without error for several months but suddenly is failing since yesterday. The error message is: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. No changes have been made to the data sch...more >>

I tried to transfer the logins from on server to another and received this error message. "Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have rights to copy file over the network." How do you change the sql servi...more >>

I know we should've backed up our DTS.... but this is still strange. We use several DTS packages to exchange data. Suddenly last night the jobs quit working. When I open the DTS in Ent. Mgr the package is empty!! No workflows, no file objects nothing!...in ANY of the DTS packages...the date ...more >>

Simple one I hope... I have a DTS package which branches depending on the success or failure of a task. The Package is scheduled to run as a job under SQLAgent. If the Failure branch is taken the Package returns Failure status to SQLAgent although the subsequent steps complete successfully. I gu...more >>

I would be greatful if any one can help with the following: I would like to move large SQL tables (10 million rows) containing blob data to another SQL server located on a separtate network. Is there a native SQL format I can use rather than exporting to dbf,paradox etc. I would like t...more >>

SQL Server 2000 SP3, Win 2000 Server SP3 I have a DTS package which reads data from an Oracle database. Installed the Oracle client 8.1.6.0.0 on the server. If I log in using the account under which the SQL Server Agent runs, I can run SQL*Plus and tnsping against the Oracle database and can e...more >>

I have a Local DTS package which creates an extract file from a table in SQL Server using a basic VBscript ActiveX script on SQL Server 7.0. It runs fine from Enterprise Manager, and also if called via a SQL Agent job, but not when I call it from an ASP webpage. See below for the web script co...more >>

I am trying to populate a csv file with a stored procedure that returns result set. Everytime I do that Enterprise manager crashes. Is there any known SP3 bugs/issues which cause a problem with DTS? Environment- OS- Win 2000 Adv Server SP4 SQL Server 2000 SP3 Steps 1: DTS --> new pa...more >>

Hi, I am new to DTS and SQL server. My problem is how I can create DTS, which will dump SQL query data in to CSV file. I have CnDate as datetime one column so I wants to create CSV file which contains yesterday's date in CSV file name and it dump all row which has yesterday's date under CnDat...more >>

I have a job which transforms data from Oracle to SQL. It works perfectly if I run it in DTS. However, it returns an error if I scheduled it to run in the scheduler. The error indicates that the Oracle client and networking components were not found. However, the Oracle client and the ne...more >>

Hi I have a strange problem and I don't know where to start looking. When I attach a file to the sendmail block everything seems fine, but when I get the file i the mail it has included the path in the filename!! "c:\somefolder\testfile.txt" becomes csomefoldertestfile.txt someone knows ...more >>

Is there a way in Active X to set an Excel worksheet object (from a parameter) and loop through the tabs importing data? Our client insists on keeping critical data in spreadsheets that need to be uploaded on a nightly basis. The sheets vary in numbers of tabs, and I would rather not har...more >>

I have a Stored procedure tha call a DTS package using dtsrun ie exec master..xp_cmdshell 'dtsrun /SsqlSERVER\Instance /Usa /Ppas sword /Nget_spscripts /Agv_campid="C1"' when run on the Production server I get the following error Error string: The specified DTS Package ('Name = 'M00...more >>

I wonder if anyone can assist with this one. I have a simple DTS package that reads data from an Access database and inserts it into a table on the local SQL Server. The job runs fine when I run the job from the DTS designer, or if I use DTSRUN. But when scheduled from SQL Server Agent, i...more >>