We have SQL Server 2005 and have installed the "add-in" that allows us to edit DTS2000 packages. However there seem to be two areas that were available in SQL Server 2000 that are not available in 2005 using the add-in. First off there seems to be no way to access the logging of the DTS2000 ...more >>

Hello to all, I am trying to learn the DTS one step at a time. I want to execute a DTS package using .Net. I got the idea from one of the posts here with the sub: Executing a DTS Package from VB.NET forms . It works fine when all the rows of a table are exported. Based on this, i used a p...more >>

I have an SSIS package that recently hung in the middle of execution. It was in the middle of a ReadCommitted transaction that is accessing one database. During this time, all other SQL queries to this database hang. If I stop the SSIS package, everything works fine. This package has been ...more >>

Hi, I have been reading all day trying to figure out this one and I can't find out why I am having this issue.... I have created a DTS package that export a SQL statement to Excel. The package runs perfectly in Entreprise Manager, however, when I run the package in VB, I received the follow...more >>

I need to update a table in the oracle with data that came from the SQL Server but I cant delete all the lines in the oracle I need to check if the line doenst exist in the destination table and then append this line. I know how to do it using transact-sql when the source table and the destin...more >>

I need to extract data from an Oracle 10g database to SQL server 2005 data mart using a pl/sql procedure to do the extract from the source system. I can run PL/SQL selects and create statements from SSIS to an Oracle 10g database using the MS OLE DB provider for Oracle. I cannot get an ...more >>

Hi, Is it possible to get transaction support between two ms-sql servers (ms-sql 8.0) on windows 2003 servers, on different nettworks with firewall between - and only one way traffic on specific ports allowed? Thanks, Willy ...more >>

I have a MSDN SQL Server 2005 Developer edition disk called as SQL Server 2005 CTP what is this CD ? is it the 2005 beta CD please confirm. Is it OK to install from this disk. Thanks Karen ...more >>

We have been getting a strange error with this particuar package that = we've been running a scheduled job, from Integration Services and havn't = been able to figure it out. It works fine when running from Visual Studio = but not so much when we are scheduling it. Below is all of the OnErrors ...more >>

Hi, I am trying to build an automated process that would allow someone to upload a CSV file via FTP to a specific folder and then the DTS package would do it's thing every hour and import the information then delete the CSV file. All of this is not a problem except that the first 9 rows co...more >>

I don't have accesss to DTSRUN. Can someone tell me if its /L (log_file_name) argument will accept a UNC path? Thanks....more >>

Greetings. I have a folder containing a number of .sql files that I would like to execute using Exec SQL task I'm looking for a way to dynamically set the Exec SQL Task's FileConnection property using a ForEachLoop container for the folder. Probably going to bring the path to the folder ...more >>

I have a workstation with SQL Server SP4, and a server with SQL Server SP3a. I use Enterprise Manager on the workstation (SP4) to remotely connect to the server (SP3a) and create/modify DTS Packages. If I create/modify a DTS Package that contains a FTP Task from the workstation (SP4), and then...more >>

Hi, I need help accomplishing a task and I'm not sure how to go about it but I do know that I want to do it using DTS. I have a text file, A, with a list of id's and I'm supposed to execute a SELECT query on each id and send the data to another text file, B. I'm not even sure where to start. ...more >>

I am looking for some tutorial on SSIS, beside the one from MS online tutorial. Can you help? thanks ken ...more >>

I am trying to debug a script task in an event, is this possible? I get a window that opens and contains the script task from the control flow but that is all I ever see. Any help would be appreciated. I am not sure what additional info is needed to help diagnose this, but I will provide wh...more >>

Hi - I have a 32 bit SQL Server 2000 installation that is current on service packs that is installed on a 64 bit version of Windows 2003 (this actually works ok). It's not mine, but I have to deal with it. There are a few DTS packages I need to transpose into T-SQL that read from dbase f...more >>

