Is there anyway to generate dtxs file by coding? -- Allan Yiin AsiaMiner Senior Data Mining Consultant http://www.asiaminer.com.tw/html/forum.html...more >>

Source server is a stand-a-lone (no directory) W2K advanced server running SQL2000, the destination is a 2003 standard edition server, again stand-a-lone, running SQL2005/SP1. So I am using SQL security for the transfer since local accounts don't seem to work at all. Looking at the event lo...more >>

Hello, I have, very simple dataflow task: OLEDB Source [varchar(12) CodeId "ASDF "] | V Data Conversion [varchar(12) CodeId -> nvarchar(8) CodeId] | V OLEDB Destination [nvarchar(8) CodeId] The task fails with this error message: Data conversion fa...more >>

I have a custom ODBC connector (ProvideX) for a system that I am trying to import the data into SQL Server. I have setup the System and User DSN and am trying to use the import wizard but cannot seem to use the correct driver. Is there any suggestions about how to set this up in SQL 2005 o...more >>

Hey guys, I've got a DTS package disigned to transfer data from multiple remote same-structure tables into a local centralized table. The source query is similar in functionality to: SELECT * FROM TABLE1 WHERE DATECOL > ? UNION SELECT * FROM TABLE2 WHERE DATECOL > ? UNION SELECT * FROM ...more >>

I am trying to run SQL Server 2000 DTS Package from SQL Server 2005 Legacy Data Transformation Services. This package transfers data from Lotus Notes to SQL Server 2005 using Data Driven Query Task. I am able to create a new table but data is not getting transferred. On running the DTS Package...more >>

Hi: I am trying to set the SourceConnectionID in an ActiveX Script Task at runtime: set pkg = DTSGlobalVariables.Parent pkg.Tasks("DTSTask_DTSDataPumpTask_1").SourceConnectionID = 34 ...and when I run the package I get an error saying: "object doesn't support this property or method" ...more >>

Hi: I have posted concerning this-I don't mean to double post but I have isolated the problem and have new information. (and I'm desperate!!) I am trying set the data connection object (ODBC to Sybase) twice in the same package but the Data Pump Tasks that use this connection don't seem to ...more >>

Hello Mr Mitchell, Based on several threads I've read from users having a similar problem, I believe you have a solution for dynamic transformation mapping? I need to export data from SQL tables to AS400 files(the SQL table has the same structure and column names as the file on the AS400) . ...more >>

Hi, My team is converting from DTS to SSIS and we are having a few performance problems. We pull data from an AS400 into sql server. Originally with DTS, this process was slow, but we significantly increased perfomance by setting a large fetchbuffersize on the DataPumpTask. Is there a way ...more >>

I was playing with SSIS on our standard edition 2005 server, and noticed a lot of stuff wasn't supported. For instance, the auditing and data conversion transformations couldn't run, as well as custom coded transformations. I was wondering if there is an exact list of what SSIS features ar...more >>

Hi: I have a loop that sets the source database source and runs the same query against a different database that it did the previous loop. So, like this Source_DB_1 Table1 Source_DB_2 Table1 Destaination_DB Table1 It loops through the first source DB and runs a query on Table1 on...more >>

I have a desktop that runs both SQL 2000 and SQL 2005 Enterprise Manager tools. When the programmer attempts to look into a mail step, he gets the error: "Cannot load MAPI interface layer from DTS. Please make sure that semmap90.dll is installed". I instructed him to rename the semmap.dll ...more >>

I am fairly new to SQL Server Integration Services Packages. I am looking to transfer data on a daily basis from an Access database to the SQL 2005 database. I am able to set up a DTS package and do this in SQL 2000, but do not know how to go about it in SQL 2005. I have tried importing the 2...more >>

Hi, I'm using SQL2005 SSIS designer to create a package that contains an FTP task. I can set the FTP Connection properties in the designer okay and manually run my package, but when I create as a scheduled job on SQL 2005 it fails with "-1073573489,0x,Unable to connect to FTP server using "F...more >>

I would like to utilise DTS to perform the followings. Are they possible? 1. Export data to XML files. Perform conflict resolution against the files. 2. Send the files to external users. 3. Import the XML files to the database. Perform conflick resolution against the database. ...more >>

I have a batch file(.bat) that copies some files from a remote server to my SQL server. When I scheduled the DTS pakacge that calls this batch file, it runs succsesfully without errors. But the files are not copied over at all. So when I tested with the Windows Scheduled Task and Manullay ...more >>

Hi, I want to copy the data in tables from server A to files on the AS400. The table structure on the server is the same as the file on the AS400(same column names). In other words, the source and destination columns are always the same. I created a DTS that has the following tasks: dynamic...more >>

I have a Script Transformation task in my SSIS package that nicely transforms some IBM date format into SQL 2005's date format. Works like a charm. I can't figure out how to make it return a NULL value, though. I know VB has its new handy nullable datatypes, but the script editor chooses the ...more >>

what does this error mean?!?!?!? I get this error when trying to create a file using dts. when I run the step singularly, it runs fine. when I run the whole package, it fails with "unexpected error from external database driver (9492)" I need an MVP to find out what is causing this problem, as...more >>

