Hi all, I am designing a DTS package instead of SSIS. I have a text file and already uploaded to tableA, there is a field named NameID in tableA. The field NameID should match the NameID in tableB and update other fields of tableA, the non-match records will generate another exception text file...more >>

I have a DTS package that extracts some data to Excel worksheets Total_Data and Total_Count then runs ActiveX script to open the Excel workbook and run a macro to complete formatting the data. I receive intermittent errors with the package: Step 'DTSStep_DTSActiveScriptTask_2' failed Step...more >>

Morning! I have a little Problem with the import Wizard. The situation is a Access DB with a memo field in wich are very long text. And i migrate this DB into a SQL Database wich has a field for this memo filed. I hae declared this field with a ntext type. And now when i import the db, the...more >>

Hello all, Will DTS Packages *NOT* import from UNION queries in MS Access? I have my Access & SQL Server (OLE DB Provider for SQL Server) connections set up. I have my Transform Data Task going from Access to SQL Server. But in the Source tab of the Transform Data Task Properties, my uni...more >>

Hi I have a DTS package that populates an Access Database, for offline reporting etc.. I was wondering if there is a way I can clear down the MS Access tables from the DTS package. I have a macro in the Access that performs this function, but I thought it would be smarter if this was adm...more >>

Is it possible that multiple persons can work on the same package at the same time and merge there changes? I find this will result in huge amounts of conflict while merging these changes. I also tried another way which is different developer working with different package. But the Execute Pac...more >>

Is there backwards compatability from DTS packages that are created in SQL Server 2000 in SQL Server 2005? Also, is there DTS support in the EXPRESS Edition of SQL Server 2005? Thank you....more >>

I would like to have a SSIS package which loops through each xml file (.xml files) in a folder on the network. And then for each file pull out the data and insert into a sql server table. Please kindly guide me through this i.e. What task(s) are required, etc. Thanks...more >>

Hi, i would like to encrypt password in my configuration file as well as i would like to decrypt my password before executiong SSIS Package. i am unable to do the same. if anyone can help me. please reply *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hello, The problem I am facing is quite weird. When I execute the SSIS package sometimes it rejects the correct data as well. And when the package is executed again, the data which it rejected last time is not rejected this time. Also sometimes the package is executed and no data is rejected f...more >>

I'm working with the XML Source in data flow and find that when I'm updating the schema, it won't be aware of the change. I have to re-select the xsd file which will result to a status that all its sub nodes become invalid. I need to opend and close all those sub nodes to bring it back working...more >>

Hi, I'd like to do automated unit tests for my SSIS package. Has anyone has recommendation on this issue? How can I execute a package from the C# unit test project(including defining the db and file connection)? Or there is better approach to achieve this? Thanks a lot!...more >>

Since updating to SQL Server 2005 sp2, I get an error when I drag & drop a Data Flow task into the control flow designer. The error reads: Failed to create the task. Additional Information: The designer could not be initialized. (Microsoft.DataTransformationServices.Design) Additional...more >>

I'm trying to execute the following script from Query Analyzer. The objective is to update the Global Variable in the DTS package. I'm not getting any errors (@hr <> 0) yet the GV is not updating. I am a sysadmin on the database. DECLARE @hr int, @oPKG int, @name varchar(100) SET @name = 'AL'...more >>

Good evening, I have a Lookup Query in a Data Transformation Task, searching a value in a table. The transformation script is as following: DTSDestination("incrementvenda") = DTSLookups("incvenda").Execute(DTSSource("numero")) Main = DTSTransformStat_OK Parse is okay, but when testing...more >>

Hello All, I have a DTS job which transfers the data i get to excel. However, it always appends to first worksheet of the file. I want the data to be transferred to the Active worksheek which i have created using VBscript. Thanks in advance Regards ...more >>

Hi! We have a server with Windows 2003 Standard 64-bit & SQL Server 2005 Enterprise 64-bit and want to fetch data from Oracle 8. Oracle Client 10 is installed with the 64-bit driver 'Oracle.OLEDB'. In our previous server (which was 32-bit) we use Microsoft OLE DB for Oracle driver. Que...more >>

