I am trying to use a stored procedure to look for all the DTS packages stored on the system of sql server7 and sql server 2000, Is there a system table where the names are stored? Thanks, Tom ...more >>

Hi I have an Activex Script which reads a file and does some transformations before importing data into SQL server. I am trying to import multiple files. I have a batch file which goes and looks through files in a certain folder. The batch file also passes the filepath of each file to the DT...more >>

Hi, I am trying to save a DTS package to the Meta Data repository, but it is not listed in the location drop down in the DTS Save As dialog. Any reason the meta data services repository would not be listed as a save location? I am trying to learn more about meta data in the enterprise. T...more >>

Hello, I am embarking on a project using DTS and could use some advice on how to go about it. I need to import multiple text files to sql tables from a directory. The text file names will vary based on a combination of an association number and a club number. A text file name will look like C...more >>

Hi, I'd like to import TXT files. Those files contains some records which may already exists in my tables. there is no foreign key in my tables I 'd like to import the files without the existing records. How to do ? Tom...more >>

Hello, I have a little problem with the security context of DTS. I explain my problem : I have 2 DTS, the first DTS is started through an ASP page, No problem. The second DTS is executed by the first, but I get an error message, something like that "user cannot be equal to null". For th...more >>

I am totally new to SQL Server so apologies if this seems a silly question. I am trying to schedule a daily import from a csv file into an application that runs on SQL server. I can create a DTS package to do this but the main problem is the primary key of the table is a surrogate key that automatic...more >>

Hi Has anyone used DTS to extract data from ERP systems, particularly SAP, and if so, what adaptors/connectors were required? Regards Nicola...more >>

I'm using SEM 8.0 I've installed XPSMTP from http://www.sqldev.net/xp/xpsmtp.htm and it is working fine. What I'd like to do now is to get the @subject parameter from a global variable. So I'd like to exec it like this: exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'someuser...more >>

The below SP (thanks to Database Journal (but simplified)) executes my DTS. However, I need to modify one of the connections (XLS file path) before execution. Thus, I would need to add another parameter @Path for example. But how do I change the connection information within the Stored Proced...more >>

I would like to use DTS to read from a SQL table the name address and fax # and substitute these values into a Word template and fax this resultant document. I need to do this everyday several times a day with the DTS package constantly polling the SQL table and faxing the contents. Please ...more >>

Hi All, How can we handle / know the errors occured with in the DTS Package? Also Can we Return/Retrieve any Value (say the final value of a Gloabl Variable after the package is executed) to the Caller Program, Like a Stored procedure? Any Suggestion or Web Site for reference. Thanks i...more >>

Any way to use a normal stored procedure to create an Excel file from data in a sql table? Mark ...more >>

I have a package that executes fine from the server where SQL Server in installed. However, the below code generates an error (see below code) when executed from a workstation on the client. This is a Windows .Net application. All other data access work just fine. Can anyone explain this? ...more >>

I have a package that executes fine from the server where SQL Server in installed. However, the below code generates an error (see below code) when executed from a workstation on the client. This is a Windows .Net application. All other data access work just fine. Can anyone explain this? W...more >>

