I am trying to create a deployment utility for a solution using a single package configuration file shared across packages. when I try to build the solution to create the deployment utility, the build process fails saying that the package configuration file already exists.... Any ideas ...
Is this possible? It seems when I try and do this manually or via an SSIS task it does not work whereas it will be fines with other editions. (I'm using my local developer edition as a test environment) ...
We have a very large number of SSIS jobs that are scheduled every evening/early morning to run in succession. These jobs populate and update large amounts of data for our production systems. Recently, we have begun receiving an error message on different jobs at different times. So far, it has been impossible to reproduce on a consistent...
I am receiving an Excel Worksheet file (ver 2.1) from one of our clients as part of a weekly date update. I am trying incorporate it into our automated update process, but I can't import the file in SSIS (or Sql Management Studio) as the oldest format I can process is Excel 3.0. Is there an update that will add support for this older f...
I'm currently developing an ETL solution which, for various reasons, include SSIS components as well as J2EE services. I need the various components to communicate asynchronously via messaging queues. However, the obvious constraint is that SSIS only integrates with MSMQ while it obviously makes sense to use JMS on the Java side. I h...
I've created a derived column that translates a 1 to an 'M' and a 2 to 'F'. i.e. a gender indicator. The derived column feeds into a Fuzzy Lookup transformation and then to a conditional split. The problem is the derived field does not show up in any of the downstream components. In the Fuzzy Lookup transform the "Pass Through" check...
We have an MS Access database that we want to migrate to a SQL Server Database with a new DB design. A part of the application that uses the SQL Server DB is already written. I looked around to find out how to do the migration step most easily and started with Microsofts SQL Server Integration Services (SSIS). Now I have gotten to the p...
I want to populate a fact table (dbo.FactResellerSales) in AdventureworkDW in SQL server 2005 from data in adventureworks and data in dimensions in AdventureworkDW. How should I go about populating measures in the fact table? ...
I have a project where a significant piece of the pie will be to identify where a record is duplicated in the database (Sql Server 2005). I know the obvious ways to find a duplicate record. However, in this case, we want to be fairly smart about the process. The table(s) will contain information about a prospective customer(lead). Th...
How do I debug .NET code written within a script task in a SSIS package? The development environment allows placing a breakpoint however does not take me to the code like it would in regular .NET programming while debugging. Also, I am at a loss to understand how to add the SSIS package variables to the debug watch window? Currently on...
I have a SSIS package that has a child package that is failing. The error message isn't very helpful. The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020 The problem seems to be I am running out of Virtual Memory to complete the job. I found a forum thread that may help solve the problem. http:...
Hi... I want to run a SSIS package in command prompt... for that i used the command dtexec/f "C:/Filename.dtsx"...but when i executethis command i am getting an error like "Product level is insufficient for the component "Data Conversion"... but when i run the SSIS package in BIDS,it executed successfully... y is that?? is it because o...
I have two foreach file containers in a package. Both has the same settings except they have different names: One is called "Foreach Availability File" and the other is called "Foreach Communication File". The first container "availability" goes through 1 iteration (I can see this through breakpoints) the second "communication" does no...
Hi, I have developed a custom control flow task component, just want to check if there is any specific process or way in which if we redeploy the second/later versions of the component then we need not reset toolbox and add the component manually to the Toolbox? As of now if I make any changes to the custom component and redeploy, I hav...
Hi I'm trying to insert in a ole db destination the result of a sp for each record in an ole db source, the sp returns a record set I have found this how to call a stored procedure in SSIS but i still can't see the outpout columns in OleDb Command Output Columns here is my sp: create PROCEDURE [dbo].[GetData] ( @user varc...
I'm using the export data wizard in sql server 2005. I've got a table with null values in many of the fields. I'd like to keep these fields as I export to .csv but they are being replaced with empty strings. I've tried changing the 'nullable' checkbox for the fields in the wizard, but that doesn't seem to do anything. Also tried usin...
Hi, I am stuck with something really nasty here. I have a SSAS Cube that was working fine till day before yesterday. Had some performance issues on the server and got cummulative patch 938077 on top of Service Pack2. Since then I have not been able to deploy the cube - with a strange error - File System Error: The following error occu...
Hi, I'm trying to add new output column using synchronous custom data flow component(below is the code). While testing I found that input columns I added are not getting displayed in Output columns only the new added column is getting displayed. I'm not sure where problem is. Please help! Public Overloads Overrides Sub ProvideCompo...
We have a situation where we are importing a number of files with the same format, using the same SSIS package. The package is being loaded and executed from a .net assembly. Currently the package is being reloaded for each file. I would like to load the package once during the initialisation of the .net process, and then execute it f...
Our packages are randomly failing with the following error message: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8004D00A. COM error object information is available. Source: "[Some Package Name]" error code: 0x8004D00A Description: "The SSIS Runtime has failed to enlist the OLE DB connection ...