Mark a textbox "not for data-csv export"

Is it possible to mark a textbox in a report to not be exported to csv. This
would be similar to the "Data Output" tab for textboxes - but for csv instead
of xml?Setting the DataElementOutput value affects all "data-centric" rendering
extensions. I.e. CSV and XML. You cannot control CSV specifically in this
case.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:F6027B38-C0C4-4C89-B9B2-5CCD6A33987B@.microsoft.com...
> Is it possible to mark a textbox in a report to not be exported to csv.
> This
> would be similar to the "Data Output" tab for textboxes - but for csv
> instead
> of xml?sql

Mappings question in OLE DB Destination

Hi,

I have a situation where I want to map a column from a flat file to TWO columns in a table.

However, in the mappings tab, you can only select the "Input Column" once. Once a column has been used, it no longer appears in the drop down list.

I am wondering if there's a way to override this behavior, and if not, what is the best way to handle this type of situation?

I have added an EXECUTE SQL task to update the second column with the inserted column values, but I would like to know if the default mapping behavior can be changed, as it seems so limited.

Thanks

Add a derived column right before the destination and select the column that you want to use more than once and drag it to the expression box. Adjust the name of the new column accordingly.

Then in the OLE DB Destination you can select the column you just added.

Feel free to suggest new features over at http://connect.microsoft.com/sqlserver/feedback|||

Great, thanks

sql

Mapped Drive

Can I make my "default location" for new databases be a mapped drive? When
I go into the properties and select the database tab and select the ...
box to list my drives, the shared drive does not show up. If I go ahead
and enter the path of where I want the files to be located on the "mapped"
drive, it accepts it, but does not use it when I create a new database.
My situation is I have 2 computers in a single room and I want then to be
pointed at the same file location for all databases... Both machines have
MSDE version of sql server loaded...Can I somehow point one machine to the
second machines SQL server such that we are working on the same database?
Any ideas/suggestions'> MSDE version of sql server loaded...Can I somehow point one machine to
the
> second machines SQL server such that we are working on the same database?
I don't think you can share databases between engines (even between
instances on the same machine).
Why not just point one machine's client tools to the other machine's SQL
Server? Then one machine will be working locally, and the other will be
working "remotely" so to speak. But they will be working on the same copy
of exactly one database.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||No.
First, SQL does not support mapped drives for database or transaction log
files.
Second, when SQL does open a database file, it is completely exclusive for
that server instance. Even a second instance on the same host nod could not
access the same underlying database files.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim Heavey" <JHeavey@.nospam.com> wrote in message
news:Xns9495971974DBBJHeaveyBDUP@.207.46.248.16...
> Can I make my "default location" for new databases be a mapped drive?
When
> I go into the properties and select the database tab and select the ...
> box to list my drives, the shared drive does not show up. If I go ahead
> and enter the path of where I want the files to be located on the "mapped"
> drive, it accepts it, but does not use it when I create a new database.
> My situation is I have 2 computers in a single room and I want then to be
> pointed at the same file location for all databases... Both machines
have
> MSDE version of sql server loaded...Can I somehow point one machine to
the
> second machines SQL server such that we are working on the same database?
> Any ideas/suggestions'

Mapped Drive

Can I make my "default location" for new databases be a mapped drive? When
I go into the properties and select the database tab and select the ...
box to list my drives, the shared drive does not show up. If I go ahead
and enter the path of where I want the files to be located on the "mapped"
drive, it accepts it, but does not use it when I create a new database.
My situation is I have 2 computers in a single room and I want then to be
pointed at the same file location for all databases... Both machines have
MSDE version of sql server loaded...Can I somehow point one machine to the
second machines SQL server such that we are working on the same database?
Any ideas/suggestions'> MSDE version of sql server loaded...Can I somehow point one machine to
the
> second machines SQL server such that we are working on the same database?
I don't think you can share databases between engines (even between
instances on the same machine).
Why not just point one machine's client tools to the other machine's SQL
Server? Then one machine will be working locally, and the other will be
working "remotely" so to speak. But they will be working on the same copy
of exactly one database.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||No.
First, SQL does not support mapped drives for database or transaction log
files.
Second, when SQL does open a database file, it is completely exclusive for
that server instance. Even a second instance on the same host nod could not
access the same underlying database files.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim Heavey" <JHeavey@.nospam.com> wrote in message
news:Xns9495971974DBBJHeaveyBDUP@.207.46.248.16...
> Can I make my "default location" for new databases be a mapped drive?
When
> I go into the properties and select the database tab and select the ...
> box to list my drives, the shared drive does not show up. If I go ahead
> and enter the path of where I want the files to be located on the "mapped"
> drive, it accepts it, but does not use it when I create a new database.
> My situation is I have 2 computers in a single room and I want then to be
> pointed at the same file location for all databases... Both machines
have
> MSDE version of sql server loaded...Can I somehow point one machine to
the
> second machines SQL server such that we are working on the same database?
> Any ideas/suggestions'

mapinfo, tab, data, import, sql server

Hello,
I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y informa
tion will be stored. But I want to save the full spatial information into database.
My question is:
1. Does sql server 2000 need to be configured to support the spatial datatype?
2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
Thank you for your attention.
kind regards
chenyu
Chenyu,
SQL Server does not support a native data type for geometries. However, you can use a product called MapInfo SpatialWare to acquire full support for geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to speak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y infor
mation will be stored. But I want to save the full spatial information into database.
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datatype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
>
> Thank you for your attention.
> kind regards
> chenyu
|||Chenyu,
SQL Server does not support a native data type for geometries. However, you can use a product called MapInfo SpatialWare to acquire full support for geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to speak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y infor
mation will be stored. But I want to save the full spatial information into database.
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datatype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
>
> Thank you for your attention.
> kind regards
> chenyu
sql

mapinfo, tab, data, import, sql server

Hello,
I have "mapinfo" street sample data in hands and the format is "tab". The pu
rpose is to upload the data into sql server 2000 database.
At first, I have used mapinfo professional 7.0's easyloader tool through ODB
C. But after pushing the "upload" button, the warning message gives to me th
at "the database does not supports 'point spatial' data type, therefore only
the center X and Y informa
tion will be stored. But I want to save the full spatial information into da
tabase.
My question is:
1. Does sql server 2000 need to be configured to support the spatial datatyp
e?
2. Could I use mapinfo's easyloader to do the task? If not, what's tools sho
uld I use?
Thank you for your attention.
kind regards
chenyuChenyu,
SQL Server does not support a native data type for geometries. However, you
can use a product called MapInfo SpatialWare to acquire full support fo
r geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to s
peak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The
purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But
after pushing the "upload" button, the warning message gives to me that "the databa
se does not supports 'point spatial' data type, therefore only the center X and Y in
for
mation will be stored. But I want to save the full spatial information into database.seagreen">
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datat
ype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools s
hould I use?
>
> Thank you for your attention.
> kind regards
> chenyu|||Chenyu,
SQL Server does not support a native data type for geometries. However, you
can use a product called MapInfo SpatialWare to acquire full support fo
r geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to s
peak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The
purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But
after pushing the "upload" button, the warning message gives to me that "the databa
se does not supports 'point spatial' data type, therefore only the center X and Y in
for
mation will be stored. But I want to save the full spatial information into database.seagreen">
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datat
ype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools s
hould I use?
>
> Thank you for your attention.
> kind regards
> chenyu