Hi, I have 10 .txt files in a directory and I want loop through the directory dynamically creating a table in SQL for each .txt file. Each text file has a different column list that's why it has to be dynamic. Thanks in advance, Tom ...more >>

I've been given the "honor" of being the guinea pig with a new installation of SQL 2005 to replace an aging database. The task is simple. I need to retrieve a table of ~12M rows from a remote TERADATA server and store it in a local table. I've built the package in development studio and i...more >>

I am getting this error using SQL 2005 SSIS: Error: 0xC002F363 at Xfer MRI, Transfer SQL Server Objects Task: Table "BUDGETS" does not exist at the source. Task failed: Xfer MRI But when I test the source connection it passes, and I am allowed to select "BUDGETS" in the 'objects to copy'.Ta...more >>

Hi, I posted this earlier today in the microsoft.public.sqlserver.programming group, but I've just realised I should probably have posted it here instead as it's probably more relevant to this group. So here goes... My problem is with a T-SQL statement, which itself is part of a DTS Data Dr...more >>

I may be missing somthing here but it appears the only way to get configuration information for a package into the SQL MSDB or FileSystem is to use the Package Installation Wizard. When I use the wizrd I get prompted to make changes to the configuration settings and then the dtsConfig files g...more >>

Hi is their any way around to copy a table from one database to another database on same server using store procedure not DTS thanks...more >>

Hi Think there's simple solution to this. How do you get ALTER SCHEMA dbo TRANSFER @currentTable to use the variable. I'm doing an updated version of an SP to change the object Owner/Schema and I don't want to use the now outdated sp_changeobjectowner Cheers Gary ----Old SP--- Cre...more >>

Hi, I need help in creating a DTS package. I have an excel spreadsheet that has a column of employee ids. i need to connect to an oracle database, pull employee information based on teh employee id and then dump it in sql server database. Does anyone have any suggestions on how to accomplis...more >>

I want to use SSIS to query AD and make the data available in data flow. I am using the "OLE DB Provider for Microsoft Directory Services" and I can get the query to parse, but get an error when trying to preview the data. This is the query I'm using: SELECT cn, distinguishedname FROM '...more >>

I have inherited a large number of DTS packages that have db logins/passwords hard coded in the global variables section. I want to change these to have the login/password stored in a central parameter table and have the packages look them up when they run. Is there a way to do this in Sql 2k?...more >>

Ever since installing SQL Server 2005 SP1, when using the Foreach Loop container in SSIS the Foreach File Enumerator and Foreach Item Enumerator are missing from the Enumerator drop down box. Anyone else seen this issue? and know how to fix it? Thanks, Mark...more >>

I am attempting to use the "Transfer SQL Server Objects" in the package designer for SQL Server Business Intelligence Development Studio to copy objects from a SQL 2000 server to a SQL 2005 server. When I attempt to run this step I recieve this output complete with the error message in my sub...more >>

When I run a DTS package and write a file to a drive, what security does the DTS package use to do this? I know it uses the SQL Server security to run the package but when it writes a file the SQL Server sceurity is no longer valid? Can some one help explain this? Thanks for your help -...more >>

Hi, I am expermenting with the SQL Server Import and Export Wizard in SSIS for SQL Server 2005 (Developer Edition) to import xml files, I have set my Data Source to be SQLXMLOLEDB.4.0 and clicked properties, then I have said where the file is that I want to import and set the information to...more >>

When I create a table in data pump, my source table has two guid columns that are transformed into varchar(8) when the destination table is created. why is this happening and how do I stop it? thanks! this happens when I use dbase 4 and dbase 5 drivers....more >>

I have a package that is supposed to export data to a foxpro.dbf file. There is one step that creates the export file by using the dBase 3 odbc connector and uses the sql "Create table" statment to create the file. I cannot get this to work. The error I get is "Unexpected error from external d...more >>

Hi I want to create a maintainance plan in 2005. When i right click and select 'new maintainance plan', it says error saying " can't find folder 'maintainance plan'". The maintainance plan wizard also gives the same error. where i need to create the maintainance folder. Thanks Swayam ...more >>

Hi, I'm calling a known-working DTS package from .NET but it is failing with the following error: "ERROR: System.Exception: COMException -2147220441 Execution was canceled by user. at DTS.Package2Class.Execute() at Diary.xadmin.ExportToAccessPage.ExecutePackage() in export-to-access...more >>

Suppose I have a large DTS package with a lot of step and a lot of dependancies. Say that it fails on step 25. I fix what ever the problem is that cause step 25 to fail. How can I restart the DTS package and have it begin processing on step 25?...more >>

Hey all.. I've written a stored proc to execute a particular DTS package, and that all works. What I'm trying to do now is trigger that process from an ASP page... the following code *should* work I think.. and if so, then what else might be keeping me from success???? HELP! (The driver login...more >>

Hello. From what I've read Configurations are the recommended way to pass connectionstring info to a package. I've tried this in two ways: 1) Directly populating the connectionstring property via an XML configuration file. 2) Populating the value of a variable (via an XML configuration f...more >>