Has anyone seen this before? Anyone know how to fix it? I'm getting pretty desperate and have found no info about this on any of several web searches. Sql Server 2005 SP 2 is running on Windows Server 2003, SP 1. When I installed SQL Server 2005 SP 2, all installations succeeded including SS...more >>

Hi, I have one problem. In SQL 2005 I have SSI package to export data to some excel files. I have for loop container with some job (one of the job is generate file name for exporting data and put the name into variable). My question is how I can dynamicly change Excel Connection Manager to p...more >>

Can anyone tell me how to access DTS properties (such as global variable values) via TSQL? Examples would be nice. Thanks ...more >>

Hey there! does anyone know a good site/documentation about the SSIS expression script language (e.g.: used in Derived Columns)? Thx, Chris ...more >>

Using Exchange Server 2003/Outlook 2003, we have created a custom Help Desk form in Outlook. We would like the ability to link specific fields from the Contacts Folder, in a drop-down list box if possible. We are far from knowing that something like this is even possible. Would appreciate *any...more >>

Which compontent can retrive multi-tables result from a stored procedure and save as XML which format same as ADO.NET dataset.writeXML? ...more >>

Hi All, I am looking to use DTS to manipulate data from a number of sources (access, oracle, etc.) and am looking for some direction as to best practices and gotchas that I should worry about. Do people recommend using DTS or is there a better way of doing this type of data import/manipulatio...more >>

Hi, I've got a big problem with SQL Server 2000 DTS and I hope that you could help me. I'm making a package (PKG A) calling an another one (PKG B) using =E0 Data Driven Query. When I run PKG B alone it works perfectly and there is no problem, that's perfect. But when I run it from the PKG A I...more >>

Dear all, Using DTS i'm transferring 3 tables (Just select * statement ) from database A and loading the 3 tables to database B repectively . I need the tasks to be set like this: 1) There should be only one source and one target in the dts designer sheet . 2) Every time before i load the d...more >>

Hello I am importing data from an Excel spreadsheet into a table, via DTS. I am trying to use a named range in the spreadsheet, and have used a script from Allan Mitchell to achieve this:- ' 243 (Excel Named Range) Option Explicit Function Main() Dim sActualLocationOfData Dim Exce...more >>

Hello, we execute packages from our windows-application. Some packages take a long time. Is it possible, to cancel packages programaticly? Would be very happy for any comment! Best regards Ralf Hedler ...more >>

I have written many DTS packages to move data, I've never had to branch in my workflow of tasks. I'm creating a package which has a log table. It runs four times a day. It will check the log table, if the package has already run, stop. If it hasn't run, go on with further processing. I'v...more >>

Is there an easy way to migrate the mainframe databases, e.g. ServiceCenter P4 or Model 204 to SQL Server. In general, they all can be called relational databases, but the data can not be migrated easily by using the database utility tools. Other than transfering to text or Excel, then to SQL ...more >>

I have a package that transfers data from a table in SQL Server to a table with identical schema in Oracle. This package runs fine when run from Visual Studio, but it fails when I set it up with a schedule in SSMS. Error message is: Execution of job 'Eksporter til Formula' failed. See the hi...more >>

I have to come up with a SSIS package to tranform data from oracle database to our sql server database. This oracle db is managed by a third party , I have been given 10 views from oracle so I can extarct information I need. How should I design my SSIS package? Do I have to have 10 different ...more >>

Call me stupid, but I need help. I'm converting from a Dbase5 file to SQL database. I have a "dbase5" connection for the source database and a "OLE ..SQL" connection to the destination database. Between the two connections I have a Data Transformation Task. I have a global variable called "...more >>

Perhaps somebody in this news group knows. In SSIS I have a foreach container thats got an filename enumeration collection of files in a directory stored in a variable I call FileName. Inside the foreach container, I have script task (vb.net) that I want to pass that FileName variab...more >>

