I am going to import 2 columns (out of ten) from a CSV to a database in SQL Server 2000. I would like how can I choose these 2 columns ? In DTS Import / Export Wizard, I click the Transform button. Should I change the source columns to "Ignore" for those I don't want to import OR change...more >>

Hey all, Sorry to swamp the newsgroup buuut... In the ActiveX script area of an Execute SQL Task is where my problem lies. I am having difficulty getting SQL to talk to VBScript... sqlstatement = "IF (SELECT COUNT(*) FROM "& DTSGlobalVariables("Processed_Table").Value &" WHERE lastname LIKE...more >>

All, I went through about a week of research to figure how to import files with DTS. Come to find out these files are from unix and row delimited with a leed feed character only. They are row-delimited this way because they were ftp-ed from unix under the binary transfer mode. If you ftp ...more >>

This is a "repost" continuing where a post left off. The subject has changed. The original post was "bas file does nothing". I get the following error when executing a package from vb script: Source: Microsoft Data Transformation Services Flat File Rowset Provider Description: Incomplete file f...more >>

I want to trans some similar string in oltp system by using dts? for example: ms microsoft microsoft corp. m*s* .... all trans to microsoft oracle ora oracle corp. all trans to oracle ......... how...more >>

Hello, I copied a DTS vb6 package to vb.net and can now import data in my vb.net app from a text file (or MS Access mdb) to Sql Server. What I would like to do is to have DTS pull the data directly from a data table (ADO data table in the app - memory table). Is this doable at this time...more >>

Hello, Please ignore if this is a beginner question for this group, since I am into web development. I remember seeing data transferred from SQL Server tables into .sql files. I know how to export a table structure into a .sql file, which can be executed on any other databases to create tables...more >>

We recently changed the sa password on our SQL Server 2000. After we did that, our DTS Package stopped running successfully. The package generates an error "18456- Login Failed for "sa". The owner of the job is sa. We checked that sa is still setup as a system administrator. We also ve...more >>

Hey all, ..The below code is included in the "Use ActiveX Script" area of an "Execute SQL Task" in DTS. I know it's a sloppy loop, but I'm a newbie, and it works, so... Anyways, the sqlstatement checks if a table exists, if it does, it appends an "a" to the tablename and creates a new table, i...more >>

Hi ! Well, im having my first steps with MSSQL and I have a small problem. I've created a package that retrieves data from an AS400 system and specifically from a multimember file. I need to create each time a date format like '200407' and pass it in an SQL Execute Task as parameter. I'...more >>

Hi I am facing a problem while creating a data source, I right click on data source select new data source select "Microsoft ole db provider for sql server" enter the appropriate server name,userid,pwd and Click test connection , uptill this part things go on fine but when I clikc "Ok to...more >>

I have created a DTS importing 3 columns to a table. One of them is a key. However, when I execute the DTS, I get the error message saying that another field (that is not a key) that I do not suppose to update: Cannot insert the value NULL into column 'abc' Is there any suggestion ? ...more >>

I'm trying to run a package to import a file and get the following error: Step "Copy Data from cel_stat to [Skynet].[dbo].[cel_stat] Step" Failed Error: -2147467259 Source: Microsoft Data Transformation Services Flat File Rowset Provider Description: Incomplete file format informatio...more >>

I need to export data from SQL Server 2000 to a csv file located in a web folder. When I choose the file name path using the dialog box, it becomes translated to C:\Documents and Settings\v-michh\Local Settings\Temporary Internet Files\Content.IE5\KFCRM1S1. When I run the package, I get an err...more >>

Hi I have a SQL sript that inserts information from one table into another in the same DataBase. Is it possible to do this in a DTS package because i need to schedule this task. Many Thanks AQ *** Sent via Developersdex http://www.developersdex.com *** Don't just particip...more >>

I found a great piece of code on the web that allows me to execute a DTS package on the server by using a stored procedure. Here is the code. DECLARE @object int DECLARE @hr int --create a package object EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT if @hr <> 0 BEGIN print 'er...more >>

DTS Gurus ! We have a SQL 2000 package which uses a data driven query which makes use of two stored procedures. GETNeededRecords() and ProcessNeededRecords() with transformations defined. Each record in the result set returned by the GETNeededRecords is used by the ProcessNeededRecord...more >>

