Hi All, I am using DTS to connect to an oracle db to pull back data from a view, import some spreadsheets and do some data transformations and manipulations. It's all working fine on my development machine. But when I copy the dts to the Test Server and open it in DTS Designer I receive a...more >>

Hi all, I've searched this forum quite a bit and haven't found anything to assist me in what I am trying to do. We are FTP'd at various times 2 files to be 'imported' into a SQL databse. The .txt file contains the record that actually needs to be entered into the table the other (a .pdf) just ...more >>

Hi: I have a possible project to work on where I will have to (unfortunately) pull data from multiple servers, each with it's own dialup connection. My question is, is it possible to dial a connection from within DTS, and then hangup when the package is finished? If not, any good recommend...more >>

Is it possible that a DTS job reports success, but isn't? I created a DTS job and saved it. The query was: select * from table where date >= '20061024' and insert the results to a table on another server of identical stucture and name that had no records in that date range. I then went...more >>

I'm using SQL Server 2005. I've built a DTS. Essentially it does this: Create a table and insert data Delete an excel file Export the table to Excel In BI Dev studio, the package runs just fine and everything works perfectly. However, when I run it with the SQL Server Agent, the table i...more >>

In order to test the data from the source file, I changed the DTS load job to use an ActiveX script instead of just a copy. I noticed that data with a zero length string are getting converted to nulls and this is causing an issue. There is nothing in the command which tells it to do a conve...more >>

Hi - I think that we may have an issue with our isolation level or transaction commits in our main load package. Basically we get zipped flat file extracts for 94 districts, then we enter a container that bulkloads about 300 tables for each district received, loops back and then after all d...more >>

Hi, How to identify the DTS package that is used in the SQL jobs? Thanks *** Sent via Developersdex http://www.developersdex.com ***...more >>

I just can't seem to pass a parameter (or get one returned) from an Execute SQL Task object (using an OLE DB connection). I thought that it would be as simple as defining a variable at the User level in the variable window. Then, map that User variable to another variable in the properties ...more >>

I have a DTS that is not executing any of the steps. They are not disabled and checked to run on the main thread but they come up as not run. I running Sql 2000 sp 4. Thanks Mike ...more >>

Hi, I wonder if there is a work around for the following problem, I have a DTS pack that imports a number of uploaded files as well as files that show errors that we have had in the files that we have uploaded. The DTS works fine when there are errors listed in the Error file but wont work...more >>

Can anyone tell me how I can get an ODBC connection from the Connection Manager window into the Control Flow or Data Flow windows? I have 3rd party ODBC drivers that are essential to gaining information from our non-SQL systems in order to create data warehouses for AS cubes. I can create ...more >>

I have an SA credentialed connection for both the source and destination server. Both servers are SQL Server 2000 standard. The job fails with an "unspecified error" which obviously is little help. I know it is connecting to both servers as it even shows me which jobs are already present on th...more >>

Dear Experts, I'm an Oracle guy, but I've been given an assignment to compare data in two different Sybase "databases". Given that I don't have the MINUS, or the INTERSECT command, and in this Sybase version, not even the inline views, I am trying to use Outer Joins. Now, in Oracle, when...more >>

Hi, Attempting to load data from a flat file into a SQL Server 2005 db. using the Data Flow Task. However, some of the data contains duplicate records, throwing up an error on the PK constraint. I hoped that SSIS would be able to handle this using the new inbuilt Error Handling. However,...more >>

Hi, I need to refresh the database1 in TEST. In an other word it has to be restored. I have a database file database1.db. Do you know how a can proceed from Enterprise Manager? Thanks Barb...more >>

Hello. What is the best way to transfer data from DB2 to SQL Server 2000? Any feedback is appreciated! ...more >>

Hi, I am trying to query the database and based upon which I have to generate multiple excel files as per the number of users. I am planning to use DTS...and I think activex scripting needs to be done. Does anybody have any sample code which I can look at? Also, the filename for the excel s...more >>

I need to update one column in a table that already has data in it. I need to update one field in each record with the data from an Excel file The file has the key and field data that need to be inserted Can some one post an example of this type of update statement, I could import the data to a...more >>

I created a package which executes 15 other packages. Each of the inner packages contains 3 variables which determine which files to load. Is there a way to set these variables once on the main package and then have them propagated to the sub packages programmatically? The main package cont...more >>

I'm not sure exactly where this question ought to reside..... In our production environment, we have 2 sql servers that we alternate between different days production totals. For instance, on Friday, Server #1 (the primary one) will load the previous night's production totals to it for rep...more >>

Ok - I guess I need some direction here... I have been given the task of joining some data with data from our web-based email system for email addresses. The LDAP server is supposed to be enabled ... but I'm totally stupid... Where do I need to go to get information on how to query an LDAP ...more >>

Hi, I have an issue trying to load a dBase table in a SQLServer 2000 database by DTS.Trying to open this table for copy it, DTS give next message: Source error: Microsoft JET Database Engine Description: Unexpected error from external database driver (10023) It's funny, cause from Exce...more >>

We have done a refactor of an access db to a sql db. I need to somehow keep the data from access in sink with sql, however one of the problems is that the tables in access are single fields ie. category->shoes. During our refactor we made these table have pk so the are now CategoryID->1 and ...more >>

I am in the process of finalising some new SSIS packages (based upon = previous DTS packages, but re-created in SSIS from scratch). One of the = packages that I am recreating needs to call another of the packages when = it has completed, however whenever I try this, I get an error. Further = mor...more >>

