I've scoured the 'net and can't find a solution to my problem. Using SSIS, I am trying to load a fact table with surrogate key values. But the key is based on $ amounts, so my dimension table contains a "Floor" and "Ceiling" column for defined ranges. Example of dimension table (11 rows): ...more >>

I would like the client to control the dts import. Is it possible for the end user to run the dts job from a command button?...more >>

Hi all.... I created a package that has 5 steps. 1 Transform Data Task and the others Execute SQL Task. All of them inserts data in the data base. In package properties I checked "Use transactions" and "Commit on successful package completion" checkboxes. When I run the package, and if,...more >>

The idea is to have the first step to check a table for a value. If there is a value then it will proceed to the next step, if there is no value found the package will not continue. As I am not a programmer by nature, could someone assist with some ideas or sample. I would think it would sa...more >>

Hello, I need to be able to import an excel file that has a dynamic column set. I want to import it to a sql table that will be created new each time at the time of import with the name of the excel file as the table name. Since the excel file will always have a different number of column...more >>

Hi , I created a DTS package and it running fine when I run in design view. But when I scheduled it , it fail to run and I get this kind of error , "Step 'DTSStep_DTSExecuteSQLTask_1' succeeded Step Execution Started: 9/21/2005 10:45:53 AM Step Execution Completed: 9/21/2005 10:45:5...more >>

I am trying to change the SourceObjectName of a datapump which reads an Excel file. It poops on: tsk.SourceObjectName = "Sheet2$" saying this method is not supported. OK. I need to read an Excel file whose sheet name changes each time. DTS defaults to "Sheet1$" which will not work in thi...more >>

I have a data warehouse that imports all of the required profile, transactions, logs, etc. on a daily basis and has been running fine. The other night, I started to receive the following errors during the web log import. My package logging shows: Step 'DTSStep_CS_DTSLogImps.DTSLogImport...more >>

Pls explain the ad's and disadv's of sp_OACreate. ...more >>

Hi all, I have to run a DTS on a remote server, which copies data from one DB to another on same server. The problem is, the connection is poor and I've not been able to save the DTS on that server. There is no tech guy who can do the work of saving DTS , for me. I have created a script, wh...more >>

Hi all, DB: SQL Server 2000 Enterprise how can I schedule dts package through web browser? can I make it be possible by programming? thanks ...more >>

Does anyone know of a command or a way of extracting the User ID and/or Name during the ActiveX script to then use that value to load to the table being populated by the DTS package? i.e. we'd like to add the user id as a column on every row to track who loaded a particular row at any give...more >>

Hello, Is it possible to exlude some rows during insert in DTS? or is it possible to exlude last row from insert batch Thx ...more >>

I am having a problem with DTS packages not saving changes. For example, this morning, I spent fours hours changing VBScript code and other things in a DTS package. I saved it multiple times. At 10:40AM I saved the package to the server in DTS designer, closed enterprise manager and logged off...more >>

I have an Access table from which I have to get data periodically in 30 minutes everyday to an SQL server table. both have the same data structure. I want to get all the new records as insert, modified records as update and deleted records in source table that still exists in target table to b...more >>

Is it better to copy objects such as tables to a remote server or to us a datapump and push the data to another remote server? ...more >>

I am loading a text file and I want to know if there is system global variable into which stores the current record # from the file being processed. If so please let me know method of finding the record # Thanks Karen ...more >>

I have developed a SQL MSDE based application that uses quite a few DTS packages. Now we want to use SQL Express 2005 is it possible that the same DTS packages will run on SQL Express 2005 still Thanks Karen ...more >>

I am trying to schedule a DTS package but it is giving me a error when i tried using the execution steps..., the error message is " EXECUTION CANCELLED BY USER"...., can someone help? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200509/1...more >>

I have a DTS Package that runs remote queries across a WAN and seems to take FOREVER to save to the Database. Occasionally it will also report that there is not enough storage to store the package into the database. The package itself does not have too many steps in it. 1 connection object,...more >>

Hi everyone, I have what seems to be a common problem. I'm using SSIS to pull data from Oracle. I have an Execute SQL Task that sets a variable for the LastUpdateDate. I want to use this value in the Data Flow task that will pull the Oracle data. Everything I read points me towards using ...more >>

Hi guys, I am creating a DTS in SQL server by importing from a tab sep file, I realized that one field could contain multiple, comma separeted, values: eg. Field1 Field2 Field3 Date etc.. Normal: 160 2827863 15489229 2005-03-07 21:10 .... Exeption: 197 2827867 1520...more >>

What is the best way to set up a DTS routine to input the textfile with = over 200,000 records into a database table once every month. Currently = everything is in Access and the textfile is read sequentially and inserted = into Access using a webpage, but now I want to move it to SQL Server. =...more >>

I'm using a DTS package to import a text file. Everything works properly locally during the testing using a text file on my desktop. But now I need to be able to import the text file from a web address. The user will FTP the text file to the web site and I need to then import that file. The S...more >>

I have a data pump task in which I am pulling data from Oracle to SQL Server, so hopefully somebody in here can help me out. The data pump task is running a query against an Oracle table and then copying the data straight into a SQL Server table. If I run in on our development server eve...more >>

I have DTS packages that import data from SQL Anywhere and MS Access. The ones that import from SQL Anywhere run fine (that was last month's battle). Only the jobs importing from MS Access are failing with the following message: Executed as user: FED\service. ...n OnStart: DTSStep_DTSExecu...more >>

I am launching DTSrun using global variables with /A. I have to pass the parameter "col1=col2" I have a problem: it only passes col1. Everything that comes after the sign = is not taken. I lauch dtsrun /Sbase /E /Ndtsname /Avarfilter:8=col1=col2 What can it come from ? I tried replacing the ...more >>

Ok, crazy error here. Happening on ~1/5 rows. first 10 rows date values are 12/09/02 - Works 12/04/02 - Fails 12/03/02 - Fails Empty - Fails Empty - Fails 11/19/02 - Works 11/19/02 - Works Empty - Fails 11/25/02 - Works 11/13/02 - Fails If I switch the destination column to a v...more >>

Hi, I have a dynamic proprerties task wich have a .ini source type. I would like to modify dynamically the section of the .ini. I get the value of the section from a global variable. How I can do it, for example with an Active X Thanks a lot-- mehdi...more >>

I'm having a problem with a couple of Execute SQL Tasks in my packages, with multiple DELETE statements. If I put a GO statement anywhere, between any of the statements, I get a syntax error. "Deferred prepare could not be completed. Statement(s) could not be prepared. Incorrect syntax near GO...more >>

I am looking for a query I can run that will tell me which DTS packages have sa and password hardcoded into them. I'm not sure what systems tables to look at. Does anybody know? All ideas are appreciated! Thanks, Mitch...more >>