I have tried the above suggestion on making the task work but I still can not get it to work. I have defined a task as stated above but when I do the following: oTask = pkg.Tasks.New..... The compiler states that pkg does not have these members. Please can any one advise on what I need ...more >>

Iam trying to create a new job in SQl server.So i Clicked new job in Enterprise Manager.I got Error like, "Error 22272:Can not load the DLL C:\Jobdate or one of the DLL its References. Reason :126(The Specified module could not be found)" Please help me to resolve this problem. Thanks...more >>

I want to inport a eventviewer file saved as *.csv or *.txt into SQL ,and split one row into muti rows,but I only can use one sign at one time. I just want to split one row into muti rows with muti signs such as "," and ":",how could I do? ...more >>

Hello There, what is the best methodology to schedule a DTS package, the one i used is simply right-clicking on the dts package, select scheduling and that's it. I have one package that fails with error "Not Implemented", I read the article suggested from Allan, but I do not think is ap...more >>

I have my live sql database on a remote isp server, which obviously i don't have access to the sa account. I can't use "copy database wizard" because of no access to sa account. My export from remote server to local fails on 2 tables because of relationships. Can someone give me some sample co...more >>

Hi there Hope someone can help me with this. I have a number of databases located on one server which I need to replicate to a backup server on a fairly regular basis. My first thought on doing that was to use SQL replication however I have hit upon some problems with that. The main one b...more >>

Can you run dtsrun.exe on with SQL Server 64 bit Enterprise Edition? If so, what files are required on the 64 bit machine the run. Also, is there any special registration that is required for the components. Thanks, Mike ...more >>

If a package has several steps and some of these do not run by design (e.g. they only run if a specific step fails) then looping through the steps checking for status as suggested in other posts does not always help: opkg.execute Steps_Success = True for each ostep in opkg.step if ostep....more >>