Hi Guys, I have a question regarding SSIS and Oracle Our company has two major versions of products, and currently, I am working on this project to migrate data from version A of the product to version B of the product. The database schemas for two versions have huge differences, therefore ...more >>

I want to use DTS to update a table from a view of another database. I have 3 databases in total, 3 are subs and 1 is a parent. The parent will have a table that is to be updated by the 3 subs. I have created a view in each of the 3 subs that are identical, but have a unique key. The parent...more >>

This is checking against a string value where the source system used "00/00/00" as a lack of date. There were also columns that were out of the normal range for date values (AD 1, 0600, etc). This NULLs those values out. Figured that someone may have been struggling with this and the lack of ...more >>

Is there a way to create an XML destination in a data flow task? I am trying to create an XML string to pass as a parameter in a web service....more >>

I have a package that uses a single global variable for several data pump tasks. I set the global variable and fire the DTS package. It works fine for the first data pump but not the second - i get an error message saying no given value for the global variable. Why does the second data pump...more >>

Hi Friends, Cud anybody suggest me how to get Schema information using DTS? Thanks, Dutt ...more >>

Hi everyone! I have the following problem. One of the progrmmers has design an SSIS Package in VS2005. This person put the package in the server and can run it, but if any other user try to execute the package, he cannot. The problem is in the SQL connection. It seems that lose the password ...more >>

Where are located all existing connections that appears into Existing connection combobox (execute sql task)? I said because on DTS design I see just 2 connection icons but into existing connection combobox are more than 2. I'm using SQL 2K. THKS! ...more >>

Hi, I got new server to support. This server is sql server 2000. It has lot of DTS packages defined there, but only couple of jobs which run these DTS packages. How can I find out which exactly package is run from some DTS job. All I can see in job definition is encrypted value: i.e.DTSRun ...more >>

Hi; Could anyone tell me how to get this code to compile in Visual Studio 2005 code behind ASP.net 2.0 Web Page ? It compiles fine as a windows module in vs 2005. Here is the code: Dim oPackage As New DTS.Package2Class Dim oStep As DTS.Step I tried including the following : ...more >>

I have create a oledb connection(drag drop style from GUI named ABCD01 which connects to a SQL Server ABCD01) in DTS Package. I have a ActiveX Script task which checks if this connection is open or close or inuse. Can anyone tell me how do i refer this in my activex script. Pl provide me detail...more >>

Hi What is the easiest way of stopping a DTS package within an AcitiveX Task? I have an ActiveX task (VBS) which does some checks before it continues with the package.. I don't want to 'Fail' the package, I just want it bail out reporting 'Success' without running any of the following ...more >>

Hi, I wonder if anybody has any way of doing this. I have quite a complicated package and I need to add a run process step to it that I only want to run on a Monday. Is there any way of doing this? I was thinking down the lines of using workflow on a step that always fails every other day of ...more >>

I have a DTS package that exports requisitions to an Excel spreadsheet. I have a global variable that holds that last requisition number. When I execute the DTS package it does not save the last requisition number to the global variable. How can I persist the changed requisition number to the ...more >>

Hi; Have the DTS objects that work with SQL Server 2000 changed that drastically in VS 2005 ? Here is the code I am trying to compile: Dim conn As New SqlConnection("initial catalog=My_Data;server= XYZ081552X7X441\TRSQL;integrated security=SSPI") Dim hold1 As Integer ...more >>

Hi, I'm trying to write a script that'll parse a database and print a graphic header then text from the database to a printer also selected from the database. I'm not sure if I can do this through DTS or VBS or what, but I was wondering if anyone had a suggestion... Thanks -- Alex ...more >>

hi ! how is do for when finished dts ,sending mail by sql server..also i am using sql server 2000... can i do ? thx... ...more >>

Can someone tell me if this is possible? Create an SSIS package with a single ftp task. Create a job in the agent that runs that SSIS package on request. Somehow we pass that job all the ftp parameters at run time? At a high level, how do we do this? In particular the who parm passing bit....more >>

I have a series of 30 stored procedures which extract data from a SQL Server warehouse. The procedures extract the data and I can individually create a DTS package which writes the result set to a .csv text file. (These files will be imported into a 3rd party package.) What I'm trying to d...more >>

Hi Can someone explain/help how can I create a schedule at SQL Server 2000 that exports at X time of the day a SQL database into a access database without exporting the views that the SQL database has. Thanks [] Ricky ...more >>

Hi, As I know, although DTS gives graphical view of the data transformation/conversion work flow, it tend to be slower than BCP and TSQL scripts. So, keeping all that in mind, can I still use DTS (b'cos its a good tool to illustrate what's happening inside, easy to understand and maintain) bu...more >>

I'm new to SSIS in SQL 2005 but i have done good work in DTS before. I'm working on a simple data load process between 2 different SQL srv 2005 databases. the problem is that i need to transfer around 50K records at a time. When i run my package from Visual Studio 2005 it takes ages and even ...more >>

I want to rename the db for the test db to the production db. Russel Loski gave me this code: Sub loadPackages() Dim rs As Recordset Dim DTS As DTS.Package2 Dim i As Integer Set rs = DBEngine(0)(0).OpenRecordset("Select distinct Name from dbo_sysdtspackages ", dbOpenSnapshot) Do Unt...more >>

I'm perplexed and in need of a sanity check ... Instance of SQL2K5-SP1 on Server2003R2. Created two databases Test1 and Test2, create single 2-column table (tblTest)in Test1 with one row of data. Create SSIS package to transfer the table and its data to database Test2 using "Transfer Obje...more >>

Question: When I run a certain SSIS package that is configured to execute 2 Containers, I get the following error. Code: 0x40016042 Source: extract_SVC00901V Description: The package is attempting to configure from the parent variable "ConnSource". I get this error a number of t...more >>

Hi! I have a dts package that performs a number of activex and at the end of the package I need to save a summary file of the files that ran though it. I need therefore to keep the carrier and post date in order to grab the correct records from a summary table. At the beginning of the dts I...more >>

For some reason, when i run a package that has an Oracle connection with Oracle'd OLEDB Provider, the package executes (i.e I run it on the SQL Server 2005 as I am logged on). If I schedule the package, the connection does not work. So the Oracle client software is installed correct but won...more >>

Just upgraded to SQL 2005 and developers have lost their ability to open existing DTS packages. We will eventually migrate them to SSIS, but aren't ready yet. The developers see the "Data Transformation Services" tab under "Legacy" in SSMS, but can't see the package names. I have added the ...more >>

I am working on sql server 2005 and was exporting data from a table using the Import and Export Wizard. when I tried to open the package with the .dtsx extension, from visual studio, I got the following error message. TITLE: Microsoft Visual Studio ------------------------------ There wer...more >>

Hi, I have a DTS Job (SQL 2000) which: Opens an Excel file on C:\ Runs a Macro to populate the spreadsheet through ADO Saves the file with a new name Winzips the file EMails the zip file It works fine when I run the DTS job on the server, but fails saying the following. It seems to be...more >>

Hi, I've got a data pump from an Oracle database into a SQL 2000 Database and am getting a General Conversion Failure. The Source datatype is DBTYPE_VARNUMERIC and the destination is DBTYPE_NUMERIC... Is there a better destination data type for this? Thanks Matt...more >>

Hi folks, I have two tables CurrentNews and HistoricNews when a news item is created it is inserted into CurrentNews it is assigned a storyID (ST071) which it maintains through its life cycle. The story then gets reviewed and the reviewed column is set to true it is also given a version number...more >>

I have several DTS packages whose connection database is the test database. Is there some code I could write to go through all of them and change the database to the production db? If so, could you give me an idea of how to do it? Thanks. ...more >>