MS SQL Server :: Retrieves The Information About The Pipeline Components

[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 !

Need Help With A Query That Retrieves DEFAULT Constraints
Hi guys,

I am trying to write a query that seaches for all DEFAULT constraints in a database and prints the column with the default value, the value of the default, and the name of the default constraint.

So far I have the two queries that let me get all the information I need.

SELECT Name FROM sysobjects
WHERE xtype = 'D'

SELECT column_default, column_name FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_default IS NOT Null

I am unable to merge them into one query. I cannot seem to find a commun field to both of them.

Many thanks in advance.
Darkneon

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 !

Developing Custom Components By Extending The SSIS Stock Data Flow Components
Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.

But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.

View Replies !

Using Composition To Create New Specialised Components From Multiple Sub-components?
Hi,

In another thread Jamie Thomson very informatively said "The components in SSIS
are deliberately atomic (i.e. they do something very specific) so that
its easy to put them together to build something greater than the sum
of the parts". Which does make a lot of sense. However, I've been finding that I end up having to create exactly the same "pattern" of combined transform components again and again in order to solve the same problem but in different dataflows (or even within the same dataflow). Cut-and-paste-tastic! In order to obtain real re-use, it seems to me like SSIS is crying out for an easy way to create new components by using composition - i.e. the ability to take commonly-used combinations of existing components and create new "super" components (without having to write Custom Transform Components in C#/VB.Net and handle everything in code).

Does anyone know if this sort of functionality is likely to make it into SSIS in the forseeable future?

Regards,

Lawrie

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 !

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 !

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 !

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 !

Logging In The Data Flow Pipeline
Hi,

Does anybody have any experience implementing logging within a data flow task? ie. logging timestamps for SCD component start and finish times.

Thx

tony

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 !

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 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 !

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 !

DTS.Pipeline: Validation Phase Is Beginning.
Hi, My package hangs and the log says DTS.Pipeline: Validation phase is beginning. Any ideas why this is happennig? This same package runs fine when I run it without turning on the transaction.

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 !

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 !

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 !

SecurityException Class &&"SQLServerDatabaseMetaData&&"'s Signer Information Does Not Match Signer Information Of Other
Hello,

I have some troubles with IBM WebSphere Application Server using MS SQL Server 2005 JDBC Driver. I always get the error e.g.
java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData"'s signer information does not match signer information of other classes in the same package

I found this Feedback but it seems to be closed.

A temporary solution for me was to delete the meta-inf directory of the JAR-File, but that can't be the solution.

Can anyone help me with this problem?

Simon

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 !

Can't Find SQL Server: SSIS Pipeline Performance Object In Perfmon For 64-bit Server
I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why?

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 !

Job Won't Run, All Components Do
Gurus,

I have a job that contains a step to run a DTS task (DTSRUN /S.....etc.) via a batch file.

I can run either the DTSRUN command line, or the batch file that contains it just fine,
but when I try to run the job, it reports success but does not actually do the work.

I dont get an error message. I am using the sa account to run the DTS task from the command line.

I know this must be a permissions issue. As I am working at a Defense contractor, I cannot get a
domain admin account to run SQL Agent.

Any ideas where to look?

Kevin

View Replies !

SQL 7 Components
Hi,

How can I tell whether I have SQL Server 7 Components on my computer?

Thanks,
Denise

View Replies !

SQL Server Components
Can any one give me brief useful explanations or guide me to a usefulresource of what Development Tools component and Profiler are?Is there anything I should be aware of if I want to install ClientConnectivity component (don't want to overwrite anything)?Thank you in advance.

View Replies !

Custom Components On 64-bit
Hi again, All!!

I'm having a problem with problems with some custom components I built. I have a custom Connection Manager and Data Flow Source that I have built.

My local PC is 64-bit, but I followed the MS instructions on building and deploying custom components. They run fine inside of VS2005, as long as I have 'Run64BitRuntime" set to 'False'. When I try to run packages using the custom components in 64-bit mode, I get:

Error: 0xC0014005 at : The connection type "<MyConnectionManagerType>" specified for connection manager "PRI" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

I suspect I need to either change the way I build or deploy the custom components. Can someone shed some light on this?

Thanks,
Frank

View Replies !

GACing Components
Hi, help please!!

View Replies !

Invisible Components
I am not sure why when the packages are run, the components dissapear. The only thing I see is the result in the output.
So there is no visual on the tabs.
Thanks

View Replies !

Where Are My SQL 2005 Components?
Hi,

I have a SQL 2005 Ent server on Windows 2000 Ent server with SP4. After I applied SQL Server 2005 post-SP1 hotfix 918222 (Build 2153), the SQL server still running OK and I can see it in Control Panel/Services and I can manage it through SSMS. But I starting noticed that there is no entry in "SQL Server 2005 Services" when I open SQL Server Configuration Manager. If I use Surface Area Configuration tool then I will get an error say "No SQL Server 2005 components were found on the specified computer. ......". I know I am a local admin and have SA rights for that server. Can someone help me to get it back?

Thanks in advance.

Austin

View Replies !

Components Installation
I am just a novice, and am curious.I

I was trying subscription, but an error occured: "Microsoft Server Management Studio is un able to accessreplication components because replication is not installed on this instance.

I went to change, located my setup exe, installed. but at the end, I get this message: No selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine......

I downloaded the Express edition via MSDN download.

May somebody please help? What wrong did I do? What did I miss to do?

View Replies !

SSI And Other Components Don't Install
Hi

I have installed SQL Server 2005 but Integration Services is just not there. I have uninstalled and reinstalled several times and in the process uninstalled an old version of Visual Studio.NET (manually because it wouldn't uninstall automatically) and Visual Web Developer, just in case they were interfering with Integration Services. No luck, in fact it got worse, now Analysis Services also does not work because it can't find devenv.exe!

I have installed exactly this same software on another clean PC (ie. no previous Visual Studio variants on it) and it installs perfectly.

There seems to be some kind of clash between old versions of Visual Studio and SQL Server 2005 that prevents SQL Server from properly installing products like Integration Services that use the Visual Studio interface (ie. devenv.exe).

I now can't even reinstall the old version of Visual Studio.NET, and devenv.exe is nowhere to be found on my PC although it is referenced throughout the registry.

Has anyone got any suggestions, all I am after if a full and clean install of SQL Server 2005 so I can develop against it using Visual Web Developer.

Thanks

View Replies !

Sql Client Components
I have a question about client components. I read someplace where if sql client components are preinstalled
(if you delete sql express-client components cannot install, even if they are preinstalled

I have sql express default installation from vs 2008 pro
I have not installed sql express (client components, database components
I wish to install cd standard edition on my computer for reporting services
Also wanted to add enterprise server so I need report manager
office 2007 installed by myself. I came across this article kb909967.
Is there anyway to check make sure I can install client components installs on standard edition
I also read kb 964164 installing sql on vs 2008 vista ultimate Thanks

View Replies !

Adding Components
We're currently trying to install CRM 4 on an SBS 2003 R2 server.

As a requirement we had to install SP2 for SQL 2005, which went fine We're now getting the following errors;

The word breaker for language 1033 is not installed.
The full-text component is not installed on the specified SQL server.

I try to add these components by running the sql setup again but it complains with the following;

- Edition Change Check (Warning) Messages
Edition Change Check

To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

I'm guessing this error comes up as the cd isnt at the sql sp2 level and from what i read you can not slipstream sp2 into it. So whats the best way to go ahead with this.

View Replies !

Server Components Can't Be Installed
I have a Windows XP machine that I have run SQL Server on in the past.I recently re-formatted the hard drive and re-installed XP from scratch,and now when I try to re-install SQL Server 2000, I get an error messagesaying that the "server component is not supported on this operatingsystem. Only client components will be available for installation." Ihave a hard time understanding why the server components can't beinstalled on XP, especially since I've installed them before on thissame machine.Can anyone explain why this might be, and what I can do (if anything) sothat it can be installed again?Thanks.Steve

View Replies !

ActiveX Components Within SQL Server
Thanks in advance for your help...

I have been trying to create, then call an activeX object. I use sp_OAcreate and then sp_OAmethod to create the object, the call the method within. I have registered the DLL but I can not get it to work. I used the examples within T-SQL help but it doesn't seem to work. I am calling from within a sp within the northwind db. I need to pass 4 parms to the method. Here is the proc.

CREATE PROCEDURE SIMPLE2_SP
(@CUSTOMERID nVARCHAR(25) = NULL,
@ORDERID INT = NULL)
AS

DECLARE @BLOB nVARCHAR(1200),
@PARM1 nVARCHAR(25),
@SF INT,
@pOBJ INT

/***Make sure that the customerid is specified, if not, get out. sfogli 7-17-00
***/
IF (@CUSTOMERID is NULL) OR (@CUSTOMERID = '')
BEGIN
RAISERROR('Must specify a CUSTOMER name.',-1,-1)
RETURN (1)
END

/***Hardcode the path, customerid, and orderid for testing purposes. sfogli 7-17-00.
***/
--SELECT @BLOB = 'PATH=C:REPORT.HTM;CUSTOMERID=' + @CUSTOMERID + ';' + 'ORDERID=' + CONVERT(VARCHAR(5),@ORDERID)+ ';'
SELECT@PARM1 = 'PATH=C:REPORT.HTM;'

/***Append BLOB with revelant data from customer table, sfogli 7-17-00.
***/
SELECT @BLOB = (SELECT'CustomerID=' + CUSTOMERID + ';' +
'CompanyName=' + COMPANYNAME + ';' +
'ContactName=' + CONTACTNAME + ';' +
'ContactTitle=' + CONTACTTITLE + ';' +
'Address=' + ADDRESS + ';' +
'City=' + CITY + ';' +
--Contains null values'Region=' + REGION + ';' +
'PostalCode=' + POSTALCODE + ';' +
'Country=' + COUNTRY + ';' +
'Phone=' + PHONE + ';' +
'Fax=' + FAX + ';'
FROMCUSTOMERS
WHERECUSTOMERID = @CUSTOMERID)

/***Make sure that the orderid is specified, if not, raise message. sfogli 7-17-00
***/
IF (@ORDERID is NULL) OR (@ORDERID = '')
BEGIN
RAISERROR('To continue process, please specify an ORDERID and retry.',-1,-1)
PRINT @BLOB
RETURN (1)
END

/***Append BLOB with revelant data from orders table, sfogli 7-17-00.
***/
SELECT@BLOB = @BLOB + (SELECT'OrderID=' + CONVERT(VARCHAR(5),ORDERID) + ';' +
'CustomerID=' + CUSTOMERID + ';' +
'EmployeeID=' + CONVERT(VARCHAR(7),EMPLOYEEID) + ';' +
'OrderDate=' + CONVERT(VARCHAR(15),ORDERDATE) + ';'
/***'RequiredDate=' + REQUIREDDATE + ';' +
'ShippedDate=' + SHIPPEDDATE + ';' +
'ShipVia=' + SHIPVIA + ';' +
'Freight=' + FREIGHT + ';' +
'ShipName=' + SHIPNAME + ';' +
'ShipAddress=' + SHIPADDRESS + ';' +
'ShipCity=' + SHIPCITY + ';' +
'ShipRegion=' + SHIPREGION + ';' +
'ShipPostalCode=' + SHIPPOSTALCODE + ';' +
'ShipCountry=' + SHIPCOUNTRY + ';'
***/
FROMORDERS
WHEREORDERID = CONVERT(VARCHAR(5),@ORDERID))

EXEC @SF = SP_OACREATE "PMIDocHandler.HTMLDocs", @pOBJ OUT
IF @SF <> 0 GOTO ERR
--(sPath, sCustomer, sContractID, sKeyValuePairs)
EXEC @SF = SP_OAMETHOD @pOBJ, "CreateDocument" ,@PARM1, @CUSTOMERID, @ORDERID, @BLOB
IF @SF <> 0 GOTO ERR

ERR:
RAISERROR('THIS IS ONLY A TEST.',16,1)

--SELECT @BLOB AS 'VARIABLES PASSED'
RETURN

View Replies !

Data Flow Components
Does anyone know a good place to download (or even purchase) custom data flow components?

Some ideas I've had (and I'm sure I'm not the first):

Transformations:

Filter
Sometimes I just want to filter out certain rows.

Unicode Converter
Convert all unicode columns in place.

Sequence Column
Adds a column with a sequence of numbers. Or perhaps even random numbers.

GUID Column
Adds a column with a GUID.

Destinations:

Garbage
Would act as a visual indicator in the designer that these rows are being discarded. You could add a data viewer right before it too.

Log File
Good for redirected error rows, writes them to various log files.

Email
Along the same lines as Log File, but sends off all the rows in a single email. Great for day to day things. Nothing too critical.

View Replies !

Debugging DataFlow Components
I'm trying to do design time debugging of a dataflow component that I developed. I'm clearly doing something wrong, but I can't figure out what so I'm looking for suggestions if anyone has had a similar issue.

The reason I think I doing the steps correctly is that I can debug other components. However, that set seems to be limited to those developed in C#. My component is developed in VB. Shouldn't matter, I wouldn't think.

As a test I tried to debug other VB components from the SQL Server Samples and I have the same problem with them. Last one I tried was ChangeCaseVB. Though I just tried ChangeCaseVS and it didn't stop for me either...

The problem I have is when I drop the controls onto the design surface in the second instance of VS, the first instance of VS, which has the code for the component, does not hit any of the breakpoints, such as ProvideComponentProperties, which I know should be hit, and are hit when I debug a C# component.

To recap, I have an instance of VS open with the code for the component, developed in VB.

I compile the component.
I copy the component to C:Program FilesMicrosoft SQL Server90DTSPipelineComponents
I gacutil the component and then it shows in C:WINDOWSassembly
I add the component to the toolbox in my second instance of VS where I am designing the SSIS package which will host the component
I attach my first VS instance to my second VS instance
I drop the component on the designer in the second VS instance.
At this point I expect the first VS instance to hit a breakpoint, it does not.

I have also tried the method of setting the external program and command line arguements in the component's VS for running dtexec.exe directly.

Any suggestions???

View Replies !

Extending Native Components
Can anyone provide any direction in extending existing SSIS components with a custom component, if it's possible at all. In some cases there are just slight bits of functionality missing that I think I could add in myself. But, I'm not much of a programmer and need a bit of help in the declaration of the component in my own custom component.

Thanks.

View Replies !

Adding SCRIPT And LOOK UP Components Using C#
Hi,

Could you please tell me how to add SCRIPT and LOOK UP component to a data flow using C#? Also, is there any artilces/site which gives information about the SSIS programming?

Regards,

Gopi

View Replies !

DTS 2000 Designer Components
After installing the DTS 2000 designer components from the feature packI get the following error message when trying to open a package:

----------

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

---------

The thing is that I have installed them!! so what's going on here, is there a registry key I need to remove or something?, I've uninstalled and re-installed them, rebooted the server numerous times but still no joy, SQL Server just tells me that they're not installed, as you can imagine this is a real pain as I cannot do anything with my legacy packages on the 2005 server.

I cannot just migrate the packages from my 2000 server as they are in daily use on a production server. Is there an option to migrate/copy packages but leave the source packages untouched?

Help!

View Replies !

Extending Source Components?

How can I create a source extension that reads a text file and returns a XML file? I would like to have an xml File as output, because the information is already normalized.

If I extend the class €œPipelineComponent€? I can just define IDTSExternalMetadataColumn90 as output. And I do not want to have columns. I would like to return a xml file

Is it possible to achieve this?

View Replies !

Number Of Source Components
Hi All,
I want to run 13 flat file sources in one Data Flow Task, is it possible to do so? I mean I have File1, File2, File3 .....File13 as a Flat file source, Thus i want to have a transformation component for each Flat file source (File1, File2 etc), is it possible to run all these in one Data Flow Task, would you suggest your best practices? Thank you for your advice and consideration.

Example:

FlatFile1                          FlatFile2                              FlatFile3 FlatFile4           Etc
     :                                        :                                                 :
     :                                       :                                                 :
Derived Column1           Derived Column1                         Derived Column1              Etc
     :                                        :                                                 :
     :                                        :                                                 :
OLEDB Destination1     OLEDB Destination2                   OLEDB Destination3

This is to show i have 13 like this in one Data Flow Task.
Thanks

View Replies !