I've got a delimited text file that aprox 5.5GB that I'm trying to load into a table on SQL 2000 (Windows Server 2003) and I keep getting the error "Not enough storage is available to complete this operation." Changing the commit size doesn't seem to make a difference, but when I changed a co...more >>

(Re-Posted from another site with permission, since I have the same problem and he stated the issue well:) -- David Walker Kirk Shanks Uploading Text File with Header and Trailer Records I have bunch of records to upload that has trailer and header records from which I need to c...more >>

I am having trouble with the pivot transform. My desired results are not quite like the examples I have seen in the Help, and I am wondering if the pivot transform is the right tool to use. I have source data that is similar to the following: Customer BankName BankRole ABC C...more >>

In SSIS, what toolboox item can I use to pull the disinct rows from a flat file that has repeating data. I am trying to do this without importing the data into staged table then use tsql to pull distinct values and load the production table -- BrettVP...more >>

SQL Server 2000 SP4. I built a large DTS package that grabs a number of tables from an Oracle DB, does some scrubbing, updates, and date verification and loads to a SQL Server DB. Most of the tables are full refresh and a few are incremental. Main DW: DwSQL Staging Area: DwLoadAreaSQL ...more >>

I am running SQL Server 2005 and trying to make a copy of a database from Management Studio. Using the Backup wizard I go through all the steps that you would normally walk through to make a copy, and actually start the copy, but when I do I get the following error message from the copy datab...more >>

Hi, I am using a foreach loop to go through the .txt files inside a folder. Using a variable I can pickup the filenames the loop is going through. At present there is a sql task inside the foreach loop which takes the filename as a parameter and passes this filename to a stored procedure. Now ...more >>

Hi, I am going to use the SQL Agent to schedule my SSIS Job. However, I only want my SSIS Package to run if a flag in a table has been set. This flag is set by another job/process which someone else in my company developed. Can I set up my job within SQL Agent to check this flag? If...more >>

I'm Using a VB Script (ActiveX Script Task) to create a connection and a = recordset to a specific database in the local server. I dont want to name the server explicitly in the connection string = because the DTS package would be installed in another server with = another name. How could I ref...more >>

I last developed SSIS in Oct 05 and this bug was a major irritant. 18 months later I'm revisiting the same deployment and it's annoying me all over again. I'm wondering if one of the service packs has fixed it in the meantime? Thanks in advance David...more >>

I create a Execute task that sets a boolean value of whether or not to continue the processing of the package How do I evaluate that variable to determin whether to continue of fail. In DTS I would have written and ActieX script and giving it a status code but I do not see the same function in...more >>

Background of the problem I am encounting: In a SQL 2000 DTS package, I created a ActiveX script task with the following code (simplified version). I want to copy a string and paste it to the clipboard, and this task is executed as the last step in the package. The problem is when I execute...more >>

Hi, I have a SSIS Package that uses SQL Server to store the config data. When the package executes I get these warnings (16 of them) there are 8 config keys. If there are 14 config keys there are 28 warnings. In Visual Studio they are printed in chinese! I have deleted the config and re ...more >>

I have a server that had SQL agent working on it, and running scheduled jobs on set interval forever. Windows Server 2003, SQL 2000, most current service packs on both. I installed an instance of SQL 2005 on this server. Now, when I look at Enterprise Manager & try to see what's happening ...more >>

Hello, I have a Pipe ('|') delimited Flat File having Nested records into it. Can I handle i.e. pull data from such files into SQL Server using SSIS? The Flat File is as follows: ------------------------------------------------------------------------ BHR (1) Batch Header Record PRD (...more >>

Hi is it possible to set *.TXT;*.DOC;*.XLS in the files: textbox i Foreach Task Component ...more >>