Hi All, I want to know a way how to move databases which are currently in SQL server 2005 CTP into SQL server 2005 enterprise version. This is urgent for me and I would like to know the most easiest way. Best Regards, Roshan ...more >>

I created 2 DTS packages on SQL Server 2000 that I need to either edit or just delete outright. However, when I try to do either one, I get an error saying that "only the owner" of the DTS package can edit or delete it. Well, as the OWNER I'm just a little miffed my own packages don't recogni...more >>

Hi, This is the first time I've am scheduling an SQL Server 2005 package. The package contains few vb.net scripts and other sql scripts. The package works fine when I execute from Visual studio. So I tried to schedule from sql server agent. But it just fails on me, no specific error message...more >>

Allo, I've set up a system that sends out an email if certain defect levels are in my DB are met. The system consists of a DTS package that processes the cubes, then runs a sql task that executes a stored proc to check levels and send out an email with xp_sendmail if they are too high. I wo...more >>

I have a set of pkgs I want to execute from a "master" pkg. These are for distribution to a customer who wants SQL authentication. We can't have the PWD unencrypted in the master pkg, so what params do I use for LoadFromSqlServer in the master pkg to create and execute the child packages? C...more >>

Hello, how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects. Andrey. ...more >>

Hi! I have a very simple DTS Package but it's failing! First, there is an Execute SQL task that selects a short list of intentory item numbers from a small table. It puts the item numbers into an output parameter rowset global variable called rs_ItemIds Then there is a data trans...more >>

Hello, On the SQL Enterprise Manager (SQL Server 2000), I'm trying to set the "Enforce distributed tansactions (MTS)" setting on the Connections tab of the SQL Server properties. I can "set" the configured values for this property, but when I view the Running values, this flag is cleared. ...more >>

Hello again, everyone! I'm attempting, once again to migrate data from an Oracle database to MS SQL. So I fire up DTS. I use an ODBC provided by Oracle (the MS one doesn't see all the tables/schema in Oracle, so I MUST use this) to select the source, and select the MS SQL database for the...more >>

Hello together, does anybody knows, if there is a way (maybe a toll) to document which tables (or also views, stored procedures etc.) are used in a DTS Package? Thx and greetz from germany Dietmar ...more >>

i've created a integration services project and dtsx package to extract data from one server to another. the package runs fine from the IDE, but i can't figure out how to deploy it to the server. any ideas?...more >>

Is there an env var or property that tells me if I have been run from Enterprise Manager of from DTSRun (e.g. scheduled). If I have been run from the GUI I can request input, or show errors in an activex, but if not, I would want to quit immediately. -- Thanks and Good Luck. Fergus ...more >>

I have a live, production db that I'd like to keep lean and mean for performance reasons. Every so often, I'll run a cleanup script to scrub out some older data in order to keep the tables from growing indefinitely and slowing my querying speed. But some employees would like to query ALL the...more >>

I've started learning SSIS and I'd like to replace our import tool with an SSIS project. The data warehouse is populated from flat files (fixed width format) - there are a handful of different formats and all the files are quite wide ~300 columns. I already have custom format files used by ou...more >>

On Darren's page... http://www.sqldts.com/default.aspx?288 At the bottom of the page, the DTS icons are shown with an Execute SQL Task "Create MDB" connected (via. success arrow) to a Microsoft OLE DB provider for SQL Server connection "SQL Server". When I attempt to place the success wo...more >>

I am trying to manually re-create a DTS package in SSIS. The data source is a Sybase database (not in my control) and the destination is my own lovely SQL Server 2005 database. I can't figure out how to add a data flow source object/task/icon that will connect me to the Sybase data. I add...more >>

Hi, I just started using SQL server integration services. It looks me very buggy and hangs so frequently. When i select a table name as a oledb sources it hangs there. Some times the package does n't open saying the package has been deleted or moved. Has anybody faced similar kind of problem...more >>

Dear all I’m experiencing a display problem in SSIS in design and control flow in the VS 2005 Designer: When I open a package all icons and arrows of task and containers are hidden. If I click on the task/container they show up. Do you have any idea why this happens? Best regards and...more >>

