Hi, Trying to relearn SQL. Need a SQL Syntax Quick Reference ASAP please. Thanks very much for the help. ...more >>

I have a dts package that when scheduled via Enterprise Manager it does not run. The owner is same as the SQL Agent service. When I run it interactively it runs. Does any one have any help! Thanks, Katherine Phelps Mgr DBA ...more >>

Hi i have a dts-package which exports sql-data to an excel sheet, works fine. now i want a dynamic output path, which i read from a sql-table into a global value of the package (also no problem) can i assign this global value to the excel connection datasource many thanks uwe Heidelbe...more >>

I am trying to create an alert that will execute a job and pass arguments to it to perform certain tasks. Does anyone know if this is possible?...more >>

Hi Is there a way to save all packages to Visual Basic in one go? DTSBackup does not support Visual Basic as a Target. Hans...more >>

I am trying to import a text file in DTS. The file has 3 different record types each are a different length. The table I am trying to import into has only 2 fields. The first field is varchar(3) for the record type and the second field is varchar(300). The last record is 80 char and does e...more >>

A Copy Database wizard was run and the optional Master objects were copied as well. They weren't meant to be included in the copy and now there are 5 Stored Procedures in the destination Master showing they were created at the time the copy was done. I don't remember if those stored procedures were ...more >>

Hi, I have a question regarding an error message when running a saved DTS package that copies a database through the Import/Export function. When I run the package, it runs for a little while. I can see the objects being copied and while it is copying the table the "Package Result Exe...more >>

Based on a single query, I need to output the row data to different files depending on a specific column value. For example: Query results Symbol Shares Exchange --------- -------- ---------- MSFT 1000 XNAS --> write to XNAS.csv DIA ...more >>

I have an Access DB and recently designed a SQL 2000 tables scheme that is some how similar to Access but added more fields and more tables and normalized tables to more tables. I need to use DTS (if this is the right tool to use, if not, please suggest) to transform all the data ONLY from Acc...more >>

I have a package that I want to export to a text file from a stored procedure. Both connections are set up correctly. When I try to edit the transformation I cannot define any column mappings, the designer crashes when I click on define columns. How do I create the transformations because at t...more >>

i need to write a DTS package that will copy DatabaseA to DatabaseB on a nightly basis. the DB being copied serves as the backend to an ASP application. before restoring form DatabaseA to DatabaseB i need to first kill all current connections. im not sure how/where to go about this. fi...more >>

How to check SQL Agent job status by using VB Scripts from command prompt? Thanks for help. -Tom...more >>

HI All, I have a package which transfers dat from access to sql server.Access.mdb file is located on network ,when i created the package i picked the path from browse window.it runs fine from my machine but if i try to execute it from other machine it cannto copy tables,how do i set a u...more >>

Hi maybe someone can help me with following. pleeeeeeeeeease I have a desktop engine on my pc (XP). I create a DTS package on SQL server through Enterprise Manager. Grabbing some data from SQL server and exporting it to Excel. Everything works fine. However I need to run the package from SQL se...more >>

I am trying to figure out if this is possible. I need to transfer data from SQL server(from a web application) into an Access database multiple times, both the SQL server database and Access will have data inputed into them at various times. The Access database has an autonumber field as a p...more >>

I've noticed that when I have a sql server agent job that calls a DTS package, and that package in turn calls another DTS package, when the inner package fails, it does not return an error to the outer package and hence the sql server agent job indicates success even though the inner dts package...more >>

My data from SQL server is going to Excel. I am having trouble getting the format converted properly and need help to get there faster. Are there any good articles, etc on working with DTS(coding, etc)to convert data types, formats, concatenate, etc. For example I want to take the fie...more >>

I have 2 connection (conn1 and conn2) to the different sources. I need to do the following logic: 1. Select data from conn1 based on pk 2.Compare the data to the data in conn2 based on pl 3.If data exists in conn2 update conn1 based on pk Please help me with the task I should use in order to ...more >>

Attempting to utilize the DTSSendMailTask within an ActiveX Script and the package is failing with the following errors? Logon failed: MapiLogonEx Failed due to Mapi error 273: Mapi logon failed. I am logged onto the server with the account used for the sql service, have the same mapi ...more >>

I'm importing an excel file with the dts wizard and running into these weird results 1. Whole number columns still go in as float not int, but when I change in transformation get an error 2. columns formatted to 2 decimal places go in with a lot more than 2 3. Text columns that have numbers or...more >>

Does anyone know an easy way to get the name of the last file dropped on an ftp site and then specifying the MS SQL ftp Task to retrieve the file? I assume this will be done using a lot of VB and I'm not proficient with VB. ...more >>

How I can change a date column in format mm/dd/yyyy hh:mm:ss to mm/dd/yyyy fro Query Analyzer?...more >>

