Would You Like The Ability To Hide Columns In The Pipeline?
Alot of people complain, legitamately, that they wish to remove columns from the SSIS pipeline that they know are not going to be used again. This would help to avoid the "clutter" that can exist when there are alot of columns in the pipeline.
If you are one of those people then click-through below, vote and (most importantly) add a comment. The more people that do that - the more likely we are to get this functionality in a future version.
SSIS: Hide columns in the pipeline
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=252462
-Jamie
View Complete Forum Thread with Replies
Related Forum Messages:
How To Hide Columns In A Matrix
Hi everybody, I've a big Matrix with 50 columns and 20 rows, I would like to hide the columns in 'real time' is it possible? for example: -col_1 -col_2 -col_3 -col_N row_1 a b c d row_2 a b c d row_3 a b c d row_N . . . . If we don't want to see the col_1 and col_3 , we can give a click and hiding, is it possible? maybe with the option 'visibility can be toggled by another report item' or expanded and collapsed option, some idea? Regards, Marcos
View Replies !
Hide Some Columns In Matrix But Not In Subtotal
Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% ‚¬ 217.763.099,50 ‚¬ 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 ‚¬ ‚¬ 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% ‚¬ 847.871.349,50 ‚¬ 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other way to show the "amount" and "amount class." in the subtotal without adding those values in the details are of the matrix. But when I select "Hide" in the properties those values are hidden in the subtotal as well. Is there any way to hide a value in the details area but not in the subtotals ? How can I achieve this ?
View Replies !
Hide Columns && Fields On Export
I have a couple of fields on a report which I do not want export to excel or PDF. They have links behind them to other reports which do not work in PDF and might confuse the users if excel Is there any way to prevent them from exporting? Thanks JPS
View Replies !
Hide Columns In Matrix Report
Hi, I have a matrxi report with 6 Columns (Col 1, 2, ...6). Based on the parameters I select I wanted to hide 3 of the columns (Col 2, 4 and 6. But the problem is when I hide the columns, it leaves a gap. That means, the matrix report shows Col 1, 3 and 5 with gap in between the Columns. There is no Column Visibility property in matrix report. Please help me as I am looking to solve this issue for a long time now. Thanks, S Suresh
View Replies !
Show/hide Report Columns
Hello, I'm currently investigating whether SQL Reporting Services might be the right solution to some reporting requirements I have been given (web reports). There is a requirement that some of the columns are hidden to begin with and can be shown by clicking on the header of one of the other columns. E.g. There is a list of clients and a "Total Revenue" column, clicking on the "Total Revenue" column header would show an additional 5 or so columns which show a breakdown of different figures that make up the total revenue. So my question is this: Is it possible to show/hide columns by clicking on the headers of other columns in the report? Thanks, Lachlan
View Replies !
How Do I Write Multiple Pipeline Buffer To Multiple Targets Based On A Calculated Value In The Pipeline Buffer
The scenario is as follows: I have a source with many rows. Each row has a column called max_qty_value. I need to perform a calculation using another column called qty. This calculation is something similar to dividing qty/(ceiling) max_qty_value. Once I have that number I need to write an additional duplicate row for each value from the prior calculation performed. For example, 15/4 = 4. I need to write 4 rows to the same target table as in line information for a purchase order. The multicast transform appears to only support fixed and/or predetermined outputs. How do I design this logic in SSIS to write out dynamic number of rows to a target table. Any ideas would be greatly appreciated. thanks John
View Replies !
Ability To Update SQL 7 Through ASP
Hello, My problem is this. I did a dts of my old access database to a new sql 7 db. I used Access 97 as the frontened and connected the two databases using linked tables. I made sure all the indexes and such were correct in the SQL database before linking + made sure all the security was corret. When I open a table in the access frontend that is linked to the sql backend, I cannot update or change any data even though I am part of the NT administration group which is given full permissions to the database. Any reason why?
View Replies !
Ability To Update SQL 7 Through Access
Hello, My problem is this. I did a dts of my old access database to a new sql 7 db. I used Access 97 as the frontened and connected the two databases using linked tables. I made sure all the indexes and such were correct in the SQL database before linking + made sure all the security was corret. When I open a table in the access frontend that is linked to the sql backend, I cannot update or change any data even though I am part of the NT administration group which is given full permissions to the database. Any reason why?
View Replies !
Using One SqlDataSource For Many DropDownLists, But Ability To Set Parameters?
If I have a lot of dropdowns of similar type but only differ in one field, is there a way to set parameters so that the dropdownlist can specify what the parameter values are? For example dropdowns: expenseaccount, incomeaccount, assetaccount SqlDataSource: SelectCommand="select accountid,accountname from accounts, accounttypest where accounts.accounttypeid=acounttypes.accounttypeid and accounttypes.accounttypename=? order by accountname" <SelectParameters> <asp:Parameter Name="accountTypeName" Type="string" /> </SelectParameters> ------- I would like expenseaccount to be able to specify "EXPENSE", incomeaccount to specify "INCOME", etc... Or is sqldatasource reusage bad practice? (damn vs2k5 colors)
View Replies !
Suggestions On Where To Jump-start One's Ability In Transact-SQL
Hi, Can some participants in this forum provide ideas on suggested training for somebody with a basic knowledge of SQL (started working in this field 6 months ago and still feel like a newbie beginner). I assume I should focus on getting T-SQL nailed down before delving into the SSIS piece of SQL Server 2005? Maybe there are a few companies that seem to give good practical knowledge and are located in the greater Los Angeles metro area? Is it better to get certified through a 1 week or 2 week course via companies like Trainingcamp - does that really give you the practical skills to jump up several levels at one does at work? Hope I can get some suggestions or direction on where I could best post this question for answers. Regards, Patrick
View Replies !
Pipeline
Hi, I want to incorporate this code but I dont know how to import Microsoft.SqlServer.Dts.Pipeline in an Integration Services Project template. I was thinking of putting this code in the script task but still, I cant import Pipeline. Add reference list does not have it as well. Please let me know how to incorporate this code. Thanks! Code: if (ComponentMetaData.RuntimeConnectionCollection["SourceFileConnection"].ConnectionManager != null) { cm = DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection["SourceFileConnection"].ConnectionManager); if (cm.CreationName == "FILE") { fileUsage = (Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType)cm.Properties["FileUsageType"].GetValue(cm); if (fileUsage == Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType.FileExists) { connectionString = ComponentMetaData.RuntimeConnectionCollection["SourceFileConnection"].ConnectionManager.AcquireConnection(transaction).ToString(); if (connectionString == null || connectionString.Length == 0) { throw new Exception("No file name specfiy"); } } else throw new Exception("Incorrect file connection usage type, should be set to exiting file type"); } else throw new Exception("Connection is not a file connection"); } else throw new Exception("Connection is not as assign");
View Replies !
Ability To Use Variables In Package Configurations And Set Their Values At Runtime
Hi, My scenario: I am using a FTP Connection Manager and the configuration setting for it is being set in the package configuration xml file. So the xml file contains the Ftpserver, FTp server username and password. The package is picking up the values from the xml file and is executing successfully. I have to do this because I was not able to provide an expression to the Connection Manager Server Password property. Now, I want to pick up the ftp details from a database table and set it in the xml file during runtime. Is this possible? OR something like using the <Configuration ConfiguredType="Property" Path="Package.Connections[FTP Connection Manager].Properties[ServerPassword]" ValueType="Variable"><ConfiguredValue>@[user::FtpPassword]</ConfiguredValue></Configuration> Kindly look at the items in bold. Is this possible? Then I can set the value of the variable in the package before the FTP connection manager task is executed. Thanks for all the help. $wapnil
View Replies !
Sql Server Express Loses Ability To Write To Database
After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation. The problem on one machine does not cause a similar problem elsewhere at the same time (hence it appears to be an issue with the relationship between the application and SQL Server) This does not appear to relate to the response to Q asked by sgcook on 9 may as we are not using user instances, but only a bare minimum connection string.
View Replies !
Split Pipeline
This is probably obvious, but how do I split a pipeline. I.e. I've got a data source with 200 columns - I need to split this into 20 pipelines each containing 10 of the original columns.
View Replies !
Lost Ability To Debug CLR Stored Procs After SQL 2005 Upgrade To SP1
OS: Windows XP Pro, SP2 SQL: SQL Server 2005 (Server 9.0.2047) SP1 VS: Visual Studio 2005 RTM.050727-4200 -------- After upgrading our SQL Servers to SP1 we have lost the ability to debug .net CLR stored procedures. The debugging process worked fine until we installed the Service Pack. All other features we use test out fine after the upgrade. The only and very important feature that does not work is debugging CLR procs. In fact this problem is happening in every environment we have. Be it SQL2005 running on Windows XP SP2, Windows Server 2003 SP1, Window Server 2000 SP4. SQL Server remote or local on the machine doing the debugging. All 5 developer workstations with Visual Studio in virtual machines or installed on in base OS are behaving exactly the same. Every developer on our team has the exact same problem regardless of their configuration after the upgrade to the service pack 1. All developers and environments were working correctly before the upgrade. Even building a new SQL box from scratch and installing all tools and creating a new clean database we fail with same error. We have verified CLR Debugging is enabled for the database connection. We have dropped the connection and recreated it. Here is an example of the output from the output window: This is the output up to the CLR call The thread 'sql_test2 [62]' (0x68c) has exited with code 0 (0x0). The thread 'sql_test2 [62]' (0x68c) has exited with code 0 (0x0). Auto-attach to process '[1072] [SQL] sql_test2' on machine 'sql_test2' succeeded. Output AFTER the CLR Call Auto-attach to process '[1072] sqlservr.exe' on machine 'sql_test2' succeeded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_32mscorlib2.0.0.0__b77a5c561934e089mscorlib.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSqlAccess.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_32System.Transactions2.0.0.0__b77a5c561934e089System.Transactions.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_MSILSystem.Security2.0.0.0__b03f5f7f11d50a3aSystem.Security.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'CIS_Release6a', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_MSILMicrosoft.VisualBasic8.0.0.0__b03f5f7f11d50a3aMicrosoft.VisualBasic.dll', No symbols loaded. 'sqlservr.exe' (Managed): Loaded 'C:WINNTassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll', No symbols loaded. Program Locks up with blank screen and hangs. If we stop the Debugging then the correct results will appear in the output window. Column1 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- <CIS><Header><MessageType>FosterParent</MessageType><Status>-1</Status><ErrorMsg><Code>-100</Code><Description>Requested Record Not Available</Description></ErrorMsg></Header></CIS> No rows affected. (1 row(s) returned) @RETURN_VALUE = Finished running [dbo].[qsp_FF_FD_FP_FosterParent]. Any ideas? TIA
View Replies !
SQL 2K5 SSIS DTS.Pipeline Errors
We have deployed an SSIS package successfully to production. We needed to apply SP1 to fix a different issue and now have encountered a new problem. We have numerous Data Reader Sources in different Data Flow Tasks that connect to a IBM iSeries (DB2) source. Pretty simple extracts that have worked fine in the past. They pump the data into staging tables on the SQL2K5 instance running the package (64-bit). After we applied SP1 however, all of the Data Reader tasks fail AFTER they successfully copy the records with the following error. [iSeries Invoice Details [1]] Error: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) If I delete the source and destination and recreate identical transforms, they work fine, but I don't feel like rebuilding all of the extracts. Any ideas! The problem occurs in all environments that we've tried. TIA, Michael Shugarman P.S. I just tried the SP2 CTP, but that doesn't fix the problem.
View Replies !
Remove Duplicates Within Pipeline
I have a situation where we get XML files sent daily that need uploading into SQL Server tables, but the source system producing these files sometimes generates duplicate records in the file. The tricky part is, that the record isn't entirely duplicated. What I mean, is that if I look for duplicates by grouping the key columns, having count(*) > 1, I find which ones are duplicates, but when I inspect the data on these duplicates, the other details in the remaining columns may differ. So our rule is: pick the first record, toss the rest of the duplicates. Because we don't sort on any columns during the import, the first record kept of the duplicates is arbitrary. Again, we can't tell at this point which of the duplicated records is more correct. Someday down the road, we will do this research. Now, I need to know the most efficient way to accomplish this in SSIS. If it makes it easier, I could just discard all the duplicates, since the number of them is so small. If the source were a relational table, I could use a SQL statement to filter the records to remove the duplicates, but since the source is an XML file, I don't know how to filter these out in the pipeline, since the file has to be aggregated to search for dups. Thanks Kory
View Replies !
DTS.Pipeline.1 In SQL Server 2008
Hi I have an existing application that programmatically builds SSIS 2005 packages. I'm trying to get to working with the February CTP of SQL Server 2008. Having changed all the 2005 references to 2008 references and things like IDTSComponentMetaData90 to IDTSComponentMetaData100, my application compiles okay now, but hits a problem when it tries to create a Data Flow task. The code which worked fine before (and seems to still be the recommended way in Books Online is): Code Snippet Dts.TaskHost myMainPipe = (Dts.TaskHost)container.Add("DTS.Pipeline.1"); However, this now produces the exception: Cannot create a task with the name "DTS.Pipeline.1". Verify that the name is correct. Should I be using a different moniker now? I took a stab at "DTS.Pipeline.2", but that didn't make a difference. Thanks, Andrew
View Replies !
DTS.Pipeline Information - Can I Access This?
Is there any way I can capture the below information? I want to capture this to get the no of rows processed by each transformation. [DTS.Pipeline] Information: "component "abc" (3798)" wrote 2142 rows. [DTS.Pipeline] Information: "component "xyz" (4223)" wrote 1026 rows. [DTS.Pipeline] Information: "component "abc2" (4324)" wrote 7875 rows. Thanks
View Replies !
SSIS [DTS.Pipeline] Error
Hi I have created a simple SSIS project on my client that carries out 4 Data Flow tasks, each one copying a few hundred rows from an Oracle 10.0.2 database. This works OK and will also run in debug mode fine. I have copied the package to the file system on our development server and get the following error when in debug mode:- [DTS.Pipeline] Information: Validation phase is beginning. Progress: Validating - 0 percent complete [OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Server.user" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [DTS.Pipeline] Error: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. Progress: Validating - 50 percent complete [DTS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Validation is completed [Connection manager "Server.user"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Error while trying to retrieve text for error ORA-01019 ". Validation is completed If you go to the source of each flow task and select preview you can retreive the data. Thanks Paul
View Replies !
Microsoft.SqlServer.Dts.Pipeline.BlobColumn
I am using Component Script to do - Transforming Comma-delimited list row data to column and I want to use MessageBox to see the value Dim DataPnts As String DataPnts = Row.DataPnts.ToString() -- this is my input column (data type = text in Source table and I put as Unicode string [DT_WSTR] in Output column) MessageBox.Show(DataPnts, "DataPoints1", MessageBoxButtons.OK) ---and why can't I see it. It gives me some message with Microsoft.SqlServer.Dts.Pipeline.BlobColumn. Why? Values = DataPnts.Split(CChar(",")) Please point me to more info on how to do transform Comma-delimited list row data to column. Thanks.
View Replies !
Understanding What This Dts.Pipeline ERROR Means
Im am pulling down table called PRV from another server throught an ODBC connection in my SSIS package. I have the source and destination task all set up. I get this error when i run the packag. Most of the time, the error is pretty self explanatory but this one is .....beyond me. Any ideas. Error: 0xC02090F5 at PRV TABLE FROM CYPRESS, PRV SOURCE [1]: The component "PRV SOURCE" (1) was unable to process the data. Error: 0xC0047038 at PRV TABLE FROM CYPRESS, DTS.Pipeline: The PrimeOutput method on component "PRV SOURCE" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. Error: 0xC0047021 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038. Error: 0xC0047039 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. Error: 0xC0047021 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039. Information: 0x40043008 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DF at PRV TABLE FROM CYPRESS, PRV Destination [4076]: The final commit for the data insertion has started. Error: 0xC0202009 at PRV TABLE FROM CYPRESS, PRV Destination [4076]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Arithmetic overflow occurred.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Arithmetic overflow error converting IDENTITY to data type smallint.". Information: 0x402090E0 at PRV TABLE FROM CYPRESS, PRV Destination [4076]: The final commit for the data insertion has ended. Error: 0xC0047018 at PRV TABLE FROM CYPRESS, DTS.Pipeline: component "PRV Destination" (4076) failed the post-execute phase and returned error code 0xC0202009. Information: 0x40043009 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at PRV TABLE FROM CYPRESS, DTS.Pipeline: "component "PRV Destination" (4076)" wrote 113136 rows. Task failed: PRV TABLE FROM CYPRESS
View Replies !
Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException
Hi I have a SSIS project that has one parent package and three child packages. When I run the project on my development machine in debug mode it works fine. Also if i run the packages using dtexec on my development machine it still works fine. However the problem comes in when I try and run the project using dtexec on the staging server i get the following error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer. does anyone have any idea how to fix this please? thanks G
View Replies !
Intercept Pipeline Events Programmatically
Hello, I'm wish to receive pipeline events fired by a SSIS package. I execute the package successufully with the following code (c#): MyEventListener eventListener = new XplorerEventListener(); DtsApplication app = new DtsApplication(); Package pkg = app.LoadPackage("c: est.dstx", null); pkg.Execute(null, null, eventListener, null, null); MyEventListener is inherited from DefaultEvents, overriding all OnXXX methods. It works perfectly, however I cannot intercept the following events: - PipelineExecutionTrees - PipelineExecutionPlan - PipelineExecutionInitialization - BufferSizeTuning - PipelineInitialization Anyone knows how to catch those pipeline events? TIA, Paolo.
View Replies !
Retrieves The Information About The Pipeline Components
Dear Experts, I can look the values of the proprieties in each PipelineComponentInfo, for example: ComponentType: Transform CreationName: DTSTransform.Merge.1 Description: Merge Transformation FileName: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMerge.dll FileNameVersionString: 2000.90.1049.0 IconFile: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMerge.dll IconResource: -201 ID: {08AE886A-4124-499C-B332-16E3299D225A} Name: Merge NoEditor: False ShapeProgID: UITypeName: Microsoft.DataTransformationServices..... but I don't know what means the proprieties: FileName, FileNameVersionString, IconFile, IconResource, NoEdit, ShapeProgID and UITypeName... Can anyone helps Me? Thanks Francesco
View Replies !
SSIS DTS.Pipeline To MSAccess Databse
I cannot get a simple package to execute a data pump to an access database from SQL2005. I have tried it in both SSIS and by running the Export data function. I have been able to write to this database in the past using dtp in SQL2000 but I am not able to write to it using SQL2005. What is the deal with the new SSIS? Does anybody have any ideas I can try to get my export to work. I have many more to do and I have to migrate over all of my SQL 2000 DTS packages to SQL2005 and some export to MSAccess. This is the only error message I can find: [DTS.Pipeline] Information: "component "OLE DB Destination 1" (2196)" wrote 0 rows. Edit: I found more errors in the debug section and a post here that discussed the problem as they had run into it. I was able to use part of that and some more research in order to tackle my problem. I would still be interested in finding out why I suddenly had this problem arise after I upgraded to SQL2005. This is going to be a real pain as apparently SQL2005 treats NULL as Zero Length and now all of my databsaes that had that set in access will have to be modified to deal with this in the export.
View Replies !
ReUse Common Surrogate Key Pipeline
I have several stage to star (i.e. moving data from a staging table through the key lookups into a fact table) ETL transformations in a single SSIS package. Each fact table has a different set of measures but the identical foreign key set, e.g. ConsultantKey, SubsidiaryKey, ContestKey, ContestParamKey and MonthKey. Currently I have to replicate the key lookup (Surrogate Key Pipeline, or SKP) for each data flow. If I could cache each dimension one time in the package and reuse it for each stage to fact it would be much more efficient. Is there a way for me to reuse a common data flow?
View Replies !
Small Necessary Changes Missing In SP2. Any Idea If This Is In Pipeline
1. i find it hard to believe that I cannot use stylesheets for textboxes or for that matter anything. I have to manually go and edit every textbox. 2. I have to define at t global level if a link opens in a new window or same window. Anyone has ideas if this is even in the pipeline to be done?. I had asked the same questions on the release of SQL Server RS and that time it was thought that it would already be there in SP1/SP2. But i do not see it. Or anyone has ideas how to achieve the above?
View Replies !
Transformation Object To Filter Data In Pipeline
Hi, I have some data coming through pipeline and I wanna add some component at some point to pass on only selected rows based on conditions to the objects onwards. My opinion is I should use conditional split object, but Please suggest me something if you know better. Thanks, Fahad
View Replies !
How To Update A Dimension Column With The Pipeline Tasks
I have been working with DTS and ETL in data warehousing projects for several years and my question is this. You can only update a dimension column with SSIS by using TSQL-update statements. There is no way to do this except issuing TSQL from the control flow or the data flow? This subject is not mentioned in Wrox SSIS book nore in Kirk Haseldens book. When you run the SCD task in the data flow you will get an OLEDB command that actually do this, issue a TSQL-statement. Is this correct? Regards Thomas Ivarsson
View Replies !
[DTS.Pipeline] Information: Pre-Execute Phase Is Beginning
Hi, I have a SSIS package which pumps data from one server to other without any additional steps. There are 11 tables for which data is transferred. And this packages runs fine on two different environments but fails in one environment i.e. on SIT. It doesn't throw any error and every time stops at the below step [DTS.Pipeline] Information: Pre-Execute phase is beginning. Progress: Pre-Execute - 0 percent complete Progress: Pre-Execute - 1 percent complete Progress: Pre-Execute - 2 percent complete Progress: Pre-Execute - 3 percent complete Progress: Pre-Execute - 4 percent complete Progress: Pre-Execute - 5 percent complete Progress: Pre-Execute - 6 percent complete Progress: Pre-Execute - 7 percent complete It doesn't complete neither throws an error. Any pointers on what the problem could be Thanks
View Replies !
Imports Microsoft.sqlserver.dts.pipeline Does Not Work
I have been trying to follow/implement the examples in the following help topics (thanks to Jamie for these links). Building Packages Programmatically (http://msdn2.microsoft.com/en-us/library/ms345167.aspx) Connecting Data Flow Components Programmatically (http://msdn2.microsoft.com/en-us/library/ms136086.aspx) The problem I am having is that MainPipe is not recognized as a valid type in my Script task, even though I have the imports statements that are listed in the example. I get the message "Error 30002: Type 'MainPipe' is not defined". The other and related problem is that when I type "imports microsoft.sqlserver.dts", the intellisense offers only two choices: {}Runtime and {}Tasks. I don't see any choice for Pipeline. Can anyone tell what I am missing? It seems to be some kind of configuration/installation issue, but I have no idea how to resolve it. I have tried this on 3 different machines, with both the RTM SQL 2005 standard edition, and with SP2 installed, all with the same result. Any help is appreciated Here is my code: ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.wrapper Imports Microsoft.SqlServer.Dts. Public Class ScriptMain Public Sub Main() ' Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ New Microsoft.SqlServer.Dts.Runtime.Package() Dim e As Executable = package.Executables.Add("DTS.Pipeline.1") Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType(e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType(thMainPipe.InnerObject, MainPipe) Dts.TaskResult = Dts.Results.Success End Sub End Class
View Replies !
Adding Column Attributes For Custom Pipeline Component
I'm building a custom transform component. I want to mark some input columns as keys for deduplicating. In a similar way to the provided Sort component, I want to check those columns and allow pass-throughs (or not) for the others - so next to each input column name I need two checkboxes (1:use for dedupe; 2:include in output if 1 not checked). If a column is checked for use in the dedupe, I want some other attributes to be shown indicating how it will be used. How do I display the checkboxes to let users select which columns to include for deduplication, and then how do I add further attributes underneath (copying the Sort component's look) for selection? Thanks in advance for guidance and pointers on this.
View Replies !
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer Column Ordinal From Name?
Hi, I need to access columns from a data flow by ordinal position in a script transformation (I'm parsing an excel file which has several rowsets across the page). The first problem I encountered is the generated BufferWrapper does not expose the columns collection (i.e. Input0Buffer(0) does not work) but I got around that by implementing my own ProcessInputs(InputId, Buffer) method instead of using the wrapper. My problem now is that the column ordinals are in some random order (i.e. Column "F1" is ordinal 1 but Column "F2" is 243). Where in the object model can I map between the name and the ordinal - it's not jumping out at me? Dave PS Why is the script editor modal, it's frustrating having to switch between the Visual Studio environment and the VSA one.
View Replies !
RS2k Issue: PDF Exporting Report With Hidden Columns, Stretches Visible Columns And Misplaces Columns On Spanned Page
Hello: I am running into an issue with RS2k PDF export. Case: Exporting Report to PDF/Printing/TIFF Report: Contains 1 table with 19 Columns. 1 column is static, the other 18 are visible at the users descretion. Report when printed/exported to pdf spans 2 pages naturally, 16 on the first page, 3 on the second, and the column widths have been adjusted to provide a perfect page span . User A elects to hide two of the columns, and show the rest. The report complies and the viewable version is perfect, the excel export is perfect.. the PDF export on the first page causes every fith column, starting with the last column that was hidden to be expanded to take up additional width. On the spanned page, it renders the first column on that page correctly, then there is a white space gap equal to the width of the hidden columns and then the rest of the cells show with the last column expanded to take up the same width that the original 2 columns were going to take up, plus its width. We have tried several different settings to see if it helps this issue or makes it worse. So far cangrow/canshrink/keep together have made no impact. It is not possible to increase the page size due to limited page size selection availablility for the client. There are far too many combinations of what the user can elect to show or hide to put together different tables to show and hide on the same report to remove this effect. Any help or suggestion on this issue would be appreciated
View Replies !
MS SQL Server 2005: Collect Procedure For &&"dts Pipeline Generate Error
Dear experts, My MS SQL Server 2005 is generating the following error. may i know what's wrong with it? " The Collect Procedure for the "DTSPipeline" service in DLL "XXX:Program FilesMicrosoft SQL Server (x86)90DTSBinnDTSPipelinePerf.dll" generated an exception or returned an invalid status. Performance data returned by counter DLL will be not be returned in Perf Data Block. The exception or status code returned is the first DWORD in the attached data. " Thanks in advance for any assistance rendered. pat
View Replies !
Is There A &"user Defined Row Type&" Ability In MSSQL Server?
Hi all. We have a mix of informix and mssql server and I want to know if something we do in informix has an analogous feature in MSSQL. We can define a "row type" in informix, like so: create row type name_1(fname char(20),lname char(20)); The when we create any table that includes a first and last name, we do so using this row type like so: create table sometable(name name_1, some column,...etc) This allows us to set a standard for certain common fields and avoids having different developers build the same type of field in more than one way, different lengths, etc. Is there a similar function in MSSQL server?
View Replies !
Delay Between CREATE DATABASE And Ability To Connect To That Database
I have an application that creates a new database during installation,and I've noticed some strange behavior. Once I've created thedatabase, I am able to immediately create tables and populate lookupdata, provided I remain connected to the server. If, however, Idisconnect and attempt to reconnect immediately, I'll get an errorsaying that my login is invalid for the new database.I can get around this by having my code simply wait 5 seconds beforeattempting to reconnect, but I'm curious to see if anybody here cangive an explaination for why this is happening. Here is a bit ofpseudo code to explain what I'm seeing:open new connectioncreate databasecreate tablespopulate tablesclose connection// open new connection /* can't do this yet, as it would break */for (int a=0; a<5; a++){Thread.Sleep(2000)try{open new connectionbreak;}catch{Debug("still waiting...");}}Running my version of this code, I'll see that "still waiting..."message go past 2-3 times before SQL Server wakes up and realizes thatI'm allowed to connect to it. Anybody know why?Thanks,Jason KesterExpat Software Consulting Serviceshttp://www.expatsoftware.com/---Get your own Travel Blog, with itinerary maps and photos!http://www.blogabond.com/
View Replies !
Does MSSQL Have The Ability To Do &"named Row Types?&"
Hi all. We have a mix of informix and mssql server and I want to knowif something we do in informix has an analogous feature in MSSQL. Wecan define a "row type" in informix, like so:create row type name_1(fname char(20),lname char(20));The when we create any table that includes a first and last name, wedo so using this row type like so:create table sometable(name name_1, some column,...etc)This allows us to set a standard for certain common fields and avoidshaving different developers build the same type of field in more thanone way, different lengths, etc.Is there a similar function in MSSQL server?
View Replies !
Pipeline Error-excel Source-data Reader Does Not Read In Meta Data
Hi all, i got this error: [DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". and also this: [Excel Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Fiscal Week" needs to be updated in the external metadata column collection. The column "Fiscal Year" needs to be updated in the external metadata column collection. The column "1st level" needs to be added to the external metadata column collection. The column "2nd level" needs to be added to the external metadata column collection. The column "3rd level" needs to be added to the external metadata column collection. The "external metadata column "1st Level" (16745)" needs to be removed from the external metadata column collection. The "external metadata column "3rd Level" (16609)" needs to be removed from the external metadata column collection. The "external metadata column "2nd Level" (16272)" needs to be removed from the external metadata column collection. I tried going data flow->excel connection->advanced editor for excel source-> input and output properties and tried to refresh the columns affected. It seems that somehow the 3 columns are not read in from the source file? ans alslo fiscal year, fiscal week is not set up up properly in my data destination? anyone faced such errors before? Thanks
View Replies !
&&<Data&&>Microsoft.SqlServer.Dts.Pipeline.BlobColumn&&</Data&&>
I have a custom (dataset) destination component from ms samples and it has an input holds DT_NTEXT value. Whenever I try to retrieve data from this it returns "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" as value. I try this but didn't work: String sValue = System.Text.Encoding.Default.GetString(Convert.FromBase64String(this.dataSet.Tables[0].Rows["Data"].ToString())); It throws an execption "invalid character in.." Please help how I can convert this? Thanks in advance
View Replies !
|
TRACKER
