I have an execute package task that calls another package containing a disabled task which is a precedent for a analysis services processing task. The processing task goes green with no discernible errors in the execution results, but the execute package task fails with the following results:...more >>

I am trying to setup a DTS job that must run every 30 minutes and pull 3.5 million rows from an Oracle database into our SQL2k database. The job runs fine (2 minutes), but consumes a TON of network bandwidth on the network card and we have a VERY bandwidth sensitive application that connects t...more >>

Hi all, I need to run a job on the 1st day of every quarter. the only option is to run it every three months. The issue is if I need to manually run this job in the 2nd month of a quarter, will the schedule change to be the 1st day of the 2nd month instead of the original 1st day of the 1st...more >>

We have jobs that have steps that run DTSs. Unfortunately, the setup of the jobs were not documented very well. The DTS run command has an encrypted value and the Step Name was not set to the actual name of the DTS. Is there anyway to determine the english name of the DTS from the encrypted...more >>

I am developing a custom source component, which will have a custom GUI as well. Users will be providing connection information via a GUI interface which in turn will save the data into Custom Properties of the component. What I would like to do and was not able to figure out a way how, is to ...more >>

ENVIRONMENT: RAID 10 CLUSTERs with upto 8 processors. SQL server 2000 SP4 WINDOWS 2003 with latest SPs INTRO: I have a DTS which has Database context that is set thro' Dynamic Properties Task. This DTS has a bunch of transform data task to copy data from a SQL server DB to an ...more >>

I am attemping to update a MS Access table from a SLQ Table using DTS. I have created a connection for both the Access db and the Server db. Both contain the table costcenters with these fields costcenternumber and costcentername. The table in Access is a subset of the table on the Server....more >>

Hello everyone. I want to provide the db_reader database role to some users. The problem is that, on the same time, I don't want them to be able to export data (e.g. not able to create and execute DTS Packages or run the DTS Wizard). Is that possible? Thank you all....more >>

Hi , my DTS package has two tasks: DTSTask_DTSActiveScriptTask_1 DTSTask_DTSSendMailTask_1 I add the following code to the Active X Task: Function Main() Dim accAppImport Dim appPath, appDB , frmStart appPath = DTSGlobalVariables("AppPath").Value appDB = DTSGlobalVariables("AppDB")...more >>

hi everyone, does any of you know which assembly do I have do add to my project in order to have dataflow task components in my c# toolbox, so that I can edit them in a new package? Thanks, Paganelli Francesco...more >>

Hi All, I would like to know whether whether the SQL Server 2000 DTS Packages will run in SQL Server 2005 without any modification. Also if necessary what are the modifications required. Thanks, Rajesh Shukla ...more >>

My DTS package has, in order: 1. a Dynamic Properties task 2. an Execute SQL task 3. a Transform Data task (aka Data Pump task) When running this DTS package through DTS Designer, it's successful. When running this DTS package by calling "dtsrun" from the command line, we sometimes see...more >>

We are running SQL 2000 Enterprise Server Edition under Windows 2003 Server Standard Edition. How do you schedule a batch file to run daily to export selected records? Thanks. ...more >>

Arghhh......the inconsistencies of Microsoft. We have to live with them don't we? I have an Excel file. I created a package to import it into a SQL server database table. I run it from my machine's SQL Enterprise manager...it runs great I log into the server Run it from Enterprise mana...more >>

We have a huge database on SQL 2005 and there are hundreds of users having the copy of this datbase on SQL 2000 We used to provide backup dump file for them to restore Now with SQL 2005, I have read that we can not restore a dump from 2005 on to 2000 Is there any alternate method or third...more >>

I am not sure if this is the right group for this post, but I did find some other SSIS topics. I opened up the "New Project" screen, and Data Transformation Project is not available as an option. The only new project options I have are SQL Server Scripts, Analsys Services Scripts, and SQL Mob...more >>

When I create a new DTS Package I get a DTS Designer Error that states “There was a problem retrieving the list of OLE DB providers.” When I click ok the design window opens and I only have 2 connection icons where there should be many more. I have the same issue when opening already exi...more >>

Hi, I need to import data from an XML file to SQL server 2000. Is there any way of doing this through DTS without having to write code? Thanks -- pmud...more >>

Hi, I used to redistribute SQL 2000 DTS package on servers who do not have SQL SERVER installed as described in the following article: http://www.sqldts.com/default.aspx?225 I need to run an SSIS package from a webserver and my question is what dlls do I need to register on a Server on wh...more >>

I was very fond of using the sql 2000 DTS wizard to move stored procedures from one db to another. It was dirt easy using the wizard. I opened up sql 20005 management studio, right clicked on the db > Import Data> and there is no longer the option "move objects between db" anymore! Where di...more >>

Hi all, I have 2 SSIS packages. The first package calls the second one in a for loop. The inner package contains several tasks (execute SQL task which runs stored procedures, and data flow tasks which transfer data from one SQL server 2000 database to another SQL server 2000 database). The...more >>

Hi, I'm using ssis 2005 - I'm trying to create an ole db coomand which uses parameters in sub-qyery: SELECT vwContactInteraction.iContactID, vwContactInteraction.iInteractionID, 1 AS iSiteID FROM nice_interactions.dbo.vwContactInteraction AS vwContactInteraction WHERE (...more >>