Hi all experts, I would like to know if there are ways to make a schedule to export an table result to an excel file. thanks a lot. Rena. ...more >>

Hi I am running DTS as schedule jobs and many times it fails with error Catastrophics or some time memory error codes I am pulling data from AS400 using ODBC connectivity. many times jobs just gets hang with any error message. any one can give some idea what can be reason ... Thanks a lot!...more >>

I am pretty new to VB and scripting so any help would be greatly appreciated. I have to import some files that are fixed width but which contain Header information. I can extract the column info fine by telling DTs to start at Row #, but I need to capture information from row 6 in the Header ...more >>

I have table with 500 fields, each record has to be converted to one giant XML(48000 Characters) and update the filed called ISIRXMLDATA in the same table Only 1/3 of concatenated nodes make it to the XML String I wish to provide the solution as stored procedure and VBS, away from VB, The data is ...more >>

Hi All I have created an ASP script at my IIS server according the article at http://www.sqldts.com/default.aspx?207 I'm using a server Windowns 2003 (!) IIS 6.0, SQL Server 2000 Standard Edition I have tried for two days now all kind of options but the DTS doesn't function properly. I'm 100% ...more >>

Hi all, I am trying to run a batch file on a remote server. When I do this through a UNC call to the batch on a remote application server. When I do this however, the executable appears to run locally on my SQL Server. Does anyone know how I can instruct the call to run the batch on ...more >>

This very important online survey will give you the opportunity to provide feedback on the availability of SQL Server information and peer support in the SQL Server communities. This will help Microsoft and its community partners to better understand customer needs and how to improve your experienc...more >>

I have a DTS package that is pumping data from a SQL Server connection to an Excel file. The destination for the data pump is a SQL statement. My problem is this, I am using three input variables, nothing crazy just you basic parameters, but when I try to parse the query I get an error stating that ...more >>

My DTS package need to invoke web service,but I have no experience on it. Could anyone tell me what can i do to call web service api on DTS package. Thanks in advance! Victor ...more >>

I'm converting a large amount of data for a customer. I'm building SQL Server tables. I want to burn the result onto CDs and send it to my customer for them to load on their SQL Server. The operation is time sensitive since their system is shut down for the duration of the conversion. My ...more >>

Hello People I have began to store binary data in my database, for example word documents, PDF's....etc But now my database file is growing beyond what I want, and I need to move all of the files out of the DB table and onto normal hard disk space Is there anyway, say by using a bulk copy comm...more >>

When I try to set up a DTS bt. Oracle 9i and SQL Svr 2000 using the Oracle ODBC datasource in DTS, I get an Oracle components not found error message. Is there a driver or something that I need to download or should I be trying some other type of data source? TIA...more >>

Im writing several dts custom tasks in c# The only problem I have is with custom icons: I use DTSIconFile and DTSIconIndex registry entries, and they work fine with icon resources from dtsui.rll, but I can't have the designer use my own icons I've tried setting the application icon in the project ...more >>

Hi, I am trying to use Bulk Insert to insert rows from a .dbf (dbase IV) file into a table in sql(2000 sp3). I get the following error: Bulk Insert fails. Column is too long in the data file for row 1, column 2. Make sure the field terminator and row terminator are specified correctly. ...more >>

I have a fairly basic DTS Package that when all is said and done exports a table to an Excel spread sheet. ( I do have some other stuff in there with the file system object and stuff) Anyway here's my problem. The excel sheet gets exported no problem, and all the data is correct. What I want ...more >>

I have some dts set up in the SQL server. Sometimes I found I can easily make a mistake by accidently double click a dts package and make it run immediately. Acutally I intend to modify the design instead of running it. I think one way to avoid to make ths happen is to add a password to a dts, how...more >>

I'm at a loss.. i had a job running as a scheduled task for quite a while. It was set to run ever 5 minutes every weekday between 8 - 7 , I disabled the Job as i need to make anedments to the DTS. I can not get the job to execute any more, I haqve ebven deleted the job and chreated a new schedule...more >>

Hi, Would like to know if there is any DTS SDK installer which comes in msdn for installing the dts package component (dtspkg.dll). I don't want to install sql cleint for this? Thanks in advance. Sumanta ...more >>

hi all ! I have a Data Driven Query task that: from the source, reads from the join of tables A and B at the transformation process records obtained from AxB (say AnBn) at the destination, UPDATES record Bn at table B the problem is that the Update tries to modify the same re...more >>

What function do I use to pass the first day of the current year date (01/01/current year) ? Thanks in advance for your help? Olivia...more >>

My money data type is been left justified by default. Shouldn't money datatype been right justified by default. If not, what do I need to do to make it happen without having to format every money data type field. Thank you in advance for your help. Olivia...more >>

Step 1 is a DTS FTP connection that grabs 4 JPGs, and writes them to D:\tmp\images Step 2 is xp_cmdshell [D:\tmp\images\ren.bat] This runs fine from EM, or DTS Design mode but when the schedule fires I get the following error. Executed as user: CDB1\SQLAdmin. The process could not be cr...more >>

I have a stored procedure that creates a key which I would like to use as my look up value. It has to be a lookup and not a global lookup as I need to generate this key for every record. Any ideas how I can capture the output parameter from my stored procedure as a lookup value? ...more >>

I'm importing data using DTS and I get error 1105 primary filegroup is full. The description of the error indicates the drive is out of free space. There's lots of space on my server. I'm importing 175,000 80 char records. How do I enlarge the primary filegroup?...more >>

I'm transferring Data from one SQL server to another SQL server following is the query that im using to load data from souce SET NOCOUNT O DECLARE @maxDate DATETIM SELECT @maxDate = MAX(event_dtm) FROM Finance_bind_customer_profil IF @maxDate IS NUL BEGI SET @maxDate = '01/01/2001 EN SELE...more >>

Anyone know what happens if you change the sql pwd for that user after creating the dts pkg? Will it work? or you have to create it again?...more >>

Is there such a thing as a debugger for DTS? The out of the box errors are difficult to troubleshoot. ...more >>

Is it possible to execute a stored procedure for every record when importing? I have a table with a number of rows that need to imported into a table that requires a unique key, this unique key is generated via a stored procedure. So what I'd like to do is call this stored procedure, grab the ...more >>

I am trying to use dtsrun to execute a package. When I try to execute it from the database, I receive the following error: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package ...more >>

Hey All, I am trying to run a DTS Job and for some reason it's timeing out. When i run it (Execute Package), it executes in about 3 seconds. Whne i run it through the Execute xp_cmdshell command i get the following error. I also get the same error when i run it as a job. The Error Message is...more >>

Hi NG, i've wrote some custum-task in vb.net. They work well. Normally i've specified the sql-connection-parameters for the task with an extra UI (included in the custom task) an stored them into the propertybag Is there a possibility to use an connection that already exists into the package?...more >>

Hi all, Does anyone have an example of how to execute a DTS package from with an VS enivornment (I am trying to do so from within Excel). Thanks, Mark...more >>

hi all, i want to save data from hetrogeneous data-sources into a local SQL Server2000 database table after performing the joins etc. i'm using VB.Net. till now, i've been able to get the data into a dataset, but have reached a dead-end. after a lot of research, i found that using DTS co...more >>

(SQLServer 2000 SP3, Windows 2000) I am using a DTS ActiveX Script Task to rename another package's tasks (& their associated steps etc) so as to see 'friendly' names in logfiles & error messages, rather than having to decipher DTSTask_DTSExecuteSQLTask_1 etc. The script works fine for variou...more >>

I downloaded the "Export all tables in a database" sample from SQLDTS.com. I get "invalid class string" error when I do an open package and select the dts file from the sample. Is there something wrong with the dts file or is it something on my end? ...more >>

Refresh all objects from one database to another is what I try to do The functions are causing trouble I got a table with a computed field calling a function, which in turn calls a function I cannot drop the function since it is used in the table If I transfer a table, the drop table will work, ...more >>

Hi, guy There is a column which type is ISO DATE type in my source DB, And I want to convert this ISO date time to JAVA long time in my destination DB. can anyone tell me how to do this? ...more >>

I'm trying to import a text file into a table through DTS when I import the data with bulk import I use the default ROWTERMINATOR and it works fine. when in setup the package then I get an empty row after each correct data row. How do I remove the empty rows, when none of the provided rowde...more >>

Can I create a user-defined function that can be called from a particular transformation's ActiveX script? Function Main() DTSDestination("mydestcolumn") = MyCustomFunction ( DTSSource("mysourcecolumn") ) Main = DTSTransformStat_OK End Function TIA! ...more >>

Hello - I am very much a newbie here, so please bear with me. I created an Export package (using the wizard) to select data from a SQL*Server database and push it over to an Oracle database table. It works great. Now I want to put this functionality in the hands of my users and I w...more >>

Hi! I have to export lines to a flat file. The lines are build in one strings (=1 Col) combined with various columns. I use Unicode, Fixed, CR/LF. My longest line is 2202 chars. But all other lines, that are shorter, are filled with "blank" at the end! How can i avoid the blanks? ...more >>

I have a DTS package that is processing my cubes. It was running just fine until someone had to re-image my computer. To save these packages, I saved them out to another server..although I made no changes to them. Then, I saved them back to my own local server after my machine was re-built. ...more >>

