Hi there, I have a large XML document (100Mg) that I want to process through a data flow process. Part of the process is to Sort the various relational tables created by the XML Source - then merge join them. The Sorts consume all the available memory and the process grinds to a halt. ...more >>

I’m experiencing a problem with a VB Script inside a DTS Package. When I run the task via the Package designer it runs fine. However, when I run the entire package the result is different. I need to be able to debug the VB script within the package. The script uses DTS global variab...more >>

We are attempting to use the Transfer SQL Server Objects Task to migrate tables (schema, indexes, triggers & data) from SQL Server 2000 to SQL Server 2005. It works fine if we are able to log into the source database as dbo but that is often not possible. The problem can be reproduced as...more >>

Is there a SSIS componet that can move data from one table to another (not copy but move)? ...more >>

Dear knowledgeable ones: For some reason, out of the blue, I am unable to schedule or run new jobs. However, old scheduled tasks continue to run. When I attempt to run a new job, I receive the following error: Microsoft SQL-DMO(ODBC SQLState: 42000) Error 22022: SQLServerAgent is not curr...more >>

I have 2 steps in my DTS, On Successfull completion of first step, second steps got error some data issue, after data is fixed I disabled step 1 through Disconnected Edit changed Disabled Steps value to -1 After above changes, when I execute DTS package, it says successfully completed but s...more >>

