Hi All,
I am receiving the following message when I run Dts package which is
creating a cube.
Error Source : Microsoft Data transmission Services (DTS)
Package
Error Description: File name or extension is too long
Any help will be appreciated!
Thanks in advance,
Mohammed Sarwar
Ocp dba oracle 9i,8i,8.0
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I checked quickly one network  and I ran into the folders; I found out the folder MSSQL backup, nothing strange so far. Within that folder, anyway, I found out several backup and one very huge file (datawarehouse) with extension FILE. I am wondering what can be? I got datawarehouse mdf of course and datawarehouse log but what is that huge file (1 TB)?
View 6 Replies View RelatedI was told by my website provider that they do not support the .mdf extension and only support the mdb extension. What am I not getting here? I am using SQL Server Express 2005. Is .mdf a subset of .mdb?
View 1 Replies View RelatedHi,
I need to read a binary file with extention *.dat like this:
tat.dat and import it in ms sql server 7.0.
Thanks for any help
Dr Bangaly Diané
Hi,
If access database has an extension of .mdb then what is sqlserver2000 file extension?
Hello there!
I am in need of urgent help. i do believe that when you used the command SPOOL filename without specifying an extension name, it automatically puts an .lst extension name. Can you help me identify if there is any way i can generate a file without an extension name? I am in need of help right now. I hope someone will answer my post as soon as possible. I really really appreciate it!
Thanks,
Jen
In document for encryption in SQLServer with application XP_Crypt, i see file with extension .pem when using private key or public key. How to create file .pem. Please explain me private key or public key.
View 1 Replies View Related
Hi,
I'm trying to change the file extension of one of the database files of a big database that contains 10 years of EPOS data.
When this file was created, at the beginning of 2008, with the following script:
USE [Live]
ALTER DATABASE [Live] ADD FILE (NAME = 'Live_2008',
FILENAME = €˜E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLive_2008') TO FILEGROUP [2008]
the .ndf file extension was not added to the filename. So the file now has a file type of "File", instead of "SQL Server Secondary Data File"
I tried, in a test environment, to bring the database offline, change the filename to "Live_2008.ndf" and bring the database back online, but it gives me an error message saying that "cannot open the Live_2008 file", i'm guessing because it's looking for "Live_2008" and it finds "Live_2008.ndf" instead.
This file is quite big (5Gb) and I cannot afford to risk to lose any data.
The situation is complicated even further by the fact that it seems that a partition for 2008 does not exist.
How can I find out what data this file contains?
Is it going to be an issue if I leave the file like that?
Thanks
I set up a basic ForEach enumerator loop and specified files of type *.sql.
In the directory, I had some files I needed to keep but didn't want the package to touch, so I changed the extension to *.sqlo. Much to my dismay, the ForEach loop picked up those files. (Though it did skip the *.xml and *.bat and a few other types...)
Sounds like a bug to me.
I programmed a Source extension, that accesss a text file. In my code I have the following code to open a file:
protected override void reader(PipelineBuffer buffer)
{
TextReader reader = File.OpenText(_filename);
The komponnet works well. How do I grant permissions to access this text file? Because I got problems when I try to run my package using a task created in the SQL Server Agent.
i have sql server 2000 db with two data file... primary data file has extension mdf and secondary file has extension ndf (as per microsoft recommendation)..
when i try to backup the db and restore thru the enterprise manager .. in the restore -> options window ... i see both the files has the same extension mdf.. and when the restore completed, the new database still has extension mdf for both the file..
why this behaviour?
* i even try to create a new test db with two files, still its the same behaviour.
I have just begun to try out differential backups. Almost every reference I found on the internet said to use a .dif file extension. Books Online "Back Up Database Task (Maintenance Plan) MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/ed1ef012-fa14-4ba5-bafe-d1527ba065b3.htm only says :
Backup file extension Specify the extension to use for the backup files. The default is .bak.
                                                                                                                                  Â
Using .dif for the differential shows "Microsoft Office Excel Data Interchange Format" as the type when looking at the backup folder. URL... indicates that .dif has 11 different uses, including "Difference data file." In a couple of posts in this forum in April and May of this year David Dye said that the file extension for differential backups is .bak, the same as for the full backup.
Â
If this is the case, this would cause a problem with our maintenance plan policy which is to retain the two most recent backup files on the server. If we do a full backup for the base on the weekend and differential backups the rest of the week, our full backup would have to be restored from out tape system before we could do a restore. Recoveries are pretty rare, but when we get that panicked phone call that someone accidently deleted all the records of a major client, time is of the essence in getting that point in time restore done.
Hello,
I try to add an data extension who take the information to connect to the database in a config file. But It's could not retreive the values corresponding to the key.
I'm using the class ConfigurationManager from the namespace System.Configuration.
ConfigurationManager.AppSettings["QueryModel"]
Without the config file, the extension is working well.... I got the impression that reporting service and Visual Studio BI don't find the config file.
If someone can help me or have some advices. I will be pleased
I have a source file as filename.mar it is microsoft access report. When I am loading into my database the file name was something like filename.nov (its current month).
When I ran the package its shows error system cannot find the file filename.nov.
I use an execute sql task and excel connection manager to craete excel file.
Execute sql task:
In the connection:
Â
It works. But when i choose file path to: C:1111.xlsx
And excel version to micorsoft excel 2007. When open the file it created,it promotes the format is not correct. How to solve this?
When I am saving a SSRS report in excel format in a shared network drive, how can I add the date extension to the filename ?I assume this is something that needs to be handled within the SSRS reporting side rather than the subscription side.
View 5 Replies View RelatedUsing SSRS 2008R2 is it possible to change the file extension of a CSV data driven subscription? Â I'm outputting a text file with a .csv extension, but users have access to these files and I don;t want them opened with Excel and then saved back in an incorrect format.Â
These are the options I have from the report "manage" option. Â
I have implemented a package to load multiple files to a destination. Since the source was a txt file, i have created as flat file source. However now we are getting files in excel format as well.
Is there anyway the source gets changed dynamically based on the file extension, output of the foreach file enumerator? I can think one solution to have 2 dataflow tasks based on precedence constraining and expression one is for .txt and other one is for .xls.
Hi,
In my Excel file I have one column "Summary" which contains large amounts of data. In ExcelSource I changed the Output Column: Summary datatype to Unicode[DT_Ntext], but I am not able to chnage the External column datatype from [DT_WSTR] to [DT_NTEXT].
Initilly it is string so changed to unicode. Still I am getting this error:
"Failed to retrieve long data for column " Summary".
I tried the BlobTempStoragePath to other directory? Still not working.
How to solve this error?
Thanks in advance
I have one really long .sql file I'm working on. It's actually a data conversion type script. It's gotten really cumbersome to work on as long as it is. I would like to split up various logical parts of script into their own .sql file.How can I have one file .bat, .sql or whatever call each .sql file in the order I specify? Hoping this is easy. Thanks
View 3 Replies View RelatedHi,
for testing purposes I'm inserting a flat file into a sql-server table using BULK INSERT unsig the following code:
BULK INSERT rsk_staging
FROM 'c: empulk
sk.txt'
WITH (
FIELDTERMINATOR = '',
ROWTERMINATOR = '
',
CODEPAGE = 'RAW',
DATAFILETYPE = 'char',
BATCHSIZE = 100000,
ROWS_PER_BATCH = 1925604,
TABLOCK
)
I have two versions of "rsk.txt" one with 1.9mill rows and one with the first 2000 rows only. The files have one column only with 115 characters that I'll split in to several columns later using SUBSTRING. The one with 2000 rows fires in to the database with no problems whatsoever using this exact code, the other one throws the following error:
Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
How can I resolve this problem?
EDIT: I tried several different row- and fieldterminators but this exact one works for the small data-file so I assume it should also work for the large one...the large one is however copyed directly using binary ftp from a unix-filesystem and the small one is manually copied into a new txt-file using UltraEdit.
hello ... I am trying to copy 1 field from a table in database called DB1 to a same table in DB2 .. I am not sure if this is possible. I found out form www3.schools.com it's doable using Select Into ... but it uses MS Access for example (Northwind.mdb) ... I wonder what's the extension database in MS SQL? Does anyone know where can we check the query syntax on the web? Can anyone tell me it's correct? I dun have MS SQL from home .. so :(
======copy prodID from DB1 to DB2 table called production1 (both DB1 and DB2)=======
// this is done in SQL QUERY ANALYZER under DB1?
SELECT production1.prodID INTO production1 IN DB2 FROM DB1
=====create VIEW in DB2=======
// this has to be done in DB1 ... if I have multiple databases, is there anyway to do it using something like SELECT INTO to create view in differences databases?
CREATE VIEW production_id AS SELECT prodID from DB1
I have made the sql server 2008 database backup through proper procedure.I am doing this backup in remote server. The task is completed successfully. But When I check the folder that I made the backup,is showing extension as file,not .bak. Why the backup extension is not proper? And due to that,when I sent this backupfile through mail to someone,that person is not being able to retrieve or restore it..
View 1 Replies View RelatedI've been using Michaels excellent date function http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519 quite honestly it has saved me loads of time (the e-beers are on me)
For my purposes I need to work sometimes with Financial Years and I also need the Dates available to SQL Server 7. So I used Michaels function to create a table and added two fields (possibly more to follow). Please note that this has only been done on SQL Server 2000
ALTER TABLE DATEINFO
ADD -- Needs these to allow NULL so that the Alter Table will work.
FINANCIAL_YEAR_START_DATE[datetime]null , -- the start date for the financial year
FINANCIAL_YEAR_START_YEAR[smallint]null , -- the year that the financial years starts in depending on the Financial Year Start Date
Given that the table is then populated by Michaels function, to set the FINANCIAL_YEAR_START_DATE I used
/* @ARBITRARY_FINANICAL_YEAR_START_DATE is SET to any date that would be the start date of a financial year
only the day and month parts are important, so in this case the start of the financial year is 1 April
*/
DECLARE @ARBITRARY_FINANCIAL_YEAR_START_DATE DATETIME
SET @ARBITRARY_FINANCIAL_YEAR_START_DATE = '20060401'
UPDATE DATEINFO
SET FINANCIAL_YEAR_START_DATE =
CASE
WHEN DATEDIFF(dd,DATEADD(yy, year([DATE]) - YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE), @ARBITRARY_FINANCIAL_YEAR_START_DATE),[DATE]) < 0
Then DATEADD(YY,YEAR([DATE])- YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE) -1, @ARBITRARY_FINANCIAL_YEAR_START_DATE)
Else DATEADD(YY,YEAR([DATE])- YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE) , @ARBITRARY_FINANCIAL_YEAR_START_DATE)
END
With that it is trivial to set FINANCIAL_YEAR_START_YEAR to YEAR(FINANCIAL_YEAR_START_DATE)
steve
-----------
Don't worry head. The computer will do all the thinking from now on.
Guys,
I am running SQL Server 2005 Enterp Trial version, which is about to expire in 14 days..
Is this possible to Extend this?
Or
Un-installing and re-installing may give me back 180 days again? I haven't tried this, but need to know before I do an attempt?
Don't have other machine, don't want to re-built my system..
Any help?
Thanks in advance
SKR
When rendering extension for RTF or Doc or WordML will be available?
Will it be released in service pack for SQL2K5 or it will be released in next version of SQL Server?
What is Reporting Service Extension and how can I check that whether it is installed in my PC or not.
And if not then what is requirement for get it installed...?
We just upgraded to 2005 from a previous installation of 2000. Due to performance issues, I stopped the 2000 instance, and now the following message keeps popping up in the event log:
MS SQL SNMP Extension Agent reconnecting.
Following that, there are the following messages:
ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..
-------------
ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..
-------------
ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..
-------------
ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..
Any suggestions?a
I have actually extended my requestI have a scenario like this.......update esan set tes_address_city = 'TEST1' --at some timeupdate esan set tes_address_city = 'TEST12' --at some timeupdate esan set tes_address_city = 'TEST123' --at some timebackup database TESTWMS to disk = 'D: empRecoveryTestTESTWMS.db'backup log TESTWMS to disk = 'D: empRecoveryTestTESTWMS01.log'I take these backups at the end of day....Now i want to recover till the second update ie 'TEST12'...Assumptions to be made:-I dont know the timing of the updates.I am allowed to take back only once.We can also assume to have a backup of the previous day also.Is this possible and how can i do it.......Please help me ...and urgent also.......Thanks in advanceRVGExtension is hereSuppose that ou database is crashing at 2.30 and i run the restoreRESTORE DATABASE TESTWMS FROM DISK='D: empRecoveryTestTESTWMS.DB'with norecovery --Prev day logRESTORE LOG TESTWMS FROM DISK='D: empRecoveryTestTESTWMS01.log'with norecoveryRESTORE LOG TESTWMS FROM DISK='D: empRecoveryTestTESTWMS02.log'with recovery, STOPAT = '2003-08-26 16:37:45.870'i get message like thisThis log file contains records logged before the designatedpoint-in-time. The database is being left in load state so you canapply another log file.RESTORE LOG successfully processed 0 pages in 0.389 seconds (0.000MB/sec).Now when i try to run aSelect * i get message lkeServer: Msg 927, Level 14, State 2, Line 1Database 'TESTWMS' cannot be opened. It is in the middle of a restore.How do i solve this problem. One way is to use a NO_TRUNCATE with abackup in between (ie incase of database corruption).But i dont want to use a log backup once again. I should be able tosolve it without using a log backup once again. In shot backup onlyonce a day. Aslo i need to refer to a database to that particularpoint of time from my backup.Thanks in advanceRVG
View 6 Replies View RelatedHi,
I have installed the SSRS 2005 Forms based login security extension as per the sample and instructions that come with the product install. I have double checked my work and debugged up to the point explained here.
My user is in the database and I can get to the login page. I have traced the code and can see the user being authenticated properly by server.LogonUser, the authentication cookie being created and placed in the response object, and then the redirect url being set to the reports/pages/folder.aspx. I have employed tcptrace and can see the sqlAuthCookie set in subsequent posts.
Unfortunately the redirect to folder.aspx never happens. I keep returning to UILogon.aspx. I think their is something either wrong with the auth cookie or the web.config in the ReportServer IIS virtual directory. The relevant xml from the web.config is attached below.
I would appreciate any thoughts. I am running on W2K3 SP1. Thanks.
Mitch
<identity impersonate="false" />
<!--<authentication mode="Windows" />-->
<authentication mode="Forms">
<forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/"></forms>
</authentication>
<authorization>
<deny users="?" />
</authorization>
Does someone of you know a rendering extension for ppt. Any integrated or third party componens ?
The management wants to have the reports as powerpoint presentation
Best regards
HANNES
I recently installed the Teradata .NET data provider and I am trying to use named parameters and multi-value parameters in my SQL. I am finding information on this topic hard to come by.
In order to get parameters to work do I need to write my own Teradata data extension from scratch, expand an existing data extension to work with Teradata, or can I simple edit my .config files to point to a generic extension wrapper already existing?
Thanks!
Hi all,
My query should be pretty simple to answer by the gurus. I have SQL Server Express Advance series installed at my system along with VS 2005. I tried the reporting services (remote mode) to display a report in the report viewer on my aspx page. The report simply uses an SQL query to get the result. Everything works fine and dandy!
However if i want to get data from my own data set, i used a webservice and ussed the XML data source option in the report to traverse through the XML. In the preview mode of the RDL everything works fine however when i deploy or rather run it using report viewer on my webpage, it gives an error that 'XML' has not been registered as an extension etc.
I looked in the rsserver config file, it IS configured. The only answer i have is that the EXPRESS version of SQL only supports the regular SQL data sources. I do not understand if that was the case, why does the preview mode work fine??
If i am correct then for the next release the ms developers should disable that or rather give a more meaning full error. I spent an entire day fideling around just to find out that it isnt supported with debates all over the place as to why in the world does it work in the preview mode?
Anyhoo, to get around that issue, i am wondering if the Custom Data Extension would work on the SQL Express or not? I am assuming it wouldnt. Please clearify this. Ideally all i want is to access my own data set in the report, no SQL queries or whatever, CDE seems the way forward but does SQL Express allow it?
Many thanks guyz.
Regards
Zeeshan
(btw, its only been two days since i started working with reporting services, so be gentle :-D )