hi I have a DTS package which actually has only 2 execute package tasks. Both tasks, if run individually runs very fast (20 second max), but when I run the entire package it goes for a toss, keeps on running and doesn't stop even after 30 minutes. I am using sql 2000 ent edition with win ...more >>

I have a File System Task step in my DTS. It is supposed to delete an Excel file from my C drive. When I run the DTS in BI Dev Studio it works fine. However, when I try to run it using SQL Server Agent, the file isn't deleted. Any ideas of what could cause this behavior? Thanks. -- J...more >>

I have a scheduled job that is causing errors in the System Event Log, and I don't know why. The job is a DTS package that has two steps -- first step connects to our AS400 and copies down data, the second step takes that data an formats it for later use. Whether running the DTS manually, ...more >>

Sorry, it's the DTSWizard.exe, not DTSMigrationWizard.exe in my last post. ---------------- When I run DTSWizard.exe in SQL2005, I get a "General access denied error." I have both SQL2000 & SQL2005 installed on my WinXP professional. Thanks, ...more >>

When I run DTSMigrationWizard.exe in SQL2005, I get a "General access denied error." I have both SQL2000 & SQL2005 installed on my WinXP professional. Thanks, ...more >>

Hi, I migrated DTS packages into SSIS. Now how do I modify them in sql 2005 after migration. Thanks ...more >>

Hi all, I have been looking at deploying an SSIS package which is called by a web service. I have had to reconfigure the package so that all connections use windows authentication. This windows account will be the one used by the application pool which calls the web service. On my developme...more >>

I created a dts package in sql server 7 enterprise manager designer. I decided that I did not need the package and deleted it. The package continues to run and I am getting an error ever Minute!!!! Please help. How do I stop this ...more >>

I created a DTS package which loads data from Access to SQL Server. It will be used in 15 different databases. The table names are exactly the same in each database. As I rolled out the package to each database, I changed the connection object to point to that database. I also had to go ...more >>

Hi, I migrated SQL2000 dts packages into sql2005. But I don't see them under SQL2005 SSIS. I am sysadmin. Do I need specific permission for SSIS packages? or When I did the migration. the packages were not in SSIS folder? Where did they go? Thnaks ...more >>

Hi, I've migrated dts packages from sql2k to sql2005 successfully, but i dont see the package in sql2005/ legarcy folder? Any ideas? or there is something that i was doing incorrectly. Thanks ...more >>

Hello, I am new to SSIS, any help is greatly appreciated. I need to convert a few DTS packages that manupulate excel files to SSIS. In DTS, I used vbscript task to open excel, insert data from database, format the data, and save the file. How can I do this in SSIS? Is it possible? What'...more >>

I have set up a package that runs a query, returns a row count into a global variable, and then based on that value determines if an email should be sent. An Active X script in the workflow of the email step is where this determination is done. Is it possible to add additional global varia...more >>

Encountering some odd behavior inside of a DTS package. The package itself is very simple: The first step copies data into a temp table. If that step fails, it sends an e-mail to a list of recipients. If it succeeds, it goes to the next step, which is to populate the "real" table. If that ...more >>

Hi folks, I have one developing SSIS Visual Studio project as below: for the following data flow tasks step 1. for OLE DB source task, define the input table, and verify columns selected step 2. for fussyLookup task | in the reference window, define the refernece table step 3. f...more >>

Hi, I have three related questions. 1. I am trying to import about 30 tables from one SQL 2005 database to another. However, whenever I do so, I get one of two errors: ERROR : errorCode=-1073548784 description=Executing the query "TRUNCATE TABLE [knowledge_website].[dbo].[tblCateg...more >>

I would like to create a managed connection to a file that has a new name each time the SSIS package processes. Is it possible to dynamically control the name or create the managed connection based on input parameters? ...more >>

Hello, I've SQL2000 Standard Edition running on Win2003 server. I am working with a DTS that was created by a third party software company. This DTS copys informtion from an iSeries application into a SQL application. DTS runs fine when I open in E.M. and execute it also works fine when I sav...more >>

If I have some simple text data like: 2005A115DWU 096003 24997.28 2005A115DWU 097003 -46718.25 2005A116DWU 000101 127129.38 2005A116DWU 035901 113579.90 2005A116DWU 041002 -7338.00 I can go int...more >>

Hello, all. I'm xfering data from a SQL 2000 table to an Oracle 10G database. The table in question contains 41 million records, and is a faily wide record. I've xfer'd this table from another SQL Server months ago, and it ran within an hour...very fast indeed. However, my DTS xfer to Orac...more >>

I have read several posts and articles regarding connection manager password security in SSIS and how to go about this using configuration files, changing ProtectionLevel and supplying package passwords, but I believe my issue is different: I've designed a package using a configuration file. T...more >>

I am trying to migrate a DTS package from server 2000 to 2005. I is there a How-to for this. I am also getting a Client unable to establish connection Encryption not supported on SQL Server. (Microsoft SQL Native Client) when I try to expand the MSDB folder in Stored Packages. Any h...more >>

I have more that 200 DTS packages saved in "Local Packages" under SQL Enterprise Manager. I know I can save them one by one to migrate to other serevr. Are there any easy way to migrate all 200 DTS ? Thanks for help, ...more >>

Hi, We are running SQL Server 2000 on Windows 2003 server. I have a DTS which tries to run a batch file stored on a different server. When I created this DTS I used UNC to point to the batch file. During the design time (at the time of designing the DTS) the DTS can see the batch file. (...more >>

I need to derive address information from the zip code. I have a zip code file that I need to put into a SQL table. What's the best way to do this?...more >>