Hi all, I need some help here. I want to create an ActiveX with an Inputbox = ("Enter a number")in a DTS Package. Value entered in the input box at the runtime should be passed to Global Variable "gvweek" as Input Parameter. I want to use this GV.Value as a condition (e.g. Where week_no = ...more >>

Hi All. I need a help. I have a SQL2000 SP3 on Windows2003 (English) and I am trying to export an Unicode base table into a S-JIS base csv file. Using dts, I can choose only UNICODE , ANSI or OEM.. Is there anyway to convert it to S-JIS (Japanese Standard) ?? Thanks. Aki ...more >>

Hello, I saved a DTS packaged down to a VB6 module. If I compile this module in VB6 it runs fine. But I would like to incorporate the code into a VB.net app. I am having a lot of problems with this. I have turned Option Strict Off (for now) and even with that I still get 3 types of er...more >>

I have two SQL Servers in the dts package. SQL_Source and SQL_Dest. I am doing a very basic transformation that copies columns from a SQL_Source.table1 to SQL_Dest.dest. I have a data transformation task that does it no problem. I am also doing a transformation from another table in SQL_So...more >>

If I get a CSV file with 10 columns but there are only 2 columns have to be imported to a table via DTS. Is it possible for me to do so ?...more >>

I am using the Bulk Export task with an ActiveX script. The script was working fine a couple of days ago, but for some reason has stopped working now. I am trying to dynamically set the ObjectName and the ExportFile properties in the ActiveX script, but the script fails when setting the ObjectNa...more >>

Hi, On one of my SQL servers i have a number of DTS packages (about 50). I need to transfer (export) all these packages to my another machine. What would be the best way to export DTS packages from one machine and import into another. Thanks for you reply in advance Poorav...more >>

Hi, I am fairly new to SQL so please forgive me for any ignorance displayed! I have 2 different SQL servers running on a network, both have identical databases and table structure etc... I want on a nightly basis to export all data from one of the servers to the other server, I want th...more >>

I'm making a data transformation of about 20 columns from one table to another. I can't see anything that is triggering it, but it seems that after I save and open the "properties" for the column order they are all reversed!!!! It's enough work to have to do it all manually once, but to have ...more >>

Hi all: I am trying to import a csv file into a SQL Server table. (It's a bit more involved than that, with an ActiveX script doing the transformation). The first 265 rows are done just fine, but then the process stops with the error Data for source column 1 ('Col001') is too large for th...more >>

How can I create a DTS Package to export data to an .ics file in this layout? With the Cap names being the fields. BEGIN:VCALENDAR METHOD:PUBLISH BEGIN:VEVENT ORGANIZER:MAILTO:vJones@philamuseum.org DTSTART:20040805T190000Z DTEND:20040805T203000Z LOCATION:Pereleman TRANSP:OPAQUE SEQUENCE...more >>

How run DTS Export data from SQLServer2000 to text file with vb.net? ...more >>

Hi, After a lot of research and online help and also using the DTS wizard option in the Enterprise Manager, I was able to develop a program in asp that creates a DTS package starting from setting up the connections, the tasks and the final execute to import data from a text file to a table. ...more >>

I have a DTS local package that's scheduled via the SQL Server Agent. This job, when it runs normally, takes less than a minute to run. Periodically, the job will hang. When I examine the job in Enterprise Manager, I find that the job status is still "Executing". I then have to stop the job from run...more >>

I am transforming a date from text to smalldatetime, however when I come across dates with years way in the future, such as 3001, the transformation falls over with this message syntax error converting character string to smalldatetime data type I have tried using the advanced tab to t...more >>

Hi, group: I am having a problem with a DTS job that processes an OLAP cube. The DTS package executes successfully from the DTS Designer but when run from SQLAgent, it fails with the following error: NOTE: my SQL Server is on computer A, while MS Analysis Services is on another computer B. ...more >>

3rd post: Allan, The example at the URL does look like exactly what I asked for, however I'm not sure I know how to use it (plus it implies it's for a SQL Server version beyond 2000). However, to let you understand why I can't take advantage of that, let me say that I have about six years o...more >>

I have some files I need to load and have learned how to create a DTS package to do so. The problem is that the file path changes every day according to the date. I can do it usine MS Access but this doesn't meet the time or performance constraint. I would like to be able to call a DTS package wh...more >>

Hi, I have the foll csv file 01,12111 02,14155 05,11011 10,00114 34,00001 03,11000 I have the following code that parse the text file and and import in sql = server table, it import perfectly except it is removing leading zeros so = 01 is returned as 1. Why? With Con1 ....more >>

I wrote a stored procedure which uses temp tables in its logic, tested it in query analyser it is executed without errors, when i try to execute it in DTS activex script, it is failing. If i remove temp tables usage inside procedure i am able to execute in the same activex script, can someone get...more >>

I have defined several transformations for importing data into my SQL7-SP3 (Win2K)from text files. Now, I no longer see the option for specifying "Text file" as the source for a new transformation that I'm trying to set up. I downloaded and installed MDAC 2.8 but that didn't resolve the ...more >>

Hello There! I have a text file containing 3,876,240 rows and i am using a simple DTS package to copy this text file into a table with same column definition. According to the Status bar on the "Executing DTS Package" window it loaded in less than 3 minutes 3,876,200 rows and then it t...more >>

I need to create a DTS Export job that can be imported to MSDE via script. But I need to be able to alter the destination server in the script. When I use DTS wizard to create the job and create a script from it. I do not see how I can change the destination server within the script, becaus...more >>

Hello, I'm having trouble running a DTS package that pumps data from an Excel sheet into a table in SQL Server. The package runs well when starting it from within Enterprise Manager. But every time i change the name (DataSource) of the Excel file to be imported, the designer asks me to CLEAR t...more >>

my requirment/problem I have stp, it generate a table, I want to export that table (5 columns) to Excel sheet then send a email as attachement. Excel file name is hardcoded, we cann't change the file name. When i ran my dts it export data to excel that works fine. problem is if i h...more >>

I'm a bit lost. When I execute a DTS package via the SQL Server Agent I get a Permission Denied for CreateObject after the job successfully creates an object. Set cn = CreateObject("ADODB.Connection") works ... some code... Set ftp = CreateObject("doFtp.Ftp") fails When I log in a...more >>

Hi How can I get the DTS detail error information? Is there any method of function like GetExecutionErrorInfo in VB? I got the "Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed. -2147220440" error. But I don't know why. the err.Description doesn't work fot it. Any sugges...more >>

I have to SQL2000 servers setup and for a while I was backing one to the other using a DTS package. Now it fails. I cannot figure out why. The latest error is a "DMO Bulk Copy Execution Failed" error. Perhaps I am doing this wrong. What should I be doing to totally backup a database from o...more >>

Declare a variable XXX a table name = TableXXXName ( insert variable between Table and Name) how to write a select statement where table name got insert a variable ? Select * from Table+XXX+Name .......can not Select * from Table%XXX%Name......can not Select * from Table&XXX&Name .......c...more >>

Hi, I want to execute a windows application inside the SQL Server by defining a task, and but that application will jump a user interface waiting for user echo, Is that all right? ...more >>

I have a server that until yesterday had SQL 7 on it, and it ran okay. However, after upgrading from SQL 7 to SQL 2000, I have one job that won't run. It's a scheduled job to be run each night, and it kicked out last night as soon as it was scheduled. A "normal" run of the job would give th...more >>

Hi, Thank you for the quick response earlier, but I'm still having a little trouble. My DTS Package has a Transform Data Task (TDT) between two connections, i then have an Execute SQL Task (EST) to delete the records in the source table if the TDT is successful, but i can't figure out how to stop t...more >>

My DTS package consists of two tasks, one... to transfer the data and two... to delete the data at the data source if the first task was successful, how can i cancel the first task if the deletion task is unsuccessful, i'm sending the same data twice because the first is allowed to retrieve the data...more >>

I want to insert a text file with comma seperated fields. De text-field have text qualifiers: "field1","field2","field3" I made a Bulk Insert with FMT file. I choose comma seperated with text qualifiers. In the example screen the data looked perfect. After the insert however the text qualifiers wh...more >>

I have various DTS packages that copy data from our Progress Database to our Sql Database. The packages work fine when running from the Enterprise manager, either by right-clicking the package and executing or from inside the package. When we try to execute it from the schedular (Sql Server A...more >>