I want to use a (Parent) package to call on several other (Child) packages. I need to return from these Child packages specific Global Variable values in order to determine what additional Child packages I need to call on. In addition to this I need to pass some Parent Global Variable values ...more >>

Could someone advise me to the best practice to achive the following objective? Thank you Objective: Use a field value of another database and table in the as a condition in the Data Pump SQL Query ...more >>

Hi All: i have three DTS package in my local computer and i schedule them in one sql agent job as three steps, my question is that any commands i can write in stored procedure to call this job instead of calling DTS package three times? Cheers nick ...more >>

Hi, I am looking for some advice/ or examples on the best approach for Importing a text file to a SQL Server DB using DTS and a GlobalVariable for the pathName. I plan on executing this DTSPackage from a VB.NET application. Thank You, Chris ...more >>

All, I've written a DTS package that contains a complex VBScript that all works fine but the problem is that I dont know how to fire this DTS package from an INSERT trigger on a table (I specifically want to avoid a scheduled DTS job in this case for performance). I suppose the alternati...more >>

Hi All: i am trying to edit job step and i got a questin when i gonna to choose job failure action, I couldn't find QuitWithRollBack this optin. just wondering does this option exist . how to find it if it exist? because i have a job script which has this option. Cheers nick ...more >>

Hi All, I have scheduled a DTS package that runs every night and shows in EM that it was successfull. I have a query that sums up a key fields to make sure the two tables are in sync. When I check my verification the totals are not in sync. If I run the DTS job manually, everything is in syn...more >>

I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent server, the DTS packages pull data from SQL server databases, sybase & oracle. The plan is to move the databases to 4 SQL servers, is there an easy why to find which DTS package uses which databases so we would now w...more >>

Hey, Is there a way to change in a DTS package a specific server? I explain why. I have about 140 DTS packages who collects data from an AS/400 to store in several SQL databases on a server. Now we ar migrating that server to a new one. The name of the server is diff...more >>

I have inherited a Sql Server instance that has a lot of DTS packages, and one of them uses something called WebFileFetcher to download WEB page data files and parse them. I searched MSDN and found one article which also appears on a non-MS web site. There is also a directory on the server w...more >>

I am using the DTS COM object to import a bunch of different text files. some are 2 or 3 million rows. if there's an invalid row (can't find row delimiter or column delimiter) sometimes DTS will crash and stop the import... it even does it if I try to import it from the GUI, and going int...more >>

I have created a DTS package that seems to run fine reporting it has processed all 5 million records but then there are none in the table - where would I begin to look?...more >>

I tried to copy some tables from another server using DTS Package Copy SQL Server Objects Task and all tables are copied over but I noticed that some of the logs has this error message: ::Error:: In file SERVER1.COGNOS_DW.BND in statement on line 4 Transfer Status: Creating Column binding...more >>

What security permissions need to be set for a user to view a DTS package in enterprise manager and then execute it? Are there any server level permissions (roles) that would keep a user from doing this? I understand the package runs in the context of the user and its permissions but I don'...more >>

I have a datetime field in a SQL SERVER and I need to know clients that are scheduled for the next day when reading the info on the current day. I have tried [tblevent].[begin_datetime] = dateadd(d,1,getdate()) within the where clause and this does not return any records. I know that ...more >>

