Enhancement: SSIS Designer

May 3, 2006

Not quite sure if this is the right place for this comment...

While using SSIS Designer came across a DUE where the package was setup to:

SEQ1 - Truncate staging tables
SEQ2 - Load staging tables (sequence container had been setup to hold multiple data flows)

For some reason one data flow was run before the truncate table sequence.

Looking in the designer it appeared that the dataflow was a member of SEQ2 but looking at the Package Explorer it was outside the sequence container.

It would be good to have some visible indicator to show that a task is a member/not a member of a container

John.

View 3 Replies


ADVERTISEMENT

Dynamic Query Enhancement

May 13, 2008

The following dynamic query returns a list of tables some of which do not have records in them. Can someone help me out, I am trying to exclude the tables with no records returned? Also, I want to exclude tables where there is not a rn_create_user or rn_edit_user defined in the table?

DECLARE @TableName sysname, @Sql varchar(8000)

SELECT @TableName=MIN(TABLE_NAME)
FROM INFORMATION_SCHEMA.TABLES

WHILE @TableName IS NOT NULL
BEGIN
SELECT @Sql='select o.*
from ' + @TableName +
' o where not exists(select * from users u
where (u.users_id = o.rn_create_user) or (u.users_id = o.rn_edit_user)
)'

EXEC (@Sql)

SELECT @TableName=MIN(TABLE_NAME)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME>@TableName

END

View 4 Replies View Related

Perfomance Enhancement Through Proper Database Designing

Jul 20, 2005

Dear ReaderI am trying to design a database. How can I make best Judgement that Indexing (which I am trying to fix during Diagram Desingning process)is ok.I am able to identify the best candidate for the indexing.Below is the details I want to understand:AreaZIPCityCountyDistrictState/ProvinceCountryNow I want the data retrival optimization through Index. (you can suggest another idea, also)Entities Area,...., Country have independent tables.Example:Area_TableAreaID (PK)AreaThey have relationship- one to many- if you go from Country to Area.There is one more table:Location_Table (PK)LocationIDAreaIDZIPIDCityIDCountyIDDistrictIDState/ProvinceIDCountryID(Location_ID is further related to the Address of the contact.)GUI has a single form to enter these details.On a save command details in all the tables -Area to Country- (individually) being inserted.& simultaniously Location_Table is also being inserted with the details.Following is the situation of being queried these tables:(1) GUI user can select an Area than the related details of ZIP .., ..., ...upto Country etc. should be loaded automatically (id it is previously stored by the user entry in the database.)(2) Contacts have to be retrived on the basis of Area, ZIP, .....County. (Necessary Groupings are required )Example:If Contacts are queried Country Wise then the Display should beCountry1State1District1County1City1ZIP1Area1Area2ZIP2City2County2District2Country2Please Guide.SuryaPrakash****************************************** This message was posted via http://www.sqlmonster.com** Report spam or abuse by clicking the following URL:* http://www.sqlmonster.com/Uwe/Abuse...0255a1765491f15*****************************************

View 5 Replies View Related

Where Can I Send An Enhancement Request For Reporting Services

Aug 10, 2007



Hi All,



I looked around the Microsoft web sites but could not find anything on how to submit an enhancement request for Microsoft Reporting Services. I would like to request the ability to prevent exporting of a report without having to disable exports for all reports on the reporting server. In other words I would like certain reports to be exportable but others not.



Thanks,

View 6 Replies View Related

How Install SSIS Designer?

Apr 7, 2008

Hi,

I have sql server 2005 express and toolkits installed. However, I only see Report Server projects in my Visual Studio 2005 when I choose a Business Intelligence project.

Will someone please help me download the right file to start using SSIS designer?

Thanks,
Jae

View 3 Replies View Related

Variables In Ssis Designer

Oct 22, 2007

Hi there,

I have a script which grabs data from a source server. The problem is I have over 50 source servers, so I have to make a script for each one.. EXACTLY the same code but different linked server address.

So I was wondering if i can put the server name into a variable so I only need to make one script.
Is that possible?

thanks,

View 3 Replies View Related

SSIS Dataflow Designer Bug

Jul 19, 2006

When I drop a new component onto the design surface, it appears with dotted lines around it, as it is selected.

But, the F2 key (the hotkey for rename) does not work.

I have to click on some other component, and then back on the new component, and then the F2 key works.

I remember reporting this bug back in the beta cycle, but it is still present even in the release -- I actually think Ã?'m using the SP1 version of 2005, but see version info below to be sure:


Remote terminal services broke my copy buffer again, as is so often does, so pasting in the version info failed -- falling back to manual typing -- SSIS 9.00.2047.00.

View 2 Replies View Related

Ssis Designer Immediate Window

Dec 18, 2006

Where can I find instructions on how to use it?

View 1 Replies View Related

SQL Server SSIS Designer Installation

Feb 22, 2008

How to Install SQL Server SSIS Designer? Is it part of SQL Server Buisness Intelligence?

View 5 Replies View Related

Cannot Insert A Variable In SSIS Package Designer

Feb 21, 2007

