Answer Questions

• Superobotz variables in data flow OLE DB

  I'm storing a sql command (could be an SP call or simple select) that I would like to pass into the "OLE DB Source" container in my data flow task. If I choose Data Access Mode: SQL Command from variable, I get an error saying there is a data source column with no name. I've fought SSIS pretty good up to this point. I realize you need to "initialize" variables & expressions in the control flow ahead of time if you want to access them in the data flow. But I was kind of hoping that all I would need to do in this case would be pass a SQL command into a variable and access that somehow in the data flow without jumping through any hoops. Is this possible This is a great forum btw, thanks, Phil ...Show All

• GMS0012 DataReader output column length

  Hello, I have an ODBC connection manager to a Progress database. In that database there is a column declared as a string of 10 characters long. However, some data in this column is actually up to 15 characters long. This makes my DataReader Source fail everytime I try to run my package because it sets the output column like this : Datatype : Unicode string [DT_WSTR] Length : 10 Is there any way to solve this without changing the datatype in the Progress database (that is beyond my control) tanks in advance ... Thanks for the suggestion, but that did not work. I also tried a query on the column in management studio (linked server) and that also did not work. OLE DB provider "MSDASQL&q ...Show All

• jam66 Blank Pages in report

  I am supporting a web based application (ASP.NET 1.1) that uses RS 2005 on the production server. I needed to change a report, I make my changes, it looks fine in the Developer Viewer and it exports fine to PDF on my PC. I have deployed it to the production server but when you pull the report within the application (PDF format) it has 3 additional blank pages on the end of the report. The report is the correct size. It does not excede the 8/11 page size including the margins, there are no hidden fields. The report does have 4 tables. I have even viewed the report from //localhost/reports on the server and it shows only one page and exports to pdf with one page. I have looked at all the postings that deal with Blank pages and nothing seems ...Show All

• Mr Teter Help-me merge replication

  Good morning. I have a big problem with merge replication. This a scenary. I have one database SQL 2000 in my server, and one aplication in PDA with SQL CE, but a read very turorials and always ask for a developer another aplication for a sincronization ! Exists one control in SQL CE for this []'s Sorry You're in the wrong place. try the Replication forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=90&SiteID=1 -Jamie ...Show All

