Problem Description: The following error is popping up and not allowing opening or running any of the DTS packages. Connection objects are not available in DTS Designer.
"Error in the DLL"
"Need to run the object to perform this operation"
We have reinstalled the MS SQL Server 2000 Standard Edition with Service pack 3 and MSO3031 hot fix. Still the issue continues.
Operating System:Windows 2000
I'm making a copy of some tanles between 2 servers.
Server 1 requires a sql login
Server 2 is using Windows Auth.
I have a user on server 1 named "odbc" able to log in.
however my copy task fails, when I drill the error, it's lists the first user in server 1 alphabetically as the failed login???? but in my dts I am specifying the "odbc" user and password.
I think I have a permissions problem on server 1. So my Question, what minimum permissions does user "odbc" need to copy a table?
On server 1 I can copy from northwind to server 2 just fine..but any other db on server 1 causes the weird failure with the wrong username.
Any Ideas? I am not a DBA obviously :)
Thanks,
Carl
I currently have the following code in my designer file
<asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="select Site_name, system_id, ASP_Archive, sitetimes,HPOV_ROC, UPPER(CircuitType) as CircuitType, QwestCircuit_ID, SiteConfig,Site_Nat, PVC_VCI from tblASPCustomerWan order by Asp_Archive asc"
UpdateCommand="UPDATE tblASPCustomerWan SET [Site_name] = @Site_name, [system_id] = @system_id, [ASP_Archive] = @ASP_Archive, [sitetimes] = @sitetimes, [HPOV_ROC] = @HPOV_ROC, [CircuitType] = @CircuitType, [QwestCircuit_ID] = @QwestCircuit_ID, [SiteConfig]= @SiteConfig, [Site_Nat]=@Site_Nat,[PVC_VCI]=@PVC_VCI"
ConnectionString="server=localhost;Trusted_Connection=yes;uid=portal_user;pwd=Cr@zyP@55w0rd;database=CusPortal_Staging" />
I would like the change the connection so it takes it value from System.Configuration.ConfigurationManager.AppSettings("appStrConnection"), how can i do that??
64b SQL2005 EE and all clent tools installed on the same server. Im trying to create a new connection in DTS Designer but after succesful test of the connection it errors out with
The new connection manager couldnt be created. Additional info : Exeption from HRESULT 0xC0010014
Any idea whats the problem here?
My goal is to develop packages that get all basic information from an external config file. I would like to be able to deploy my packages in different parts of the enterprise without having to define Connection managers/File Managers/ FTP managers ... at each and every site. It should get it from an external file. All I should have to do is to edit my config/resource file to suit the needs of the target site and I should be good to go. Is that possible now ?
Thx,
chiraj
Hi
I have recently upgraded several of our SQL2005 servers to SP2a :) version 9.0.3050
and find that I can no longer script the Service Broker objects from a remote connection. The error I am getting is:
Script failed for MessageType 'MyMessageType' (Microsoft.SqlServer.Smo)
Additional Information
Either the object or one of its properties is not supported on the target server version
(Microsoft.SqlServer.Smo)
Now I know that this worked pre SP2 using exactly the same setup. Has anyone else experienced this or know how to fix it?
Hi,
As I was developing my SSIS package, I created several variables and tasks ( FTP, WMI Reader Task ). I am now cleaning up, deleting unwanted variables and connections in the design window. I save and build the package and when I load the package, I get warnings that these variables are referenced but can't find them and errors that the WMI connection is not found.
When a package calls a sub-package, it stores the absolute path of the child package in its dtsx xml file in a Connection String property. How annoying !!! . When I deploy this to another machine with a different file structure, it becomes a problem. Why can't it store the path relative to the parent package, which would be typically in a sub-directory under the parent ?
These last 2 days have been nothing but frustration and my deadline is slipping. Any help is appreciated.
Thx,
-chiraj.
please help newbieI need to create a lot of objects the same type (let's say: schemas)I wish to use paramerized block in loop to do so.- how to put names of my objects to such control-flow?belss you for help
View 5 Replies View Relatedpassing serialised objects to a stored procedure for the purpose of data inserts. I see this as being a way to handle multiple row inserts efficiently.
However, in my limited use of XML data I am not so sure how to link the data when I have a dependency on another "object" within the serialised XML.
Below is a code snippet showing what I have so far.
The first insert statement works fine - but how to retrieve the identifier created by the DB - I want to use an SQL statement that finds the record in the table based on the XML representation (of the PluginInfo), allowing me to insert the ConfigurationInfo with the correct reference to the PluginInfo
DECLARE @Config NVARCHAR(MAX)
DECLARE @Handle AS INT
DECLARE @TransactionCount AS INT
SELECT @Config = '
<ConfigurationDirectory >
<ConfigurationInfo groupKey="Notifications" sectionKey="App.Customization.PluginInfo"
[code]....
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
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
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.
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?
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.
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
Have anyone tried installing the DTS Designer 2000 Components in 64 Bit Environment
Vic
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
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
Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express?
View 4 Replies View RelatedCan 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 RelatedI 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.
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
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
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
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
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
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
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.
When I try to Return All Records in a table, I receive the error "Query Designer encountered a query error: unspecified error." I can successfully view the design of the table just not the records themselves. This is happening in all of my tables in all dbases.
Thanks for any suggestions.
Thanks in advance for any help you may offer.
I have never seen this error before... When I click on DTS to either open an existing package or create a new one I get the following errors: Error in the DLL, DTS Design Error. When I try to create a new DTS it gives me the errors but still opens but I'm missing all of the connection objects except for MS data link and other connection. I had no problems designing and executing the packages from a development box. I'm not even refering to the typical scheduling problems that exist when SQL Agent is configured incorrectly!
Hi. I am not sure why, but i can't change any of the values in my Table Designer. I want to change my primary key's "IsIdentity" value to "yes" and the Identity Increment to "1" but everything is greyed out and nothing is editable. Please help! I am not in debug/run mode when i am editing these values. I have a feeling that I am going to feel stupid when somebody points out what i am (not) doing. So, any takers?
View 7 Replies View RelatedHi
According to the RDL spec (nov 2005), RDL Designers are supposed to preserved custom elements. In my initial test Visual Studio 2005 overwrites/removes any custom elements. I tried to find some support/samples of this but was unsuccessful.
Here is what I added
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:myNameSpace="http://myNameSpace.com/myNameSpace">
<CustomProperties name="Custom">
<myNameSpace:test>test</myNameSpace:test>
</CustomProperties>
..
Anybody have some advice about this.
Thanks Tobias
Whenever we open a task and choose the lookups tab ellypsis button we get this error
Microsoft SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience.
If you were in the middle of something, the information you were working on might be lost.
Any idea what might be causing this? Am I missing something?