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 >>

Hello, how can i send a file with the FTP Task direct from the SQLserver 2000 R Stefan ...more >>

I'm using sql server 2005. I'm trying to create a package that import data from Oracle 10g to SQL server 2005. in the Data Flow Designer the OLEDB Source is displaying a warining icon saying: The component reported the following warnings: Warning at {1C010C8E-2695-4214-BC94-067A57B1823E}...more >>

Hi there, I have a development server where I have tables that are bound to the dbo schema, I tried to use the "Transfer SQL Server Objects Task" to transfer these tables to my hosting providers SQL 2005 server. However for obvious reasons I'm not dbo over there. So when I select the tables h...more >>

I have windows2000 server running sql server2000 sp4 with sqlmail installed, configured, and working. Sql Server Agent is started using a dummy domain account with administrative rights for sql and the domain. I created a dts package that when manually run, works everytime. However when...more >>

Hi, I would like to create a dynamic package which exports results of different stored procedures with select statement and different number of columns to a .csv file. I've already got a script which changes SourceSQLStatement to 'exec ' + sp_name and and Connection DataSource property to the...more >>

We are having a website that generates postscript files when an order is placed on it. These files are placed in a folder on the network. I have been told to Load the postscript files into an existing sql database and then delete the file from the folder. If anyone has an idea on how to l...more >>

Is it possible to load a blank or empty file with a data pump task? We have a process that loads multiple files, and sometimes they contain data and sometimes they don't. We don't know which files will contain data and which ones wont. Instead of creating multiple packages to handle every p...more >>

Given: I'm using a DTS Package to import data into a table. Each row from a text file gets placed into a corresponding table. What I need to do: I'd like to modify the DTS Package to change the data saved to a table based on values in the records from the text file. In otherwords, if a ...more >>

Hi All, Firstly apologies for the obscure subject line. The task I am try to achieve is to copy information from Database A on Server 1 to Database B on Server 2. I would like this to be a DTS task (so that Many tables can be updated in the target database). However my knowledge of DTS is...more >>

I'm trying to implement an archive operation using DTS. In this case, data from certain tables I need to overwrite in the destination DB, so I'm using Copy SQL Server Object task, its fine. But for certain tables, I need to append the new rows. Here I'm using datapump task. In this scenario, w...more >>

We've been trying to convert an application from MSDE to SQLServer 2005 Express Edition. That application transfers some data form a SQLServer database to an Access database and the other way around. We have been using DTS, created/configured at run time by the application, to create the destin...more >>

Hi Using DTS Packages: I have to downlaod a file from ftp server which is not a problem, but this file is a zip file which consists of a mdb file. Now, is there a way to extract the mdb file from this zip file from the dts package. If there is, can you please give me some sample on how to do...more >>

Hi, All, I want to edit a package was created by sql server Import and Export Wizard. It did run great before. but I found there are some files or innerpackage.dtsx were missing which were located at temp folder later. this package just do copy data between two database. I want to add some...more >>

Hi I have DTS got 12 task, I am using on completion flow, even if task failed, i want to continue to run other task, My question is, is there any way to find out through workflow property, status of previous step, failed or success thanks kalyan...more >>

I need an activeX script that will: Query a table in my database: Select FailReason from ErrorLog where DateOfFileCopy = getDate() I want to store the result in a variable called flds. then: If Flds = 0 Then DTSGlobalVariables("ExecuteTruePath").Value = True Else DTSGlobalV...more >>

I have a DTS package that copies data from an Oracle db to a MSSQL db . When I schedule this package to run on the target server, it fails with the following error… Step Error Source: Microsoft OLE DB Provider for ODBC Drivers Step Error Description:[Microsoft][ODBC Driver Manager] Drive...more >>

I have a database that captures real time production data that I'm trying to keep lean 'n mean. We don't want our analysts querying this db all day. So, we've decided to have a second db that we will keep in sync with the lean 'n mean production db, and the analysts can query this until the c...more >>

I have the below table that I need to load about 1 billion records into. I was wondering if anyone could offer some tips on how to optimize the process. I load data_table via a staging table that could have 1000 records - 50 million records. I use a left outer join to ensure that no duplica...more >>

Hi, The fixed length column input file includes the data from next record if one or more of the previous record columns are missed. Tried all the row delimiter (CF,LF,CF&LF).Is there any solution to solve this issue? Thanks *** Sent via Developersdex http://www.developersdex.com *...more >>

Hi I am writing a package that i want to have email me on two possible success scenarios. essentially, this is the conditions: IF @result = 0 BEGIN EXEC master..xp_cmdshell @copyfile, NO_OUTPUT PRINT 'Operation Successful' END ELSE BEGIN PRINT 'This operation failed. Error Code:01....more >>

Hi I am writing a package that i want to have email me on two possible success scenarios. essentially, this is the conditions: IF @result = 0 BEGIN EXEC master..xp_cmdshell @copyfile, NO_OUTPUT PRINT 'Operation Successful' END ELSE BEGIN PRINT 'This operation failed. Error Code:01....more >>

I am using the import/export wizard to import all the objects from one database into another. My problem is that any views that use User Defined Functions are failing because the view is being created before the UDF. I have searched for this error, and found the following microsoft article:...more >>

Hi, I am using a cursor inside a stored procedure to do some complex work on each row in a table. Looking at the execution plan everything looks fine (Always worry about cursors!!) and the Stored Procedure runs fine if I call it via Query Analyser. When I go to run the stored procedure f...more >>

Hi, I have an SSIS project, has a connection to tempdb (local sql2k5 server), 3 tasks, creating a table, populating the table, then deleting the table. of course when I test the connection i GET TEST Succesfull (I am using sa ...) Whenever I run the package, all tasks become red colored, I ge...more >>

I built a dts package that executes fine when I manually start it but it fails immediately (event view says within 1 second) when scheduled. this package copies elements of a db on the production server to the backup server. Help. Andre ...more >>

I am writing a tool to convert DTS packages by using the scripting model. I have to change the connections in multiple ways. Some packages are behaving weirdly with their connections: in de original package there are only the connections visible that are used in that packages, but in my conver...more >>

Using SQL Server 2000, I have a DTS job that imports data from a text file that uses 2 connections and a transform data task. Obiviously the first connection is the text file and the other is the SQL Server database. The problem is that the text file will not always be in the same directory ...more >>

Hi All, I have a package that sends a mail using VB as opposed to sendmail (I'm no expert on VB so apologies in advance). Basically it will retrieve the users that match criteria, insert images and information and send the mail. This works fine from DTS designer, but when run as a scheduled...more >>