It there an easy way to 'clean out' a SQL Server database? I need to get a database of an unknown state back to a known state of 'empty'. Is there an easy way to drop ALL structures; TABLES, VIEWS, SPROCS, FUNCTIONS, INDEXES, TRIGGERS, CONSTRAINTS, etc. (Did I miss anything?) (I don't want ...more >>

I am trying to access the web service of SQL Server 2005 Reporting Services within a SSIS project in order to render a report. I have tried two methods to achieve this, and neither has worked so far. 1. I tried using the Web Service Task. After setting a connection to the report server (...more >>

Hi: Is it true that if you want to schedule a package on the server using SQL Server Agent, you have to be on the server? If you schedule it on a remote client it actually runs on that client, similar to running the package manually from the client. I always have to get clients to give me a...more >>

Hi - I'm pretty new to dts, but I've been able to import a few files so far. I tried to change the data access mode to "Table name or view name variable" (I'm importing an excel file), and then I provide the variable name that has the filename in it. I get this error: =====================...more >>

Hi, I need to load some excel files but they don't have the same number of columns, I know which one has the max amount of columns and I created a table that has enough columns to handle this one, Problem is when I try to load them I get an error, how can I have dts to automatically rema...more >>

I'm trying to load 35 million records using bulk insert. The bulk insert works fine in 2000 but fails in 2005. BULK INSERT [TESTDB].[dbo].[tblTEST] FROM 'C:\Test.Dat' WITH (BATCHSIZE = 10000, FIELDTERMINATOR='|', ORDER (Company_Code,Main_Account,Sub_Account,Location_Type,Location_Code,J...more >>

Hi NG! I was searching the web for an ActiveX-solution for counting columns in a row when importing a txt file with DTS. Can anybody provide some samples or useful web links? Thx a lot! Peter ...more >>

Hi NG! I'm trying to import some data from a txt file, containing in the first column a string and the others having (floating point) numbers: column1 column2 column3 column4 column5 column1 67 column3 column4 column5 column1 123 column3 column4 ...more >>

Hello I need to know how to execute tasks in DTS package base on a flag. Here is what I am trying to do: Read the value of the flag... If it the value is true, execute task A;otherwise, execute task B Thanks in advance Joann ...more >>

I'm using SSIS to pull data from a Unix based ERP system using an ODBC driver and keep getting the following error. [DTS.Pipeline] Error: The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine cal...more >>

I want to export my existing sql server 2000 database to a new ACCESS 2000 database. I don't want to export any data, but just all the table structures, and constraints and relationships between tables. Right now I use the export wizard to export all tables. But I get a copy of ACCESS with ...more >>

Hello, There is a Table T, which exists in two databases on different servers S1 and S2. I want to update all columns of T in S2 with the contents of T in S1, with a "Join" on identical Primary Key Columns. What kind of DTS-Task can I use, or have I to write a kind of ActiveX-Task for a tas...more >>

Hi, I have to import data from a hand made Excel file into a data base. The excel file is build by an other department of my company. As this process needs to be done many times, I build a SSIS package for it. My problem is the following: as the Excel file is build manually, Typos can happ...more >>

Hi to all, I know that i can just create a transform task to run a query and set up a destination file and dump the records that way. however, i want to do something similar through activex scripting as practice. I have figured out how to write to a file by creating a FileSystemObject. ...more >>

and scheduler jobs etc... is this simply a question of backing up 'master'? if not, any pointers would be greatly appreciated Regards and thanks in advance CharlesA...more >>

After I defined a transfer SQL Server object task in SSIS, I find there is no any object appears in destination database, could you tell me what configuration I must set? ...more >>

I've installed SQL 2005 - but I can't find the sample SSIS packages anywhere!! Does anyone know how I can download the SQL Sever 2005 SDK??...more >>

I am trying to pass a date paramater into a query of a DataReader Source, not an OLE DB database. I cannot get it to work, or actually know where to start. I am trying do something simple like this.. select * from table where datefield = MYDATEVARIABLE Is it possible to pass variables to...more >>

Hi, I'm using the following code to execute a DTS package from .NET: http://support.microsoft.com/?kbid=319985 However when I run my package from ASP.NET, only the OnQueryCancel event seems to fire. The OnProgress and OnError events do not fire. If I cause an error on purpose, a COMExce...more >>

If I want to run a DTS package from a VB.NET app. do I need SQL Server command line capabilities? My DBA, understandably so, does not want to give me xp_cmdshell. TIA, Marc Miller ...more >>

I have two connection objects (source and destination), one transformation task (task1) that imports data from source to destination tables. And I have an ActiveX Script task. The AxtiveX script task will loop through each table in a pre-defined list, and programmingly remove all existing t...more >>

I have a job schedule which run 10 DTS package using DTSRUN cmdexec ... Currently i enabled logging but it only show following for every dts : DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun O...more >>

In SqlServer 2000 I could copy objects and data between two databases. This was very convenient for manually syncing databases between development and production environments. In SqlServer 2005 this opportunity seems to have vanished. How do I go about copying objects, as well as data, between 2...more >>

I have a stored procedure that returns a smallint record and only one record. How can I get SSIS to read that field... I'm using Execute SQL Task... This is the stored procedure that I'm using which returns a record of 472: CREATE PROCEDURE [Lookup].[GetAppelleeStyleID] @StyleID SMALLINT ...more >>

I have SQL 2000 client tools and SQL 2005 express installed. I no longer have access to the SQL 2000 server, but need to design DTS packages. How can I design DTS packages without access to a SQL server? ...more >>

Hi All, I need to import an excel spreadsheet into a SQL Express 2005 DB...Please tell me how. Thanks. JN ...more >>

I use ActiveX script for data transformation. The source table and the destination table are exactly the same. For a table that has two columns, the following function works. ------------- Function Main() DTSDestination(1) = DTSSource(1) DTSDestination(2) = DTSSource(2) Mai...more >>

I have a DTS package that calls other packages as well. When I execute a package INSIDE the main package it causes an error, when I execute the subpackage by itself, works fine. Some of the subpackages contents have been modified. Any clue?...more >>

I'm in a new position, without documentation, and I am attempting to document the jobs and dts's. My problem, is that when I see the jobs, all of the DTS's id are encrypted (/~Z0x....). How do I identify the DTS from this encrypted id, without executing the DTS. Many Thanks, ...more >>

Hello. I am hoping that someone can help with a problem. We are upgrading servers and I want to transfer the DTS packages that currently exist on the old server to the new server. Can anyone point me in the right direction? Thanks, Dave...more >>

Hi All, We have a 3rd application that writes data to an Access database every hour. I wrote a DTS package to import this data just after the data is written. The package works fine when it's run in standalone mode (ie: executed manually), but when I schedule the package, I get the followin...more >>

In Visual Studio 2005, when I try to create a connection is a SQL Integration Service project. I get an error message connection manager not installed. can somebody help me on this?...more >>

I'm trying to import a text file into a SQL 2000 database. But my challenge is to make sure my customer doesn't import the same text file twice. The file does not have any unique ID. I may be able to make an unique key combined by 2 or 3 of the fields in the file. But how should I check agains...more >>

Hi All , I want to execute SSIS pakage through a web apllication. Please give me some pointers and idea , how to achieve this Regards Shagun...more >>

Hi All, I have recently installed SQL Server 2005 on a local machine , just to see what is different and how it all works and then I can debate on whether to upgrade from 2000, one of the things that I have noticed is there seems to be no DTS option, the only thing that I can find is the fa...more >>

I'm trying to get output parameter of this stored procedure from Oracle: CREATE OR REPLACE PROCEDURE TEST(L OUT VARCHAR2) IS BEGIN L:='111'; select 'HELLO' into L from dual; END TEST; But it gets "Parameter object is improperly defined" error, i am following the guide from this web pa...more >>

Following the instructions in books online, I created an Integration Services Package to copy a table from an oracle database to a sql svr 2005 one. In the package, i entered the oracle id and password in the oracle connection. For the package I chose a protection level of encryptsensitivewi...more >>

I am trying to redistribute SS2K DTS to a machine running Windows 64 Professional (dual Opteron) but am having problems registering the DLLs because it seems that some dependencies are not in place. Is it possible to do what I'm trying to do? I'm following this guide: http://www.sqldts.com/...more >>

Hello, Is it possible to change the servername in a scheduled job that executes a dts package? I have 2 sql2000 servers running and I want to move all databases from server A to Server B. I restored all databases, dts packages and jobs. (I've created the jobs using a exported sql script) ...more >>

Hi, Last week I began to use a new computer with Windows XP pro. Now I cannot use the SQL2K's EM to open DTS packages. I tried SP3 and later SP4 but it always says "Error occurred during creation of a DTS package". I know the ADO version is 2.8. Would you share your solution for this iss...more >>

I have to import 100+ tables from an ACCESS database into SQL Server database for unspecified number of times. The access database structure is exported from SQL Server DB, which means they have the same table names and columns. The imported data should be appended to existing SQL DB. Th...more >>

Can I create a row sequence number in a derived column transform?...more >>

Hi, I have a number of clients who all use SQL Server 2000 and are running my product. One of the clients is having a problem running one of the DTS Packages from my Windows application. The Windows app calls a stored procedure on the SQL DB that uses xp_cmdshell which in turn runs the DT...more >>

95% of my database size comes from a handful of large tables (as is typical). But in development, when I want to get at an old version of something other than those tables, I don't want to have to restore 50 GB. So I have another database which has everything the main database has, except the da...more >>