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 >>

Hi Everyone, I am having a problem sending emails from DTS. I want to look through a customer database and send out emails depending on the status of the customer, for example to inform them that their membership is about to expire. By the the way I am working with SQL Server 7.0 After...more >>

Hi guys I have written one stored procedure. At the end it returns the set of rows. I want to define cursor on the result which is sent by stored procedure. How can i do that ? Thanks ...more >>

Hi all, I think I'm going to ask the stupidest question there is but, I need to download a file daily from a website, it will always be the same filename, just different content. Now I can schedule a job to run on my server (SQL Server 2000) but what script do I use to tell the pc that it's...more >>

I am importing company information from a third party who adds a @ sign in front of certain tickers. Is there a way for me to remove this sign while doing the import? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi Can anyone tell me how can I send email through stored procedure in sql server ? I want to send attachment with this email too. TIA ...more >>

Hello, can anyone point me to a list of the various DTS.Connection properties. I need to know which properties to set to import a fixed field file. Thanks, Erik ...more >>

Hi, Currently we get data from more then 200 different sources and all of our vendors provide data in different file formats. The problem is we have more then 100 DTS packages now and the maintainance is very diffucult. Every time our vendor changes the format we have to change in multiple ...more >>

I have a DTS package that I have had to manually run because it got blocked by XP Security. Now XP is even blocking the copyfile command step when I manually run it. How do I turn off the XP Security or how do I change the scripts to run. thanks. ...more >>

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Hi, I've setup a SAP BW OLE DB Provider to read data from a SAP Query with a Transform Data Task. When I select a SAP-Query from the list of available Table/Views and click Preview I allways get an Error: Package Error - Unknown Error. ...more >>

I'm not sure if this is where I post this but here it goes. I have already imported the data from an excel file, in excel it has the ability to display this field as the total amount of time sense the start of the clock for example "66:21:22" is 66hrs 21mins and 22secs. The raw number in ...more >>