data export to flat file

Hi, I hope you can help, and thank you.
SQL 2000. I need to generate a flat file export from a single table. I need
a line feed between select fields. I've tried using bcp and Bulk Insert with
a format file, but I've never used either, and I must be missing a critical
step somewhere.
The flat file format for a single record would be similar to the following:
Field1, Field2, Field3, Field4, Field5, Image Path1
Image Path2
Image Path3
I appreciate any assistance you can provide. Thanks!
Did you try the DTS (data transfomation service)tool in SQL Server 2000?
Easy to use for transforming data to export files.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/dtssql2k.mspx
Good luck.
sql

data export to flat file

Hi, I hope you can help, and thank you.
SQL 2000. I need to generate a flat file export from a single table. I nee
d
a line feed between select fields. I've tried using bcp and Bulk Insert with
a format file, but I've never used either, and I must be missing a critical
step somewhere.
The flat file format for a single record would be similar to the following:
Field1, Field2, Field3, Field4, Field5, Image Path1
Image Path2
Image Path3
I appreciate any assistance you can provide. Thanks!Did you try the DTS (data transfomation service)tool in SQL Server 2000?
Easy to use for transforming data to export files.
http://www.microsoft.com/technet/pr...y/dtssql2k.mspx
Good luck.

Data Driven Subscription with no results

I have a data driven subscription that is set up to email and uses a sql statement to generate the delivery settings and report parameters for each recipient (so each person does not reveive one email per row in the result set). I'm told that this is a good work around for creating a subscription that will NOT fire an email if there are no results returned, however I can not seem to get this to work...it continues to send an email with a blank report if there is no data for the previous day. Any thoughts/help would be appreciated. thanks in advance!If you want a fixed recipient list you want to do the following:

Assume your report data set comes from table DataTable, Pseudo SQL:
select Top 1 * from DataTable where InsertDate >= DATEADD(day, -1, GETDATE())

This will return exactly one row (one delivery) anytime there is data to report on. If you have multiple data sets in your report you'll need to play with the Joins to get this behavior.

Then in your subscription in the TO field, provide the static list of recipients.

If you need a dynamic list of recipients, I'd write a stored proc that returns the list of recipients if there was data in the DataTable, or no rows if there wasn't.

-Lukaszsql

Data Dictionary

In SQL 2000 is there a way to generate a data dictionary of an existing data
base? If so how do you go about doing it? In Access it has a documenter that
will create one for you. ThanksSQL doesn't really have a tool like that, but there are a couple of things
you might do.
1. Right click a database in SQL Enterprise manager -> all tasks -> generate
Sql script...
2. Go to metadata in Enterprise Manager (under Data transformation services)
and import metdata...
Neither is really what you are looking for I suspect
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:C5866E7F-E6A7-4791-8F28-2C82E3343984@.microsoft.com...

quote:

---

> In SQL 2000 is there a way to generate a data dictionary of an existing

---

database? If so how do you go about doing it? In Access it has a documenter
that will create one for you. Thankssql

Data Dictionary

In SQL 2000 is there a way to generate a data dictionary of an existing database? If so how do you go about doing it? In Access it has a documenter that will create one for you. ThanksSQL doesn't really have a tool like that, but there are a couple of things
you might do.
1. Right click a database in SQL Enterprise manager -> all tasks -> generate
Sql script...
2. Go to metadata in Enterprise Manager (under Data transformation services)
and import metdata...
Neither is really what you are looking for I suspect
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:C5866E7F-E6A7-4791-8F28-2C82E3343984@.microsoft.com...
> In SQL 2000 is there a way to generate a data dictionary of an existing
database? If so how do you go about doing it? In Access it has a documenter
that will create one for you. Thankssql

Data Diagram Software

Hi SQL Gurus,
I have a database that has 250 tables. I need to a 3rd party software that
will generate data diagram for me. I used data diagram from sql but it is
useless with a huge amount of tables.
I would be nice if that 3rd party software can do other things more than
just generate data diagram.
Your suggestions are always highly regarded.
Vito Corleone
My personal choice is Visio for Enterprise Architects. It will do forward
and reverse database engineering as well as excellent diagramming. It also
is included in several MSDN products so you may already have a license for
it.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Vito Corleone" <VitoCorleone@.discussions.microsoft.com> wrote in message
news:7A80466D-2948-4775-94A8-70EC75C76AB5@.microsoft.com...
> Hi SQL Gurus,
> I have a database that has 250 tables. I need to a 3rd party software
> that
> will generate data diagram for me. I used data diagram from sql but it is
> useless with a huge amount of tables.
> I would be nice if that 3rd party software can do other things more than
> just generate data diagram.
> Your suggestions are always highly regarded.
> Vito Corleone

Daily build - trying to deploy from the command line

Hi

I'm trying to automate the build of a SSIS VisualStudio solution (ie I want to generate the deploy package automatically), but I get a weird error:

Error: Could not get a list of SSIS packages from the project.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

I get this error when launching devenv with the following command-line:

devenv.exe MySolution.sln /Deploy development /Out build.log

Did anyone already meet this error ? How can I avoid that ?

regards

Thibaut
I should add that this error only appears when I set the CreateDeploymentUtility variable to true under the Deployment Utility section of the properties...|||Hi

Is there actually a anyone launching devenv.exe to generate the deployment packages ?

If no, is there any other known alternative ? (the idea is to automate the deployment package creation on a build server).

any hint will be most welcome.

regards

Thibaut|||

This link might help.

http://mgarner.wordpress.com/2006/08/31/automating-ssis-deployment/

Daily build - trying to deploy from the command line

Hi

I'm trying to automate the build of a SSIS VisualStudio solution (ie I want to generate the deploy package automatically), but I get a weird error:

Error: Could not get a list of SSIS packages from the project.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

I get this error when launching devenv with the following command-line:

devenv.exe MySolution.sln /Deploy development /Out build.log

Did anyone already meet this error ? How can I avoid that ?

regards

Thibaut
I should add that this error only appears when I set the CreateDeploymentUtility variable to true under the Deployment Utility section of the properties...|||Hi

Is there actually a anyone launching devenv.exe to generate the deployment packages ?

If no, is there any other known alternative ? (the idea is to automate the deployment package creation on a build server).

any hint will be most welcome.

regards

Thibaut|||

This link might help.

http://mgarner.wordpress.com/2006/08/31/automating-ssis-deployment/