Over the time we have been using DTS, our tean has acuminated a lot of packages and sometimes more than one package for a job. Just wonder if there's anyway to have a more organized way of saving the packages (i.e. folders) so we can manage the packages easier Thanks!...more >>

Hi I'm configuring a DTS packatge that will import data from an Access fil (.mdb). For serveral reasons the mdb file need to placed locally on the server. But the server don't have MS Access installed! Is it possible to work with Access files via SQL Server if you don't have Access installed? Can...more >>

Does anyone know how to open an Access database that has a password on it ?...more >>

I'm trying to move a multiple-table database structure from SQL Server to Access (don't blame me, blame my client...). A very simplified view of the problem is this: * The SQL "ProblemReports" table contains information submitted by a user. This table includes the user's name and ID string, a...more >>

I have the developers edition of SQL 2000 on both my desktop and my laptop. On my laptop, I have had more problems with msdart. I keep getting error messages that state that the "procedure entry point .... could not be located in dynamic link library MSDART.DLL." I have reinstalled SQ...more >>

Hi Everyone, I have my DTS Package branching now but I'm having trouble getting back to one path. What I mean is I'm branching using an ActiveX script to create an Excel spreadsheet. When any one of the branches is finished with a Success, I want to run a SQL script to write the result into a ...more >>

Can anyone help with this problem We have a SQL Server 2000 Enterprise Edition (SP3) on Windows 2000 Server SP3 When creating a DTS package through Enterprise Manager we get a 'DTS Designer Error' dialog box filled with squares and then find that nearly all of the Data Sources are missing from t...more >>

I am getting this error trying to import data from a text file to database Data for source column 3 ('hdrall_') is too large for the specified buffer size. Does anybody know ho to increase the buffer size Thank you ...more >>

In the wizard when defining connections DTS pulls an 8 KB sample of the data rather than the entire contents of a large file or database table. Is there any information available on how this is accomplished? I've looked at various connection properties and the headerfile for the DTSFlatFile OLE...more >>

hi, I created a package for FTP Task with overwrite option, but some how...once the file transferred via FTP, the destination file is getting deleted. I am not sure, whether I am missing some thing or the other... Please help me...thanks, Sreenath...more >>

new to dts. i have dts packages which import data from source text files into sql server. so far I've been unsuccessful in finding a way to block import of data in those text files which already exists in sql tables. the basic design of the dts package looks like this text files(1- n)-->data pum...more >>