Hello,
This morning I got an odd problem, I just added a new package to my dtproj and I cannot add a variable. Am I missing anything. ?

here is the image

View 6 Replies View Related

SSIS Designer Freezing Up When Using The Debug Utility !

Jan 23, 2007

I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint ?

If you have any suggestions or workarounds for de same plz do reply

Thanks in Advance
Shailesh

View 2 Replies View Related

SSIS Package Designer Performance After Installing SP1

Jan 9, 2007

Hi,

When I installed SP1 on my SQL Server 2005, the performance of the package designer dropped enormously. I have to wait like 30 seconds after I drag-and-drop a datasource from the toolbox to the design area. Also it takes a very long time to run the very simple package. Not to mention opening some complicated package that was done before applying SP1. The package scheduled in SQL Agent went from 3-4min to 5-6min.

Can anyone address this issue? Maybe there's something I did wrong?

While installing SP1 I ecountered strange behaviour (some messages about file locking, rebooting and stuff), but in the end it said that it was successful

Best Regards
Wojtek

View 8 Replies View Related

Removing A Custom Component From SSIS Designer

Mar 12, 2007

How do I remove a custom component from SSIS Designer pernamently? I can easily remove it from the tool box, but I want to get rid of it completely.

I tried searching in MSDN for an answer to this question but I could not find it.

Thanks

View 6 Replies View Related

SSIS Package Designer Error Displaying The Layout

Aug 10, 2007

Our Visual Studio installation suddenly starting producing the error below upon trying to open any .dtsx package; although by "suddenly" I'm sure it was due to some Windows update or other program install, update, or uninstall. I've spent two days uninstalling, reinstalling, and repairing everything that is seemingly related to VS, but no luck. I've searched the forums and could not find this specific error mentioned, although I have tried some of the suggestions to fix possibly related 'class not registered' errors, but again no luck.

===================================
There was an error displaying the layout. (Microsoft Visual Studio)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DDSErrorDeserializeDiagram&LinkId=20476
===================================
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (msddsp)
------------------------------
Program Location:
at MSDDS.IDdsDiagram.CreateShape(String ProgID, Boolean Visible, Int32 X, Int32 Y)
at Microsoft.DataWarehouse.Controls.Interop.AxMSDDS.CreateShape(String progID, Boolean visible, Int32 x, Int32 y)
at Microsoft.DataWarehouse.Design.ComponentDiagram.OnCreateShape(Object logicalObject, Int32 x, Int32 y, Boolean visible)
at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.OnCreateShape(Object component, Int32 x, Int32 y, Boolean visible)
at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateShape(Object logicalObject, Int32 x, Int32 y)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.CreateExecutableShape(DtsContainer dtsContainer, Int32 x, Int32 y, Int32 width, Int32 height)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.RefreshSequenceExecutables(IDTSSequence sequence)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.AfterDeserialize()



Any help would be greatly appreciated.

TIA,

Scott

View 7 Replies View Related

SSIS Package Designer Lookup Component GUI Error?

Jul 5, 2006

Has anybody seen this issue already?

If you try to "enable memory restriction" from the Lookup component GUI you need to input both 32 and 64 bit size of maximum memory. However when clicking "OK" on the editor you get a message like :

TITLE: Microsoft Visual Studio
------------------------------

Error at Update Execution Logs [Lookup folder path 1 [4429]]: Failed to set property "MaxMemoryUsage64" on "component "Lookup folder path 1" (4429)".



------------------------------
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------


You can only set the properties directly for mthe Properties window (F4).

I think this is a post SP1 bug in Visual studio designer...



View 5 Replies View Related

Text Qualifier In SSIS Designer For Flat File Source

May 19, 2008



Unlike SQL Server 2000 DTS, SSIS Flat File Connection Manager Editor does not provide available list of Text qualifier,

i tried

