Server: SQL2K I want to have a backup server ready to deploy in case my production server gets damaged. One of tables has identity column, and the other has no primary key. So, I gave up Replication method. (Does Replication still work?) I chose DTS to copy database. When the backup...more >>

Hi, I am trying to migrate DTS package from sql2000sp4 to sql2005/legacy. I got this error, an error has occurred while establishing a connection to the server. whne connecting to sql server 2005, this failure may be caused by the fact that under the default settings sql server does not allo...more >>

I am exporting two different views to the same spreadsheet but different sheets. The first export works fine but the second creates the second worksheet with the same headings as the first. Both exports are created using the wizard so they are in different packages. Anybody tried this suc...more >>

I read in a book that the DTS packages could be invoked by a program (in my case a C# program) as long as you provided the login ID and password. Now I am looking for an example. Is it possible and where could I find an example. Thanks in advance for your assistance!!!...more >>

I want to copy the contents of one package into another package. I can bring up the 2 packages side by side in DTS Designer and I can copy things like the Connection and the Text file, but I can't copy the transform between the 2 opjects....Is there a way to copy the contents of one package i...more >>

Hi there, is there any way that a DTS package can be executed via a shortcut? I need to make this as simple as possible for a customer who is not familiar with Enterprise Manager. ...more >>

Hi I am trying to schedule DTS jobs that would pull from SQL and extract the data to specific Excel files. These jobs are being run daily at 8am. Eg. Pull data from SQL Table A and copy to Excel File A. Also, I am discovering some wierd behavior; the new data being pulled from SQL, adds to the...more >>

Hello all, quickly: I want to be able to be able to have a specific task fail, run a stored procedure to log the error, and then continue processing the package as if nothing had gone wrong. When it gets to the end, I'd like the package to act as if it had suceeded. More detail: I'm working...more >>

Hi, I have both sql2000 and sql2005 server in my computer. In order to open legacy/DTS package in design mode sql2005 I installed SQLServer2005_DTS.msi. I was able to open DTS in sql2005. Now my problem is I can user sql2000 anymore. It gives error says that The procedure entry point? pr...more >>

I have been asked to produce a set of csv output files for a number of subsets of data from a database. I have created a DTS package that can output each query to a hardcoded filename specified in the Destination file object in the package. As I have to do this appoximately 160 times I need to...more >>

I can't find SSIS in sql2005? the SSIS service is running. Thanks ...more >>

Hi, After I upgraded the sql2000 to sql2005. I see the dts package under legacy. but i can open it. WHY? Thanks ...more >>

dear gurus, I don't understand a feature. It is in Package Properties->Logging and it's called as 'Fail package on first error' What the heck! Any of our dts end up when any task fails. is it referring to warnings or something like that? Please, let me know how works that option button and ...more >>

Hello! I have a stored procedure (FL_LIGenerateNextPkg) which I call to set the global variables of a DTS Pkg and execute it (Pkg A). Pkg A then runs a couple of stored procedures and after they have successfully completed, it calls FL_LIGenerateNextPkg again, passing different parameters ...more >>

I'm using MS SQL 2K. I'm trying to design a DTS that uses DDQ that uses a query as its source from DB1, then using that data it needs to update a table in a second DB (DB2). Both DBs are defined in the DTS as a Connection. I have the source query completed and tested, I've defined my binding ...more >>

Is there a way to change the owner of a DTS Package. I am running SQL 2000 Enterprise with SP4. Thanks. ...more >>

Hi, I would really appreciate if anyone of you can help me. I am new to the DTS and working on multiple column lookup under ActiveX script. I am using SQL Server 2000. Lookup Query: SELECT STATUS_DATE,STATUS_CODE,DELIVERY_DATE FROM PRODUCT_ORDER WHERE (PRODUCT_ORDER_ID = ?) The Trans...more >>

When I modify the server connection to change the login ID when I transfer a DTS package to a different server, the tables I selected for copy on the original package get de-selected. How can I preserve the object selection when changing a connection login? This is in SQL Server 2000. Thank...more >>

I am using the Copy SQL Server Objects task in DTS on SQL Server 2000 sp4 to copy a number of specific tables from one database to another on the same server. The package fails with the error message "Could not find check constraint for table 'x', although the table is flagged as having one."...more >>

I'm new to DTS so bear with me. I have an app that exports several tab-delimited files throughout the day. I'd like to then schedule a time when these can be imported into an SQL database. I've got it to work fine on a test server using DTS for one file. The exported files generated have diff...more >>

(SQL Server 2000, SP3a) Hello all! I've been trying to figure out whether DTS will allow for "shared" code. That is, I have a DTS package that has a file logging system. I'd like to somehow leverage that code inside of other DTS packages -- sort of like an "include" file, if you will. ...more >>

How do I identify running DTS executions? We have some DTS's which don't log to the system (DTS) tables and are absolute resource dogs !!! So, how do I identify them? All I can get from master..sysprocesses is "DTS Designer" and the enormous I/O being generated. Thanx. -Cqlboy...more >>

Hello, I have a DTS package called 'MASTER' which performs 8 execute DTS package tasks. There are no workflows defined for 'MASTER'. The 'MASTER' DTS as well as 7 of the 8 packages it executes all have the same error log file name specified in the logging tab of package properties. 'MASTER...more >>

I have a DTS package that, in a simplified version, does this: - step 1. script out indexes on tables to a text file - step 2. truncates the tables - step 3. drops the table's indexes - step 4. transfers data, using the Transform Data Task. This step has one "source" connection and one ...more >>

Using SQLSever 2K, can I create a DTS package that can export the contents of a SQLServer table into the contents of a local MDB that is constantly in use by a local app? The local app has an import data feature but I've been asked to try to automate that process instead of having someone h...more >>

Hello all, I have 100 DTS packages and I am looking for particular text string (for example: like '%table_name%'). How can I look for it without opening each DTS and going through every step? I'd like to perform simmilar search to the one that we do to find text within 100s of stored proc...more >>

Hi! I have a very strange problem. I must move all the databases from one SQL Server to another one, so I backup every thing, setup the server, restore the databases and no problem. After that, I install the Oracle Cliente 9 with no problem, and them starts the problems: If I run a d...more >>

I am facing some typical error while taking the Portal Backup from the front end servers. It was working fine for many days 2 days back it started throwing error. This is medium Server Farm Setup, with data getting stored on SAN . My data size is approx 20 GB Below are the er...more >>

Hi Darren, We're trying to use the Bulk Export Task from sqldts.com in the log i get: ::Error:: [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 862 is not supported by SQL Server [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations Is there anything i c...more >>

Hi All: i have to write a DTS which has to run in the night check the values in a table and then get the email addresses from another table to send mail with some specific content.. Iam very much new to DTS. Anybody there to help me out...!! Shobana ...more >>

Hi. We've got a SQL Server 2000 DTS package that needs to read/write to an Oracle 9i database. We're pulling our hair out and can't figure out how to do it. We've installed the Oracle Client Tools on the SQL Server database machine and on the workstation of the developer, but it's giving error...more >>

In t-sql, I can insert this date 20050712, to a datetime field, and it works fine. The date shows up correctlys as 2005-12-07. When I try to do a data transformation in DTS, using CopyColumn with that same date, to the same field, I receive an error. My problem is, I don't always know what th...more >>

I have a staging db that has one field - col001 - and in it are ~300k INSERT statements to different dbs. I have the following code that loops through each line and loads the script accordingly. Problem is, this script takes forever to complete. Can anyone see if the code could be tweaked t...more >>

Does anyone know how to use the OLE DB Source/OLE DB Destination components in SSIS to carry out a load of data from a table whose name is determined at runtime? i.e. a variable which is assigned during the iterations of a loop I am trying to do load of several tables and dont fancy writing a...more >>

in executing a SQL Task, i will create a #temptable with records inserted in it. can i then save the record from #temptable to Excel ? if yes, now ? thanks....more >>

Hello, I would like to learn more about activex and scripting. any suggestions on book are websites that will ease me into the subject as i d not knoe much about it. Thx ...more >>

Hi, I have a SSIS package that executes a SQL Task. It does a simple insert to a table. It works in the BIDS. When I deploy to SQL Server (same machine) it fails to execute the SQL Agent Job I have tried as many combinations of sa vs windows authentication, file vs server deployement as i c...more >>

Hi I have created a DTS in which first i m deleting values then populating data from text file. the problem is that i have to open the pakage and then execute each process manually in the pakage. wht i want to know how can i confiqure the flow that i only execute main package then, first...more >>

I have a 40MB SQL script that I'd like to load into a DB using DTS. Can someone step me through setting this up in DTS designer? I believe I need to define the dynamic prooperties, point to the scripts location, etc. Any help will be greatly appreciated....more >>

Hi, I have 10 different DTS's, all of which have the exact same ActiveX script task at the start. I'd like to know if there's a way of storing my vbscript in 1 location, rather than 10 locations, allowing for easier modification of my code? Thanks in advance Regards Jon Derbyshir...more >>

Hi All, I'm trying to execute a 2005 package that retrieves data using the IBM RedBrick ODBC drivers and I get a time-out message. I can't find the option to set this time-out value to 0. I'm using the ADO.NET:System.Data.Odbc.OdbcConnection and DataReader Source in the DataFlow. How ...more >>

Hi I try to create a DTS package on SQL Server 2000 SP4 and keep getting a window "Package Error" saying "Parameter is incorrect" when I try to put a task or a connection in the empty package. All I can say is that I have the suspect that it might have something to do with the installati...more >>

I'm using a script component in ssis to create some custom output columns with vb.net. This is working great, and I've read that I can use mutiple inputs to reuse the code with multiple data sources. However, when I create a second source and try to drag a path to the script component, I get t...more >>

Hi How can I set the input file name at run time in SSIS for at bulk insert task? In DTS I could set the filename using a Dynamic Properties Task, and in that way specify the name, which in my case change according to the date. But how do I do this in SSIS? I can set the SourceConnection prop...more >>

Hi, This is continuation of an issue I posted on before. Thanks to the responses for to that , as they gave some pointers - but problem is not fully resolved. The background is:- Server A is running SQL 2000 and in domain X Server B is running IIS and host web-sevvice, also in do...more >>

I am panning to write a DTS (SQLServer 2000) package whcih alters the table and output any error messages when failed. I have created Execute SQL Task in which I have wrote the following command. Alter table Employee ADD EmpStatus char(4) DEFAULT A not null; I have created a work flow t...more >>

hi, i'm using SQL Server 7. wanna use DTS to run a SP and save the result in Excel. In SP, temp table ( #xyz ) is created & used. however during the DTS creation, DTS will generate error msg " Error Desciption : Invalid object name '#xyz ' " do you have any idea how to overcome ? next...more >>

I have a DTS package already created on the server. I want to call it in a sp using the xp_cmdshell 'dtsrun ...' I'm getting "xpsql.cpp: Error 87 from GetProxyAccount on line 604" Any ideas how to fix this? Thanks Mike ...more >>

Hi, SSIS doesn't provides an easy to use interface for a simple dimension update. have you any workaround? In my staging database I allready know which rows are new and which rows need an update. The new is simple, I insert, so the mapping is easy and automatically generated by SSIS. ...more >>

I was trying to migrate DTS packages from SQL Server 2000 using Package Migration Wizard of SQL Server 2005 and successfully migrated 27 of them. When I tried the 28th DTS package, I got the following error message. From then on, I could not migrate any more DTS packages even from the same S...more >>