Hi All, I am using DTS Packages to Import Data from .dbf files to SQL Server database. I am using Global variables for "Source DBF Path", "DBF File Name", "SQL Server", "Database", "arget Table Name" (Which is SAME every time). I am using Source Connection (dbase 5), target connection (sql ...more >>

How can I wirte to task log file the object DTSPackageLog is not woking it just complains Object Required. Can someone please tell me how can I get reference to taht object I have searched the complete msdn and there is no documentation on this. thanks ...more >>

Hi, I've had a strange problem. Can anyone confirm? SQL2K, version: 8.00.760 Stored procedure: ================= CREATE PROCEDURE dbo.myProc @myID int OUTPUT AS SET NOCOUNT ON SET @myID = 123 --reseed with myTable with new Identity DBCC CHECKIDENT ('myTable', RESEED, @myID) GO In...more >>

I wanted to transfer a job from one server to another. That's what I did: In DTS/local package, New Package -> Click on a Task button called "Transfer Job Task". -> Set user names and passwords on both tab of source and dest servers-> select a job on third tab->Save it. Both are SQL 2000 ...more >>

Good Morning, I have a DTS that export on AS400 to Sql Server 2000. I want on the dts create the table on AS400 but it respond me with an error. Help Me ...more >>

Is there any way to execute dts package from stored procedure? If there is, please specify how. Thank you....more >>

I have been trying to pass a global variable from the parent DTS package to the child DTS package. I am using the Execute Package task to invoke the child package. I have added the two global variables on the Inner Package Global Variables tab and the Outer Package Global Variable tab. The chil...more >>

Hey all, I've trying to use a dos batch file (through the dtsrnui executable) to send 2 parameters to a dts package: a table name (aka, the 'input' table from which I want to pull records from) and an output file name (aka, the .txt file which I want the pulled data to be saved to). I've basi...more >>

How can I abort a package. I can't use a transaction as one of my activex scripts uses a shell command so success or failure will not show up in the workflow. I need to test for a condition in activex task and abort the entire package accordingly. Regards, Chris. ...more >>

Hello All I have a fixed template in which the only thing that changes is about 8 set of values and rest of the template is constant. I have another file containing about 5000 records and each of this record fields I need to substitute in the above fixed template at regular known positions....more >>

Dear all I'm trying to in import a excell-table to my MSSQL-database. Problem is that I have a auto increment field of record id. If I import the table I tried to <ignore> the ID-field but with the conversion it won't use auto increment. Now the wizard reports that BLABLA_ID can't be NULL, cause i...more >>

Hi, I have a DTS Package that executes a simple stored=20 procedure and exports the results into a text file. The=20 problem I have is with some of the German databases. When=20 I execute the procedures manually the data in the table=20 looks correct, however when this procedure is executed...more >>

Hi All, I have created one DTS Packages in with 4 Global Variables. I am able to Execute the Package from with in a Stored procedure. Then I have Copied the DTS Packages to another server (using save as - structured storage ...) and loaded the packages to target using open package. I was able ...more >>

I want to selectively copy Excel worksheets and columns to a SQL 2000 database using VBA. Specifically, I want to copy data from any worksheet whose name matches a table in the database and copy the data whose column header matches a column name in the table. I ignore worksheet names and colum...more >>

Hi, I am trying to import a .dbf file using the DTS wizard. I specify the directory and it finds the file I want. But when I try to start the import it says the object is not found. Any ideas? Denis...more >>

Hi All, I am using some 'Execute SQL Task's and fire some stored proc from it, and I need transaction in it. should I still handle transaction Commit Rollback in stored proc ? Or is it enough to handle Transaction in the Task's workflow properties ? Thank you for your help, Trist ...more >>

Is there anyway that I can hide or restrict DTSs from users? Thanks, tt...more >>

I'm trying to run a URL from a DTS that triggers a remote server operation. I have the remote URL operational, it's just the DTS piece I need to complete at this point. I'm not finding any pointers on how to run this on MSDN or google. Any ideas? Thank you, -Steve ...more >>

Want to add DTSRUN command in bat file and have that complete before proceeding, what is the best way? Also would like the bat file to fail if the DTSRUN utility fail, what would the code be for that? DTSRun.exe -s "<server name>" -e -n "Con_OPR_Adj_Prod" Other commands................more >>

Any help would be much appreciated!! I am creating a generic DTS package that will export data from SQL to Access on a daily basis. All one would do is change the database names etc stored in global variables and run the package. The steps I have are as follows: 1) Select table names in the...more >>

Hi, I need to transfer comma separated data from about 1000 text files to a database I’ve looked into BCP, DTS and also tried to create a .bat file DTS works fine, but to sit down and run through this process for each and every text file is going to be a mission BCP- I don’t have format file...more >>

I have a quick question. When saving a DTS package, SQL Server indicates that you can save that package to SQL Server, Meta Data Services, Structured Storage File, or a Visual Basic File. However, in all of the editions (PER, STD, ENT) that I've used, I don't see an option to save the pac...more >>