-- ""
-- double quote {"}
-- "
--{"}

but none of them worked....!
My file sample looks like this

"Col1","Col2"
"1234","3456"
"3456","1234"

what qualifier should I use then?

Many Thanks,

View 7 Replies View Related

DTS Designer Error

May 31, 2001

Hello everybody!
I've already posted this question before but this error never been resolved.
My DTS designer is totally screwed.
When trying to create new local package getting error message "Could not create Component Categories Manager".
I can't even use DTS to copy data in using DTS wizard.
Somebody recommended to reinstall SQL Server which I did but it didn't solve my problem.

Any other suggestions?

Thanks for your help

Lena

View 1 Replies View Related

Query Designer

Oct 5, 2001

Does any one know of a way that a group of my developers can use this without giving them access to the rest of Enterprise manager?

Want to give them access to write queries and they are all Access developers so that I have to do as little training as possible then letting them have Query designer would keep them in their nice little world without hassing me to much.

Cheers for any help.

View 1 Replies View Related

DTS Designer Error

Dec 1, 2000

When using Enterprise Mgr on a workstation connected to a MSSQL Server, if I attempt to start a new DTS Package, I get the following msg:
Title: DTS Designer Error
Text : Could not create Component Categories Manager

I get the same msg when trying to edit an existing package. I tried to re-register Dtspkg.dll,Dtsui.dll, and dtsffile.dll. All were successful but Dtspkg.dll, which failed. Does anyone know what causes this, and what else I can try?

View 2 Replies View Related

Query Designer

Feb 27, 2001

When i'm trying to open the table say return all rows in Enterprize manger it gives me an error saying
Query Designer encountered a query error
Unspecified Error.
I could not figure out what's goin on...

I appriciate if any one can help me out solving with this problem.

or what need to be done ?

Thanks a lot in advance!!!

Hari.

View 7 Replies View Related

DTS Designer Error

Mar 4, 2004

When I open my DTS package at my PC ( Client ) .There is an error message show like below .

DTR Designer Error.
There was a problem retriving the list of OLE DB providers.

No. Provider is selected .TO continue,you must select a valid provider.


Please help

View 7 Replies View Related

DTS Designer In 64 Bit Version

Oct 17, 2007

Have anyone tried installing the DTS Designer 2000 Components in 64 Bit Environment

Vic

View 6 Replies View Related

Where Is The Query Designer?

Dec 6, 2007

In SQL 2000 the query designer could be opened and the query type changed to create an INSERT.

Is this feature still available in SQL 2005?
If so, how do I open the query designer and change query types?

Thanks

View 5 Replies View Related

KPI Designer In Proclarity

May 20, 2008

I'm fairly new to Proclarity and I'm using 6.3. I just have desktop professional and we still don't have proclarity analytical server installed yet. I would like to work around with KPI Designer, how am I able to install it. Does it come with extra components and needs to be installed from the installation CD?


...Also folks any good resources in learning proclariy?


thanks in advance!!

Rok

View 1 Replies View Related

Download DTS Designer?

Jun 17, 2005

Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express? 

View 4 Replies View Related

Designer Grid

Aug 15, 2007

Can you turn on a grid in the designer to assist you with aligning tasks, etc. I've trie all kinds of things, but can't get a grid. Or even maybe rules? I'm probably missing something real simple, but can't find.

View 7 Replies View Related

Query Designer

Nov 5, 2007

I use the Report Wizard to generate reports. Within the "Design the Query" screen, I try the query statement as :
exec mydb.dbo.rptSales @fortheyear
It shows me an error: Implicit conversion from data type sql_variant to smallint is not allowed. Use the CONVERT function to run this query.

The stored procedure of rptSales is
CREATE PROCEDURE dbo.rptSales
@pyear smallint=null
AS
.......

The rptSales has been tested OK on SQL Server Management Studio.

Actually, I have other similiar stored procedures using smallint as a parameter, and I can use the Report Wizard to generate reports, except the above one.

How can I fix this?

Thanks a lot,
Joe.


View 4 Replies View Related

SqlDataSource Control Does Not Appear In Designer

Feb 1, 2006

I have dragged 3 SqlDataSource Controls to the WebDesigner and none are appearing graphically in the Designer View, but they are in the Source View.  How can I get the control to appear in the designer.
 
Thanks,
Mark

View 5 Replies View Related

DTS Designer Error-URGENT!

Jul 18, 2001

Hello!
Yesterday my DTS designer was fine and today suddenly when I open the package in designer there is nothing there.
I tried to create new package and it gave me an error when I was trying to save it "It is insufficient disk space to complete operation".

What does this mean?

Thanks

Lena

View 1 Replies View Related

DTS Designer Error In SQL 2000

Oct 19, 2001

I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.

However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.

Has anyone experienced anything similar? Any suggestions would be appreciated.

Thanks.
Barb

View 2 Replies View Related

DTS Designer Error In SQL 2000

Oct 9, 2000

I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.

However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.

Has anyone experienced anything similar? Any suggestions would be appreciated.

Regards,

Karl

View 1 Replies View Related

Query Designer Error?

Nov 24, 1999

Hello all

I've got SQL Server 7.0 SP1 installed (in a NT4 SP6 environment).

Recently, it came up with error whenever I try to open a table or a view (return all rows) inside the Enterprise Manager. The descriptive (NOT!) error message is like this:

"The query cannot be executed because some files are either missing or not registered", and on pressing "help",
the help files report
"Query Designer cannot locate your query files and cannot run your query"

I have tried re-booting the machine and upgrading mmc.exe to version 1.2 (from 1.1), but both in vain.

Can anyone shed some lights please?

Simon

View 2 Replies View Related

Query Designer Error

Feb 9, 2001

Checked out BOL on this issue, but not enough info received to troubleshoot. Hoping someone out there has some input.

This issue is only happening on the server side not the client. Also, it suddenly appeared on three different machines.

Query Designer:
"An unexpected error happened during this operation" [Query} - Query Designer encountered a Query error: Unspecified error.

The how: In a database, go to tables and select a table known to have data right click on mouse and select Open Table, return all rows. This is when the error appears.

BOL states the the file may be corrupt or from a non-supported version of SQL Server EM. Nothing was installed on these servers and we're still on SP2. This error just all of a sudden appeared and spread to 3 different machines...

Another issue is the Return to Top function is disabled. This function provides the maximum number of rows to fetch.

Any assistance would be appreciated! Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved