Hi, I have my dts package as a structured storage file. I plan to save it to my server for scheduling. Is there any way that I can remove the previous versions from the file to make it smaller before I save it on the server? Thanx...more >>

When trying to open the DTS Designer, I get an error stating Error in the DLL. It will then open, but when I save, I get the same error. Also, I cannot open any DTS tasks previously created from another machine. I have tried reregistering DLLs, and also removing and readding, SQL Server 2000...more >>

Hi, Our software uses a SQL database and is designed to get rid of data after a specified amount of time to maintain performance. We would like to be able to keep that data in another database along with the up date information for reporting purposes, while leaving the main database to serv...more >>

Hello All, I'm exporting a SQL table to a text file and want to add a little bit of header information. Is the best option ActiveX Script using FSO? Any thoughts. Thanks, LP...more >>

SQL Server Agent reports the following error when attempting to execute a scheduled DTS pacakge: --------------------------------------------------------------------------------------- Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Error Code: 0 ...more >>

Hi all, I have a DB on SQL Server and I need to create a table that is a link to a table inside another MsAccess DB. How can I do this? I'd reply the same behaviour like I do in MsAccess when I run the command "Link table". Any help is appreciated. Regard, Mike....more >>

Hi All, I have a DTS Packag that copies tables from one server to another. Is there a way to add a new table to this package? I have not been able to figure this out with the help of BOL. TIA, Joe...more >>

Hello, I have 3 sql servers running. lets call them sql server 1,2 and 3 all 3 servers have a table with the following columns ID, Location, transaction id. server 1 and 2 collect data and populate thier tables....i would like server 3 to get the data from the tables on server 1 and...more >>

Can DTS load data into Hyperion's Essbase? I know I can output a text file and then call a .bat file that uses an Essbase load command, but I was wondering if DTS supported a direct connection. -- To Email Me, ROT13 My Shown Email Address ...more >>

I'll be the first to admit, the title for the post isn't the greatest but didn't know what else to write. Anyways... Im importing data from Excel into SQL. My StoreNbr coulmn can be in General, Text, Number, etc... take your pick, the problem still persists. Sheet1: StoreNbr 1234 96AB...more >>

Hello, Can any one tell me how to copy the DTS Packages from One server to Other Server. Both of My server are at on different machines. Thanks in advance, siaj ...more >>

Apparently DTS already keeps count of the rows it processes. I'll just bet there's some way of putting in a post-source or pump-complete handler that accesses that number, rather than keep my own count by incrementing a global on each row. I've only just been introduced to the mystery of the ...more >>

I am using the DTS wizard to export data from a table to a CSV. I have a varchar(7000) field that is getting truncated around 255 charachters. Is there anyway to work around this truncation, so I am not losing information from this field when exporting to CSV?...more >>

Hello there, I am experiencing performance problems with an aplication running over a SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM memory. When there are just on or two users working, the aplication performance is suportable, but when more users are using the...more >>

Hi Gurus We are trying to use linked server to oracle. A simple insert of 100 rows is taking 3 minutes, If i do bcp out and sql loader in to oracle it is just few seconds. Is there away to find out what is wrong. How can i use trace, or profiler to check what is happning on the oracle end. we...more >>

I work for an environmental agency. I need to import data from a text file every 30 minutes. This text file contains weather info which is collected every minutes by an instrument in the Gulf. So every minutes a line of data is added to the text file. Then every 30 minutes, I need to read ...more >>

Can I add the date to the file name when I export SQL data using a Dynamic Properties task. LP...more >>

I need to build an extensive DTS package and my experience is with simple DTS techniques only. I like books that start with simple but include advanced. What would you reccomend? Thanks, Darwin ...more >>

Hi Hopefully just a quickie. When just importing tables and their data, is it better to use seperate source & destination connections for each table, to run the process in parallel, or to use a "Copy SQL Objects Task" to include all tables? With the later, I'm thinking that the imports ...more >>

Hello, i new to msde and ms sql. i need to migrate a access db to msde/sql. The access 2000 upsizing manager crash with a overflow error for me. M$ suggest to use dtsrunui , but msde2000a is missing dtsrunui, dtsrun and all dlls are there, but there gui is missing. Is that true ? Can i get the gu...more >>

Hi, I need the ability to export any sql statement or stored procedure (with parameters) to an excel file at will. Anyone know how to put that into a DTS package, or know of a premade one available somewhere?...more >>

Okay, I have 4 tables that I need to load data into. I was thinking of using DTS to do the data load. The 4 tables already exist with old data. Some of the data in the text files is the same as the data in the tables. I have tried to disable to contraints on the tables and truncate the dat...more >>

I used the export wizard to create a package to export a table to a CSV text file. When the wizard is done the package runs OK and creates my CSV file. However you can not edit the resulting package. When trying to edit the Transform Data Task the “Verifying Transformations” dialog pops u...more >>

My ActiveX Script Task Properties dialog box has the "functions" window maximized and I can no longer get at my code. I can not find any way to resize it. Please .... If anyone has come across this and can help... it will be much appreciated. I've never had this happen before. Thanks ...more >>

Hi, I am trying to retrive the info (SQL Statement) from a data pump task. But i got an error It said "Object doesn't support this property or method" Am i MISSING something Dim tsk Dim resul Set tsk = DTSGlobalVariables.parent Set resul = tsk.tasks("DTSTask_DTSDataPumpTask_1") msgbox ...more >>

Using SS2000 SP3a. I have a step in a package where I check for the existence of a file. If the file is not there, I want the package to stop but it doesn't. I've set "fail package on first error in package properties. The code in the step is this: Function Main() Set fso=createobject("scri...more >>

I have several DTS Packages that are scheduled to run every night. If I change the Packages, which version will be run the following night? If its the old one, how to I update the schedule to recognize the new version? -- SQL2K SP3 TIA, ChrisR ...more >>

I am going crazy over a load job, I am loading few tables from one sql server to another sql server, for that i created a DTS package, it was running fine until recently, all of a sudden it started giving me problems. It was scheduled to run daily. The package logging shows every sub modu...more >>

Hi, I have a stored procedure that generates a table variable. How am I able to export the result of that table variable to an excel file. I don't see any function in Transformation Task that allows to run any stored procedure. All I can choose from Transformation Task is a table or a vi...more >>

When you execute a package from SQL Server Agent there is some run information that gets written to msdb.sysjobhistory.messages. Is there a way to use a script action to append some text to that information? This seems like an obvious thing to do to me but I'm banging my head against the wal...more >>

I need to run 5 different Select Count(*)......... Statement from the DTS package and get the result out to the text file. What is the best way to do this ? (It has to be a DTS package and not any other method Jobs, SP e.t.c.) Thanks....more >>

I wish to execute a DTS package from an ASP. The package was written in SQL enterprise mangaer then exported to a VB file. The reason for this is that the source file and it's path can and will change. I therefore allow the user to specify the file name and path and dynamically change the v...more >>

Hello evryone, I want to load access files in sql 2000 server with a dts package. the acce4ss files are in different directory's for example d:\Models\wk1\data.mdb d:\Models\wk2\data.mdb d:\Models\wk3\data.mdb etc.. Is it possible to use a script that wil change the dts package so i can ...more >>

Hi, I currently use Transform Data Task to load data into a tbl. The source data is a select stmt. I'd like to make the db names used in the select stmt dynamic/varaible. I've unsuccessully tried using input params in the sql stmt (the source tab). Also considered using an SP for the select s...more >>

im working on Server-client environment where i need to query data from MS SQL to be inserted into MS access database whenever user prints report. would like to know on the SQL Statement syntax on how to do that . insert into <ms Access tbl> select ...... from <MSSQLTbl> ... Thank you ...more >>

Hi Group I want to divide one column by another column and stored that value into third column. Example : Column A, Column B, Column C I want to divide Column B by Column C and stored that value within Column A Basically Column A is % Column B < Column C ( always ) When I use divi...more >>

I have a DTS package that contains a "Execute Process Task Properties". the task executes a Vb.Net exe file. I am trying to pass a value from the DTS package to the vb.net exe file/app. However I do not want the console to open and wait for my input. When I enter a value in the parameter sec...more >>

Hi, I need some help on creating a process where i need to save webpages as a text file and load it into sql server. Can this be done using DTS? Thanks!...more >>

Dear All, I've created some packages to transfer data from text files to SQL Server tables. I need to do this whenever I receive new data. Can I execute those packages from a stored procedure so that I don't have to run them one by one manually? Thank you. Linda...more >>

Hi, How to convert and transfer ANSI string data from FoxPro table to MS SQL Unicode table. Data in FoxPro are in 1251 codepage (Russian Windows). Now result is like "ÊÎËÜÖÀ ÊÎÌÏÐÅÑÑÎÐÀ 100ìì ".The ODBC driver does not performs the conversion from ANSI to Unicode. Help. ...more >>

I am importing data from one database to another using DTS. During the importation process, I get the following error message: INSERT statement conflicted with COLUMN FOREIGH KEY constraint. “FK_foot_Gen”. The conflict occurred in database ‘Sales’, table ‘Gen’, column ‘ID’ ...more >>

Hi all Is it possible to convert a dts package saved as .bas file back to a sql server package so it can be opened, designed,saved and used again in sql server? Thanks alot Rea ...more >>

I have a fields with the space char in data. How to find a space character in query? 'Smith David' ...more >>

I have a simple DTS package which imports rows from a text file into a sql database table. Connection 1 -> Connection 2 The DTS is just a tab delimited text file (Connection 1) of data going into a SQL table (Connection 2) with no conversions. How do I log the rows imported from the tex...more >>

Hi all, I am currently still looking for a solution to my problem, anyone have any ideas? This is how far I came: Hi Darren, Well, I am testing by just double clicking in windows, but when the script does what I want it to, it'll be running in a DTS task on sql server 2000. My sc...more >>

I have 2 tables. At a timed interval I have "transform Data task" setup to copy the data from one table to the other. I want to delete the transfered data from the first one once the transfer is complete. I can create the SQL task to do the delate. However, I was think, what if there is data in...more >>

Hello All, I created a simple DTS package which uses the FTP task in Enterprise Manager. I want to get a file off of the SQL Server D:\ Drive and copy it to a network server , the F:\ Drive. When I manually execute the job (right click execute package) it runs perfectly. When I try to sched...more >>

I have a very simple DTS process that copies five columns from an Excel spreadsheet into a SQL table. One of the fields is product description that tends to be about 350-500 characters long. When I run the DTS, SQL Server truncates the description field at 255 characters? Does anyone know w...more >>

Hi everybody: I need help... I get the next error when i try to import data (using DTS Wizard) from a OLAP Cube, that have a "custom rollup" dimension: "CONTEX: ERROR CALLING OPENROWSET ON THE PROVIDER" I am using SQL Server 2000 and "Microsoft OLE DB Provider for OLAP Services Ser...more >>

I have created a DTS Packaget that successfully transfers files from an FTP - sometimes. If I execute each step manually, the FTP transfer succeeeds. When I execute the package, sometimes the FTP package succeeds, and sometimes it does not. I checked all the parameters that I am dynamical...more >>