Hi, What's the best way to import data from a csv file into a table in which some of the rows already exist in the table? Assume the primary key value is in the csv file. So I'm basically looking for a "replace" operation on that row. thanks, Deac ...more >>

I've been experiencing a problem using the Transform Data Task to call a parameterized stored procedure and output the results to a file. I've searched the groups already but haven't found a solution. The following has occurred on two separate SQL 2000 servers (at work - where my real problem...more >>

Is it possible to write to a file in the ActiveX props in DTS? I was thinking of the FileSystemObject, but am not sure. I've looked on sqldts.com, and see that I can create, delete, move, check attributes, etc. But I dont see any way to write to a file. Possible? TIA, ChrisR ...more >>

I am new to SQL. I have coded a query that has 4 separate SELECT statements. Each step stores the result in temporary tables that are then referenced in the next step. When I execute this series of steps in SQL Analyzer it works fine. When I inlcude this query in a DTS package and execute i...more >>

I get this error when trying to run a package from a job: Error: -2147220460 (80040414); Provider Error: 0 (0) Error string: Cannot find specified package in the storage location specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sq...more >>

I am working with OLE DB from IBM (iSeries Access V5R3 - I tried all the 3 different provider) and SQL Server 2005. When I try to get Data from an AS400 Table from an OLE DB Source with SQL Command (also simple SELECTS) I get the error as listed below. Although in the Query Builder Window and...more >>

I'm seeking help on system backup for DTS packages, and, information on how to backup or save DTS packages so they can be moved / restored to another server. (we can save to individual .dts files but this is longwinded - we're looking for a batch solution) We have tried backup of the msdb ...more >>

Hi all, I am having problems importing data from Access 97 .mdb files into my SQL Tables. Using DTS, I invoked the Import/Export wizard. When prompt for the source, I specified Microsoft Access and it's path/filename. I did not enter username and password for the source. But...more >>

If I open my DTS pkg in Designer, and then save it as a .bas file to modify it, how can I bring it back in to DTS "Local Packages" in Enterprise manager? Thanks. ...more >>