We're offering all the latest factory pressed high quality dvd movies, ps2, psp and xbox silvers with factory printed colour inserts at fantastic prices, whether for personal use or reselling. We're shipping worldwide with various shipping methods. For resellers, please contact us for bulk disco...more >>

I am trying to null out a column if it is blank, but get an error in the derived column transformation. Something about casting operands... but seems illogical to me... Column: tax_auth_group DT_STR(10) Transform: TRIM(tax_auth_group) == "" ? NULL(DT_STR, 10, 1252) : tax_auth_gr...more >>

It is possible to generate an EDI file via DTS - SQL 7 / SQL 2000? I want to get data from a linked Oracle database and generate an EDI file.. Links to articles would definitely help. Thank you....more >>

Hello, After patching a Windows2k3 server (terminal server/app server/SQL tools) with SP1 and ALL criticals and SP4 for the SQL tools we are getting the following errors when a DTS Package is even opened in Design Package mode when we are pointing to the SQL(2K) server: MMC.EXE - Entry Poi...more >>

I've got a pipe delimited file. When I try to use the dts wizard it gives me an error. However, when I import it into excel or access it works fine. I think... that there may be a carriage return in some of the text data, in one of the fields. When this happens, the wizard thinks it's the en...more >>

Where can I find SSIS DTS objects and methods so that I can understand and use it in the script component etc? ...more >>

Hello, I have been doing similar data importing related tasks (with the same settings, source, and destination) in the past but never experienced this problem till now :( Whenever I try to do edit the data pump (in the DTS designer), my PC goes to sleep and comes back after a long time. Thi...more >>

Dear all, I am using SQL 2000 SP4. I want to use DTS to transfer a text file to a SQL table. The text file contain one string and I transfer it to a column. However, I found that sometimes, some records are missed. The length of the records are the same. Does anyone encounter simil...more >>

Hi wondering if someone can point me in the right direction. i currently have a DTS package that imports data from 300+ flat files and updates a main table with results from it. i need to add some additional checking which forces me to record the filename and the results if they hit cer...more >>

Hi, I got this error when I was trying to run BCP from DOS command. SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file The following is my code. I got results from by running the query alone. --sp_spaceused docphrase DECLA...more >>

I have two data pipelines in a dataflow and would like to merge them to achieve the same thing as this sql statement: select col1, col2, col3 from tablea union select col1, col2, col3 from tableb where not exists (select 1 from tablea where tablea.pk = tableb.pk) I can't figure how to im...more >>

I need some assistance setting up a global variable that will be used to specify the path of a text file as my data source. I have accomplished this in the past, but cannot duplicate. In what order do I add the Dynamic Property and the Text File (Source) - or does it even matter? Every ...more >>

I am struggling, can someone point me in the right direction. I am trying to setup backups, or maintanence plans for my SQL 2005 standard databases. These databases were converted from sql 2000. They are working fine, but my CA brightstor backups fail as do my SQL backups. CA brightstor f...more >>

Dear All, I am facing a problem that how to log descriptive error in database or flat file when lookup failure occurs. Regards, Stephen ...more >>

Hi all, I have a prob with the dts when it is executed from the vb 6 application.When i invoke the dts from my application , my prog is not responding untill the completion of the dts. But i need to get the control when it is getting executed.What should i do.. Thanks for any help ...more >>

Need some good URL to learn more about DTSs -- Gracias J.Eddy...more >>

Hello: All I am trying to do is to create a simple table, by DTS'ing a csv file that was created from DTS'ing data from another table. Let me explain. I have a database named DEV1 and a database named DYNCUSTOM. I DTS'ed a table from DEV1 to a csv file. Then, I tried to use DTS to impor...more >>

Hello, I've been getting consistent errors in SQL Server 2000 Developer Edition after opening DTS packages in Enterprise Manager recently, but I can't find any descriptions of others with the same problem. The nature of the problem has changed a little after troubleshooting. In all case...more >>

I am importing data from Access to SQL Server. There were two DateTime fields in Access. One contained a date, the other a time created by the TimeSerial serial function. The date imports correctly and the Time field gets the error below. The field created on SQL Server is SMALLDATETIME fo...more >>