I just checked and I guess the reason I was getting the last error("could not find the selected row delimiter within the first 8k of data.Is the selected row delimeter valid?") is because the row I am trying to dts is larger than 8k- Is there any other way I could accomplish this? Thanks!...more >>

I need to import very large amout of data contained in xml files xml files with almost 10-20K records I need to check also for import errors, I need also a very fast solution Do you have any suggestions? Thanks ...more >>

I am trying to dts a mainframe text dump. I keep getting the following error no mater what different delimeters I use. "could not find the selected row delimiter within the first 8k of data.Is the selected row delimeter valid?"...more >>

Hello NG I use a Windows Server 2003 Web Edition standalone Server as Web Server. On this Server I have a web application running. This Web Application use some Com+ components. The Com+ components uses the MSDTC. When I try to connect to the DB - I recive the following error message from ...more >>

We have two databases. The sql server on the web server needs to export some new data to our internal Access database routinely. I want to create a global variable Maxdate which can store value from a query like max(UpdateDate)from the Access tables Then in dts package I'll only transf...more >>

I go through the DTS wizard and specify what table to import from Access to SQL. It seems to want a table already created? If I have a col FName then, the data from the Access table appears in the SQL table. If I create a query within DTS wizard and specify which cols to import and have somethi...more >>

I need to dts 150 files that have the same schema and same file name except the date will be tagged on the file. What is the best way to accomplish this task. I thought about using an Active X Script that would dynamically change the source name, and use the data transformation task to move ...more >>

If I am executing a Data Driven Query within DTS, how can I determine the number of rows returned by the SQL query for the source? Somehow, I need to retrieve this value into a variable within the ActiveX script for the row transformation. What I am hoping to do is execute a function within the...more >>

Hi, I am trying to load several excel-spreadsheets via DTS. My problem is, that I need a routine, which can transpose the excel-sheets in the DTS codebefore loading, like the transpose command in Excel. The data, which should be loaded, is different in each excel-workbook, so that a stati...more >>

The Microsoft Distributed Transaction Service Does Not Start and Error 3221229584 Is Logged in the event viewer. On Component services - My Computer the Properties windows is also not opening to Reset the msdtc.log file in SQL Server 2003. How to solve the problem....more >>

I tried posting this earlier but am still stuck: I'm running SQL7.0sp4 on NT4. My Package consists of one task, an ActiveX script that simply attempts to create an object (an ActiveX written in VB6). The script runs fine if I right-click on the package and select Execute. If I try to...more >>

Hi... i'm trying desperately to execute a DTS in SQL Server from asp but encountered the below error: "Microsoft Data Transformation Services (DTS) Package error '80030002' The system cannot find the file specified. " below is the code that i'm using to call the DTS in asp: <% Co...more >>

hi, I have a DTS. I need to execute it from ASP.NET. My .Net System has not SQLServer or client version. Without SQL server or client in .Net system, Can i execute DTS from ASP.NET? If possible, Please explain me.. Thanks in advance. With regards, Prakash....more >>

hello! When I run a TSQL command to restore database, I got this error: "Restore database is terminating abnormally. Exclusive access could not be obtained because the database is in use". My command for restoring is 'restore database aasam from aasam_backup' I tried using the command b...more >>

I'm using email to notify if a package is successful or failed. How can I add into the email what step of the DTS package failed so I have an idea where to start looking? Thanks in advance...more >>

Hi, I have two customer databases, each with different information about the same customer. How can I pull the data from both databases and combine it into one record in an Excel spreadsheet. The customer name and ID number are the same in both databases. Please Help... Thanks, Dan ...more >>

Hi, is there a way to extract the table/column mapping specifed in the data pump (transform)? I want to document the mapping from source to destination and currently DTS package is all we have in terms of any mapping. So without manually going through each transform data task, I like to be abl...more >>

Hello, I want to know if I can pass variables to a DTS. I call my DTS with this: exec master.dbo.xp_cmdshell 'DTSRun /S salmarjo /N "Genera_Archivo_Clasificados" /E' I need to pass some variables to this DTS. Could I do that? Regards, Oswaldo...more >>

Hi All, I have to steps in DTS which I want to run in indeterminate loop. DTSStep_DTSActiveScriptTask_1 DTSStep_DTSActiveScriptTask_2 In DTSStep_DTSActiveScriptTask_2, Though VB Script in Main() I am trying to execute DTSStep_DTSActiveScriptTask_1 Set oPkg = DTSGlobalVariables.Parent S...more >>

I'm transfering a text data field into a varchar data field and it sometimes takes a very long time. So, I want to optimize this activeXscript '********************************************************** ' Visual Basic Transformation Script '*************************************************...more >>

I would like to back up the dts log files as a last step in my dts package. (exception file and error file - are there any others?). My first choice would be to load the contents into a column in the database. If this is not possible, then I'd be happy just to copy the files to another l...more >>

Is there any way I can have the db connection in my dts packages set up as an alias name so if I need to move my db schema to another database (in the same server) I don't need to go in each connection and transformation and change the db name. Thanks in advance for your help. Sandra :)...more >>

Is there any way I can have the db connection in my dts packages set up as an alias name so if I need to move my db schema to another database (in the same server) I don't need to go in each connection and transformation and change the db name. Thanks in advance for your help. Sandra :)...more >>

Microsoft Consumer this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

Hi I need to rewrite several dts packages so that they can be easily transferred between dev, test and live. Most of the settings I've put into an INI file, and I use a Dynamic Properties Task to set the necessary before executing. That works fine for all the source files, constant values, ...more >>

Hi we have a problem where different clients are not seeing=20 the character for a particular text code value ie client 1 sees code value as =A3 client 2 sees code value as accented u any ideas on how to resolve so that the server to client=20 character mapping is the same - changing lo...more >>

hi, I have a DTS, which will run from DTSRun utility. And I am converting msaccess database to SQL database. Now i want to Get the msaccess file dynamically from user. I am getting this by global variable name as conString. now How can i put this as a MSaccess Data Sourc...more >>

HI: does anyone know it this can be done ? if so, can you please share the basics and maybe some sample code ((i am also interested in executing a DTS package from ACCESS'97)) thanks ...more >>

Is it possible to reset the owner's password and the user's password for DTS packages? Thanks!...more >>

Hi. I'm trying to access a parameterized stored proc as a source for a data pump task. My SQL statement is as follows: sp_mystoredproc ? I then assign a global string variable with the value I would pass, but when I try to preview data, the interface keeps coming back with: "no value give...more >>

Is there a way to make a particular task in DTS conditional based on a global parameter value? Something like IF globalparam1 = 1 Then execute task1 I don't mean the work flow where a task will be executed on completion of some other task. ...more >>

I am hoping someone out there can help me! I am a relative newbie to DTS programming and am driving myself crazy trying to figure out how to pass the number of records affected by a delete query I have writting in an Execute SQL task to and Active X Script task. Here is the SQL statement: B...more >>

Hello, I am working with a SQL Server 2000 DTS, this DTS should extract data from Oracle (version 8.1), and it also make one Update into that Oracle Database, The Dts is working fine, but the database server are on different locations and the network some times fails. Because of it i try to ...more >>

I have looked at Books Online and am now reading through SQL Server DTS from Magenic. I have used DTS to do simple imports, but now I have need to make use of the tasks, I just can't figure out how to go about it. I have done quite a bit of messing with it, but I am running out of mess time an...more >>

Greetings, Very simple guys: X = 2.000 X = 2.001 X = 2.356 X = 2.899 1st X should return 2, all others should return 3. What is the dynamic function to make this happen? Thanks, Don *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET.....more >>

Hi... I'm writing a DTS that before running, it's crucial that one variable is changed. To remind me (or whoever) to change this variable, I'd like to write a ActiveX script to simply say something like "Did you change the Month Code Variable" [Yes] [No]. If they click Yes, it contiues and ...more >>

Hi! I have the following problem with SQL 2000: I'm connected to EM with a SQL login. I create a package and save it and the owner of the package becomes my NT account and not my SQL login. Anyone knows why? And yes, I know how to change the owner but that's not my problem. Regards Toma...more >>

Hi Maybe someone can suggest a better way of doing this: I have DTS Packages to load data into a data warehouse, and the packages fetch settings from an INI file. I want to move the packages up from DEV to STAGING then to LIVE. Each time, the directory structure will be different, so the pa...more >>

Hello DTS Group, This is a helpful group. I have a question. How to help SQL Server read a particular table type. Here is the environment: the table is a *.dbf, with a *.cdx. The table runs/updated/etc under the Novell operating system (an old version, 3 or 4) and is a table in what is...more >>

Hello, I'm currently working on debugging a very large DTS package that was created by someone else for the purpose of importing data into my company's database. The data is mainly user/contact-related data for our customer base. We ran into problems when one import, of about 40,000 rows...more >>

Apologies in advance for hitting the newsgroup with such a 'clueless noob' question... I'd like to import a series of external raw binary data tables into a database. I've already defined the database tables that I want this data to go into and assigned the various columns the appropriate...more >>

Hi I have a MSDE (SP 3) and SQL Server Personal Edition (SP 3 a) installed on a Windows XP machine. Trying to use the Import wizard I receive the following error: "The specified module was not found". The wizard starts up, but when I click on the Next button after choosing a datasource nothi...more >>

I keep getting this message when I try to execute my DTS package using Execute Package Task : "Execution was canceled by the user" However when I executed the same DTS package from itself I have no problems. Has anyone run into this problem? Thanks in advance for any help. Sandra...more >>

I loop through all the steps of a given package, put them in a list, and let the user pick one -- how do I find it again ? I can't find how to identify a step -- I imagine it must have an ID (a GUID), but I can't figure out how to get it in the first place, nor how to reload the DTS.Step if I ...more >>

I am trying to run a DTS package via asp.net in a little example project. The DTS package contains a activex script. When I run the web app on a pc with sql server installed, everything works. When I run the web app on a pc with msde installed, the dts package runs, but appears to skip...more >>

I want to run the following query: SELECT DISTINCT EBase.EbClock, EPerson.EpStreet1, EPerson.EpStreet2, EPerson.EpCity, EPerson.EpState, EPerson.EpZip, EPerson.EpCountry, (SELECT EPerson.EpHomePhone = CASE WHEN EPerson.EpHomePhoneUnlisted = 'y' THEN '' WHEN EPerson.EpHomePhoneUnlisted...more >>

I'm importing a csv and the line width is 1600 char wide and it is not importing correctly. Each line imported is now showing up 2 times in the destination table. I tried to import into a single table, with single column and then parse it. but the import will not allow me to select a fu...more >>

When I click the 'parameters' button, I get this error: The column prefix 'pw' does not match with a table name or alias name used in the query. The column prefix 'x' does not match with a table name or alias name used in the query. Replacing the "?"s with hardcoded values works fine. He...more >>

I have a DTS package that is running five Data Driven Query tasks. When I view the progresscount in msdb..sysdtssteplog, I can see the progresscount for the first four tasks but not the fifth. Each task does similiar processing. Insert and update queries are defined to each DDQ task. There a...more >>

Is there a way to run an Excel macro abc.xls on a spreedsheet xyz.xls in an ActiveX script...more >>

If you are using a parameterized query as a data source in Transform Data Task, is it possible to retrieve the actual sql statement sent to the server (with the parameters resolved)? Using the "SourceSQLStatment" property, retrieves the SQL with the parameter placeholders (?) instead of the...more >>

What is the fastest way to make a copy of a database. Let's say, I have a database call my_db and I want to recreate the same database and called my_db2. This is all in the same server. Thanks in advance for any help. Sandra...more >>

Hi, I have a DTS package which exports large amount of data from Server1 (SQL Server 2000) to Server2 (SQL Server 2000) daily. Both the servers reside at the server room and there is a direct network connection between Server1 and Server2. Both the servers have another LAN network conne...more >>

G'day all, I'm new to DTS and just need a pointer in the right direction. I want to set-up a package that will extract data records from a remote database, write the data to a comma separated text file, then ftp the file to my Linux server. I've set-up an Execute SQL task with the SQL statemen...more >>

Hi I need to export out a bunch of files on a regular basis to Text files. Can I use Dynamic properties to set this up and not have to do any Activex scripting ? On the same vein, can I set up a DTS package to run on several servers that can be setup Dynamically ? I am using SQL Server 20...more >>

'~' delimited file. 365000+ rows. Sql7sp4. Win2k. I keep getting the 'Column Delimiter Not Found' error message after about 41000 rows (I researched that issue and was informed to apply the latest service pack - no change there). I tried loading the data into Access...it errors out at ...more >>

When executing a DTS package via VB, I am importing a text file into MSDE (less than 1GB of data) and I am getting a - 2147024882 error (Not enough storage is available to complete this operation). I have Win2K SP4, MDAC 2.8 and MSDE SP4. This use to work fine until the text file I am impor...more >>

i am using the example from sqldts.com (link below). but when i enter a unc path into the global variable and the fso object function FolderExists returns a false. There are no permissions issues. http://www.sqldts.com/Default.aspx?246 ...more >>

I tried to use SQL Mail function in the DTS. Is it possible I can send E-Mail without using SQL Mail in SQL Server . I knew that there is an CDOSYS.dll driver in the server. How to use CDO to send E-Mail? Many Thanks....more >>

Hello all, I mentioned this problem earlier, but I found something interesting... I created a DTS to import an ASCII-file. When I manually start this DTS, everything is working fine. But when I schedule this one, it fails. I use real datatype fields in the table and I found out this was th...more >>