I have a DTS package (DTS#1) that has an ActiveX script that compares two values to determine whether package DTS#2 should be executed or not. Does anyone have an example of how to execute a package from within an ActiveX script or is there a better way to handle this? TIA. Chris....more >>

I need to extract some data from a client's Access 2000 .mdb with user ID and Password. The .mdb is on a PC with a static IP address. I can log onto the PC with Microsoft's Remote Desktop Connection. The database is REALLY, REALLY BIG relative to their DSL speed. Consequently, it is NOT...more >>

Hi, I have a dts package that reads a text file and enters the data in a table. There is a global variable which I have to pass the value when executing the package. Instead of passing a value I want the package to do everything. All I have to do is ececute the package. I created an sql task...more >>

Hi Everyone Im Trying To Import Data From Excel File To Table. This Table Have 2 Fileds Only & They r Both Primary Key & With Relation to Another Table But It keeps give me the error that there is a violation in Primary Key inspite that there isnt any repeated record in the excel sheet. Any ...more >>

Hi, I have created a DTS package for reading data from Excel sheet and copying them to SQL Server database. Overall it works fine. But I have a query about date conversion and would be thankful if someone can help me with the same. Here I go - In the excel sheet, there are (among othe...more >>

I have a strange problem. I have built a DTS which runs fine when each step is executed individually, but when the DTS is run as a whole, the last step fails. I have checked the workflow and nothing seems amiss there. Now I'm stumped and don't know what else could be the problem. The DTS ...more >>

Chaps.... I am facing a problem with DTS 2005 (or actually IS 2005, DTS's "successor") that I am really not able to resolve as of now. I have a package that reads a flat file and writes data into a database using an OLE DB connection. It does some transformations using a Script Component,...more >>

I have defined a DTS custom task with the following declarations for the DTS Custom Task class 'Required for CustomTask Implements DTS.CustomTask 'Required for CustomTask with User Interface Implements DTS.CustomTaskUI 'Required Custom Task Properties Public Description As String Publi...more >>

Hi, I created a simple DTS package to export data of some tables to Excel file. I want to execute it with dtsrun.exe but it hangs before complete. The message is like these( I’m using SQLServer Japanese version so I translated the output. maybe it is not exact) C:\temp\dtsrun /FMyDTS.dts...more >>

I want to set destination table programmaticaly in Transformation Data Task. Is it posible? Thanks ...more >>

Hi everyone: Could you help me, I'm trying to execute dts in file format from an asp.net application. I tired using the guide from "DotNETCookBook", the process is not successful, there aren't any error code nether action!. I can't use DTS stored in the SQL, and I can't use xp_cmdshell for...more >>

Hello everyone, I have just created some DTS package wich pump data from Visual FoxPro database to SQL Server 2000. Everything works fine when I execute de package on my local machine or any other machine that aren't servers. Things gets ugly when I try to execute these package directly o...more >>

I have a CSV file which I'm trnsferring its content to a table with follwoing feilds: 1)ClientID 2)EmailAddress 3)AddressDescription 4)Primary there could be multiple address for each client ,but each client **MUST** have atleast one address with "Primary" flag set to "Y" (which mean th...more >>

Dear all, When I am building a sql server task I am not be able to put a global variable inside a dynamic command. Look at this: SET @bcpCommand= 'bcp ' + @db + '' + @table + ' out ' + @strPath + '.dat -c -S ' + @host + ' -U ' + @strUser +' -P ' + ? + '' The last one, i.e (...more >>

Potential newbie question... I have one package that runs inside another one. I have noticed that I have to update which version of the package I am running in the envolping one. So lets says I make a change and save - it gets a different time stamp. How can I clear these old versions out...more >>

Is it adequate to use the Database Copy Wizard for large databases. The database is about 20 GB ...more >>

I'm trying to import a name range from an excel file. I call the DTS package via VBA and it captures the information I want perfectly. However, this is only assuming that the workbook I'm calling the package from is the first workbook open on my desktop. If for some reason it is not when I ca...more >>

hi is there any way to find last modified date for any stored procedures thanks kalyan...more >>

Hello: I have 1-day experence with SQL Server 2005. So bear with my ignorance. I created a Project and several DTS Packages in it using BI Development Studio. I am able to execute the packages within the BI DS IDE. These were stored as file system objects (*.dtsx). They don't show up unde...more >>

Hello all! I have a series of file-based DTS packages that I want to execute from our web servers, and I have a couple of questions about the deployment of the objects necessary to support these packages. In my DTS packages, I have some ActiveX scripts that do some "package manipulation"...more >>

I'm trying to import data from Excel 2000 file with DTS in MSSql2000. I keep getting NULL values during import. I have been using this post mostly http://www.sqldts.com/default.aspx?254 I've been trying to use the third option of using an ActiveX script. But it doesn't have any effect for...more >>

We are using a dynamically created DTS package to do a complete push replication from our production system to our public-facing website. Recently, our DTS package has started to throw errors like to the following (Culled from the DTS DataPump log, obviously) ---- Execution Started: 6/9/200...more >>

We are using SQL v8 from the newest version of ACT! (v2005). We'd like to use DTS to transfer data in and out of ACT! to an MS SQL server. The ACT server is on the local LAN and the MS SQL server is at our hosting site outside of the firewall. We'd prefer to not initiate DTS transfers from out...more >>

I'm having intermittent problems with a DTS package randomly generating empty files. My package is actually split up into 4 packages, due to size, and each package calls the next package in turn. The first 2 packages work fine (no exports) gathering data from an external source and processi...more >>

Hello: I just installed 2005 Beta 2 and I have been trying to understand DTS. I was able to create a DTS package using the wizard and saving it. But the task failed because of some data mis-match. I am trying to find out how I can edit it and then run it? Can somebody educate me on both...more >>

New guy here - basic situation is as follows. Trying to import text file into SQL Server. The file is sometimes empty so I want to skip the attempted copy if the file is empty and move on to the next step. the procedure I'm attempting is at: http://www.sqldts.com/default.aspx?214 In the "...more >>

Hi, I am a newbie at sql server. Can someone please tell me if there is anyway to only import data from source database that aren't already existed in a table of the destination database? Thanks. Donna ...more >>

I use either of these two patterns 1)"d\d\d\d\d\d\d\d\d\d" 2)""d{10}" to regex a 10 digit number but it never pass the test method (always says that the input dosen't match) . Anyone can help? Thanks ...more >>

I need to create a table and populate its data, including about 100 icon files stored in IMAGE columns. This will be part of an install that creates or updates an existing database at a customer site. Whats the best way to accomplish this via DTS? Since I will not have access to the remote ...more >>

hi in my table date value is 2005-05-30 16:40:00 In select statement, i want to compare with 05/30/2005 can anyone tell me how to use date column in where clause thanks kalyan ...more >>

Does anyone know where/how to change the path and filename used by the Dynamic Properties task when reading an INI file. I would like to change this when installing a DTS package via my setup program for an application. Any help or directions would be appreciated. ...more >>

Good morning folks, I am at my wits end and have turned to you so that I can keep some of the remaining hair on my head. This is going to be a long winded post as well. Fair warning. We have a Pervasive 2000i database which we had SP4 on. We have several individual DTS packages on SQL Serve...more >>

We had a DTS package that was working fine until yesterday and since today it does not work and we get the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(null)'. Reason not associated with a trusted SQL Server connection. Please clarify ...more >>