I have a mySQL database that collects call detail reports, it is mySQL becasue it runs on Linux and MSSQL is not an option. The app generating the data only supports mySQL up to version 4, and mySQL 4 does not have "views" I need to get this data into a MS SQL 2000 server database in near real...more >>

Hoping that someone will throw the dog a bone here :) I am trying to build a DTS package that will import all of the rows that do not already exist from a mySQL database (via ODBC) to a MS SQL database. Like this step1 - get the last incremented ID from the mssql table (not the mssql ID,...more >>

I've just installed a client version of SQL 2K on my machine to enable connection to the server. I am able to connect to the databases via enterprise manager. However, when I try to open up a new DTS package ...the message "DTS Designer Error : Access Denied" pops up. I didn't encounter this ...more >>

I am exporting from a SQL table to a text file, but DTS is overwriting the file on disk rather than appending to it. is there no way in the DTS GUI to make it append? TIA, Joel ...more >>

Hello. I have a VB 6.0 program that works with DTS packages. I have SQL 2000 installed on my pc and the program runs correctly there. The program has been copied to another pc where SQL 2000 is not installed but I copied all the required DLLs and Rlls and dtsrun.exe as described in an ar...more >>

Hi, I have around 300 tables to import from an Access database to an MS SQL server. I want to be able to store the DTS package into a file so I can use it to populate my MS SQL database from the Access database in my setup and deployment project. The problem is the datasource of both my acc...more >>

Hi, We got a production database that gets tables added to it daily. So, every single day we transfer those new tables via DTS to five (5) other servers (Each having the same database name). I found no way to use the 'select' stmt across servers. Can we accomplish this daily transfer by...more >>

I'm sure this has been asked before, but I must not be using the right search terms... Is there a code-view alternative to the DTS package view in Enterprise Manager? I'd like to open the DTS in Query Analyzer or at least get some other view that lists what all the graphics are doing so I can...more >>

Hi, I am fairly dissapointed with the new SSIS. I've been trying to insert a csv file into sql server and had many problems. OK, the file is not 2-3 columns with 5-10 rows but if that was DTS it would have worked the first time I tried!! It seems that Microsoft have lost their magic creat...more >>

Hi all, Recently, I added new DTS in SQL Server. The DTS owner is admin1(this SQL user is SQL System Administrators and has right to access related database as "public"). This DTS works perfectly fine when manual run in server. However, schedule job always failed. The job owner is admin2. T...more >>

Hello, I'm having some troubles using de Execute SQL Task. I have defined the following stored procedure: ALTER PROCEDURE dbo.sp_InsertDateImage AS BEGIN SET NOCOUNT ON Insert into DataImage (Image) values (null) RETURN @@IDENTITY END I want to use the return value off this S...more >>

I am trying to find the most optimal approach to load Fact table which has FK(es) to Dimensions(8 dimension) without using Cursors. MSIS or t-sql or C# code or all of above? Highly appreciate any direction/architecture approach/white papers or any source of info to optimize the peformance fo...more >>

I have installed SQL Server 2005 Enterprise Edition on a Windows 2003 Server. What are the procedures to import data from Access database into a SQL Server 2005 database? In SQL Server 2000 it was so easy to import data with the DTS program. Please help me with the procedures to import th...more >>

Hi, I am building SSIS packages using BI Development Studio in a 32bits environment. After I finish the package I copy it and the manifest, using the filesystem, to a 64bit environment (Itanium 2, Windows 2003 Server Enterprise Edition SP1, SQL Server 2005 Enterprise Edition). When I try to ...more >>

I've set up a PC that is to act as a DTS engine to pull data out of an Oracle server & pump it into a database under SQL 2000. I've done it this way, rather than using the SQL Server itself because I don't want to install the Oracle client software onto the server. I've created the DTS pack...more >>

I've got two folders - Folder1 contains files that I want to process. Folder2 contains files that I've processed in the past. I want to compare the filenames as I go through and see if they're already in folder2 before I process folder1. I've got it working, but it's painfully slow (I've got a...more >>

Hi, I need to import data from a single text file to different tables; i.e from one text file, different fields need to go to different tables in the database. Is it possible to do that and how? Thanks for any help. -- pmud...more >>

I am looking for resources (book, web site, etc.) with examples of DTS development using VB.NET Thanks! Ric...more >>

Hi, I am trying to confirm a hypothesis on the Network traffic that a certain DTS will generate, my environment is configured as follows: Server A: SQL Server Instance to act as source Server B: SQL Server Instance to execute DTS Package Server C: File Server at remote location to be tar...more >>

Hello, I'm trying to use a global variable in a simple SQL statement in a DTS. I created a global variable (type integer) at the package level. I know I can access it in an ActiveX script (DTSGlobalVariables("myGlobalVariable").Value), but that syntax doesn't work in the SQL statement. M...more >>

I don't know if this was the cause of my error, but at the moment my dts job is enabled for logging and the txt file is on the C drive. The DTS job which copies tables from one server to another had that it had succeeded when in fact it had failed. When checking the logging information from ...more >>

Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage....more >>

Hi, I am trying to freeze pane but keeps getting the "Obj doesn't support this property" error. Here is my code and the error message. Any suggestion would really be appreciated. Thanks in advance. Joanna '********************************************************************** ' Visua...more >>

Is it possible to run multiple DTS packages from ONE DTS Package? Thanks! ...more >>

Hello Trying to figure out a clever solution for splitting multivalued columns out into n-columns. For that I've build a custom component in SSIS using ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/dtsref9/html/4dc0f631-8fd6-4007-b573-ca67f58ca068.htm as an example. I need to be able...more >>

I have a file in MySQL format that I bring down from a web site daily. I've manually scrubbed this file to use it in SQL. I've loaded all db objects and now am only interested in the INSERT statements. Is there a way using DTS to stop the manually process of scrubbing the data so its usable...more >>

Hi, I have been reading through various web sites about the upgrade from DTS to SSIS and I am more confused then when I started, it could be the Friday thing or I am just reading the wrong sites. I am after some very basics about SSIS what all these tabs are in Microsoft Visual Studion, so...more >>

Hi, I am using MS SQL SERVER 2000 and its Data Transformation Service(DTS) to import my DBASE IV database to MS SQL server database. I can import most of the files without any trouble, but with some files, I get the following error message: Error Source: Microsoft JET Database Engine Er...more >>

Hi, we have to start using DTS here for some conversion work. Can anyone recommend a suitable book to get started on DTS. Don't want one of the "DTS for Dummies" type of thing, needs to be a bit in depth. Thanks Keith ...more >>

Is there an equivelent SSIS capability to Business Objects Data Integrator's Table Compare function? Thanks TR ...more >>

How would anyone go about importing rows into two tables from one flat file. One row contains an attribute for an insert - "I"; one row contains an attribute for an update - "U". I would like the updates to go to one table and the inserts to go to another. How can I accomplish this with a text so...more >>

Hi, I would appreciate if anyone can help me in this regard. 1. My client uploads excel file through web, this excel has only 4 columns . 2. Now i want to insert the data from Excel to Sql Server how do i do that? i have only one solution that i can read excel file using VB.NET and then S...more >>

Hi All, I have a strange situation with a dts package that I have. I have = developed it without any problems and through the use of performing a = "Save As" and choosing a "Structured Storage File" have distributed it = to our customers without any problems. Now we have a change made to the...more >>

I can not figure this out in SSIS and its making me feel very stupid. Scenario is to import several rows of data from Excel into SQL, but first I have to get the next BatchID from a SQL table by inserting a new row. I have the Excel import, transformations and import working fine w...more >>

Hi folks, I'm looking for pointers or clues on how to handle loading different file types into a stage table from one SSIS project. For example I may have a table with file names and types in it and need to use the correct task for that file type. The table may look like: FileName File...more >>

Hi Guys, I am new to DTS Package and would appreciate your help. I need to create a DTS package that send the output to a flatfile, I figured this thing out and the output is fine but the problem is I need to send "0" and "NA" for some fields that are not even in source tables. How can I do t...more >>

hi, i have 2 huge DBs, lets say DB1 has 30,000,000 rows and DB2 has 6,000,000 rows. I wanna bulk insert datas from DB2 into DB1 but there are common datas so, i only want to insert DISTICT datas. How can i do this in a very very fast way? thanks -- One by one they all went down...more >>

I have a package saved in SQL server on my machine. It is one source dataflow component(select..) and one datareader destination. in a commandprompt I can execute with dtexec, everything goes OK. When I try to run in VB (same machine) with dtsclient.dtsconnection /dtscommand as found in examp...more >>

Hello! How do you delete unused sql server connections from Disconnected Edit in the dts pkg? Example: I've a dts pkg that has 4 sql server connections. There were six but I deleted two and they are gone from the designer but in the 'Disconnected Edit', they are still there. I need to dele...more >>

Hi, I have migrated several DTS packages to SSIS (re-written) and I'm trying to improve the logging. I currently have a execute sql task which logs to a database table on the OnTaskFailed event, I can get the name of the task which has failed using expressions and 'System:SourceName' but is...more >>

Hi, I have a DTC/RPC problem here that I need to solve urgently - any help would be much appreciated! I was experiencing problems with a DTS package, so I used the DtcPing utility provided my Microsoft to examine things further. I'm getting the error message "Problem:fail to invoke remote R...more >>

MMC is crashing nearly all the time when I exit the Package Designer on SQL Server 2000 with SP4. Now most of the create table icons don't show but they run. Could this crash be because I have 400+ tables covering 10K plus fields and so I just pushed this Microsoft Package Designer over the to...more >>

I am load up a global variable with a nvarchar field using a query, when i try to use the data from the query in an activex script all the unicode (international characters) are garbage. How can I get around this? I been trying to fix this for over a week now with no results. I seem to be ...more >>

Hi I have a DTS package which is being moved from development to Production environment. I would like to set the IP address of the target sql server database with a parameter which can be set when it is moved to production. How can I achieve this. Thanks Bob...more >>

I'm trying to create a merge join that essentially does this: SELECT DISTINCT a.CustomerID ,a.AddressID ,b.SalesOrderID ,b.SalesOrderDetailID FROM ( SELECT Sales.Customer.CustomerID ,Sales.CustomerAddress.AddressID FROM Sales.Customer INNER JOIN Sales.CustomerAddress ON Sal...more >>

Hi folks, I'm just looking for helpful general pointers, not the actual solution or any code I've got to import about 10 files or so into a staging post database and my aim is simple. If the file is one I haven't imported before (and is therefore a newer version) I wish to import it (i.e e...more >>

I'm trying to schedule an SSIS job that I deployed to SQL Server and NOT to the file system. 1) When creating the job step, after choosing step type SSIS Package, I get to choose the package source. Should I choose SQL Server, or SSIS Package Store? I see my package in both cases. What is ...more >>

Hi, I would like to know what people think about Biztalk and the new Integration Services. My requirement is to take different sources of data and integrate them into a database. It was also mentioned that Biztalk could be used for this task instead of SSIS, alas have no experience with Biz...more >>