Hi, I'm the newbie to DTS. I've a listing of excel file that would like to load to the sql DB. each excel file has a different name (i.e. prefix + yymmdd.xls) --> e.g. dts050202.xls And for each file, I would like to extract specific porton of data (e.g. sheet1 first cell of column A1 down to ...more >>

Hi folks, right now I'm planning to migrate a complete Oracle database (Oracle is V9.2.0.5 running on a Microsoft Server) to a SQL 2000 Server. Now the question is, wether DTS is the right tool to do this or not. This is the first time I'm doing a task like that, so I still try finding the r...more >>

I would like an export to be sent to a user at the first of each day based on a query. How is the best way to do this...more >>

I have this code and am getting an error near group. I do not see anything can someone else's eyes locate the problem; select [tblparticipating_entity].[entity_id], [tblperson].[first_name] & " " & [tblperson].[last_name] AS [Consumer Namr], [tblhealth_plan].[health_plan_desc] from [tbl...more >>

I am importing data in the table which has primary key as identity. Data file doesn't has the data for the column. I created view which has the column except the identity column trying to import but getting error Server: Msg 515, Level 16, State 2, Line 1 Cannot insert the value NULL into co...more >>

I'm trying to create a DTS to simulate the following - because of security I cannot use linked servers - however I am allowed to query the servers via DTS. If I was allowed a linked server - my TSQL may look like this: Select myVal from server1.win.dbo.encase where MyVal not in (se...more >>

Hi everyone, I need recommendations about the best way to merge two identical database tables. We have two database servers setup as follows One database is located outside a firewall, all information entered from outside the company is stored in this database. We then have the exact same a...more >>

Hi, I am trying to execute an update query in an Execute SQL Task of the following kind: update a set a.emploeeno=b.employeeno, a.employeename=b.employeename a.employeeaddress=b.employeeaddress a.lastmodifieddate=b.lastmodifieddate from empintranet a, temp_empintranet b where a....more >>

I'm trying to retrieve a value from a stored procedure I'm running on a MS SQL Server database. I've added an Exec SQL Task, which I've defined as: exec niisp_HasMovedFileToday ?,?,? The stored procedure is defined in the database as: ========= CREATE PROCEDURE niisp_HasMovedFi...more >>

I currently have a DTS package that outputs to 7 different text files based upon criteria in the SQL query. The text files are dumped as comma delimited files and goto different folders on the Network. Is there a way (Global Variables) that I can run this package without having to edit each on...more >>

Hi, What is the minimal permission for users to run a DTS Package? Not only that, I assure they also need permission to execute all underlying tables which are fired off by the DTS package as well, am i right? Thanks Ed...more >>

Hi!!! I am a newbie and need know how can I use the DTS to transfer one DB from SQL 7 which has CP850 as a code page to a SQL 2000 which has the collation SQL_Latin1_General_CI_AS. What I need to check during DTS operation to preserve SQL 7 code page in order to avoid weird characters in S...more >>

I want to set the properties of my SendMailTask based on the results of a script that runs and processes a text file out into a table. I can't seem to find any code that shows me how to set properties for an existing SendMailTask using VBScript. I'm setting the text file source name using ...more >>

Hello all, I have a stored procedure (syntax available on request) which counts the number of records that fits a certain criteria. I would like to know if it is possible that when this stored procedure is called during the execution of a DTS package the "on faliure" would be tripped if th...more >>

Is there an easy way to more a large number of dts packages from one server to another? thanks mike w....more >>

I want to make an HTTP request from a DTS task just to produce a log in an IIS log file. This I'm sure to have IIS log file processed by my DTS jobs. How can I make such a task ? ActiveX Script task ? -- Kind regards / Cordialement Sébastien MARSOLLE ...more >>

We have several instances of SQL Server 2000(sp3) on a Windows 2003 development box. (3gigs ram, dual P4 2.8ghz xeons). We are experiencing a problem where DTS packages are taking an unusually long time to open. This only occurs when using EM on other clients and not on the actual local s...more >>

I have a DTS package containg a Send Mail task, which runs fine when manually executed. Thanks to some great tip at this site I've managed to create a shell command, which also fires the package. What I really want to do is to run this package from a query, which contains: EXEC [master].[dbo]....more >>

Hello! I looked through the archives but couldn't find anything there. I make a connection to an excel file and move a single worksheet through a data pipe to a table on sql 2000. The execution of the DTS package fails if there are cells with more than 256 characters in the spreadsheet. ...more >>

I am trying to append records from a .csv file into an existing table in SQL Server 2000 using DTS. The existing table looks like this: Field1 Field2 Field3 A 10% 1/3/2005 B 11% 1/4/2005 C 8% 1/4/2005 The .csv file only has two fields that I want to...more >>

I'm sure there is obvious way of doing this, but I haven't used DTS in a long, long time. What I'm trying to do is to import log files from some web servers that are clustered. I've had no problem with importing the text file, but I don't know how to handle a variable number of web servers. ...more >>

I'm creating a new Transform Data Task in SQL Server 2000. I have the option to select a table/view from the source database, or write my own SQL to select the appropriate data. I would like to be able to write my own SQL query, but be able to use the value of a global variable in the query ...more >>

I have a DTS package, part of which does this:_ select * from database.tablename where ididat = 20050130 What I would like to do is replace the fixed date with a dynamic date, so I don't have to edit it. I've tried combinations of DateAdd and GetDate() etc, but to no avail. I just can't...more >>

How to set up DTSPackageLog? I spesify the error log file in package properties however it is still not working. Any idea why? DTSPackageLog.WriteStringToLog "File """ & sFilename & _ """ does not exist." ...more >>

I'm SQL Server developer dbo priviledges to a database. I have created 10 DTS packages but cannot see them in the SQL Server 2000 Enterprise Manager. I deleted and add the SQL Server registration. The old SQL Server had authentication with SQL Server and Windows. The new registered SQL Ser...more >>

I had a working DTS datapump task. I added columns to the source table. When I open the datapump task to map the new source columns, the changes are not reflected in the available source columns. The changes to the table have been saved. What I have available is the old table structure. ...more >>

In activeX I have the following VBscript. Where I getting the filename and location from Connection Source. I need to add the date to the file name by using the code below the date is adding at the end of the file name after .txt. I need to add before the .txt to look like that \\filenamed...more >>

Does anyone have a clue how to pass a global variable in an Alter Statement. The following works ALTER TABLE [Outlets Query_Crosstab3] ADD [10/1/2005] int and I want to have the date as global variable. Thanks in advance. Riri ...more >>