Cannot Edit My Dts Package (Urgent Please)
Mar 11, 2002
HI,
I created a dts package using my Windows NT authentication. One of my colleague edited that package last week and when I tried to open it now, it gives me an error message "The system cannot find the file specified". The package still has my NT id as the owner. Could anyone please let me know why is this happening ???
My colleague is still able to edit my package. My NT id and my colleague NT id both are setup as administrators on the sql server. Any help is greatly appreciated.
Thanks
Ramesh
View 1 Replies
ADVERTISEMENT
Feb 20, 2008
OK, I've figured out how to create and schedule my packages.
now I want to go back in and redefine some of the options.
How can I get at it so i can edit it.
thanks
ICW
View 6 Replies
View Related
Nov 28, 2007
I have a SSIS package, I export it as a dtsx package and open it with MS Business intelligence. I am not able to edit the package.
Please help.
View 5 Replies
View Related
May 23, 2006
This is probably a st00p1d n00b question, but here goes:
I have a DTS package that I got from someone else, but it needs to be edited. It was set as a local package, but when I double-click it in Enterprise Manager and edit it, then save and quit, I can go right back in and changes are gone, as if it was never edited.
Well, lo and behold, I got the bright idea to edit the package using Notepad, then bring the package back into Enterprise Manager. Now it says it can't do it because it's no longer a DTS Package. Fortunately, I have another unmodified copy, or I would have really thrown out the baby with the bathwater.
So my question is: What do I need to use to edit the package offline, then be able to bring it back into Enterprise Manager as a valid DTS Package?
View 2 Replies
View Related
Apr 28, 2015
I found a problem in the SQL that's a part of a SSIS package written by a third party, which is in our SQL Server 2008 R2 database. I've discussed this with the third party person; she's given me the necessary changes to the SQL. But I don't know what to do next.We've got this package on a test database server. I've got SSIS open to Stored Packages and have drilled down to the necessary folders to find it. But beyond that I don't know what to do. I understand that BIDS is involved, but that's as far as my understand of it goes.
View 3 Replies
View Related
Mar 31, 2006
I have used the wizard to import a DTS package from a SQL 2000 server to our new SQL 2005 server and need to make edits to reference the new server and database. I am able to see the package within the SQL Management studio under Integration Services, but I cannot find it in the Development studio?
What am I missing?
Thanks
View 1 Replies
View Related
Mar 3, 2008
Hi, I have created a DTS Package in SQL Server 2000, is there any way that a different user can edit and execute that DTS WITHOUT having server roles?
Thanks
View 6 Replies
View Related
Mar 12, 2008
I was working on a flat file import spec yesterday, using the import wizard, and I saved my work as a SSIS package. Today, if I connect to Integration Services through SQL Management Studio, I can see the package, but I can't edit it. I've tried to open the package using BIDS, but I can't find it on the server. Obviously it exists, but where?
How the heck can I edit this package? And, where is it? I don't understand why things are so much more difficult in 2005 vs. 2000.
Thanks.
View 4 Replies
View Related
Aug 6, 2007
What is the best way to move a SSIS solution to a new server so that I can edit the solution when I have problems?
Thanks,
View 5 Replies
View Related
May 22, 2008
We are on SQL Server 2000 SP2 version.
I have 3 DTS packages that are running successfully every day.
We need to change them as the source side tables are going to be changed pretty soon.
When I go into the designer view Enterprise Manager hangs when I do any of the following:
1. click on Properties for the transformation task
2. Click on Disconnected Edit
3. Click on Properties of connection 1(IBM DB2/400 Source), properties window pops up, now change the userid/pwd and click ok.
Any help will be greatly appreciated.
View 4 Replies
View Related
Mar 23, 2006
Which tool is used to maintain packages stored in the MSDB. Do you have to export them as file based to edit them?
View 3 Replies
View Related
Nov 16, 2006
Is it possible to open a package that is saved to a server??
The reason being is I develop on desktop but some of the development I cannot do due to access restrictions.... So I want to save the package to the server then do the final creation there...
Is this possible??
If so How??
View 1 Replies
View Related
Apr 20, 2007
I created a package via the import wizard in SQL Server Management Studio. When I test-ran the package I realised it needed to be modified. How do I do this without using either Visual Studio, SSIS Designer or an XML editor, none of which is installed where the package was created? Ideally I want to hear that there's a way of redisplaying the package in the import wizard.
View 1 Replies
View Related
Aug 24, 2015
I "upgraded" to Windows 10 (I was installing a new c: drive anyway). I installed SQL Server & SSIS, Visual Studio 2012, SQL Server Data Tools 2012, etc. When I try to load up my project (.sln) in SQL Data Tools I get the following warnings/errors:
Warning 1
Warning loading DataImport.dtproj: Warning: Failed to decrypt an encrypted XML node. Verify that the project was created by the same user. Project load will attempt to continue without the encrypted information.
Warning 2
Warning loading DataImport.dtproj: Warning: Failed to decrypt sensitive data in project with a user key. You may not be the user who encrypted this project, or you are not using the same machine that was used to save the project. If the sensitive
data is a parameter value, the value may be required to run the package on the Integration Services server.
Error 3
Error loading ImportFiles.dtsx: The version number in the package is not valid. The version number cannot be greater than current version number.
Error 4
Error loading ImportFiles.dtsx: Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".
Error 5
Error loading ImportFiles.dtsx: Error loading value "<DTS:Property xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">8</DTS:Property>" from node "DTS:Property".
Error 6
Error loading 'ImportFiles.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return
value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
As well as installing Windows 10, I had also renamed by computer. I have tried renaming it back (I noticed some references to the computer name in the xml), but no difference.Have I installed the wrong versions of one of the software? If so, how could I check which one I need to install (to match the VS project/dts package)?
View 3 Replies
View Related
Mar 28, 2002
I have created a DTS package its owned by me, there is another user who has created another DTS package owned by him, we are both public users to the same database.
Now we both want to look at each others DTS, when we spoke to the DBA he said the only work around was to give us the SA permission which he don't want to.
Is there any work around for this....since we have several packages ..or can we create some global account and then give it some other previlage so as we can view the packages ..
Thanks in advance.
Sheryl
View 4 Replies
View Related
May 20, 2002
Hi,
I have a question on dynamically changing DTS Package connection strings.
E.g.
I created a DTS Package as follows and saved it as a file:
Source
Server : X
Databse : DB1
User : sa
Pwd : ****
Destination
Server : Y
Databse : DB2
User : sa
Pwd : *****
Now I want to run this package file with different source & destination
i.e.
Source
Server : P
Databse : DB4
User : sa
Pwd : ****
Destination
Server : Q
Databse : DB5
User : sa
Pwd : *****
My question is , how do I change the database connection strings at run time?
Is such a execution possible?
Thanks,
Shefali
View 4 Replies
View Related
Oct 17, 2004
Dear All,
Can any one tell me how to recover the DTS Package from SQL Server 2000.
The package has different versions, when i tried to edit that version i can see only an empty screen. Is there any way that we can get the related physical file ? How can this physical file be used for restoring the package ?
Please tell me Is there any other alternatives to get the DTS Package back.
Thanks In advance...
View 2 Replies
View Related
Jun 15, 2001
Hello!
I'm trying to execute DTS package using dtsrun utility from MSDOS Prompt
and getting error message "Cannot Open user default database '<ID>'.Using master database instead".
here's the syntax
dtsrun -Stestserver -Utestuser -Ptestuser -Ncustomers
How can I resolve this?
Thank you
Lena
View 2 Replies
View Related
Apr 27, 2000
Hi
Could any one let me know how do i transfer DTS Package from One server to another Server.
I do not want to take complete backup & restore on another server, but i want to move one by one from server.
I would appreciate if someone could help me.
Cheers
Hemant
View 1 Replies
View Related
Sep 27, 2000
This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.
Please help!!!
View 3 Replies
View Related
Oct 26, 2000
hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
View 1 Replies
View Related
Mar 23, 2001
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
View 4 Replies
View Related
Dec 7, 2006
Edski writes "Help please,
below is my sql query, when I run it, I get the right result with one problem. I get same customers with same email many times. I would only like the same customer shown one time. Checking it by email.
SELECT od.pName, od.dIndx AS dindx, od.pIndx AS pindx, od.device AS device, c.Cust_Id AS cust_id,
c.First_Name AS First_name,
c.Last_Name AS last_name, c.Email AS Email, c.Phone AS phone,c.company, h.productCode AS
product_code, DATEDIFF(dd, GETDATE(), h.expirationDate)
AS Difference, h.hotSyncId AS regcode, od.autorenewal AS autorenewal, od.installment AS
installment
FROM Orders_Detail od INNER JOIN
Hot_Sync_ID h ON od.dIndx = h.dIndx INNER JOIN
Customers c ON c.Cust_Id = h.cust_id
WHERE (od.prenewal ='False') and (od.autorenewal = 'no') and (c.newsletter <> 0) AND
(DATEDIFF(dd, GETDATE(), h.expirationDate) = '27') AND (c.company <> 'University of Alberta')
ORDER BY difference, c.Last_Name, h.productCode"
View 2 Replies
View Related
Jul 6, 2000
Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;
It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
Thank you very much for your concern.
View 2 Replies
View Related
Oct 9, 2004
Hello,
I have been working in ASP.Net web sites with Access database.
Now I want to create a web site using an MS SQL database.
What software or softwares can I use to create and edit MS SQL databases?
I am using Windows XP Professional SP2.
Thank You,
Miguel
View 5 Replies
View Related
Nov 24, 2001
Hello,
I have some problems to edit a recordset in an ActiveX DTS using Vbscript.
Here is an example of the script :
dim varsql, varset, varconn
set varconn = CreateObject("ADODB.Connection")
set varset = CreateObject("ADODB.Recordset")
varconn.Open = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=Enregistrement3;user id = 'sa';password=''"
varsql = "SELECT * "
varsql = varsql & "FROM mytable "
varset.Open varsql, varconn, 3,3
msgbox "How much : " & varset.recordcount
if varset.recordcount >0 then
do while varset.eof
varset.edit
.........................
varset.update
varset.movenext
loop
end if
varset.close
varconn.close
Does someone see what is wrong ?
I allways get -1 for the varset.recordcount ! (I checked there are some records into the table).
I don't think it is a problem of user's right as it works with the same user configuration using a SQL action requery.
If I modify the open statement like this :
varset.Open varsql, varconn, 1
varset.recordcount contains the good number of records but the recordset is read noly and can't be modified...
Any Help will be very wellcome !
TIA
View 1 Replies
View Related
Aug 23, 2000
This is a basic, remedial question, but I've no experience whatsoever with SQL server or Access (although I'm familiar with basic DB concepts). Even so, I have inherited this project because no one else will take it (besides, I like the challenge of learning something new :-). If I understand correctly, I can use Access 2000 to create and edit DBs on my SQL 7 server, and to run queries. This is done by creating a WBEM ODBC connector (I have no idea how this is done). I'm pretty good at figuring things out on my own, but I sure would appreciate being pointed in the right direction. What I'd like to know is first of all, am I on the right track, and secondly, what do you all recommend as a good source of info on this topic (the Microsoft web site, technet, manuals?).
All info is greatly appreciated.
thanx,
-scott
View 3 Replies
View Related
Oct 25, 2005
Where do I go to modify the T-SQL statement I entered while creating a job with the web assistant wizard?
View 1 Replies
View Related
Jan 31, 2006
I need to convert this from Jet SqL to SQL Server. Moving out of an MDB to an ADP some of the queries I need to change over, I inherited this database and the bosses want all databases moved over from MDB to ADP.
SELECT Format$([Main Table].Date,'mmmm yyyy') AS [Date By Month], [Main Table].[Action Type], Count([Main Table].[Action Type]) AS [CountOfAction Type]
FROM [Main Table]
GROUP BY Format$([Main Table].Date,'mmmm yyyy'), [Main Table].[Action Type]
HAVING (((Format$([Main Table].[Date],'mmmm yyyy'))=[Enter the Month and the Year]));
View 1 Replies
View Related
Jul 23, 2005
How can i mark a row with its last edit time?With access it was obvious, in sqlserver?
View 1 Replies
View Related
Jul 23, 2005
Greetings,Are there any tools freely available to modify or edit a .mdf databasefile? As far as seeing the actual tables?Regards,cd
View 6 Replies
View Related
Mar 18, 2008
Hi,
please, it is possible to know the edit distance used in the fuzzy lookup/grouping.
On this forum I read fuzzy lookup use 4-gram with fix size.
Does exist any document explaining how fuzzy lookup calculate the similarity? In other word, what kind of edit distance, algorithm is used by fuzzy lookup/grouping?
I hope I was enough clear with my poor english.
Thanks All
View 1 Replies
View Related
Sep 3, 2007
Two days back we have installed SP2 on SQLServer2005 Active/Active Cluster which result in failure.
Only Database Services and Analysis Services where not updated and rest of the services got updated.
After a restart , the behaviour of SQLServer is helarious.
We got into lot of problem so we opened support from Microsoft.
One of the problem i forgot to mentioed to Microsoft was on editing the Job i cannot see anything inside,all the entries where empty closing the job window and opening it again i got all my entries back but on editing i got the below mentioned Error.
Error:
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error:c001f011(Microsoft.SqlServer.ManagedDTS)
If anyone faced the same problem and got any resolution please let me know.
Anyhelp will be appriciated.
View 2 Replies
View Related