Hi - I've been having a problem with all of the packages I create. I create them in BIDS on my local machine (which is running SSIS, as I discovered that was needed for the packages to run properly on the server). I then create an XML config file and deploy them to the file system on the serv...more >>

Hi all, How can I have my c# program execute a DTS package on a client PC that doesn’t have SQL client tools installed? I have a c# program that executes a DTS package on a SQL 2000 server. The program works as expected when run on the development PC. When I install the program on a cl...more >>

This is a newbie question. I'm starting a new DTS package. I click and drag the Microsoft ODBC drive for Oracle to the IDE. I enter the inforamtion and click okay. I received this error dialog box: Title = Package Error Text area Error Source: Microsoft OLE DB Provider for ODBC Dri...more >>

I have some DTS packages that load a flat file to the SQL 2000 database and then to a AS 2000 cube. I want to migrate this to SSIS on SQL 2005 and AS 2005 kindly explain the procedure for the migration. Thanks Karen ...more >>

Hi Everybody, I am having problems in DTS packages that runs nightly. It is always the same Error at the same 'Execute SQL Task'. The ohter Tasks in the same DTS packages works fine with the same OLE connection. "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network...more >>

I am running several ActiveX script tasks that are basically inserting legacy data into the new DB structure. Using stored procedures with cursors has taken far too long so i wrote some relatively simple scripts that handle the job very well and very fast. However, I want to be able to write any e...more >>

Hi, I am trying to run a DTS package from my SQL server command line using DTSrun.exe. I cannot get the syntax right to find the package, for I keep getting "The specified DTS package ... does not exist". Here is the command I'm using: C:\Program Files\Microsoft SQL Server\80\Tools\binn>Dt...more >>

I am import Excel files into SQL 2005. I need to capture the total from Excel and compare the total in SQL destination table. If they are not equal, then there is an error. Did anyone know how to do it in SSIS? Thanks....more >>

Can somebody from the MS team help me with this? I never got an answer. I'm a sys admin on the SQL Server and working locally. I go into bids and try to save a copy of a dtsx file to the server (SQL Server). I can see the folders I've defined in integration services fine, but when I expand the...more >>

We have an interesting scenario here at work which to be honest doesnt = seem very difficult but we have never had the opportunity to try this = out. One of my co-workers has written a dts package containing one simple = transformation. This dts package simply reads from a file and puts it = in...more >>

Converting mind and server to SQLServer 2005. Bought a book to help in the transition. I need a new DTS project. I open SS Business Inteliigence Dev, File, New Project, Intergration Services Project. My book example shows a Data Transformation template. In real life, my server shows no tem...more >>

Hi. After applying SP1 on my SQL Server 2005 developer edition on my laptop, there is no longer a File enumeratorin the Foreach Loop container. I have found this problem described earlier, but not yet found any solution for this problem: http://groups.google.dk/group/microsoft.public.sqls...more >>

Hello There, I have a very simple SSIS package that I want to schedule to run via SQL Server Agent Job, but so far I was not able to make to run. The SSIS package runs fine within SS Management Studio and Business Intelligence Development Studio (BIDS), but when I tried to run it in a s...more >>

Can anyone recommend a good book which deals strictly with using Activex in DTS ? Is there an DTS Object Module similar to the Access Object Module and a way to view it ? Are there methods and properties as in Microsoft Access and a way to view them ?...more >>

Hi, we use xp_cmshell inside custom procedure to execute DTS and dtexec is any way to create clr procedure that will call dtexec ? could not find any examples exept http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=407609&SiteID=1 thanks Alex ...more >>

Hi, I have an requirement wherein I get the data in the form of an txt file and I need to push this data onto different tables based on an column. And while pushing these data onto different tables, I need to check whether the data already exists in the table based on an unique column. If it ...more >>