Hi, I am asked to help a customer writing data to a table on an iSeries system. There is no ODBC source nor target in SSIS. But he can read using the DataReader Source via ODBC. But for writing? The DataReader Target only goes to memory. And what I am supposed to do then? Isn't there...more >>

Ive tried several ways to create a DTS package to import a text file into my SQL database from a remote web server (ip address). When i walk through the text file wizard I've tried the following paths for the connection but it keeps failing. My permissions on the webserver are ok because yo...more >>

Hello, I am trying to create a file name that puts in the current date and time at the time of creation. I am able to create it just fine without the date and time stamp but not with it. Can someone out there tell me what I am doing wrong? I keep getting a type mismatch error. I think the pro...more >>

Hi Guys, I have just moved from SS2000 to SS20053 and I can not find SSIS packages. I have created a SSIS package and I now want to modify it. Can anyone tell me where to look for SSIS packages saved on the server? TIA Peter...more >>

Good Morning, Has anyone successfully executed an SSIS package from within an MSMQ trigger? Environment - We are running Windows 2003, .NET Framework 2.0, and Sql Server 2005. Our trigger is written in C#. It has been registered using RegAsm. It is running inside Component Services (...more >>

Hi I have installed evaluation version of sql 2005 and i see that business studio is missing. I tried to reinstall but got the same result. Does anybody know what could be a problem? Gene....more >>

I'm exporting ( dts package) a query to a csv file, how do I get the column names in the file. I get the data but no column headings. Thanks in advance ...more >>

I am upgrading to SQL 2005. I have a VB script that calls a DTS package (shown below). Is there a way for a VB script to call a SSIS package? I have seen posts that mention adding a reference to Microsoft.SqlServer.ManagedDTS.dll in VB.NET and calling oApp.LoadFromSQLServer, but what about V...more >>

Quote from a book: Using (local) for the server name ensures that this package can be easily migrated from a development computer to a production computer without editing the DTS package, because this connection object will always attempt to connect to the default SQL Server instance on the c...more >>

Hi - I can't figure out how to tell the Flat File Connection Manager to use ETX (Hex 03) as the row delimeter. I tried typing {&h03}, but that didn't work. Does anybody know how to accomplish this? Thanks! B ...more >>

I have no experience of Oracle and have a little SQL Server knowledge. I am trying to connect to a Oracle 9i database managed by a (not very good) external vendor and hence have little knowledge of its inner workings. I have got as far as adding a new datasource in SSIS and would be grateful ...more >>

Hi Hi I have a package executed by SQLSERVER agent.It was executing fine over months now.It has failed over weekend with message. Executed as user: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1 DTSRun OnError: DTSStep_DTSOlapProcess.Task_...more >>

I am performing a query and an ASCII export within a DTS job. The conditions have been set for the export as Vertical line (PIPE) as the delimator and having a hard return at the end of each row. How can I put a vertical line at the end of each row. I tried forcing a new column with PIPE bu...more >>

Hello everyone, I can't seem to be able to add a reference to Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask Namespace in Sript Task because it just doesn't show up in the available components list. Any ideas? Thank you, Igor *** Sent via Developersdex http://www.develope...more >>

I want to run a DTS/SSIS package from web but we do not want a full web server on the SQL box to do this but still the ability to run the DTS/SSIS package from a HTTP connection. Please advice. Thanks Karen ...more >>

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug messages. The second, when equals 1, turns on the openning, fetching, and closing of a cursor. Things are fine if only one of the two parameters was...more >>

I have a problem, I am in the process of moving jobs and packages to SQL 2005 and I have a DTS package on SQL Server 7 that has been scheduled into a job. Unfortunately I have no idea what DTS package this job is running only an encrypted package name in the DTSRUN command, unfortunately this ...more >>

I wrote and deployed an SSIS package as a file system package (SQLServer 2005). I tried scheduling the package to run as a job step using SQL Agent Service Account with Windows Authentication and I have admin rights. It fails. I have tried a lot of things to get this job to run the package ...more >>