Hello! Anyone know how to access the error descriptions via VB script (not full VB, I am using the DTS gui to design & execute)? I am logging the insert or transform errors in SqlServer, but cannot figure out how to access the specific error message (the one that comes up in the text log fi...more >>

I have a number of packages saved in repository with lineage & scanning switched on. As soon as I click on 'MetaData' under the DTS folder, I get this popup : "An ActiveX control on this page might be unable to interact with other parts of the page. Do you want to allow this interaction?" (...more >>

Hi all, The following I found in the logfile from dtsrun: /* Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:ActiveX Scripting was not able to initialize the script execution engine. Step Error code: 800403F9 Step Error Help File:sqldts80.hl...more >>

Hi, using the wizard I'm trying to copy a database from my local PC to a server and I'm getting the following errors. Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 08001) Step Error Description:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. ...more >>

I don't know if this is possible: Is there a way where in MS Exchanges data and info are replicated or somewhat transmitted to sql server. I know i have heared it somehow using dts......somebody can answer, I just need something that will give me a "go signal", so that I can research. I don'...more >>

I need to export data daily in Excel format, the file name changes every day eg Exportddmmyyyy.xls. This works OK if you run it manaually but when you schedule it a a Job, it failes every time. I have a item that deletes the tempory table and rebuilds it, but as the name changes each time ...more >>

Hi , I am using the DTS to import the excel file to SQL Server. This excel files is generated by other system and is already in fix format, my job is only import the data to SQL Server.But , I found out that the excel file did not have any column header in row 1. That means the...more >>

Hi, I have an ActiveX transformation in a DTS package that runs fine if i execute the the individual data pump task, but behave differently if i run the whole package. Either from the DTS editor or from a schedule agent task. I have even tried the most basic script and the same thing ha...more >>

Hi, When I import from excel the first few columns decide the data type. I my first few cokumns are text followed by numeric. The value are stored as null in the Sql db after importing. This is know problem in Sql, is there any way I can bypass this programatically. Regards Sats ...more >>

Hi there... I'm trying to extract from a Sybase SQL Anywhere 5.0 database, and dump it into a table on the MSSQL server. It works perfectly when I activate the DTS package, directly on the server, but if I use a vbscript to do so, it fails to start up the client program, which is needed for Sy...more >>

Hello I have a DTS package which i have scheduled to run everyday at 5:00 am, and first day it failed on the task is suppossed to execute which is a task that executes another DTS package. The error is "Not implemented" when i manually execute the package, I have never seen this error b...more >>

Hello there I have two databases which are the same One of them is on my local server And the other one is on an internet server Every 12:00 PM i would like to update the internet server with the changes that were made on my local server Can someone help to know how to connect betwee...more >>

Dear all i got a problem. The situation is i got three package(a,b,c) by schedule. I wanted to run package c when package a and package b completed. Does anyone have any idea to slove this problem ? Thanks. ...more >>

con Sqlserver 2000, puedo ejecutar trabajos con ActiveX, con VBScript y Javascript, ¿puedo hacer lo mismo con C#, es decir ejecutar scripts hechos en C#, con trabajos de Sqlserver 2000? ¿Se puede ejecutar scripts con C# al igual que podía con VBScript? Con VBScript escribo codigo en un archivo...more >>

Hi Is there any way of downloading/uploading files from secure ftp site using DTS FTP task? If not Can i use windows command line FTP as part of DTS execute process to do the same? Is there any alternative? Thanks!...more >>

Hi! I am using DTS SQL DMO Bulk Copy program to bulk export/import data. Now i have 2 problems! 1. The incoming data file will have a header record containing the no. of records in the file followed by the file data. Now - how do i check the no. of records in the flat file is same as the no. ...more >>

Dears, I am getting below error while connecting from remote to sql server " New transaction cannot enlist in the specified transaction coordinator. " Thanks in Advance Dinesh...more >>

Hey, I have a DTS import package which works a treat when it is referencing the filename (txt file) setup via EM, but can you dynamically pass in a filename of your choice to a DTS to use as the txt source file? This DTS can be triggered via the web I want a text filename to be dynamic s...more >>

I'm attempting to move a database which currently exists on an old Oracle 7.34 instance and tried to use Data Import via DTS to SQL 2000. The Oracle database consists of views, indexes,packages,triggers as well as tables structures. I tried DTS using both the ODBC and OLE for Oracle and only t...more >>

I'm attempting to move a database which currently exists on an old Oracle 7.34 instance and tried to use Data Import via DTS to SQL 2000. The Oracle database consists of views, indexes,packages,triggers as well as tables structures. I tried DTS using both the ODBC and OLE for Oracle and only t...more >>

I am running SQL 2000 on Windows 2000. I am trying to run the following in DTS, but I get an invalid pointer error. It will successfully run in query analyzer, but not DTS. declare @temp table (center_id varchar (30)) insert into @temp select center_id from smscbm.cids_2003_vol where ...more >>

When I am using DTS to do a simple transform from one table into another, I need to select the destination table name. However, the drop-down list which gives the table name also shows the DB instance name, and since the instance name is quite long, the actual tables names are not visible...more >>

Hi, I want to know how does the Data Pump Task works when given the lookup query. Dowes it make a join between the source table and the table in the Lookup query and then update the destination table column with the result of the previous join for each record inserted in the destination tabl...more >>

Hi Experts, One of my customers wants a copy of the database to be on Unix so he can run his analysis tools. What is the fastest way to migrate data between SQL Server 2000/ Windows 2k --> Sybase 12.5.1 on Unix. I estimate my data to be around 10GB. What can I expect in term of migration ...more >>

Hi, I have 2 gigs of files (pipe delimited fields) from a mainframe, every field has trailing blank spaces of various lengths after the real content.exampe daveb |y|123456 | etc No problem at the SQL end if I have a numeric column. The problem starts if I have a varchar ---daveb wo...more >>

Hi - I have a DTS job with a transform on a column written in Perlscript. It basically splits the sections of a string formatted date (HHMMSStttt) into variables and concatenates them into a string that SQL can recognize as a datetime. Everything works fine until I try to add in the millise...more >>

Does anyone know if it is possible to programmatically map columns (source to destination) in a dts package. I call a stored procedure from vb that returns a sql select statement. This statement is then set as a property of a DTS package and the package is executed. I've been asked to a...more >>

Under the "Transaction" section of the Option tab in the workflow properties of a SQL task step, there is an option to check "Commit transaction on successful completion of this step". Do I have to check this in order to have each SQL task step (s) to commit when completed?...in this case,...more >>

HELP! has anybody else experienced this? Emperical evidence has shown that a DTS package that converts a table, containing a text field, with an ActiveX transform task used to work, and now fails with XP SP2 installed. Uninstalling SP2 brougt back a successful transformation. I searche...more >>

How can I use an automatically generated field(column) that is derived from other columns of the same table as a variable in generating another column within the same query on SQL Server. I tried this on MS Access and it worked quite well. An example of such query is given below: SELECT deb...more >>

Hello, I am trying to write a vb script that would check not one but the existence of two files before it goes into the next dtstask. I tried to use dtsglobalvariables, but is the same problem as if i have before with the function below: Function Main() Main = CheckFile(FILE1,FILE2)...more >>

I am interested in determining what the key features/differences are in Yukon's DTS compared to SQL Server 2000. We are building an application today in a combination of C#.net and calling DTS packages as apprropriate primarily because DTS seems kinda hard to program. I'd like to see if th...more >>

Howdy. I'm trying to build a query that will take an Excel file and pull a few rows of data from a particular sheet. I'm having a problem with my WHERE clause - I can can tell it to import WHERE a field matches a value, or WHERE the field matches another value, but not both. I've tried bunche...more >>

Hello, when I import my Access 2000 DB into SQL Server 2000, both tables and views are imported correctly, i.e. I can see the tables under folder "tables" and views under folder "views". When I import my Access 2000 DB into SQL Server 2005 beta, only tables are imported correctly, the vi...more >>

Hi, Can someone please help me. I have a directory full of .txt files and I wish to import the contents and the filename into a table in SQL2000. Any links on the web etc...?? Any help will be much appreciated. Thanks, Skc...more >>