Hi All, Currently we are implementing an ETL Process via DTS. There is some confusion regarding Staging Area. As far as my understanding is concerned, i feel that the Staging Area (SA) is the area where where i _EXPLICITLY_ store data from my legacy system, the reason to use a SA can or can...more >>

I'm trying to create a transform data task using the following query: select * from Code_Authorizations_phi where Authorization_pkey in (Select pkey from Code_Authorizations where dir_pkey = ?) When I click the 'parameters' button or 'Parse Query' button I get the following error: Error Sou...more >>

Running SQL Server 2000 SP3a on Win2000 Server (fully patched). Trying to get a simple example to work for copying a Test DB (which has one simple table) on ServerA to ServerB. DB does not exist on ServerB, both Servers running as services with identical accounts (made administrators; not ...more >>

Hi all What is the best way to transfer a DTS package from one server to another? TIA Reg ...more >>

Hello -- I have a file named mypackage.dts that was e-mailed to me. I need to install this DTS package on my SQL Server box. How do I accomplish this? I do not see an Open or Import option on the DTS local within Enterprise Manager for me to add package. Any help would be appreciated. ...more >>

How can i transfer a DTS Package from one machine to another?(Is there a file containing the script that runs the package that must be moved?). Thanks In Advance, Vinny...more >>

Can I specify a XML file as a Source file in a DTS package? How? If not, what is the best way to map XML data to my relational database?...more >>

When I encrypt a DTS package that has global variable using DTSrun, I cannot use a package password. Any DTS package saved with an owner password fails with below even though the owner password is set on the dtsrun command line using /m. The package has sensitive info in the global variables...more >>

Does anyone know of a SQLServer tool or other, such as DTS that allows me to export my SQLServer data to a SQL text file (or perhaps less preferably to XML)? The resulting file would assumidly look like a bunch of "INSERT" statements for the putting the rows of data back into their respective ...more >>

How to read number of lines in a flat file using a DTS package? I am using SQL 2K. Thanks, Ram ...more >>

How to read a file time stamp of a flat file using a DTS package? I am using SQL 2K. Thanks, Ram ...more >>

I've got a DTS package that creates several excel spreadsheets, and stores them with their last name and date. I use a global variable for distinct HR names from an Execute SQL task output parameter. The package loops thru each record in the rs and skips the data pump if there aren't any recor...more >>

Hello, I have written a couple of DTS packages that pull information from an FTP web site to a directory on the local SQL server then imported into the database and processed. Seems fairly simple, however. The files are placed in the FTP server from our Mainframe, and occationally, they a...more >>

I have a stored procedure written for number of updates, inserts to the database. This stored procedure takes too long to run. I have created few indexes around few tables, but the response time is not that defferent. THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and ...more >>

I tried to export data from SQL Server to a Excel file within ASP. I use DTSPackage object library V2.0. I know that it can connection to a Excel file using the following code in VB. But I got problem within ASP. The error shows up while my ASP running: "Microsoft VBScript rnntiom error: Objec...more >>

Hi all, i'll try to explain my problem in the best way! I'd like to create a DTS package that make a spreadsheet file where each sheet represents an ubication of objects and contains the list of objects for that ubication. In order to obtain this I'm thinking to run 2 queries, the firs...more >>

Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of my IIS sites has a real Internet address specified, w.x.y.z. So when the VPN comes up using a private IP, I can't connect to any of the FTP sites u...more >>

I have sucessfully created packages that can FTP a text file form a server and tehn import the data to SQL. Now I want to export data to a Text file and then FTP it to another Server. There is no FTP task then can ftp to another Unix Server ftp:/xxxx. Am I missing the obvious? Thanks for any h...more >>

I have a problem importing data with SQL. I want to transfer data from one SQL server to another. Apparently I only managed to transfer data when the new table is empty. I am choosing Append data to existing table but this is not working for me. What am I doing wrong? *************************...more >>

I am trying to import data from MSAccess. when I choose the data source and enter the userID and Password I get the following error: *************************************************** Error Source:Microsoft Jet Database Engine Error Description:Cannot start your application. the workgroup info...more >>

Does anybody know how I can delete existing connections within DTS...more >>

Hi, How to upload data from an excel sheet into SQL database? We are using ASP.Net Webmatrix and C# as backend. Thanks in advance. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I'm writing a dts package that imports a file. I want to allow my user to browse to the file, but can't figure out how. Any suggestions? Thanks, Andre ...more >>

Hi. Some facts first: Win2003 64-bit and SQL2000 64 bit on 3 Cluster nodes Q: I have to do Deligation of DTS Pakages to the Developers without giving them sa rights. I have read the the following pages: http://eddorre.com/comments.aspx?post_id=204 http://www.sqldts.com/default.aspx?212 ( how...more >>

.....is done best how ? Have heard of Toad...or perhaps linked server and then use query analyzer ? But this way I cannot get a list of tables on the Oracle database ? And second (or third..) I need to have an Oracle client on the SQL Server that needs to get data from Oracle ? Not just an ...more >>

Hi All, Can any tell me how can i plan only get the rows that have been updated only after the last DTS Process. Thanks, Mansoor...more >>

In SQL2000 I can execute a DTS package with this code just fine DTS.Package2Class test = new DTS.Package2Class(); object pVarPersistStgOfHost = null; test.LoadFromSQLServer("myServer",null,null,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,"myPackage",ref pVarPe...more >>

I have .dts file from another sql server. I would like to import and install this file as a DTS package on MSDE and schedule it to run periodically. How do I do this in MSDE 2000....more >>

Hi everyone i have a package that have two tasks if the first one failed , it goes to the second task when i execute the package, it run succefully but when i schedule it, the job take hours & doesent failed neither successed , it stay runing so i stop it. i repeat it many time & still the j...more >>

I'm trying to import data into my table and I'm received an error message that I've been unable to resolve. The message is: Error Source: Microsoft Transformation Services (DTS) Data Pump Error Description: Data for source column 3 ("column_name") is too large for the specified buffer size....more >>

I am getting burned in every direction I take to get around this problem. I have a loop in a Stored Procedure that reads records from a table to build the SQL string to create the structure of another table. In this loop I am concantinating the field names together. Doing this I CANNOT ex...more >>

?I have a dts package which is run once per day and will fail on 1in6 attempts at execution with the above error. It is running on a dual proc Win2000 Server, I have been unable to recreate it on a single proc dev machine. Is the issue related to the package stucture (we are using multiple ...more >>

I have a stored procedure as follows :- Create Procedure GetNewYear_mnth as Declare @OldYear int, @OldMonth int, @NewYear int, @NewMonth int select @Oldyear=max(uc_year_num) from tprocess_control select @OldMonth=max(UC_MNTH_NUM ) from tprocess_control where uc_year_num=@OldY...more >>

i have an existing sql database with data and i'm trying to migrate the data to another empty sql database. our software's been updated and the new database's schema's been changed. i want our existing data inserted into the new database. i've tried to use dts but am having problems. first try...more >>

I have a DTS job that is scheduled to run once a day at 5PM. The job invokes a couple of batch files which in turn execute a java application and periodically I am seeing from the logs that the job appears to be executed multiple times on the same day -- usually within a couples of seconds ...more >>

Hi, I have several dts packages which I want to set from "export all records" to incremental export. I need to export these records once an hour, so my first idea is to modify the select statement to only include the records from the last hour, but, when the server misses a turn for some reas...more >>

Hi , i need an help . I need to import data from database access to sql server database , and this is not a problem . The really problem is that the database access is variable . My idea is to insert database location on an sql server table and use this to change dynamically datasource on my...more >>

I am trying to import IIS logs using a DTS package. I have everything working, except I cannot figure out how to tell it to do al the logs in a directory, instead of a specific filename. Also what would be the best way to make sure it doesnt import duplicate into the database? I dont see a ...more >>

Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>

hi I have around abt 10 fixed width text files in a particular directory of the hard drive . I want to automate the task of importing all these files into 1 table of SQL Server. All the files have the same fields. How do i do this....more >>

I have a table with 40,000 keys on SQL Server. In a SQL Task I can create a recordset from that table as an output parameter in a global variable. I have ODBC access to an Informix DB in DTS. I don't know how to join the Informix Table with the SQL table. I don't know how to make the Informix a ...more >>

I'm trying to schedule a DTS package that generates a flat file and then does an SFTP upload of that file. The package runs a batch file (using an execute process task) to do the upload. The batch file contains commands for an SFTP command line program (exe file) to do the upload. When I run ...more >>

I have a Text File (Source) Connection object. I need to dynamically control the Record Length to properly read some non-standard CSV files. When you use the Text File Properties dialog and specify a Row Delimiter of NONE you have to also specify the Record Length. I need to specify the Re...more >>

I have a package (A) which executes another package (B). The executed package B contains a custom task. Package B executes correctly when run by itself, but fails with "Not implemeted" when executed from package A. If the custom task is removed from package B, it runs OK when executed from pac...more >>

I am converting data from a multi-dimensional database which means that many of the columns are in-effect sub-tables that have delimited values. As a result for each of these columns I need to create/insert/update a table. Does DTS have a function that will do this? Thanks ...more >>

...anyone have a solution to this. Have 100 excel files stored in a table in binary format and need to export them...have an asp application where I can pick them one but would of course prefer not having to do that.... ...more >>

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error -2147467259 (80004005) Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec ...more >>

Hi Everyone im using the sql package (send mail task) & it work fine on my machine when i try to run the job on the server(other machine) it gives me an error say: "Initialization of MAPI Failed , Please make sure that you have messaging services installed on this system" Any Idea About what...more >>

What is the ASCII Equivalent to the SQL 2000 NULL? Chr(0) would have been my first guess but it does not import into SQL 2000 as <NULL>. Chr(20) is what SQL 2000 gives you when you export a NULL to a CSV file, but SQL 2000 does not import Chr(20) as <NULL>. So someone please tell me wha...more >>

I have created a DTS package. Now I have schedule the package to run under the SQL Server scheduler. When I execute the package manually, it runs just fine. When I run the job from the scheduler it fails. Below is the complete error message. The package is simple. It opens a text file an...more >>