• DotNetWhyNot Updating Multiple Table Names

  Hi I need to update one of the test databases: There are about 140 tables which don’t get used but I don't want to delete to I want to prefix them with 'x'. Is this possible or do I have to alter each one, one at a time Thanks Rich use sp_rename 'TableName', 'xTableName'  I use the following query to get the statements, then i will execute the output in another window.. Select 'sp_rename ''' + Name + ''', ''x' + Name + '''' From Sysobjects Where Type='U' Thanks for your reply, I will try that ...Show All

• Lucas Condé Union all does not union all rows

  Hi all, I have a Union All transformation with 4 inputs and one output when I debug the package the sum of the different inputs rows does not match the row count in output. I don't understand, I've used the Union All transform many times and I've never seen this. Any idea why this could happen That would not be a union all, would it That would be an ordinary union... Bart OK, here is the description of my Data Flow: 1. OleDbSource 2. Conditional Split with 3 outputs. 3. The first output goes directly to the Union All which cause the problem. 4. The second output goes to a Derived Column transform and then goes to the Union All 5. The thi ...Show All

• MeasleScar Problem with size of text of title of column.

  Hello : In a title of a column of a table, I put a too long text, with sorting, but when I spread (display) the report has a problem on text of the title of the column there. The probleme settles (arises) when I activate the sorting to post (show) the image of sorting. How to fit the size of the cell to the text   Thenk's. ....... ...Show All

• Rahul Saxena Determining a client IP in Reporting Services

  Is it possible to capture a client IP and use it as a parameter in Reporting Services I've been looking at using System.Web without success. ...Show All

• arsonist Use Variable as Table Name

  I am trying to write a stored procedure that accepts a table name as an argument and then displays all of the columns of the table. My code does not work and I don't know why any ideas set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [selectTable] @tableName varchar ( 50 ) AS select * from @tableName ; I get this error: Msg 1087, Level 15, State 2, Procedure selectTable, Line 5 Must declare the table variable "@tableName". Please help. modify these 2 lines... set @sql = 'select @t=max(id) from ' + @tableName ; exec ( @sql ) To answer specific to your question, you have to declare the ...Show All

• Scott Allison Last GASP on "Insert row in table with Identity field, and get new Identity back " ?

  While I have learned a lot from this thread I am still basically confused about the issues involved. .I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple. To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package. 1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful. 2. ...Show All

• bzoli Error: unable to retrieve column information from the data source

  Hi, I am trying to set up a data flow task. The source is "SQL Command" which is a stored procedure. The proc has a few temp tables that it outputs the final resultset from. When I hit preview in the ole db source editor, I see the right output. When I select the "Columns" tab on the right, the "Available External Column List" is empty. Why don't the column names appear What is the work around to get the column mappings to work b/w source and destination in this scenario. In DTS previously, you could "fool" the package by first compiling the stored procedure with hardcoded column names and dummy values, creating and saving the package and finally changing the procedure back to the actual o ...Show All

• IntMain Joined view does not contain all colums

  The joined view is named "dbo.viewExecView" and is like: SELECT Bank_No, data_center FROM [ALPHA\SQL2000].ev_db.dbo.Bank The new view that joins to the above view is like: SELECT bank.BankID, evBank.data_center AS DataCenterID FROM dbo.Bank AS bank INNER JOIN dbo.viewExecView_Bank AS evBank ON bank.BankID = evBank.BankID WHERE (bank.InactiveDate IS NULL) Note: The data_center column (an int) was recently added to the Bank table in the linked ev_db database and it shows up there. It also shows up in the view "dbo.viewExecView". It does not appear in the new view that joins to "dbo.viewExecView". And when I run the 'new' view, I get an Error Message: Invalid column name 'data ...Show All

• darknessangel Microsoft Participation in this forum

  The VSTS team have posted a really useful manifesto for their participation in MSDN forums which I have read here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=885414&SiteID=1 I'd like to politely suggest that the SSIS team do something similar on here. People have different expectations of what involvement Microsoft do/should have on this forum and it would help if Microsoft could clarify their position on this. -Jamie I agree, I'm confused as to the purpose of this forum - is it for MS SSIS experts to assist customers or simply for customers to help each other I too agree with the idea. Sharing your opinion -Tom Hi Everybody, Here is the perspect ...Show All

• mig16 Corrupt cubes in Analysis Services 2000 due to missing roles

  I have a Analaysis Services database with two cubes, shared dimensions and several roles defined (the cubes are small so the multiple roles do not use up all the memory). Unfortunatly I cannot open the cubes anymore. The editor gives an Error like: Unable to open the cube Financieel. An unexpected error occured. Please restart the application. I deleted all the rows, but still it didn't work. Then I tried to migrate the database to SSAS (2005). During the migration I got the error: The accountmanagers1 role referenced by the accountmanagers1 permission does not exist in the TestCube database. This role accountmanagers1 role is not available in the manage roles dialog. How do I repair these cubes ...Show All

• jortiz How to detach replication dbs?

  There are two databases on two web servers, db01 is on server01, db01_replica is on server02, db02 is on server02, db02_replica is on server01. db01 and db02 are both for one system. Each time after doing performance test, I have to recover databses. I copy the data files in a folder, try to use detach and attach to recover databases. But with two replication dbs, I don't know how to do it. The replication db should also be recovered. The situation is: my project is partitioned in two db servers, which all use SQL Server 2005. db01 is on server01 and has replication in server02, db02 is on server02 and has replication in server01. Each time there is a new build of the project, I have to do performance test for it. Unlucki ...Show All