i have a DTS (all done in designer) that calls a package which extracts some data i would like to have a db specified in the .ini file or in the code and change it based on the flag that i pass in the problem i am having is that when i get the db for the package which does the transformation and...more >>

I have a DTS package scheduled to run. The following is the code, to pass the date parameter: If there is no value to be passed as a parameter, the code takes the previous date as the value. /* Code */ msDateToDownload = DTSGlobalVariables("gv_DateToDownload").Value if trim(msDateToDownload) =...more >>

Hi all, SQl server 7 I have a job to run every six hours to take the transaction log backup. but the job has failed. when viewed through view job history its giving the below error msg. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. I tried starting the job ...more >>

Hi all, I am trying to bring in a large amount of records from a DB2 (ODBC) source. Frequently during my pull, the transaction fails due to network issues. Is there a way to commit the batch, say with the DTS batch size property, and then re-run the query so that it picks up the recor...more >>

HI NG I'm new to DTS and i have a quite easy task to do (at least i suppose it's easy). I got a table in SQL-Server that should be updated with records from another table (which is in Access). How the he** can i do that? I guess i have to use a Data Driven Query, but somehow i don't get ...more >>

Can you please let me know which is the best site to get the Currency exchange rates from. Can DTS automatically download currency exchange rates from any of these sites into the data warehouse. Thanks Simon...more >>

I need a facility to import data from a well formed XML file. The XML file is kept in a FTP server. I want to know how to get the file from the FTP server, read the XML file, and import the data in a particular table in SQL Server 2000...more >>

I have been using DTS to transfer selected tables between SQL 6.5 Servers it worked fine. Upgraded one server to SQL7 and DTS failed. Upgraded the other to SQL 7 DTS worked fine. Now moving to SBS 2003 with SQL2000 DTS is failing to the SQL 7 server. Are there any quick fixes? Why the inco...more >>

Could I use parameters to set the connection login & password for all packages I would like to use a dynamic parameters because the server login & password are changed regularly ...more >>

Hi and thanks in advance for replies. I have a small DTS package that if it fails will execute a stored procedure to write a log entry to a log table, I would like to write the reason for the package failure. How can I trap the error details to write out to my log table? Is this possible? ...more >>

im using the FileSystemObject - CopyFile method within a DTS package to copy a directory of ASP pages from one server to another. my problem has to do with permissions. i want to copy over ALL destination files, but these files are set to 'read-only'. therefore, the copy fails. is ...more >>

I have an ActiveX task which needs to fail the entire package if it cannot validate a GV. I use Main=DTSTaskExecResult_Failure but that does not cause the desired results. Any ideas ? ...more >>

I need to export data from a script to an excel file and overwrite it if that file already exists. Now I can export but it appends to the existing file. I deleted the file after moving it to a different location but the dts step failes due to missing excel table definition. Does any one know of the ...more >>

H Does someone know if it is possible to get from an activeX task, a SQL Task Error description th ../Ména...more >>

Does anyone know if DTS supports importing an ADABAS DB into SQL Server? Tks in advance, Thiago Santinon...more >>

In my multi-phase ActiveX Script Transformation for a DDQ my 'oLogFile' file reference works in PreSourceMain() but seems to go away in the other phases. I get a runtime error "Object Required" whenever I try to use the 'oLogFile' reference object -- even if I check if it's Nothing first. It's...more >>

I have one script that I run on multiple databases from different servers. I have a dts package setup that runs fine, but I have to copy the same script 22 times (one for each connection). Is there a way to write the script once and have all the connections us it? Would save time when modi...more >>

Does anyone know of a good reference to the variables in Active X tasks? It seems that from the listings in this newsgroups, there are set variables in DTS ActiveX scripts that are used when programming, like something_OK, etc. How and where do you get the information to program DTS pack...more >>

Hi Could someone explain what the 'Join transaction if present' option is used for in the Transform Data Task Workflow properties Thanks...more >>

WHich method is better in terms of faster, efficient, most widely used? I want to move data from one SQL Server to another, currently the database holds about 200,000 records. Right now I am using a copy objects task (it's slow takes 1 hour) it seemes it may be better to truncate the tabl...more >>

I'm new to SQLServer, I have posted this question before in this forum. With my luck, I still can't get the machine to do what it suppose to do :-(. My task is to download a table from Oracle which the table name is contained in another table (cyclic_tbl_ctrl) based on date, which cyclic_tbl_ctr...more >>

I create 3 sub package. They are 1. download data from the production databas 2. re-create the dimension 3. re-create the sales cubes They can complete successfully, if I run it one by one Then I create a master package and I use workflow - on completion, then execute the next sub-package A...more >>

I am trying to make one file containing VB Functions that I can re-use in many different packages I have an example that I pasted to an Active X Script Object in my Package & tweaked: '********************************************************************** ' Visual Basic ActiveX Script '***...more >>