Hi All, I hope someone can help me, I created a DTS job using the wizard which reads a tab delimitied text file and inserts it into a table, and saved it to a bas file because i need to use it in VB and dynamically change the filename. However when I run (having referenced the three dlls, dts...more >>

Hi, I would like to see only error messages of packages that fail. I have setup packages that import data from text files that are FTP from the AS400. I have a file that all failed error messages go to, but my problem is that successful messages are also going there. In DTS package prope...more >>

Hi , I have created a DTS package in SQL server 2000 which will write the contents of the table data to a text file. When the Job is invoked it creates the .txt file and saves it on the above server.It works fine for now If i decide to save the .txt file on some other server how should ...more >>

Hi all I have a package reading data from an ini file in the first step. I need to move the package on production server (on e:, i developed on my PC in c:) , but I haven't found any way to change the path of the ini file Exporting in BAS, it seems not bo be a properyt of dynamictransformation...more >>

Hi, I'm running SQL2k sp3 on a dual Xeon w/four drives/arrays (SCSI)(OS on C:, Logs on E:, tempdb on F:, Data on G: (500GB)). I have a large DTS package for processing text files for billing and reporting purposes. The input file averages 400,000 rows per day and ends up creating a dozen ta...more >>

I'm attempting to use Transactions within a DTS package but am experiencing problems and receiving the following error: "Package Error Error Source: Microsoft Data Transformation Services(DTS) Package Error Description: The Microsoft Distributed Transaction Coordinator (MSDTC servi...more >>

Hi! I am new to DTS scripting and I was wondering if there's any way in DTS to scan an existing table and change a field's value. I am generating a lookup table as I load my raw data. As this lookup table will be used later on to populate a dimension table, I need to programmatically scan its ...more >>

I was wondering if anyone could point to a website that would help translate VB into VBScript.. Reason is that I had a developer create a VB application tied into a SQL server. A lot of his code is outdated and not very useful. I'm trying to convert as much of it into DTS packages. Howev...more >>

I have a problem Package is stored in msdb database.But I was surprised to see many package in the database table sysdtspackage. How is this possible. Would it have some effect in my website if I am using this package there. Is there any way through Which I can Stop such recreation. ...more >>

Hi there, I=B4m trying to export a "ntext" field in which I have=20 stored notes (a lot of text). I'm using the Query=20 Analizer, but the select command only returns the first=20 line of the text in each field. It seems that when an=20 enter is found it just finishes displaying the text of=2...more >>

Hello, How can I change the creator and computer of a DTS-package with something simular to sp_reassign_dtspackageowner. Regards, Hans...more >>

hi ng, is there any other way to register a custom task (written in VB) in the DTS-Designer as register it within the DTS-Task-UI? I've read something about the "Register Custom Task command" on msdn but i don't find any further information. Any suggests, hints or informations? regards ...more >>

Hi! I am a newbie to DTS. Below is a sample code which copies the data from a source text file to a destination text file. Assuming that there are 3 columns in the source text, if one of the rows has a missing column (the last column), DTS encouters an error and then stops processing the...more >>

Hi, Can I transfer datas form SQL Server 7.0 to 2000 with DTSs. Thanks a lot, Salim ...more >>

I need to take a hierarchical text file and import into a set of relational tables. The first three characters of each line identify the format of that line. The goal is to do this with a DTS package that can be executed as new files are received. Has anyone got an example of something li...more >>

Hello, I have tried to export a table that contains fields of datatype decimal, however, when I export the data to MS Access, the values to the right of the decomal point are never present. The number is rounded to the nearest whole number. I tried creating the target table in MS Access, a...more >>

Hello, I have a package built in EM that gets columns from a table and transfers them to an existing Excel document. The package creates the appropriates columns in a new page an does the transfer. Everything works well in EM and dtsrunui. Using the code generated by dtsrunui, I execute th...more >>

I have a dts where I am transfering data from dbf to sql server database. I receive de following message but I did not find answer in microsoft knowledge base. Do you know something about it? -2147008507 (80074005); Provider Error: 0 (0) Error string: Could not acquire a FastLoad ...more >>

Hi, I need to export only the data from server1 to server2 without deleting and creating the existing data on server2.Can I do that? Also,can I backup the db on server1 and zip the backup file and send the backup file to the pc which runs the server2 and unzip the file and restore it?Can I do t...more >>

I've set up a bunch of DTS packages to import from delimited text file where the first row has column names that match exactly the field names in an SQL table (sql 2000). Runs beautifully when no changes occur to tables. However when columns change in SQL, the new columns populate with NULLS ...more >>

I have a stored procedure that runs simple DTS package. The DTS package that exports SQl table to .csv file on another PC. Runs fine as long as the destination is located on my local drive. However, when I modify the connection to point to a folder located on a network drive, I get the fol...more >>

Hello everybody I want a dynamic properties task to set the treekey property of an olap processing task to one of its partitions. From some reason this wont work and I always get the following massage: error: "-2147221499 Exception_Access_Violation. Need to run the object to perform this opera...more >>

I am trying to fetch data from an Oracle database to SQL Server 2000 database. The fetching does not take very long time (around 2 mins) if it's just simple query eg: select * from TABLE where DATE = MyDate But when I try to put additional condition in the query: select * from TABLE ...more >>

SQL gurus, please help... I am trying to import a .csv which has date and time in a column in the format "01Jan00:00:01". When I specify the field to be datetime in SQL, I get errors saying that a string cannot be converted to datetime. any help would be much appreciated. thanks, ...more >>

I am migrating data from mainframe to SQL Server 2000. The mainframe has a utility that dumps all the datatables in the mainframe database as .csv files to a windows system. There is another utility that gives me the schema for each datatable. I upload these .csv files to SQL server usin...more >>

Hello, I have DTS packages being run within a VB client through the DTS object library, and would like to run the packages in an asynch fashion if possible. At present, once a package is executed, the rest of the machine is blocked until that package finishes. Is there any way to prev...more >>

I am working on a project where I need to connect some Windows 2000 (SP3) servers to an IBM AS/400 database. I'm using IBM's Client Access OLE DB driver (V5R2 with SI08894 patch installed) on each server. The first serve is dual-processor, running SQL Server 2000 (SP3), and I have a DTS package ...more >>

I'm trying to copy the data from 1 file to another file. When I create the task transform copy and specify the text file name in the source tab and go to destination tab it comes up with a dialog box which gives all the fields. When I hit execute to define the same no. fields for the desti...more >>

Hello, I try to send data from sqlserver 2000 to a remote DB2 as400. The AS400 is connected with a dedicated line. Now, if i run the DTS package from Enterprise Manager all is ok. If i run the same package from Query Analizer or from my application programm it never goes to the end. No response ...more >>

Dear Experts.. How can I Transfer data from sql server table to excel file programatically in DTS activex script?? 1)Table data need to fetch from a sql querry that change every time the Package is excuted i.e I want to pass the sql querry(with lots of joins) every time the packeage is...more >>

