Hi As a test, I was trying to export the pubs database to Excel. There is always one table I couldn't export: the pub_info table. Others were OK. The error I got was: "The Microsoft Jet database engine could not find the object 'pub_info'. Make sure the object exists and that you spell i...more >>

Hi, I have a dts package which is very slow to update a table. I'm using a DDQ where in input I send some rows to update, and I call a storedprocedure to do my update. 1 update takes 2 to 3 seconds!!!! (i can have more then 1000 updates) * I have destroyed my indexes * I have disabled t...more >>

Hello All, I'm using the winzip cmdline tool through the Execute Process task to zip files when I'm finished loading them through DTS. I will have this situation that complicates things. When I bring the flat file into the DTS process I strip out part of the file name (the date) and t...more >>

Hi all Is there a way of exporting database as well as the relationships of the tables? I am trying to export data to Access or Excel. Thanks Yuelin ...more >>

I would like to know if there's a simples way to import/export (copy) DTS packages between servers, because I would transfer my current packages to new production Server... There's no DTS Task to copy Packages like Jobs or Users... Restoring MSDB database from the other server works, but I ...more >>

I have a DTS package that is called by a VB.NET program. This DTS package uses a text file connection as it's source and the file this source is based on is created by the VB program. It seems that the DTS package is using a cached version of the text file. I had a text file with 344 recor...more >>

Hi, A bit of a variation on the exporting text files with header & footer info theme. I currently have a package that exports data from a sql table to a text file and an ActiveX script that renames the Text File destination connection at run-time to include the date so that it gets exported...more >>

Please help ! We have a DTS which loads files using FTP to another server. This will be used by app groups and will be run via click of button using sp_start_job, Somehow the userid running the job gets "not sysadmin to run cmdshell.." Top fix that, we granted it to execute the xp_cmd...more >>

Hi to everybody, I am a newbie who is trying to import data from and XML file into a table in SQL Server 2000. I've reading all the MS information about the SQLXML's 'XML Bulk Load' and it seems that this feature can only be accesible through the 'DTS Designer' in the Enterprise Manager. I've...more >>

Is there any option in the DTS through which I can tell the SQL Execute task to commit transaction after every 1000 records. -- Thanks Akber....more >>

Hi, Today I received an "Arithabort" error in some DTS packages, but not all. I have changed the arithabort option of my target database and all works fine. But I want to know what's append Because its the first time I see this error and the DTS packages are the sames. (my DTS packages h...more >>

Hi there. I have implementet a koncept in SQLserver to import data from an Access-database using DTS-package. There is no problem starting the package from SQLserver Enterprise mangager. However, I want to execute the package from a third party sql-interface, and therefore I made at schedu...more >>

I have a VB.NET application that needs to execute a DTS package. This package includes an 'Execute Package Task' as one of its steps. I cannot get the 'Execute Package Task' step to run. My package runs fine if I take out this package. Both packages run fine if run separately. The packages...more >>

How can I be shure to execute the last version of a dts1 using the task execute package included in dts2? If I modify dts1, dts2 execute the previous version of dts1. Can I use an ActiveX code in dts2? Thnx ...more >>

Hi All I want to call DTS Package from Job. How, can I do that ? First DTS Package transfers data and then it calculates on that imported data. Wating for reply Silent Ocean ...more >>

Hi, I have created a DTS package that I am running from our SQL server. It works really well however I would like to be able to rename the both the starting Visual FoxPro Database (importing from) and the destination SQL database (importing to) globally. This way I could move the DTS file...more >>

Is it possible to have a VB application that allows a user to created a DTS package from selection made on the VB form. The developer is creating timesheet exports for different clients. There are many to create. The DTS package includes connections to dattabases, excel spreadsheets,emailin...more >>

Hi, I was wondering how i could use dts to import accessfiles and then archive them to another folder. I've read some examples on sqldts.com but i still can't figure it out. Basically this is what i want: - import an accessfile which has a name like this <companyname>_<today's date>....more >>

Hello All, I am trying to use a send mail task in a DTS job, when I add the task to the designer the following error dialog appears: Title = DTS Designer Error Msg = Unable to get MAPI profiles. If I click Ok the dialog goes away and the send mail properties are displayed but the p...more >>

Hello all, I' ve created a dts package to import some data from another data source. I've created an SQL connection and specify the provider 'Microsoft OLE DB Provider for SQL Server'. I parameterize the ServerName, User, Pwd and DBName and set their values using an activex script. When I r...more >>

Hi I have active x Script in main package which calls send mailtask in another package. both packages are in the same database. can any one help me by providing an example. i am new to Active x Scripting. thanks -- Message posted via http://www.sqlmonster.com...more >>

I am attempting to debug the "number of failing rows exceeds the maximum specified" error on an xpp sp2 client with client tools with sp3a. The DTS package copies rows from an excel document into a mssql db. I dont want to format the system, but have loaded client tools on another clean s...more >>

Hi I have a SQL Task which simply selects a row from a table based on an input parameter. The result of this is then assigned to a global varaiable. How do I then run another task based on the result of the global variable i.e. if variable has a value then run task else if 0 then skip to ne...more >>

"I need to create a file with static header info (first record), result set from a query and static trailer info (last record). Here is an example: Header Info (Record 1) Results from query (record 2) Results from query (record 3) .... Trailer Info (Record n) What is the best way to do t...more >>

declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'SRVDB1@mydomain.com', @TO = N'gmatteson@mydomain', @priority = N'HIGH', @subject = N'Process Success', @message = N'Database Backup Succeeded.', - Rather than putting Database Backup Succeeded, I would like to put "@...more >>

Is there any way to pass a file name to a DTS Package? I'm using a DTS.Package2 object in VB6 (using LoadFromSQLServer etc.). The package imports an Excel file into a SQL2000 table. When I created the DTS import I specified a file name, but I'd like to be able to override it in code. Thanks-...more >>

Running Windows 2003 Server with SQL Server 2000 w/SP3a This is the message I recieve when I go to add the profile to the server and click Test. Any ideas? Thanks, - Gabe xp_test_mapi_profile failed with mail error 0x80040111 ...more >>

Hi, I try to setup the data transfer package from DBIII to SQL2000. How can I setup the DTS package tansfer only the new data daily? Thanks,...more >>

I have a DTS package that imports a text file. The test file it import depends on a global variable that an activex script looks up while its running (it changes the source of the Text File (Source) connection). It all works fine. My question is this - if more than 1 client accesses the DTS...more >>

Using SQL Server 2000. Running the following DTSRUN line in OPCON job: DTSRUN /N"XML Data Load 1" /E /SDEV1 /L\\OPCONJOBS\OUTPUT\XML01.out The file XML01.out is growing larger and larger due to the DTSRUN output getting appended to this file rather than overwriting it. 1. Is there a DTSRU...more >>

Using SQL Server 2000 DTS package runs a simple query from a SQL Server table in the 'Transform data task' object and then writes results to a text file defined in tab 'Destination' under 'Table name:'. Each time the DTS package is run the text file 'filename.txt' is appended with new ...more >>

Is there a way to monitor all scheduled DTS jobs and restart the jobs automatically when it faillS. If the job continues failing after being restarted for several times then it must notify the responsible person. Is there a tool that i can use with SQL to do this? -- Message posted via http:...more >>

Hello NG, i really like the DTS, but why one earth cant the DTS copy the primary key property? I always have to edit the importetd tables manually and set the primary key propertie on the correct column. Why does this information get lost? It cant be so hard to check if a column has the ...more >>

I have a DTS package that is doing some unexpected things. I know the log shows which steps in the package were executed. Is there any way to track more detailed information like what the Global variables are at each step or what lines of code are executed in an ActiveX script. Terry ...more >>

I am using a DTS package to import a text file that contains weblogs from our firewall. I need to parse out one field before the import in sql2k. The field contains the date yyyy-mm-dd 00:00:00. I would like to move the time 00:00:00 to a new column in the sql db. Can any provide examples t...more >>

I've been using DTS to import data from Excel into a database (both SQLServer and Oracle). I've run across a problem recently in a couple of different spreadsheets where a cell that has data in it is being read as NULL from DTS. This happens both when I write a SQL query for the source, or j...more >>

Hi! I need to import a text file that has the date in the first row, and some data columns in other rows. That date I need to insert in the same table for every imported record. What is the best way to do that?...more >>

Hi! I was pointed in this direction from microsoft.public.windows.server.sbs I have a question about automating importing text files into a table in SQL Server. I`m a complete SQL server "noob" but I am looking for a way to import all the data from a set of text files in a folder, then t...more >>

I' am importing jpg-files into a SQL2K database. Currently I am using a staging table in wich I import the jpg's using textcopy. (first create the records with a placeholder in the image-field, then import the jpg using textcopy) Then I use a stored procedure in wich I make alle the neces...more >>

hi, By following the kb http://support.microsoft.com/default.aspx?scid=kb;en-us;321525 If I don't set any globalVariable , then LoadFromSqlSever and execute method is fine. AfterI add some scripts to set a gloablevariable value , I get errorcode = - 2147220482 on the setp the variable f...more >>

I am just starting with DTS. I am trying to import a text file into a table. In this text file the field that maps to the primary key in the SQL table has non-unique data (every row has this value set to 0). So far I have only been using the wizard to try to get this done, but I can't see ...more >>

I have a VB.NET class that I need to call from a DTS package. I need to set a couple of properties and then call a method. I've tried the activeX Script task but I can't seem to get it to work. I used CreateObject but I think it wants a COM component. Don ...more >>

following a previous post... Hi, how can i retrieve in an ActiveX the SQLServer instance name where the DTS is located. Thnx Kyky ...more >>

In an DTS ActiveX I need to open an ADODB connection whose Data Source shoud be the SQLServer instance where the DTS is located. How can I retrive the instance name? Thnx Kyky ...more >>

How can i perform a two dimensional lookup through DTS. Therefore I want to pick a value from a table by providing primary key and column name. My table is having 50 columns. I can implement the functionality using 50 lookups but that seems like a bad idea. Thanks, PM ...more >>

I'm trying to import an Excel 2000 file into a SQL Server 2000 table. The Excel file has 4 columns. The database table mirrors these columns but has an Identity field (called ID) which I have as PK to satisfy replication requirements. Also there is the replication field that defaults to newid(...more >>

When I use Import/Export feature of SQL Server 2000 to migrate SQL Server 2000 database to Oracle, SQL Server converts all table names to something like this: "table name", instead of just table names without any quotes. Because of this when the tables are successfully migrated to Oracle and...more >>

Hi everyone, I am somewhat of a newbie to DTS, but was wondering if there is a way to have DTS insert new data into a SQLServer table: CREATE TABLE SecMonthTbl ( [SecMonth] [datetime] NOT NULL ) A record for every second between two dates. Most likely be a month. Don't ask why I need th...more >>

Hello, I want to use a HTML File connexion but I don't know how to configure this connection. Do you have an example ? Thank's....more >>

can any one help me with the below script. I am getting error like Error code = 0 Error Source = ADODB.recordset Error Description : operation is not allowed when the object is closed. error on line 15 Operation is not allowed when the object is closed ***** Function Main() Dim cnn, ...more >>

I create a package to call other packages in one workflow ,it's very similar as below: Steps----on success--->step2----on success---->step3 - -----on failure--->step4 for step2, if it runs on success, step3 will run cont...more >>

I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know ...more >>

I have a CSV file like this: "fieldValue1","fieldValue2","fieldValue3","fieldValue4" I'd like to create a DTS package which dose the following operation on the CSV file: 1) Inserts "fieldValue1" into **Table1**.field1 2) Inserts "fieldValue2" into **Table2**.field2 1) Inserts "fieldValu...more >>

Hi, I now this question has been posted a few times, but I did not find an answer. I have a linked server on my SQL server to an access database via a mapped drive on a domain. (2 computers, one with SQL server and the other has the access database) When I log in to query analyzer using ...more >>

Hi all I'm trying to bring a monetary value from an Oracle server into an SQL 2000 environment. In the oracle table the monetary value displays with two decimal places but when viewed in the SQL table it has rounded to no decimal places. It does not matter what data type I use when bringing...more >>

Does anyone have any idea if you can get/set the properties of an active DTS package progress dialog box using the SQLNamespace object from within another DTS package executed after the dialog is opened?...more >>

I extracted some VB script from the WROX book "SQL Server 2000 DTS" to get error information. The rest of the script works fine. The problem segment gets a readble form of the error. How to fix this? The error message I get is: Error Code: 0 Error Source= Microsoft VBScript runtime...more >>

I'm using a .Net application to execute DTS packages within Sqlserver,I need to have very customizable and powerful Exception maangement systems which loggs different issues happend in the DTS package with my own errorCode. Can somebody give me some ideas? Thanks ...more >>

I created execute sql task with the below insert statement. Insert into properties(PROPERTYID) select propcode from htcrepr where propcode not in (select propertyid from properties) group by propcode And I also created sql Mail task , the workflow is success. the problem is the workf...more >>

Can I run a DTS from a store procedure using NT authentication? Using rundts , what's the syntax of this command? ...more >>