I have read some other articles regardimg this problem but still I could not fix the problem. My DTS package has 5 different Steps which is at first step I have a ActiveXScript ruuning. It takes an excel file (testfile.xls) in the server, copies that file to another folder with Today's Date. ...more >>

SQL Server 200 Help! Surely this has happened to others before me. A new customer wants to send updates in a fixed-width txt file in which master and detail rows alternate How do you do this Do you 1) Painfully muck around with 100,000 rows in the .txt file first--split it into 2 files, one f...more >>

Hell My finding so far is that security problems/flaws are "Sql Server Reporting Services" first and main issue ... and documenation is poor Hope to get some answers here We have two trusted NT4 domains A and B and a Squid Proxy that does not currently support NTLM The Reporting IIS Server (2...more >>

Hi All, Sql server 7 I have webassistant job that are running every one minute. they run sometimes and sometimes they fail. the error message in job history is error no 16821 SQL Web Assistant: Could not open the output file. Pls suggest. TIA Adil...more >>

Hi, I need to populate a global variable by getting a output parameter from the execution of following sql on sybase. But when i click the parameters button, i get following error "the sql statement does not contain any parameters". I tried sql with meta data same as output produced by this ...more >>

I'm importing a text file via DTS and getting a crazy problem. It's failing on a record with "too many columns", even though I told it to import as fixed width and specified no column markers. Also, the column it is failing on looks very similar to the previous column. I've even extracted th...more >>

I am trying to execute 5 Transform Data tasks in parallel from an Oracle source to a SQL Server destination. Are seperate source and destination connections required to have them go in parallel? Also, after I create seperate source and destination connections for each task, I also increas...more >>

Hi, Right now I have a SQL Server 2000 database, and an Informix database. May I know how to import data from Informix to SQL 2000 and export data from SQL to Informix? Besides, how to update certain data in the Informix/ SQL server 2000 after generating the Import/Export process? Please he...more >>

Hi ALL, So, in my project with SQL Server 2000, I need to replicate, when insert/update data ina a sql server table, to another table, with same structure, in Oracle. I don´t know yet if I need to do that after any insert/update os sql table, or in a interval of programmed hours. Well, I never...more >>

Is there a way to execute a "Compact and Repair" process in DTS for an access database. Problem is, I create an Access database from the DTS process, then I upload it using FTP.exe, but I noticed that when I compact and repair the Access database it shrinks down to about half the size. D...more >>

I would like to DTS those records in a particular Oracle table into a SQL table that were created after a certain date time value, which will be extracted from a table in the SQL database The DTS script looks something lik SELECT INTO analyst.Log_Event FROM "ORA"."Log_Events What I want to ...more >>

hi all !!! I am trying to push some data from SQL Server to Informix via ODBC. The insert query for Informix is: INSERT INTO informix.table (field1, field2, field3, field4) VALUES (?, ?, ?, ?) During design time, when I try to parse/show parameters I get the following error: "Provider c...more >>

Using Copy database Wizard I get the following error description: "Failed to create the share OMWWIZC" What does this mean and how can I get by this issue? Thanks Doug ...more >>

If I have a script to create a database and all the tables etc. How can I run that script in MSDE to create the database etc. from a command Prompt? Thanks. ...more >>

I have a DTS job that accesses a registered dll via the following code method in an ActiveX script task: set AxCDownloadManager1 = CreateObject("DSTHTTPDL.DownloadManager.1") It works great in development (SQL Server 2000 on Windows 2000). I have scheduled the DTS to run in a job. Both the DT...more >>

Is there a way to save new versions of packages when you are not the owner of the package or a member of sysadmin? For instance I have a package that was created by another person, but we want to be able to both edit the package. Neither of us are members of sysadmin. Thanks in advance....more >>

I have a DTS package that I can execute successfully through enterprise manager... however, if I sechedule it or run it through the command prompt... it fails with a weird error: -2147221499: Need to run the object to perform this operation. I have found that if I remove some fields from ...more >>

I have to import a few million text Files with a specific format importing them is not the problem; Speed is. I run the Script from DTS on a master directory which structure is similar to Results\TestStand#\'Month'\####TestNumber###\TestFiles.P*,F* We Get an upload every two hours to the curren...more >>

Help, Please, wine and crackers... I have read just about every posting in this group for the past 2 days and can't find a solution to what I think should be a simple task. I have created a DTS Package (SQL2000) that imports a .csv file into a TempTable (I am importing a bunch of outlook pst...more >>

There're 2 DTS steps failed from a package log (by SQL server agent output file) as follows Step DTSStep_DTSExecuteSQLTask_2 (SQLTask) Succeeded [SQLSTATE 01000 Step DTSStep_DTSDataPumpTask_1 (PPP.dbo.ADFRE to PY1.dbo.ADFRE) Failed [SQLSTATE 01000 Step DTSStep_DTSActiveScriptTask_5 (Finished) Su...more >>

Hi people ! I juste have newbie question : I've made a VBS ActiveX for find an existing file. If file exist : Ok, i can do my other tasks :Create my table ; import_my_file_in ; move_my_file If not : Nothing, there is nothing to do... BT NOT PUT THE DTS as FAILED ... please help me ... if...more >>

Hi, I'm exporting text files from a table. I want text file to have fixed length fields but I want decide the fields length. When I create the destination file connection, I can't change the length like I do with source files connections. Is it posible to change it? Thanks. ...more >>

I used DTS to import data from our production server to our test server. DTS informed me that it was successful. No data was imported. When I looked at the log it told me: ::Error:: In file in statement on line 0 Transfer Status: Transferring Data: (Table '[dbo].[CATEGORY]') [Microsoft][ODB...more >>

I have a dts which exports to .xls. The output file can be opened by excel 97, 2000 &2002 w/o any problem. But when I try to open it with Excel 2003, it says "damage to the file was so extensive that repairs were not possible." Have tried from multiple 2003 instances with same result. ...more >>

I am trying to merge multiple rows into 1 destination row during the transfer. Can someone point me to examples on this? Thanks. ...more >>

For a data warehouse project, I would like to use DTS but I need to handle data de-duplication and address normalization. Does anyone have experience w/ any 3rd party tools that could integrate with DTS to provide that functionality, or with writing custom code to implement it directly within DTS? ...more >>

I have seen the example on http://www.sqldts.com, but would like more clarification. Please show how to connect to a DTS package on the server and then change the connection path and file name of the excel file that contains the data to be loaded into the table. I am not getting how the Global ...more >>

After reading the helpfull comments on here and the suggested articiles, i though i had this problem licked My ExecuteQSQlTask looks like thi DECLARE @SPReturn Int EXEC @SPReturn = Boss_UpdateHeaders '217680', '21/01/2004', '924', '000000', 'Unsubmitted', 'Test', 'A' SELECT @SPReturn AS Sp...more >>

Im running SQL 2000 ( SP3 ) I have several DTS's which contain Activex Tasks. Is there a simple way to get a print of all of the code in each task other than opening each one and doing a copy / paste to word doc or similar...more >>

could somebody give me an example of how to write a cursor that will up date fields within a table from a table of the same design. this will be used to update existing data and to add new....more >>

Every time I use the upsizing wizard on Access 2003 in my new Access ADP database, I have one table in which I cannot add new rows. I think there is some kind of primary key issue preventing the addition of the new rows. The primary key is exactly the same in the other tables, and the table works ...more >>

Am I correct in thinking that there is no way to not accidentially import data from a CSV file daily data feed in the following PKG(?) DataSource = CSV file Transformation is Copy Column I don't want a user to accidentially import the same feed twice. My alternative is to use a linked ser...more >>

Hi, I've got this code: dim pkg As DTS.Package pkg = New DTS.Package Dim oconn As DTS.Connection Dim v As String pkg.LoadFromSQLServer("server", "sa", "sa", _ DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, _ "", "", "", "ImportText", Nothing) oconn = pkg.Connections.Item("...more >>

--SQL Server 2000 When i run my DTS package, it exports a table with one column to a text file, but the data comes out in double quotes... I don't want it in double quotes. How do i get around this problem. thank you Tim...more >>

Hello All, I have a SQL Server Database (2000) that pulls data from Oracle (9i). Currently I am using a 'Linked Server' for Oracle, as I am passing values from SQL Server to Oracle in a 'Where Clause' to retrieve the data that is of interest. The problem with this is that the package is taking ov...more >>

I am importing numbers from a file. The numbers in the file always have the following format: "0,00" -> which means a comma is used as decimal separator. During the import I multiply this number by 100. I do this using a VB Transformation Script. Now there is one problem with this: As soon...more >>

How to use bpc to transfer data between databases on SQL server? Thnaks. -Tom...more >>

I set up a dts package on one of our sql servers to pull the data from one table and export it to an excel spreadsheet located on a networked server. When I execute the package from within enterprise manager, it works fine. However, when I use an .asp page to try to execute it, I get an error ...more >>

Hi SQL2K, Win2K. I have 2 data pump tasks that load data from a source db to a target db. They can run synchronously (together, ie. no precedence). I can execute each of them on their own, and they run fine, but when I run the package, I get an 'unspecified error'. This is what I get in ...more >>

I have a big problem which I haven't found the answer too. The problem is if I create or edit certain (nothing logical here) data pump tasks I can't see the destination files columns and if I try to create them my MMC crashes with "memory could not be written". I'm working on a SQL 2000 S...more >>

I've got a DTS to import text to a table. I'd like to know if there is any way to find out if the rows of the file I'm importing can be inserted or not. And if it can't be inserted, can I register it in a log table? Thanks ...more >>

hi all !!! I would like my transformation to write some additional information into the package logfile. is this possible ? thanks in advance, ant. ...more >>