Hi! I´ve got a very strange trouble. I´m working with some DTS that have transformations data tasks. The problem is that when I execute the package, it throws me the following error: "DTSTask_DTSDataPumpTaks_1 was not found" I did not use Disconnected Edit for renaming tasks, but I go...more >>

Ok, so I'm working on getting a bunch of dts scripts that were set up under an individual's login set up to work under a generic group login. None of these logins can get access beyond dbo on a particular database. I did a save as on the scripts and saved them to .dts files. If I load the...more >>

I am trying to build a generic ssis package that can process xml files in a directory. Each xml file has a different schema, which is part of the xml file. I am using the access mode: XML file from variable and using inline schema. In design mode I have to actually point the variable to a valid ...more >>

Hallo Everyone, I have an excel datasource that contains 5 mandatory columns and 20 optional columns. I would like to insert all the data a recieve into a table in an SQL2005 database. What is the best way to do this? Thanks... Nigel......more >>

Hi, Can anyone help me? I have a DTS package, which basically consists of a data pump task. The source for this is a CSV file with various fields, and the destination is a table in a database (let's call it "Database A") Now, I've designed this sort of package before and have no problem w...more >>

I am trying to copy a database from a remote server to a local server using the copy wizard (DTS). Everything seems to go OK until the last step at which time I get the below error. I have not had a lot of success in my searches. The log detail says Failed to create the share OMWWIZC as part ...more >>

Hello all, I have 60 text files that I need to import into a DB. I want to figure out a way to loop through the files automatically. Can this be done in the DTS Package? I understand how to loop through all files in a folder using VB/VBA, so I can manage that if I save the package as a VB ...more >>

Is it possible for SSIS to take data from a SQL Server database and export it to an XML file? If so, how does it do it? ...more >>

Here's my objective in pseudo-code: if table.comment2 LIKE '@' and table.email ( IS NULL OR ='' ) then copy comment2 to email If I did this in VB script, I would invoke a recordset object and step through each row, comparing the two columns. I was hoping that DTS transforms would ass...more >>

Hi, I have created a DTS package to load the data from the one server to another server. To load this data i have one Flag which is defined in the desitination server table. If this flag is 1 then i have to load the data, other wise i have to exit the dts package sucessfully. to do this i ha...more >>

Does anyone know if there is a way to use a variable to refer to a column name in a script component tranformation? For example: Row.Column1 = "Test" What I'd like to do (pseudo code): strColumn = "Column1" Row(strColumn) = "Test" I'd even be ok if I could use ordinal position. Any id...more >>

Ok, So I've successfully exported our DTS packages into vb files and corrected all the login info and creator info for installing them onto our production server. So... how do I go about getting those packages onto the new server? All I have access to is Visual Studio .NET is there some way ...more >>

I've got 30 minutes to transfer a database from local testing server to live ..... I'm using the DTS wizard, and unlike the 2000 version, it seems I'm unable to specify that I'd like to drop destination objects and recreate them on live server, but this option is unavailable. Also, why can ...more >>

I am creating an excel report from within a DTS package using the ActiveX script. I have an excel file that contains column names across the top (A1:AB1). -- I would like these to be bold. Then from A2:wherever the data ends I would like to have different color background on the alternating...more >>

I have a table with the following structure: [code] CREATE TABLE [#TEST] ( [sCalldate] [varchar]((20) NULL , [sProject] [varchar] (20) NULL , [dHours] numeric (10,4) NULL) INSERT [#TEST] (sCalldate,sProject, dHours) VALUES ('20060401', 'A', 12) INSERT [#TEST] (sCalldate,sPro...more >>

SSIS newbie here... I have developed a package for importing data from text files into a SQL server database. In this package I'm using an OLEDB Connection Manager. I would like to be able to specify the connection string for this connection manager when I deploy the package. My question ...more >>

Hi I was trying to load a few excel files into the database. I was using the ForEach Loop functionality using the SQLIS 2005. I followed this article that explains the load of text files http://www.sqlis.com/default.aspx?55 I made the transformations by using a static Excel file. Then w...more >>

Hello again, everyone! I'm attempting to create a DTS package to migrate data from our old Oracle 8 system to SQL Server 2000. I decided to use the Oracle ODBC provided in their client install. The Microsoft ODBC Driver for Oracle, for some reason, doesn't see all the tables when you att...more >>

Hi There, I am a newbie to the world of SQL Server. We have a DTS package which has been running fine for almost 3 years. Now its failing with the following error. Violation of PRIMARY KEY constraint 'PK_client'. Cannot insert duplicate key in object 'client'. All the duplicate records fro...more >>

Hello, I am getting general errors in my log file (intermittently) of 80074005 and 80004005 "Unspcecified Error" when I run nightly DTS packages. The error, as I mentioned does not happen all of the time and if I execute the package manually, it runs fine. I am connecting to a couple of ...more >>

There is a DTS package that I am having a problem with. I can run it manually on the server as administor, successfully. However, when I create an sql job with the SQLSERVER and SQLAGENT using the same user account (smssql) being a member of the Domain Admin group it aborts. I'm pretty frus...more >>

Hello, This is a long post, but figured I'd supply as much info as possible up front.... I'm in the process of building a Proof of concept integration between Legacy RDB databases and Sql Server. I'm reading data from a simple table on the RDB but am having issues with a Char(1) field....more >>

Problem: Created a DTS package to get information from a MSAccess Database. We used an ODBC to get access, and configured it to use the sysem.mdw (Security file). When we run the DTS package manual (meaning by right click/execute) the package runs and gets the data. We then scheduled the the...more >>

There are many Local Packages in the Data Transformation Services, in the SQL Server 2000. How can I transform them and use in another SQL Server like the other objects (tables, views, stored procedures etc.) ? I want to export them in step like copying objects and data between SQL Server d...more >>

Greetings experienced DTS people.. I was just wondering, is there a best practice to how many "Transform Data Tasks" lines you should have between two connections? In your experience, what is the upper limit before the system performance starts to suffer? 5, 50, 500, 5000? I'm trying to ...more >>

Greetings, Sorry for a somewhat long post, but it ends with the specific question about how to exec a DTS package with an Oracle driver. We have several DTS packages that connect to Oracle by ODBC and/or OLEDB (microsoft drivers). In moving them to SQL 2005 ( using 64-bit o/s (AMD x64) ...more >>

I would like to setup all the DTS packages from a production server to my workstation for testing and development. My workstation recently became a client of a Small Business Server 2003 Domain. Prior to this change, I was able to force a database restore of the MSDB database onto the Workst...more >>

We are migrating to Active Directory from Novell. When my ID was added to AD my full ID went from machineName/ID to loc/ID. Ever since, when I try to save changes to a DTS package I receive the error 'DTS Package ID 'XXX-XXXX-etc' already exists with a different name'. The only way I can mak...more >>

Hi, I have a fundamental question to ask. I have to populate 7 new data marts (Fact tables and non-shared dimensions) from our enterprise datawarehouse (EDW). So I have to import data from EDW, calculate measures and retreive dimension ids. The fact tables will have many rows and will be ...more >>

I have a step in a DTS package that needs to run for ~5 mins before going on to the next step. What task can be inserted between step1 and step2 to accomplish this?...more >>

I am trying to tranfer a table from a SQLServer2K DB to a SQLServer2005 DB in another domain. When using the DTS import/export wizard, servers outside the local domain aren't recognized. Both domains have trust relationships setup. If I manually enter the server name the following error is rep...more >>

I use ISQLW in batch mode to load data from a SQL script. In this step, a GV is assigned to isqlw. Problem is, I can only run this by manually pasting isqlw -S phlprdsql01 -d Triactive -E -i c:\temp\triactive\test.sql -o c:\temp\triactive\test.txt into a cmd prompt. How can I ensure the a...more >>

I have implemented several DTS packages on the server where they are running successfully. But, if a user wants to run the DTS from her/his workstation, Enterprise Manager needs to be installed on that workstation. Instead, would it be possible to install the relevant DLL only. If yes what are t...more >>

When we run wizard of transfer data(Import/Export) SQL Server Generate Error Could Not Create Instance of the DTS Package -- WaseemAli...more >>

Hello, I've an issue with a DTS. Here is the scenario: Server side: the DTS has two step: 1) Delete some row from some tables. 2) Imports data from Access DB into SQL-Server, using a ODBC entry (from a file) Client side : an winforms application has two step: 1) Copy local Access DB on...more >>

Ladies and gentlemen, I have a question for you. I want to export data from an SQL db into Excel. I want to execute multiple sql statements in the same dts package. (By now your thinking: "That's easy...") But I want the results to be in different tabs (sheets) in the same excel workbook.. ...more >>

Dear all, How organizated the SSIS information in Sql25k is? We've got all the information regarding dts relationally. Tasks, steps, connections and even global variables are perfectly stored inside tables (using IDENTITY field we can to identify any DTS and its features, searchinb by name, d...more >>

Hi,, I am using activex task in my dts, creating excel file with multiple woksheets. I want to create more than 3 worksheets in a workbook. it is limiting to 3 worksheets. here is my code Dim oExcel Dim oBook Dim oSheet Set oExcel = CreateObject("Excel.Applicat...more >>

Hi I had my DBA to create a DTS Package in a SqlServer and I am trying to run it using LoadFromSQLServer from C#. Its giving exception that the user is "not a valid user in database 'msdb'". "Public" group has been given rights to sp_get_dtspackage, so I am not able to see any reason why this...more >>

hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other computers(client computers) must connect database on main computer. i m preparing my proje...more >>

Hi, SQL Server Books Online shows I can schedule a DTS package on last day of the month, but there is not sample available. Does anyone know how to do it? Thanks....more >>

Hi folks, Can someone suggest a top notch boook to learn & master the SQL - 2000 DTS ?? I understand there is other alternative in SQL'2005. But I'm more interested on SQL-2000 DTS books... Kindly suggest ur experience... Thanks a ton :-) ...more >>

I've used sql 2000 DTS to copy objects (tables, views, stored procedures) from one database to another without problem. In sql 2005, I can copy tables and views without problems via the available wizard. I've been trying to find the sql 2005 wizard that can copy objects other than tables and ...more >>

Hi, I'm playing with the XML import capabilities of SSIS, but I can't get it to work at all. I'm trying a very simple XML file, and in the DataFlow, I only have the XML Connector object and the database connection object. I'm importing directly from an output stream of the XML object into...more >>

Hello! How do you dynmaically change sql server connections (data source) through ActiveX script? This code is not working for me: DTSGlobalVariables("gv1").Value = server1 DTSGlobalVariables("gv2").Value = server2 //I am trying to pass server name.. 'gv1' and 'gv2' are globa...more >>