I have a table witrh a number of rows i.e. 12 rows of information as follows: 10198 1234 Dan Smit 01256 3344 etc. What i need to do is populate another table with the above data in columns e.g 101987 12345 Dan Smith 01256 33444 etc. Any ideas as i am at a loggerhead as how to do this in...more >>

I am using a dts package to move data from a .txt file to a data table. In that file, there are two columns of information that I need to combine into one column in the table. here is an example: col1 col2 xyz123 <null> xyz234 <null> <null> abc333 <null> abc757 If every...more >>

Dear sir I have an error in my VB.Net (updated from vb 6.0) that comes in oTask = oPackage.Tasks.New("ExecuteSqlTask") oCustomTask = oTask.CustomTask Error System.invalidCastException Sir How can I fix this error? Thanks Sir usman *** Sent via Devdex http://www.devdex.com *** ...more >>

How do I get my DTS to rollack it's tasks. I have a DTS with several activex and sql tasks. I would like it to email me if any fail but to completely roll back and changes to the database but also the file structure (I archiveand delete a lot of text files at the end of the DTS package). Regards...more >>

I faced the following problem when i do DTS to excel from my vb program. " Copy Data from Results to Results Step failed Microsoft JET Database Engine The Microsoft Jet database engine could not find the object 'Results'. Make sure the object exists and that you spell its name and the path...more >>

Hi all, At the end of transfer dts task there is always information of how many = rows were transferred. Is it possible to get this information into a = global variable and pass it out of the package, let's say to the = application calling it? Any suggest appreciated --------------------- B...more >>

I need to copy data from one table to another. The from table I connect to using an ODBC connection as it is not a SQL database. The second table is in a SQL database. Here are the tables: Table 1 (ODBC) Table2 (SQL) Field 1 Field 1 Field 2 >>> ...more >>

Hi every body I'm thinking of using sql server profiler and/or the windows performance logs (with sql server objects counters), to trace a problematic job which fails to retrieve any rows by executing a dts (which inbcludes transfare data tasks). The dts works just fine by it self. When sche...more >>

i create dts package that runs console app process. when i run package manually - all is done ok - the app's window is created, it executes and closes. but when i do a job and try to run it the job hangs up, nothing happens. ? ...more >>

Hi all After scheduling a dts, which retrieves data from a priority-tabula server (using the tabula propriatary odbc driver) , no rows are transfared. There is no error massage i can trace in sql server or in any of its logs, the job just passes gracefully by the dts data transfare tasks, which...more >>

i guess when sql agent is executing a job and time has come to run it again while the job is still running, sql agent just doesn't run it but waits untill the job is complete. do i guess right. is there info in bol? ...more >>

Have a table with 9 digit dimensioncode...need to make a new table with a 7 digit dimensioncode...is there any way I can get the name of the first 9 digit dimensioncode and use it as name for the new 7 digit dimensioncode ? Without using Cursors ? Perhaps Cursors isn't a problem with only 5...more >>

I've setup an insert trigger on a table, however when I execute a DTS package that runs a datapump into that table the trigger does not fire? Is there a method for fireing a trigger when using a datapump? Thanks in advance. ...more >>

Then you need to look at the data in isolation. Have the "to be imported" data moved to another table and do a comparison of the attributes that are going wrong -- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all y...more >>

I need some suggestions on how to go about using DTS to bring a text file into sql. The catch is that the text file has multiple lines per record, as defined in the first line of the record. I need to concatenate the subsequent lines into one field of database. Example: record# #line...more >>

Hello There, I am getting the an error trying migrate data from Excel to Oracle 9i using DTS: Error Msg: "Data for source column 50 ('GENERAL_CO') is too large for the specified buffer size" Its breaking at the first row in the column 'GENERAL_CO' where the data is more than 255 character...more >>

I have a transformation that I copy over the contents of a dbase table. I have added a column and would like to call a function that returns a value based on the sku, and storeno in that dbase table. So I call the function in query analyzer as so select dbo.SKUAverageCostPerStore (@sku, getdate...more >>

Hi I am having a DTS Package copy sql server object task which copy objects from one server to another. the drop existing option is is also selected. I am getting an error "[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'proc_change_loan_status' in the database. ...more >>