.PST to SQL

Dear all,
Does anyone know how to migrate .PST files into Sql Server? Is there any
odbc, driver or something like that?
I think that in sql2k there was no like that but I was wondering about Sql25
k
Thanks for any suggestion,
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)That's an Outlook Personal Folder file, right?
Within Outlook, if you select "Export to a File", there are options to
export to delimited text, MS Access or MS Excel, which can be more readily
imported using Enterprise Manager or DTS.
If you are an application developer, there is an ADO and ADO.NET provider
for Exchange Server. Other APIs for programatically getting messages from
Exchange Server or Outlook are OLE Automation, CDO, and WMI:
http://www.microsoft.com/technet/sc...ap.msp
x
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:668DABFB-6FCB-46FE-B8F8-34176E22D587@.microsoft.com...
> Dear all,
> Does anyone know how to migrate .PST files into Sql Server? Is there any
> odbc, driver or something like that?
> I think that in sql2k there was no like that but I was wondering about
> Sql25k
> Thanks for any suggestion,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||i would suspect the best way is to do an export to csv from outlook,
then use bcp or bulk insert, unless you have a lot of them to do.|||Thank a lot both
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"Johnny D" wrote:

> i would suspect the best way is to do an export to csv from outlook,
> then use bcp or bulk insert, unless you have a lot of them to do.
>

.dat and .idx

I have .idx and .dat files. I need an ODBC driver to allow me to attach to
or import these tables. Anyone have any clue how to help me?idx is the default for index creation statement. I don't know recognize the
.dat extension. You should be able to run the idx file as a normal SQL
statement.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:u46gUx6yGHA.2036@.TK2MSFTNGP05.phx.gbl...
>I have .idx and .dat files. I need an ODBC driver to allow me to attach to
>or import these tables. Anyone have any clue how to help me?
>|||Ben Watts wrote:
> I have .idx and .dat files. I need an ODBC driver to allow me to attach to
> or import these tables. Anyone have any clue how to help me?
>
What are these files from?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

.dat and .idx

I have .idx and .dat files. I need an ODBC driver to allow me to attach to
or import these tables. Anyone have any clue how to help me?idx is the default for index creation statement. I don't know recognize the
.dat extension. You should be able to run the idx file as a normal SQL
statement.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:u46gUx6yGHA.2036@.TK2MSFTNGP05.phx.gbl...
>I have .idx and .dat files. I need an ODBC driver to allow me to attach to
>or import these tables. Anyone have any clue how to help me?
>|||Ben Watts wrote:
> I have .idx and .dat files. I need an ODBC driver to allow me to attach to
> or import these tables. Anyone have any clue how to help me?
>
What are these files from?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

.:: MS-SQL, JTurbo and autoincrement columns ::.

Hi all!
Does anyone knows how to get if a column is autoincrement or not, using the DatabaseMetaData in java, or using de JTurbo driver for it?
Is there any other way to figure this out?
:confused:
Thank you very much in advance for any replies.select columnproperty(object_id('table_name'), 'column_name', 'isidentity')

*******How to write a driver for RS?*********

Now I met this question: Our project need us must write a driver to retrive
data from file but not from database to form a report.
That is to say: I want retrive data from a text file to form a reporting
service.
How did I ?Read up on data processing extensions in RS help. It will tell you all about
it.
Bruce L-C
"Cao tt" <Caott@.discussions.microsoft.com> wrote in message
news:752AACD0-C405-49A8-8CBE-B6366AB2C1F8@.microsoft.com...
> Now I met this question: Our project need us must write a driver to
retrive
> data from file but not from database to form a report.
> That is to say: I want retrive data from a text file to form a reporting
> service.
> How did I ?
>|||Reporting Services Data Processing Extension (DP Extension). There are file
system based samples.
Basically you must implement a subset of the ADO.NET Data Provider plus some
Reporting Services extensions - the Reporting Services Data Provider to do
this using at least a Connection, Command, and DataReader. You do not have to
support SQL. It works quite nicely.