I used the file system right-click, Deploy menu choice on the file ..\bin\deployment\<prjName>.SSISDeploymentManifest and 4 of the 13 .dtsx files were not published into the MSDB database although the log file generated says otherwise. No configuration files were involved; authored .dtsx in fi...more >>

We have a production database on a SQL 2005 server. I need a copy of the data and the schema (if possible) to be copied to a SQL 2000 server we use for development and testing. I asked my SQL DBA to set up a DTS Job to do this every day at 4am, but my SQL DBA says you can't do this (incompatib...more >>

i've been looking on this subject in this group with no luck. i've been trying to import a text file which has multiple space delimited column to a SQL server 2000. i can't seem to find any answer on this subject. i tried typing space on the delimiter field, but i get "error source: microso...more >>

Please tell me how I can GLOBALY change the default error handling to just keep going. It is far more important that I get the good rows then stop on one bad one. This error is reported from the Data Flow Control Flat File Source. For some time, I have been changing fail on error to ignore ...more >>

hi, i have made a package in SQL SERVER 2000 and then execute it from vb.net the source file is .txt file and the destination is sql table. now the source file's path is to be given at runtime thru vb.net code. i used the following code: Dim dtsImport1 As New DTS.Package2 ...more >>

It has something to do with my workstation config, same package builds and runs fine on other boxes. Breaks when I try to build it on my workstation. Simple connection to database, text file destination, straight-thru transform. Problem is the destination for some reason lists no fields, and...more >>

Hi all, I want to call stored procedure from my DTS, after execute the SQL , i want to pass the global variable to ActiveX Script. However, the global variable in ActiveX Script only hold the default value Here is my stored procedure: CREATE PROCEDURE sp_test123 @TotalCountSum int OUTPUT...more >>

When I connect to Intergration Services, expand msdb folders, I can see my packages. However when use the database as in: use msdb go Select top 11 * from dbo.sysdtspackagefolders90 Select top 11 * from dbo.sysdtspackages I can see the folders from the first query but cannot see...more >>

Here is a good question for you senior DBAs. You have to DTS 20 million rows nightly from SQL 2000 to Oracle 9.2.0. How would you do it? Here is what I did and some timings. 20 million rows. SQL Server DTS using ODBC or OLE DB [took hours] ..csv to Oracle using ODBC [took hours] SQL ...more >>

Hi, I have read hard through both SQLDTS.com and this forum but still can't make it work together :). My problem is trivial. I need to transfer data from a number of identical MS Access mdb databases into an MS SQL Server db via DTS. I need to open the first mdb, transfer data, go to the s...more >>

When I enabled logging on a package, I was asked to give a unc path and filename. My options were (and still are) Create File Existing file Create Folder Existing Folder Ocassionally, I clean out the log files directory. So I option I look for is: If the file is there, append to it; if no...more >>

Hi I am trying to import a table from SQL Server 2000 (it got about 40 Millions rows) to SQL Server 2005 table, I am getting this error after transforming for about 1 hr. I used simple data flow task with default settings. Any help [SQL Server Destination [283]] Error: An OLE DB err...more >>

Hi all, I am hoping that someone out there might be able to help me with a requirement we have from our client. We want to use SSIS to import our client's data into their database. The issue is that the source file's column definitions may change. (For example, new columns may be added ...more >>

hi! i'm trying to copy a database from one server to another. but still problems persist. here are the details of my servers. Server A (source) OS - Windows 2000 Advanced Server SQL - SQL 2000 Enterprise Edition, Service Pack 4 Server B (destination) OS - Windows 2003 Server Enterprise ...more >>

I created a custom script source component to pull data from a dirty pervasive 2000i DB service pack4. Heres the problem my component will pull 425 rows of data but it will do this only if I set my deffaultBufferMaxRows property to a small number like 17. It will not pull more than 425 it h...more >>