I am getting an error while executing a Job ..Has anyone got an idea about the same..The error goes like this... Executed as user: GECCEFDBY\##MSSQLServer. SERVER_NAME.master.dbo.xp_fixeddrives [SQLSTATE 01000] (Message 0) Access to the remote server is denied because no login-mapping ex...more >>

Hi all, I have a file that looks like: 123456.pms03071 The first part, 123456, is unpredictable. The second part is pmsYYMMDD. What I want to do is to load the file with todays suffix. How can I do this in a simple manner? I have a path in a DTS-package that looks like: sFilename = "d...more >>

I have an xls file that I want to import into a table within sql2000. I have built a DTS that does a simple column copy with a lookup to import the data and everything works fine, locally. However when I try and set up the dts on the hosts sql server it only gives me the option of connecting to a...more >>

I am attempting to export various tables to Excel 2000 - however am finding that some of the table records are losing their key field data - and are not being exported to Excel. The key field is an auto inc field, and is clearly visible in the SQL database. In one table all the keys are m...more >>

Is it possible to have a lookup with multiple parameters? If so, how do you pass them via an ActiveX script? Example: Select * from employee where jobid between # and # Thanks in advance...more >>

Hi All, I have an Excel sheet which I recieve every week. Its not too much data and the present process is to manually load that data into a SQL Server 2000 EE table. But I would like to automate this process. I have tried using the DTS, but it doesn't work. What I wud basically need is tha...more >>

Hi Folks : I have an excute SQL Task in DTS Package. I am excuting a sproc which has three output parameters . I would like to assign the values to the Global Variables in the Package so that I can use the Global variables in another Task . But when I parse the code and click for the Parame...more >>

I am trying to import FoxPro tables from a NT4 server. The DTS package fails during it's scheduled operation. It says it can't find the FoxPro tables. What appears to be happening is the FoxPro ODBC driver wants a mapped drive to the table locations and the Schedule service doesn't have the...more >>

I have some flat files stored on mainframe tapes. How can I configure the DTS in SQL2000 to get those files? What driver should I use? These files are hugh (approx. 9GB). Is it possible to connect to those files directly without FTPing into another machines before sending into SQL? Any add...more >>

I need to copy a rather complex DTS package from a Dev server to the production server. The package was saved in SQL Server. Is there a way to do this? -Joseph...more >>

Hi, I'm trying to use DTS to solve the following mess: 1) I have 120 excel spreadsheets/day 2) I run 120 macros on these excel spreadsheets - the macro does the following: 1) Inserts three columns 2) Enters in data: server, date, time. These are all the same for a give...more >>

I use login authentication for all my DTS and job. But recently my jobs have failed because the domain that authenticates these logins are having trouble and that is out of my control. So, I'm thinking about changing the loging for the packages and jobs to a sql server login. Here is the q...more >>

I am running some DTS tasks against an Oracle database and have some questions. I can establish my connection alight via OLE DB. When I query the Oracle database do I need to write the queries in T-SQL or PL/SQL? We are converting from SQL Server to Oracle and I have the queries going a...more >>

Hello, our server crashed, we move to another server with the database.... how do I recreate the DTS Packages and Jobs. Where is the information stored, and how do I import it? ...more >>

I'm stumped. I know this is probably something very simple but I just don't see it. (Running SQL 7 sp4 on W2K Server) For simplicity, I created a job with just a Microsoft OLE DB Provider for SQL Server (tried using both NT Auth and SQL Auth). I am able to Execute Package fine even thou...more >>