Reading DTS Logs On Structured Storage File
Jul 6, 2006Our DTS packages are saved as structured storage files. I can find instructions on accessing log files for locally saved DTS packages but not the kind we use.
Can someone help?
ADVERTISEMENT
Is There A Way To Do A Bulk Migration Of DTS Structured Storage Files?
Sep 22, 2006For a number of excellent reasons, I have exported the DTS packages that need to be migrated to SSIS to structured storage files. However, unlike the migration from a SQL Server source, the wizard doesn't allow a developer to select more than one package at a time.
Is there a way to do this in bulk that I am unaware of? I sure hope so as I have a couple of hundred to do and it's going to get very old very quickly if I have to do them one at a time!
Storage For Data And Logs
Apr 2, 2007I am planning on doing database mirroring using two (2) servers for each instance and a SAN to store the data and log files for both the primary server and mirrored server. How do I arrange the SAN 4 Physical Drives?
My options are:
· 2 Raid 1 Mirrors giving 250 GB to each SQL engine €“ This though has both the transaction logs and data on the same physical drive even if we split it up further into logical drives
· A Raid 10 - The transaction logs and data can be on separate drives
· A Raid 5 using the 4 Drives. (How SQL will see these drives I€™m not sure when it€™s 2 SQL engines)
· Or I could get a 5th drive and have a mirror set for transaction logs and a RAID 5 configured for the data.
Reporting Services :: SSRS To Export Report As Structured CSV File
Feb 3, 2015I'm trying to use SQL Server Reporting Services (SQL Server 2008 R2) to produce a CSV file. Â Row 1 in the CSV has to be a summary row with 8 columns. Â The detail rows which follow have 24 columns. Â The data in the summary row is "static" except for a date, a count of detail rows, and a total amount due based on the detail rows that follow. Â Here's an example of what we need it to look like:
HDR,4242,0,1,20150203,25,I,25823.18,,,,,,,,,,,,,,,,
DTL,4242,0,1,20150203,255092,20150129,989,C,Net 0,Due Upon Receipt,12703,Some Super Customer,1001 Grandview Dr,,SomeCity,TX,US,75012,9729990000,,,,
DTL,4242,0,1,20150203,255093,20150129,1360,C,Net 0,Due Upon Receipt,23774,Another Awesome Customer,52 Six Flags Dr,,DeepInTheHeart,TX,US,76006,8174445555,,,,
I've been able to get the report itself to render correctly in Visual Studio or from a browser using several different approaches but they all fail in one way or another when I try to save it as a CSV (eg, a header is prepended to each detail so they end up side by side, header and detail end up with extra columns, etc).
Reading Transaction Logs?
Jan 8, 2008Hello,
I am trying to figure out the time a certain store procedure was executed. I know the SP's name and approximetly the time it was executed. Is this possible to do?
Honestly, i am not sure if SQL server 2005 is smart enough to keep track of commited transaction on the server.
Any suggestins?
Thanks
Reading MS SQL Transaction Logs
Nov 10, 2006How do I go about reading transaction logs for a database?
View 1 Replies View RelatedIntegration Services :: Reading Data File Present In A File System From A Package Deployed In SSIS DB?
Dec 4, 2014I am trying to create and later read a data file from a package deployed in SSISDB, but it is not reading it while it is successfully creating the file. The same package when run from the file system package, runs successfully. Generating ispac and deploying in SSISDB is running for infinite time. Is it a permission issue?
View 7 Replies View RelatedSQL + File Storage + Delphi
May 19, 2008I am using Delphi 7 and need to save mulitple documents that range from 2K KB to 200K KB. These need to be stored in the database for inclusion in the database backup.
When i am working on the 200K KB file i continusely run out of memory, how can i resolve this.
SQL 2012 :: Distinct Storage Tier Of Remote BLOB Storage (RBS)
Oct 27, 2014How to implement distinct storage tiers on SQL Remote BLOB Storage (RBS)?
I want to use this SQL Feature to move files(images, videos, pdf files) from a database to a distinct database dedicated to RBS. Then I want to have several storage tiers, where objects will be saved and moved according access frequency. Old data will be arquived in cheap storage, but it must be always accessible if needed.
Description:
- 1st and main tier: new and frequently accessed objects stored in high performance storage;
- 2nd tier: automatically move older or less accessed objects to an inexpensive and different storage tier;
- in all cases, all objects must be accessible to all users, but accessing to archived objects(2nd tier) will be much slower;
Local Storage In Client's Machine In .sdf File
Apr 2, 2008
How to create a db in clients local machine with sql server ce and .net?Is any sample applications available?so,that later i can sync the data to the sql server db.
Please help.I am new to sql server ce.
Storage Of Packages: File System Or Sql Server?
Apr 5, 2006HI, we are beginning a new project at my company and I was wondering where is the best place to save SSIS packages: file system or SqlServer. I have used other ETL products and they always create a repository on an RDBMS. Since SSIS offers us the choice of DB storage or file system, is there pros and cons of both approach? Will the deployment of our application be simpler by using Sql Server since we would onky move metadata instead of files?
Thank you for your help,
Ccote
File Groups For Table Partitioning And Storage
May 31, 2007Hello,
I am building partitiong tables, partitioning on different file groups:
the question is:
Partitioned table referred to old data that are not frequent accessed for reporting can be stored on separate location(External storage, tape and so on) or to make partitioning functioning must all file groups must be presents?
If not, how can I separate old data from current ones (still using partitioning) to reduce the size of DB?
What it is the best for storage data and easy to access it when needs arise (eg reporting): Tape, external storage, others?
Thank
Storage Location For A Configuration File For Global Variables In DTS
Nov 15, 2007Hello,
We have an existing OLD System in SQL Server 2000 DTS Packages.
The Whole application runs on DTS.
There are several Packages which are called from a Master Package. Each Child packages have their own Global Variables. Most of them are the File Location variables to have the Source Location of the Input Data, mainly from the Excel Files.
Now, even if the Global Variables are there to change whenever they want to change the Locations of the Files, they have to goto each child package and change the variable themselves.
To resolve this issue, they want a configuration File (INI) / Table which would store those Variables. My thought is to read from that File/Table and Update all the packages' global variables through an ActiveX Script as the First Step of the Master package. That would eliminate the need of changing anything in the existing System.
But the Problem is the management (PM / DBAs / Team members) have different views to store the Configuration data.
1. Some wants it into a Different Database, having one table for this application so in future they can also add another table for some other application.
2. Some wants to store it in a Table in the Same Database of this Application.
3. Some wants to save it as a INI file.
As i'm the one who's going to really implement it, they have asked me to research for a best solution out there.
so I request to help me to decide which is a good solution and why.
Best Regards,
Deepak
The Database File May Be Corrupted. Run The Repair Utility To Check The Database File. [ Database Name = SDMMC Storage Cardwinp
Oct 9, 2007yes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]' .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me
View 4 Replies View RelatedI Want To Save And Work With .sdf File On Premanent Storage Without Degrading Performance...
May 5, 2008
In my pocket pc inventory application i keep database .sdf file in My Documents. This gives me good performance. But the problem is that sometime my pocket pc hangs and some users cold boot the device and everything is lost.
I tried with keeping my .sdf file on SD card. This way data is there even after cold reboot, but the preformance is very bad. it takes some seconds just to insert only one record. Also if connection is not closed properly due to any reason, the database file is corrupted.
Can anyone tell me if there is a way to persist my .sdf file even after cold reboot without degrading the performance?
Regards.
Reading Log File
Feb 9, 2000I have some records that have been deleted. I need to find out who did it and to do that I need to read the logs. Are there any utilities that will allow me to read login 7.0? How about 6.5?
Chris
Reading A Ini File In DTS
Jun 10, 2002Hi
How can I read an ini file entry and pass this parameter to a stored procedure which will be run in a DTS Package?
Thanks for the input
mipo
Reading Log File
Jun 22, 2008How do I view the SQL 2005 transaction log file(.ldf)?
Is there a built-in utility?
Thank you
Reading A File
Jun 24, 2008I am storing one text file on the server.This text file contains some mobile numbers.The file look like
009198XXXXXXXX
009198XXXXXXXX
009198XXXXXXXX
009198XXXXXXXX
etc
Here I need to read this text file row by row mobile number and then insert these mobile numbers into a table by using sql procedure or sql trigger or any other method or coding. Is it is possible or not?
If so then anybody can help me!
regards
Shaji
Reading ID From XML File???
Jul 13, 2006Hello friends...
We have sql server 2000 and i need to read one perticular xml and from that i want ID field stored in one table...is it possible by query analyzer to read xml and stored ID in table...I have only path of that xml file...
like
select ID from ("D:XMLFolder*.xml)
that i want
Reading In An XML File From A URL
Oct 17, 2006Hi
I have a problem with SSIS in that I need to read an XML file in from a URL,which brings me back the below XML. What I need to be able to do is essentially create a single record, including the nested XML <image> into the same record. This information then needs to be entered into a database table.
What I found is that if I use a data flow component, and have an XML source pointing to this URL, it essentially creates a different output for every level of nesting. This causes me serious issues because I would then have to somehow get to the information in the <image> tag, and then get everything below that, etc, to be able to get the images related to each <stock> record. This is a pain.
I also looked at using an XML task, where I could use an XSLT to transform to the required output, however, I can't point this XML task to a URL to retrieve the XML.
If anyone has any ideas I would greatly appreciate it
Thanks
Darrell
XML Format
------------------
<feed date="2006-10-17 17:08:46">
<usedstock>
<stock id="SFU22991">
<make>Peugeot</make>
<model>206</model>
<description>Peugeot 206 1.4 X-Line, 5 door Hatchback Tiptronic Auto 4Spd</description>
<hotline>08451553610</hotline>
<spec>Air Conditioning, Power Steering, Central Locking, Electric Windows, Alloy Wheels, CD Player</spec>
<deepurl>http://www.regvardy.com/used_car/dseller/SFU22991</deepurl>
<search>http://www.regvardy.com/used_cars/dseller/Peugeot/206</search>
<regdate>2005-01-27</regdate>
<colour>Blue</colour>
<price>7495</price>
<stocktype>USED</stocktype>
<category>Small</category>
<transmission>Tiptronic Auto 4Spd</transmission>
<bodystyle>Hatchback</bodystyle>
<fueltype>Petrol</fueltype>
<type>NCV</type>
<doors>5</doors>
<engine>PE0BC</engine>
<capcode>PE2614SED5HPIA</capcode>
<capid>26440</capid>
<image>
<urls>
<url>http://www.regvardy.com/imagedata/vehicles/g/pj54lyg_1.jpg</url>
<url>http://www.regvardy.com/imagedata/vehicles/g/pj54lyg_2.jpg</url>
<url>http://www.regvardy.com/imagedata/vehicles/g/pj54lyg_3.jpg</url>
</urls>
<libraryimage/>
</image>
</stock>
</usedstock>
</feed>
ASP.NET: Reading A CSV File With C#
Jan 22, 2008I am trying to read from a datasource that is a CSV file using C#, but for some reason I keep getting an error that says:
System.Exception: System.Data.OleDb.OleDbException: Syntax error in FROM clause.
My code looks like this:
String sql = " SELECT IDnumber FROM report.csv WHERE username = @Username ";
ArrayList parameters = new ArrayList();
parameters.Add(new OleDbParameter("@Username", Username));
DataTable dt = OleDbUtility.getDataTable(sql, parameters, OleDbUtility.GetCNetIDConnectionString());
It worked with an Excel file, so any ideas on this one?
It seems like the connection string is fine...
Reading A File Name That Changes
Mar 13, 2007Brand new to SSIS so bear with me, if something is obvious.
I want to be able to read a file from a certain directory. But the file name changes every day. So today its File20061203 tomorrow File20061304 or the next day it could be FileNB4434. The format in the file will always be the same though. I just want for a user to be able to drop a file in a directory and the package pick it up once a day.
Would I have to to create a script task or could I use a variable. I have been trying to use the variable but have not been able to get them to work. This calls for only looking for 1 text file in a folder but any additional links that show some good variable examples would be appreciated. One where only part of the variable changes File(Variable)Division.txt
Thanks in advance
Reading XML File
Jul 21, 2007Hello,
I'm trying to read data from xml file (i want to use this file as enviornment config file). i tried 2 methods and failed in both of them:
1.a. I loaded the XML file to the report server
1.b. I wrote a custom code for reading the XML. i got #Error
2.a. I loaded the XML file to the report server
2.b. I used XML dataset for reading the XML file.
thank you all
Moving DTS Stored Structured Files
Sep 20, 2002How do you load existing DTS Stored Structured files on to a new SQL 2000 Server?
View 1 Replies View RelatedSQL Server 2012 :: Query Servers From A List For File Storage Information
Oct 13, 2014I have a group of about 5 servers (which will likely grow toabout 25 in the near future) with their names listed in a table in a database on one of the servers. I want to query all servers in that table using the following query to pull the storage drive, database name, created date, age and size of the databases for each server listed in the table:
SELECT left(mf.Physical_Name,2) AS Storage_Drive,
DB_NAME(mf.database_id) AS DatabaseName,
db.create_Date,
DateDiff(day, db.create_date, getDate()) Age,
sum((mf.size*8))/1024 SizeMB
[Code] ...
How would I best accomplish this if I want to implement it using a TSQL procedure?
Reading In A Text File
Sep 25, 2007I need to know how to import a text file into a stored procedure as one big varchar. I don’t want to import the data straight into my tables. I need to be able to work with it in the stored proc.
View 2 Replies View RelatedReading A Text File
Jan 18, 2005hi
I need to read a hex file, the file path is in the database, and I need to read the file from sql.
Any help would be appresiated
Reading From An Excel File
Feb 7, 2002I need to select a list of rows from excel file.
I formed my query in this way :
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="MOC02c:empest/xls";Extended properties=Excel 97-2000')...xactions
This gives an error
Error is
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
If anybody knows how to read from an excel file to a query analyser , pelase reply.
Regards
Suresh
Reading Data From File
May 25, 1999Is there any way to read a text file with one value in it and load that value into a variable?
View 1 Replies View RelatedReading Sql From A Disk File
Feb 20, 2004It's probably a really easy thing to do, but I can't find out how to do it, so hopefully somebody can spare the time to help.
I want to read in T-SQL contained in a file held on disk and execute it in a stored procedure.
Anybody know how to get the contents of the text file into a variable so I can exec it ?
Thanks for your time.
Reading Sql From A Disk File
Feb 20, 2004It's probably a really easy thing to do, but I can't find out how to do it, so hopefully somebody can spare the time to help.
I want to read in T-SQL contained in a file held on disk and execute it in a stored procedure.
Anybody know how to get the contents of the text file into a variable so I can exec it ?
Thanks for your time.
Reading XML File SQL Server
Feb 27, 2004hi to all
I have been trying to read XML file in SQL Server with Stored Procedure. but i coud't get any solution.
can any one Help me.
I have XML file with List Of Countryes each Country has Id.
I need to read all Country Id,CountryName and need to be insert into DataBase or Return as String (output parameter).
How do I achive this? please Help me.
Cheers
:confused:
Buddu