I think Im close to being able to create an excel worksheet in dts. Can someone please lend a hand??? Ive searched online and cant really find this same task anywhere. Function Main() Dim exl, MyFile Set exl = CreateObject("Excel.Application") Set MyFile = exl.CreateTextFile("c:\tes...more >>

I have a DTS licensing question: Is a SQL Server 2000 license required for a machine dedicated to running DTS packages, even if that machine is not running the RDBMS component of SQL Server 2000? The DTS packages will, however, interact with SQL Server 2000 databases on separate machines (which are ...more >>

sql2k sp3 In Active X Script Task Props, I can use the FileSystemObject to create a file. Function Main() Dim fso, MyFile Set fso = CreateObject ("Scripting.FileSystemObject") Set MyFile = fso.CreateTextFile("\\packrat\Dept- IT\chris\excel\DailyRefundFromSQL\sqlout.xls", True) Ma...more >>

This is some code I copied from MSDN to use fso to create a text file. I plop it into an Active X Script in DTS and try to run it and it blows up. Function Main() Dim fso, MyFile Set fso = CreateObject ("Scripting.FileSystemObject") Set MyFile = fso.CreateTextFile ("c:\testfile.txt...more >>

Hello there Is there a way to run DTS Packege via sql code? on the query anlyser? any help would be useful ...more >>

sql2k sp3 Every day I need to run an sql query and shove those results into an excel spreadsheet. So what I wanted to do was have a dts package that: 1 SQL connection. 1 Excel connection. 1; Active X Script Task--Got todays date, replcaced the "/"'s with "", and then stuck a .xls on the...more >>

I need to import a flat file to a temporary table, then use the temporary table to modify an existing table. First, I create the temporary table. Then I do a 'transform data task' to import the flat file into the database. This is where I run into problems. I can't tell the 'transform data task...more >>

Hi I am trying to pass a recordset to a dll function from within an activex script in DTS but i am having problems. I have created a dll using vb to handle all our file outputting needs. This function required the recordset and a key and will do all the rest. My Code is === Function Mai...more >>

Hi, I am importing an Excel sheet containing a mixed data column. the first 6 or 7 rows are numercial and the next few are alphanumeric. DTS tries to import the column as float. I have read articles about this stating that the import drivers read the first 8 rows to decide the import format ...more >>

I need to change the Task Name embedded in the DTS, can anyone provide direction on how to access the Task Name for the change ? ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable ...more >>

I have to write a DTS package which would take data from SQL server and put it into an excel spreadsheet. The problem arises when I have to automate this process from an ASP front end. I have tried the code snippets available on the web but the package fails (though it runs from inside the...more >>

I'm looking for a way to reverse engineer the contents of a DTS package to store in a text file. I don't need the image - instead i need it displayed in a readable format I would like to compare dts packages across servers, so i'd like to save off the configuration, tasks, etc in a text file that ...more >>

I have a simple data transfer from Sql Server 2000 to Access 97. I have set up the DTS procedure to export a table to this Access database but am getting a permissions error. The error says it is from the JET Engine side and I've added an account to the appropriate workgroup with admin. pe...more >>

I try to save a package that I build. I used the the SaveToSQLServer method oPackage.SaveToSQLServer ("myServer","sa","",DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,"","","",ref pVarPersistStgOfHost,false); I get Access Denied error. Does any one know how I can save my package? ...more >>

After changing the sa password, I cannot open packages They are saved as structured storage files (*.dts I don't know the old sa password. How can I recover those packages Thanks...more >>

Hi We are trying to run a DTSpackage through a scheduled job. It fails! The package is running 2 ActiveX scripts that uses Scripting.Dictionary objects. The first ActiveX script fills a dictionary object and assigns a global variable 's value a reference to the object: S...more >>

hi! Recently my scheduled DTS job slowed down drastically. Normally it is a 2-3 mins job, but now it took about 1 hr. Can anyone suggest how can i do troubleshooting and where can i start from? Need advice. Thanks! Rgds, Samuel....more >>

Hi all experts, I am importing data from excel file,which contain only two line The following is excel file format: ID NAME ADDRESS 1 FRANK USA 2 BUSH JAPAN I only copy the two line data into oracle "person"table which contain the same column as the excel ...more >>

I have created a package that will take data from a view to a text file. The text file fields are fixed width. The package runs fine except for one problem. Two of the fields have a fixed width of XXXXXXX.XXXXX. When I set the destination column size to 14, (8 digits before the decimal + 1 d...more >>

Can a login with no dbo/admin perms be given perms to execute dts packages on the production server....more >>

Hello All I want to process the data coming from a input file each record to be read and passed to a SQL stored procedure or to a SQL statement as parameters. Can you please share some tips how I can read each record and pass it to a SQL statement or to a stored procedure. Thanks Belinda...more >>

Hi, We have an Oracle database and we'd like to migrate to Sql server 2000. I have exported all the data from the oracle db into a .dmp file... Is it possible to use this to import into sql server.. If not, how do I go about doing this.. Thanks, Regards, -- AS ...more >>

I'm currently running a DTS package from an Installer class (.NET) and the execution succeeds. There is transformation/copying taking place from one database to another database. Directly after executing the package (using package2class interop class) I'm trying to drop the first database in the...more >>

Hello.. I'm building an interface of sorts, taking account data from a daily dump to a text file, sucking it into a temp table (Interface_Accounts).. that's not a problem. Once it is in the temp table, I need to then either Update the Accounts table (if the account number already exists in the...more >>

I would great appreciate any suggestions on the following problem Every day about 30 zips files will come in. Each zip file contains a folder with about 20 dbf files. The dbf files are all named accordingly. So I would like to take each zip file and import all of the dbf into appropriate 20 sql...more >>

Is there a limit to the number of columns that can be viewed / transformed I have a table with 318 columns but when doing a select * from table it only shows 272 columns also is there a limit to the length of the select statement I have a statement that has 4656 characters (including sp...more >>

When running a DTS package interactively the package executes ok. When scheduled, the package fails when accessing a Scripting.Dictionary object that has been instansiated The user running SQL Server Agent has sysadmin priviliges. In DCOMCNFG the user is granted Allow Access in Default Se...more >>

hi, Thanks for the the advice to my earlier question. now I have another.. I have quite a number of DTS package that were created with the current sa account with blank password. Now I want to change a password for my sa account. Do I just have to resave my DTS package with the ne...more >>

Is there a way to set the "Source Data File" and "Use Format File" properties of a BulkInsert object using parameters or programaticaly. My values will change from day to day as the location and file name are based on dates. So hard coding these values is not possible. I know you can create a...more >>

i'm writing a data mining application in VB using MS AS...i was wondering if i could write a prediction query from the front end and have it stored in the server and is there a way of executing that stored query from the front end too.....if anyone would know the VB coding for that i would really ap...more >>

Is it possible to somehow populate an SQL Server database on a remote server using DTS via FTP? I've never heard of this, but our client's ISP has indicated this will work. Can anyone confirm or deny this? If it's possible, can someone point us to some documentation or KB articles on how th...more >>

Hi Everyone, I'm trying to make my DTS package wait if another user is running it using delay and branching. Right now I have a table set up with a bit field called InDTS. In the DTS Package I have an ActiveX Task that checks the field. If it's 0 then I set it to 1 and run the rest of the pack...more >>

I am trying to setup an operator to receive a page when a scheduled job fails. I go to the Notification tab on the Job Properties window and select Page Operator....When the job fails. After the job fails I never receive a page. This is a major problem. Please any insight would be greatly apprec...more >>

Users at this board are saying that when you are having problems running a DTS within a DTS that you must set the option "Execute on main thread". It can be found at the workflow properties However I'm using the standard edition is this something I can find in the Enterprise version I can't find...more >>

Can someone explain 'What happens if....' If I put a MsgBox in an ActiveX script task advising that X number of records had a certain flag against them, and then execute the package from an App e.g. Excel using DTSRun or DTSRunUI, Does the user see my Message Box? When I run them on my mac...more >>

I am trying to export data from a SQL2K table to a text file and it appears the row in the text file is getting truncated at 255 characters. Is there a setting in DTS causing this or is it a limit of the export to a text file? Thanks ...more >>

Are there any automated tools available to migrated from pervasive.sql database to SQL server 2000? Thanks ...more >>

Hi, I am running a scheduled Task which runs a DTS Package that has One ActiveXScript Task. In the ActiveXscipt Task, I am loading and Executing another DTS Package using VBScript. It executes the DTS packages and Gives me an error Saying that Error Occured: Execution Cancelled ByUser. ...more >>

hi, I am reading a text file and wanted to import that data into a database table...I created a connection as follows: Dim ConnectionType Set oPackage = CreateObject("DTS.Package") ConnectionType = "Text File (Source)" Set oConnection = oPackage.Connections.New(ConnectionType) oConnecti...more >>

I was trying to display the step name that shows up when you execute a DTS pacakge manually, but from th DTS log. I build a query that joins the sysdtspackagelog and sysdtssteplog tables and that gives me everythin I need except the step description. I'm getting things like DTSStep_DTSDataPumpTa...more >>

SQL Server 200 Not sure if anyone can help but thought I'd post just in case. I have a DTS package that has the following 3 steps as VB Script Modules 1) Go ut to another server (S09) and moves some files around to different folder on that serve 2) Runs an executable (on S09) that converts file...more >>

I'm developing a DTS package to assist us with upsizing a cheapo DBMS (which shall remain nameless) to SQL Server. Since I have multiple databases to convert, I'd like to be able to make this flexible; so I've implemented the source database DSN as a global variable. I've implemented the target S...more >>

Hi, I would like to use DATAPUMP Task for export data from text file to database table using DataPump using Activex, because the column names in the text file will change, so I want to do it dynamically using Activex. Can any one have snippet of code. I am having little trouble in creat...more >>

i have a simple package with 2 steps: 1. truncate table 2. simple transform data task - copy rows into table from text file if there are no duplicate rows that violate the primary key, the package runs fine - table is truncated, rows inserted. but after truncating the table, if the transf...more >>

When transferring a DB from one server to the other, short of backup/restore, does anyone know how to get the Diagrams transferred over? Thanks. ...more >>

Hello, I have some confusion about what a custom task is. I was working in WROX's book: Professional SQL Server 2000 DTS, chapter 8 I was following with the code. We are designing an ActiveX Script to send mail. We instantiated an object called oMailTask. I think I understand that's the...more >>

Im using a Text File Source . The text file contains 1 line of rubbish data and 3 lines of usuable data. I set skip lines set to 1 na dthen import the file using Insert query and Lookup queries. For some reason the DDQ only inports 2 of the three lines of data. I have even changed the text fil...more >>

Hi, I try to connect to my database using vbs in activeX. I have a error message login failed for user 'admin'. Reason : Not associated with a trusted SQL Server Connectio Could you help Thx...more >>

Hello In setting up a DTS package in DTS Designer, I notice we have the option to create the destination table. 1. If I already have a table setup (with indices, identity and timestamp columns), can I use the DTS Designer package to preserve the destination table and just fill it 2. ...more >>

im trying to write a lookup query for a Data driven Query. Im having problems with one part of the query which is in the 'where' clause im trying to compare a string value from a text file to a smalldatetime value. Smaledatetime value = 2004-02-27 00:00:00:00 textfile value ...more >>

Hello, I hope SKS can help solve a problem I've got with a DTS package (under SQL7 sp3, NT4) inserting duplicate rows. The DTS in question copies/joins a number of tables from an AS400 system into a staged_table, before updating or inserting into a live_table. The steps are: SQL-Task - ...more >>

Hi, The requirement is to daily import a tab separated text file into SQL server. The problem is that the file name has current date as a part. Is there a way to dynamically specify the file name while importing it to the SQL server? Pointers to a workaround are also welcome. Than...more >>