hi all, when try to run this Analysis Procssing task on the web server, it failed with this message: "The task "Process cube task" cannot run on this edition of Integration Services. It requires a higher level edition." I found on out that other people are having the same problem, but...more >>

Hi there, I have seen articles that import mulitple files into SQL Server but they all create a table first to do the import. the table definition would kinda be complex coz the number of columns varies from 4 -80 for about 50 files. I can import them individually without having to defin...more >>

Hi, I am trying to copy a database using the Database Transfer Task in SSIS. My package always fails with the following error 0x80131500 ( -1073548784 ) saying that the login XXX already exists in the database. When I change my package to run between two SQL 2000 instances, everything w...more >>

Hi, I created a blank databse andctarted copying over tables from an existing database. I forgot to limit the transaction log file so it grew so big (10 GB). when I realized it, i turned on the autoshrink. after that, i cannot even see the databases in the enterprises manager anymore. it free...more >>

We have a new machine with a fresh install of SQL2005. We have restored some of the DB's from the SS2K box, now I need to move some of the DTS to SS2005. We really are not ready to change our DTS to the new SSIS so we would like to continue using DTS on 2005 for a little while until we are read...more >>

(Package A > Package B) Intended to pass global variable by using "Execute Process Task" to other package I have declared variable "AA" in the package A and intend to pass the variable's value to other package ".Package B". However it failed to received the variable's value. is my comman...more >>

I have a ForEach Loop. In the ForEach Loop there is a Sequence Container that has a couple of ExecuteSQL tasks. If those tasks fail I want to do some additional logic and in either case loop again. Everything works fine as long as nothing in the SequenceContainer fails. If it fails, it w...more >>

Bonjour, SQL SERVER 2005 - Package - Job KO. J'ai un petit probl=E8me avec un package que j'ai cr=E9=E9 sur Visula Studio: celui contient une connexion Oracle. Ce package fonctionne tres bien lorsque je l'=E9x=E9cute depuis Visual. J'importe mon package dans SQL Serveur 2005, si je fais "ex...more >>

Hi all, I would like to catch progresscount from DTS package at the time of execution. Once we enabled DTS package log, all package execution details are inserted in to respective tables in MSDB data base. Before inserting Progresscount in to respective table I would like to catch progres...more >>

I set up the following items listed below. I am trying to pass CurBranch from the outer to the inner package but cannot seem to make the connection. How can CurBranch be connected to vartest ? The Outer Package package contains two tasks: SQL Task: Select CurBranch As CurBranch From ...more >>

Okay, so here's my issue. I have an execute SQL task which queries a DB for the # of orders to be processed (select count(*) as nOrders from ORDERS) for any given day. Then, I have a script task, that takes this # and (if > 0) does everything else (process the orders, creates xml file, pgp encry...more >>

have execute sqltask that quieres table and gets name of DTS, outputs to parameter as rowset, then in activex script i go thru it to process. sql task has output pararmeter rowset of gvDTSPackagesToRun query: select dts_package_name from Rerun_DTS_Package result ---- XXX get a r...more >>

When my DTS package ran I got the following information: SQL Log error: Executed as user: cwopa\pwsrvsql001. ...ting... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSE...more >>

One of our SQL Servers just died and the network team was doing backups of all databases but no other types of backups. Is it possible to get back DTS packages? Same question for SQL Jobs? Thanks in advance, Mark ...more >>

I set up an activex script to bypass a step under a specific condition: oPKG.Steps("DTSStep_DTSExecutePackageTask_15").DisableStep = True Assuming the senario listed below, how can Step 3 run if it depends on Step 2 ONLY when Step 2 is run ? First Step Step 1 Always runs On Success...more >>

Is there a way to grab all the file names in a directory and populating a SQL table with them? I am trying to create 2 different jobs: 1) I want to get a list of all my backup files in my directory and move all files over one week old to an archive folder. 2) I want to grab zip files that...more >>

I have a text file I would like to import into SQL Tables. The text files has a variable amount of rows and each row starts with a character that identifies which table it should go into. A typical text file might look like this: "h","3","5","44" "h","5","4","777" "s","3","4" "s","1","0" "...more >>

Hi, I have the following statement in execute SQL Task.... DECLARE @DATE VARCHAR(30) SELECT @DATE=VALUE FROM _PARAMETERS WHERE NAME='RTB_DATA_DATE' SELECT 'SELECT ..... from table_Name' <very long statement to be executed on oracle DB> I assign this to a user defined variable and then ...more >>

I'm importing data from VFP via OLEDB Provider. However, the source is not reading the correct length from the source and subsquently the task fails due to truncation. For example the source datatype of NUMERIC(7,3) is picked up as NUMERIC(6,3) by the OLE DB Source task. In addition, It only ...more >>

How do I use multiple destinations for the same downstream data? Want to add transformed data to 2 (or more) destination staging servers in 1 pass. Using ole/db table destinations. tia, chris...more >>

I am trying to import data from Informix in SS2K5 but am having trouble setting up a connection. I am using the OLE DB connection object but when I try to use the connection manager to connect to Informix I get a 'ClassFactory cannot supply requested class' error. I assume that the Informix...more >>

I'm trying to use the Bulk Insert Task in DTS and the max errors setting appears to default to 10. I need it set to 0. There doesn't appear to be a way to change that in the Bulk Insert Task window in DTS Designer. Does anyone know how to change the default for max errors? If not, would th...more >>

For my conditional split, I want to evaluate 2 input columns coming in as follows: ISNULL(column1) AND ISNULL(column2) -- this does not work ISNULL(column1) + ISNULL(column2) -- this does not work ISNULL(column1) & ISNULL(column2) -- this does not work How do I do this? tia chris...more >>

I am using example from sqldts.com on calling a dts from a dts. i can trap errors from steps, but how do i get error results from the oPkg.Execute statement? Basically, we have a job that runs DTS packages on demand. users put the name of a DTS package in a table and we ...more >>

Hi. I have a DTS package that calls a Execute Package task. If I set the "Inner Global Variables" of the Execute Package task, I can do the following inside the Execute Package Task: DTSGlobalVariables("IsSuccess").value = 0 After the Execute Package task, in an ActiveX Script task in ...more >>

I tried to execute a SSIS package with dtexec with the following from my SQL Server box, the package execution is successful. dtexec /FILE "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MapssIntegrationServices\MapssMartPackage.dtsx" /Conf "C:\Program Files\Microsoft SQL Ser...more >>

In general (without specific details as to what SQL is being run), if I have a DTSExecuteSQLTask that is executing SQL on another server on my LAN network, is there a big performance gain if I put the SQL into a stored procedure and call the stored procedure from the DTS step, instead of putting...more >>

Hi! I need a "howto" article describing how to create an oracle connection from a SSIS (dtsx) package. I have to use (oracle bakwards comp.) the oracle 8.1.7 client. I've tried using an oledb connection, but always end up with an ORA-06413 error. Any clues?...more >>

Hello, In DTS, if you right-click a step, there is a command called "Execute Step". How do you do the same thing from Active X scripting? Regards, Elias ...more >>

All, I am trying to load a .sql file dynamically in an SSIS Execute SQL Task. There doesn't seem to be a way to set the FileConnection property when you select "File Connection" as your "SQLSourceType". Does anyone know how to set this property dynamically through an expression or otherwise?...more >>

Dear all I have an .net 2.0 windows application that runs ssis packages. On of the packages uses an excel source as data flow source. This works fine as long the executing machine is a 32-bit box. As you know - Microsoft OLE DB Provider for Jet, used for Access and Excel databases, is not a...more >>