I created a package configuration and used the package installation wizard to deploy a package to my dev server. The package pulls data from Oracles servers (9.2 Oracle client and ADO.NET:System.Data.OracleClient.OracleConnection objects to connect to the servers. In the package configurat...more >>

Hello, I've written a DTS to copy selected objects (stored procs/tables/functions etc - data from tables also) over from a source database to a destination database. I'm using 'Copy SQL Server Objects Task' to do the actual transfer. The problem is that I need to get this DTS from the...more >>

Hi. I have a simple DTS package set up with a datasource, transform data (for my query) linking to a destination text. I also have a global variable of type decimal, which I use a parameter in my query. If I run my query in QA it works fine or if I replace the parameter with a hard-coded val...more >>

Hi All, I'm new to dts stuff. I've designed a dts package to create renewed licences. It loops through a number of files, imports the data into a temporary table and does a lot of processing on this table to create new Licence table records, mark licences as renewed and add extra table entrie...more >>

Do anyone know where to find the package log details that can be displayed by right-clicking a package and choosing "Packages Logs..."? It would be very useful to be able to query this table or tables. TIA! dj ...more >>

All, This is for SQL 2000 DTS. It is possible to run a task (ActiveX in this case) at the completion of a package, regardless of sucess/failure of any of the steps? I have a package that has a number of steps, each of which run only when the preceding step was sucessful. I would like to ...more >>

Hi all, I have a sql2000 DTS package I'm moving between windows2003 serves on the same network. The moved package appears to lose all column definitions defined for an output text file (source is a sql query). Clicking on the "Define Columns" button in the Destination tab of the Transform D...more >>

Hi, I have 100 tab-delimited text files I have to import every day into their respective tables on SQL Server 2000. The data in each of the files is not homogenious, i.e. some files have 3 columns, some have 50 and weigh 200 Mb, etc. I download all files from an ftp site. The big picture ...more >>

Hi, I'm trying to import data from DB2 to SQL 2000. The import works great, however, when I try to edit the 'Transform Data Task' on the workflow display, my Enterprise Manager just hangs. This only happens when trying to modify a task that imports from DB2. Does anyone have any ideas? ...more >>

I am using a derived column to calculate values for exploded sales estimates. The formula is pretty simple (Estimate * (sales/Summedsales)). Each of these numbers are decimal(12, 4). The problem is that the derived column values are not the same if I just did the math. An example (149947.439...more >>

Hi I am trying to load the 30 records into the database table. I have created one Format File and one .sql file to load the data. I observed one problem during loading the data into table, if there is any problem in the first record of my 30 records, the sqlcmd is rejecting the entire dat...more >>

Hello, I am writing a custom Data Source that accepts an instance of a flat file connection manager. Once I have a reference to this connection manager (ConnectionManager object with CreationName="FLATFILE"), does anybody know how can extract all its relevant meta data - especially the ...more >>

Folks: We have the need to write a lot of SSIS script tasks that talk directly to the database. We use OLEDB connections, and log into the database using database users rather than Windows integrated security. Within a script task I'm able to create a new OLEDB connection object using th...more >>

I need to set up 2 exports in DTS, they both go to an Excel File. In both cases I need the file name to be dynamic, i.e. company_<todaysdate>.xls 1. The first one will be run weekly and dropped into a folder on the shared server. What I need to do is make the file name dynamic and ...more >>

Hi, My initial tests show that this feature will only see DTS Local Packages. How can we migrate the DTS Meta Data Services Packages? Thanks Chris ...more >>

I need to import into SQL dbf files. In SQL2KDTS there was an option for this, but in SSIS I do not see an option for dbf files. I tried a few that I thought MIGHT be the instance but nothing has worked so far. What file type do I use for this now? TIA ...more >>

Hi When I am trying to insert value in remote server (Linked Server) or trying to run query with BEGIN TRAN & COMMIT from query analyzer I am getting following error. ********************************* The operation could not be performed because the ole db provider 'SQLOLEDB' was unabl...more >>