Comparing MSDE to Access - Import Wizard?

I need to rewrite an Access 2000 application to use MSDE and .NET. The one
feature I'm worried about is the ability to import tables and/or data from
Access, Excel, txt, even Outlook.
The Access Import Wizard is used a lot here and the app in question has a
lot of VBA code that works with imported tables for getting data into the
database. Does MSDE have an Import Wizard like Access? Will I have to code
all this functionality from scratch?
Thanks in advance.
hi,
deko wrote:
> I need to rewrite an Access 2000 application to use MSDE and .NET. The one
> feature I'm worried about is the ability to import tables
> and/or data from Access, Excel, txt, even Outlook.
> The Access Import Wizard is used a lot here and the app in question
> has a lot of VBA code that works with imported tables for getting
> data into the database. Does MSDE have an Import Wizard like Access?
> Will I have to code all this functionality from scratch?
> Thanks in advance.
MSDE comes with no tools but oSql.exe, BCP.exe and the DTS runtime... you
can perhaps modify your import schema to sue such tools... or, youn can even
rely on Access based database as linked server to use the JET OLE DB
provider to a access dbf, txt, excel, mdb .... and the like...
http://tinyurl.com/9vdrz
http://tinyurl.com/anvbn
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!
Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQL...pare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegr oups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>
|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQ...mpare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegroups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQL_Data_Compare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegroups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Compacting a database MS SQL

Hi
for mS SQL 2000-2500
LDF and MDF files can be very very big, if I import the datas into a new database they can become 10 time smaller
is there a way to compact (reduce the MB) of a database ?
thank youLook up DBCC SHRINKDATABASE and DBCC SHRINKFILE in BOL.|||thank you !|||Do not shrink your databases. It can impair performance. SQL Server databases are not like Microsoft Access databases, and do not need to be regularly compacted.|||if I import the datas into a new database they can become 10 time smaller.

is there a way to compact (reduce the MB) of a database ?

Yeah, you can transfer required data in the new database - using DTS.

Accordingly, make changes in your application for accessing old data too.

Note : Before any action you need to deeply analyze pros & cons for the current issues as well as upcoming issues.

compability of visual studio express vs visual studio

Can anyone tell me if Visual Studio Express and Visual Studio Report Designer
are compatible when designing reports? We tried to import .RDL files between
the two and were unsuccessful.
Our intent is to give our user something like Visual Studio Express to
develop reports , but yet be flexiable enough to maintain them or enhance
them using the full Visual Studio version. Or, take a report done in the full
version and allow he user to modify it in the Visual Studio Express version.
I highly doubt this is possible but I need some outside opinions on this.
Thanks for your time,
Dave SundellNone of this is necessary if you are using RS 2005. It comes with its own
version of VS. It will integrate with it if you have it, otherwise it will
install its own. If you are not writing your own assemblies then no need for
buying VS. This is a change from RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> Can anyone tell me if Visual Studio Express and Visual Studio Report
> Designer
> are compatible when designing reports? We tried to import .RDL files
> between
> the two and were unsuccessful.
> Our intent is to give our user something like Visual Studio Express to
> develop reports , but yet be flexiable enough to maintain them or enhance
> them using the full Visual Studio version. Or, take a report done in the
> full
> version and allow he user to modify it in the Visual Studio Express
> version.
> I highly doubt this is possible but I need some outside opinions on this.
> Thanks for your time,
> Dave Sundell|||Are you talking about Report Builder in RS 2005?
I need users to beable to modify reports that were designed/developed using
Report Designer. And visa versa, beable to modify reports that were done with
Vistual Studio Express and edit them in full Visual Stduio.
I suppose we can buy them a full version of Visual Studio but some asked me
to look into Visual Studio Express. I am installing it now in a Virtual PC
mode as to not mess my normal Visual Studio environment.
Back to Report Builder. I am sorry but it is not the same as Report Designer
and we have had user experienced in Crystal reports and we need to give them
something a little closer, like Report Designer. But we were pointed towards
Visual Studio Express as a solution.
"Bruce L-C [MVP]" wrote:
> None of this is necessary if you are using RS 2005. It comes with its own
> version of VS. It will integrate with it if you have it, otherwise it will
> install its own. If you are not writing your own assemblies then no need for
> buying VS. This is a change from RS 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> > Designer
> > are compatible when designing reports? We tried to import .RDL files
> > between
> > the two and were unsuccessful.
> >
> > Our intent is to give our user something like Visual Studio Express to
> > develop reports , but yet be flexiable enough to maintain them or enhance
> > them using the full Visual Studio version. Or, take a report done in the
> > full
> > version and allow he user to modify it in the Visual Studio Express
> > version.
> >
> > I highly doubt this is possible but I need some outside opinions on this.
> >
> > Thanks for your time,
> >
> > Dave Sundell
>
>|||No, I am talking about Report Designer not Report Builder. RS 2005 when it
installed BI (or whatever it calls it, when you install Report Designer) it
will integrate with VS 2005 if you have it, otherwise it installs a special
version just for RS 2005 Report Designer.
This was not the case with RS 2000 report designer. For that you first had
to have VS 2003. Again, that is not the case for RS 2005 report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> Are you talking about Report Builder in RS 2005?
> I need users to beable to modify reports that were designed/developed
> using
> Report Designer. And visa versa, beable to modify reports that were done
> with
> Vistual Studio Express and edit them in full Visual Stduio.
> I suppose we can buy them a full version of Visual Studio but some asked
> me
> to look into Visual Studio Express. I am installing it now in a Virtual PC
> mode as to not mess my normal Visual Studio environment.
> Back to Report Builder. I am sorry but it is not the same as Report
> Designer
> and we have had user experienced in Crystal reports and we need to give
> them
> something a little closer, like Report Designer. But we were pointed
> towards
> Visual Studio Express as a solution.
>
> "Bruce L-C [MVP]" wrote:
>> None of this is necessary if you are using RS 2005. It comes with its own
>> version of VS. It will integrate with it if you have it, otherwise it
>> will
>> install its own. If you are not writing your own assemblies then no need
>> for
>> buying VS. This is a change from RS 2000.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> > Designer
>> > are compatible when designing reports? We tried to import .RDL files
>> > between
>> > the two and were unsuccessful.
>> >
>> > Our intent is to give our user something like Visual Studio Express to
>> > develop reports , but yet be flexiable enough to maintain them or
>> > enhance
>> > them using the full Visual Studio version. Or, take a report done in
>> > the
>> > full
>> > version and allow he user to modify it in the Visual Studio Express
>> > version.
>> >
>> > I highly doubt this is possible but I need some outside opinions on
>> > this.
>> >
>> > Thanks for your time,
>> >
>> > Dave Sundell
>>|||Ist it free to anyone or if do you need a license. Is it a download or can
we allow any person to install from a SQL Server 2005 cd?
By the way, thanks for your response/time.
dave
"Bruce L-C [MVP]" wrote:
> No, I am talking about Report Designer not Report Builder. RS 2005 when it
> installed BI (or whatever it calls it, when you install Report Designer) it
> will integrate with VS 2005 if you have it, otherwise it installs a special
> version just for RS 2005 Report Designer.
> This was not the case with RS 2000 report designer. For that you first had
> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> > Are you talking about Report Builder in RS 2005?
> >
> > I need users to beable to modify reports that were designed/developed
> > using
> > Report Designer. And visa versa, beable to modify reports that were done
> > with
> > Vistual Studio Express and edit them in full Visual Stduio.
> >
> > I suppose we can buy them a full version of Visual Studio but some asked
> > me
> > to look into Visual Studio Express. I am installing it now in a Virtual PC
> > mode as to not mess my normal Visual Studio environment.
> >
> > Back to Report Builder. I am sorry but it is not the same as Report
> > Designer
> > and we have had user experienced in Crystal reports and we need to give
> > them
> > something a little closer, like Report Designer. But we were pointed
> > towards
> > Visual Studio Express as a solution.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> None of this is necessary if you are using RS 2005. It comes with its own
> >> version of VS. It will integrate with it if you have it, otherwise it
> >> will
> >> install its own. If you are not writing your own assemblies then no need
> >> for
> >> buying VS. This is a change from RS 2000.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> > Designer
> >> > are compatible when designing reports? We tried to import .RDL files
> >> > between
> >> > the two and were unsuccessful.
> >> >
> >> > Our intent is to give our user something like Visual Studio Express to
> >> > develop reports , but yet be flexiable enough to maintain them or
> >> > enhance
> >> > them using the full Visual Studio version. Or, take a report done in
> >> > the
> >> > full
> >> > version and allow he user to modify it in the Visual Studio Express
> >> > version.
> >> >
> >> > I highly doubt this is possible but I need some outside opinions on
> >> > this.
> >> >
> >> > Thanks for your time,
> >> >
> >> > Dave Sundell
> >>
> >>
> >>
>
>|||It is free. RS 2005 is licensed by the server. There is no cost/licensing
for the report designer. Just use the SQL 2005 CD and install Report
Designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> Ist it free to anyone or if do you need a license. Is it a download or
> can
> we allow any person to install from a SQL Server 2005 cd?
> By the way, thanks for your response/time.
> dave
> "Bruce L-C [MVP]" wrote:
>> No, I am talking about Report Designer not Report Builder. RS 2005 when
>> it
>> installed BI (or whatever it calls it, when you install Report Designer)
>> it
>> will integrate with VS 2005 if you have it, otherwise it installs a
>> special
>> version just for RS 2005 Report Designer.
>> This was not the case with RS 2000 report designer. For that you first
>> had
>> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> > Are you talking about Report Builder in RS 2005?
>> >
>> > I need users to beable to modify reports that were designed/developed
>> > using
>> > Report Designer. And visa versa, beable to modify reports that were
>> > done
>> > with
>> > Vistual Studio Express and edit them in full Visual Stduio.
>> >
>> > I suppose we can buy them a full version of Visual Studio but some
>> > asked
>> > me
>> > to look into Visual Studio Express. I am installing it now in a Virtual
>> > PC
>> > mode as to not mess my normal Visual Studio environment.
>> >
>> > Back to Report Builder. I am sorry but it is not the same as Report
>> > Designer
>> > and we have had user experienced in Crystal reports and we need to give
>> > them
>> > something a little closer, like Report Designer. But we were pointed
>> > towards
>> > Visual Studio Express as a solution.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> None of this is necessary if you are using RS 2005. It comes with its
>> >> own
>> >> version of VS. It will integrate with it if you have it, otherwise it
>> >> will
>> >> install its own. If you are not writing your own assemblies then no
>> >> need
>> >> for
>> >> buying VS. This is a change from RS 2000.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> >> > Designer
>> >> > are compatible when designing reports? We tried to import .RDL files
>> >> > between
>> >> > the two and were unsuccessful.
>> >> >
>> >> > Our intent is to give our user something like Visual Studio Express
>> >> > to
>> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> > enhance
>> >> > them using the full Visual Studio version. Or, take a report done in
>> >> > the
>> >> > full
>> >> > version and allow he user to modify it in the Visual Studio Express
>> >> > version.
>> >> >
>> >> > I highly doubt this is possible but I need some outside opinions on
>> >> > this.
>> >> >
>> >> > Thanks for your time,
>> >> >
>> >> > Dave Sundell
>> >>
>> >>
>> >>
>>|||I discovered my problem. I forgot that I was sharing a report from Visual
Studio 2003 with Visual Studio Express and visa versa. Once I shared between
Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
I will look at Report Designer. Is that a simlar environment as Visual
Studio Express?
Dave
"Bruce L-C [MVP]" wrote:
> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> for the report designer. Just use the SQL 2005 CD and install Report
> Designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> > Ist it free to anyone or if do you need a license. Is it a download or
> > can
> > we allow any person to install from a SQL Server 2005 cd?
> >
> > By the way, thanks for your response/time.
> >
> > dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, I am talking about Report Designer not Report Builder. RS 2005 when
> >> it
> >> installed BI (or whatever it calls it, when you install Report Designer)
> >> it
> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> special
> >> version just for RS 2005 Report Designer.
> >>
> >> This was not the case with RS 2000 report designer. For that you first
> >> had
> >> to have VS 2003. Again, that is not the case for RS 2005 report designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> > Are you talking about Report Builder in RS 2005?
> >> >
> >> > I need users to beable to modify reports that were designed/developed
> >> > using
> >> > Report Designer. And visa versa, beable to modify reports that were
> >> > done
> >> > with
> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >
> >> > I suppose we can buy them a full version of Visual Studio but some
> >> > asked
> >> > me
> >> > to look into Visual Studio Express. I am installing it now in a Virtual
> >> > PC
> >> > mode as to not mess my normal Visual Studio environment.
> >> >
> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> > Designer
> >> > and we have had user experienced in Crystal reports and we need to give
> >> > them
> >> > something a little closer, like Report Designer. But we were pointed
> >> > towards
> >> > Visual Studio Express as a solution.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> None of this is necessary if you are using RS 2005. It comes with its
> >> >> own
> >> >> version of VS. It will integrate with it if you have it, otherwise it
> >> >> will
> >> >> install its own. If you are not writing your own assemblies then no
> >> >> need
> >> >> for
> >> >> buying VS. This is a change from RS 2000.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> >> > Designer
> >> >> > are compatible when designing reports? We tried to import .RDL files
> >> >> > between
> >> >> > the two and were unsuccessful.
> >> >> >
> >> >> > Our intent is to give our user something like Visual Studio Express
> >> >> > to
> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> > enhance
> >> >> > them using the full Visual Studio version. Or, take a report done in
> >> >> > the
> >> >> > full
> >> >> > version and allow he user to modify it in the Visual Studio Express
> >> >> > version.
> >> >> >
> >> >> > I highly doubt this is possible but I need some outside opinions on
> >> >> > this.
> >> >> >
> >> >> > Thanks for your time,
> >> >> >
> >> >> > Dave Sundell
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It is a version of VS just for hosting the Report Designer. Functionally no
difference. However, it only installs if you do not have VS 2005 installed.
If VS 2005 is there then it integrates with it. Also, I found out that if
you have installed Report Designer first and then VS 2005 that you will not
see Report Designer in it. If you want Report Designer integrated with VS
(for instance you have VB.Net 2005 installed) then install VB.Net 2005
first, then report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
>I discovered my problem. I forgot that I was sharing a report from Visual
> Studio 2003 with Visual Studio Express and visa versa. Once I shared
> between
> Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> I will look at Report Designer. Is that a simlar environment as Visual
> Studio Express?
> Dave
> "Bruce L-C [MVP]" wrote:
>> It is free. RS 2005 is licensed by the server. There is no cost/licensing
>> for the report designer. Just use the SQL 2005 CD and install Report
>> Designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
>> > Ist it free to anyone or if do you need a license. Is it a download or
>> > can
>> > we allow any person to install from a SQL Server 2005 cd?
>> >
>> > By the way, thanks for your response/time.
>> >
>> > dave
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, I am talking about Report Designer not Report Builder. RS 2005
>> >> when
>> >> it
>> >> installed BI (or whatever it calls it, when you install Report
>> >> Designer)
>> >> it
>> >> will integrate with VS 2005 if you have it, otherwise it installs a
>> >> special
>> >> version just for RS 2005 Report Designer.
>> >>
>> >> This was not the case with RS 2000 report designer. For that you first
>> >> had
>> >> to have VS 2003. Again, that is not the case for RS 2005 report
>> >> designer.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> >> > Are you talking about Report Builder in RS 2005?
>> >> >
>> >> > I need users to beable to modify reports that were
>> >> > designed/developed
>> >> > using
>> >> > Report Designer. And visa versa, beable to modify reports that were
>> >> > done
>> >> > with
>> >> > Vistual Studio Express and edit them in full Visual Stduio.
>> >> >
>> >> > I suppose we can buy them a full version of Visual Studio but some
>> >> > asked
>> >> > me
>> >> > to look into Visual Studio Express. I am installing it now in a
>> >> > Virtual
>> >> > PC
>> >> > mode as to not mess my normal Visual Studio environment.
>> >> >
>> >> > Back to Report Builder. I am sorry but it is not the same as Report
>> >> > Designer
>> >> > and we have had user experienced in Crystal reports and we need to
>> >> > give
>> >> > them
>> >> > something a little closer, like Report Designer. But we were pointed
>> >> > towards
>> >> > Visual Studio Express as a solution.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> None of this is necessary if you are using RS 2005. It comes with
>> >> >> its
>> >> >> own
>> >> >> version of VS. It will integrate with it if you have it, otherwise
>> >> >> it
>> >> >> will
>> >> >> install its own. If you are not writing your own assemblies then no
>> >> >> need
>> >> >> for
>> >> >> buying VS. This is a change from RS 2000.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
>> >> >> > Report
>> >> >> > Designer
>> >> >> > are compatible when designing reports? We tried to import .RDL
>> >> >> > files
>> >> >> > between
>> >> >> > the two and were unsuccessful.
>> >> >> >
>> >> >> > Our intent is to give our user something like Visual Studio
>> >> >> > Express
>> >> >> > to
>> >> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> >> > enhance
>> >> >> > them using the full Visual Studio version. Or, take a report done
>> >> >> > in
>> >> >> > the
>> >> >> > full
>> >> >> > version and allow he user to modify it in the Visual Studio
>> >> >> > Express
>> >> >> > version.
>> >> >> >
>> >> >> > I highly doubt this is possible but I need some outside opinions
>> >> >> > on
>> >> >> > this.
>> >> >> >
>> >> >> > Thanks for your time,
>> >> >> >
>> >> >> > Dave Sundell
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Bruce,
Thank you for your time and response to this matter.
In conclusion, I did install Report Designer and it seems to be a better
route then installing SQL Express since the user really doesn't need SQL
installed but simply the environment to design a report.
Thanks again.
"Bruce L-C [MVP]" wrote:
> It is a version of VS just for hosting the Report Designer. Functionally no
> difference. However, it only installs if you do not have VS 2005 installed.
> If VS 2005 is there then it integrates with it. Also, I found out that if
> you have installed Report Designer first and then VS 2005 that you will not
> see Report Designer in it. If you want Report Designer integrated with VS
> (for instance you have VB.Net 2005 installed) then install VB.Net 2005
> first, then report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
> >I discovered my problem. I forgot that I was sharing a report from Visual
> > Studio 2003 with Visual Studio Express and visa versa. Once I shared
> > between
> > Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> >
> > I will look at Report Designer. Is that a simlar environment as Visual
> > Studio Express?
> >
> > Dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> >> for the report designer. Just use the SQL 2005 CD and install Report
> >> Designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> >> > Ist it free to anyone or if do you need a license. Is it a download or
> >> > can
> >> > we allow any person to install from a SQL Server 2005 cd?
> >> >
> >> > By the way, thanks for your response/time.
> >> >
> >> > dave
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No, I am talking about Report Designer not Report Builder. RS 2005
> >> >> when
> >> >> it
> >> >> installed BI (or whatever it calls it, when you install Report
> >> >> Designer)
> >> >> it
> >> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> >> special
> >> >> version just for RS 2005 Report Designer.
> >> >>
> >> >> This was not the case with RS 2000 report designer. For that you first
> >> >> had
> >> >> to have VS 2003. Again, that is not the case for RS 2005 report
> >> >> designer.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> >> > Are you talking about Report Builder in RS 2005?
> >> >> >
> >> >> > I need users to beable to modify reports that were
> >> >> > designed/developed
> >> >> > using
> >> >> > Report Designer. And visa versa, beable to modify reports that were
> >> >> > done
> >> >> > with
> >> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >> >
> >> >> > I suppose we can buy them a full version of Visual Studio but some
> >> >> > asked
> >> >> > me
> >> >> > to look into Visual Studio Express. I am installing it now in a
> >> >> > Virtual
> >> >> > PC
> >> >> > mode as to not mess my normal Visual Studio environment.
> >> >> >
> >> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> >> > Designer
> >> >> > and we have had user experienced in Crystal reports and we need to
> >> >> > give
> >> >> > them
> >> >> > something a little closer, like Report Designer. But we were pointed
> >> >> > towards
> >> >> > Visual Studio Express as a solution.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> None of this is necessary if you are using RS 2005. It comes with
> >> >> >> its
> >> >> >> own
> >> >> >> version of VS. It will integrate with it if you have it, otherwise
> >> >> >> it
> >> >> >> will
> >> >> >> install its own. If you are not writing your own assemblies then no
> >> >> >> need
> >> >> >> for
> >> >> >> buying VS. This is a change from RS 2000.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
> >> >> >> > Report
> >> >> >> > Designer
> >> >> >> > are compatible when designing reports? We tried to import .RDL
> >> >> >> > files
> >> >> >> > between
> >> >> >> > the two and were unsuccessful.
> >> >> >> >
> >> >> >> > Our intent is to give our user something like Visual Studio
> >> >> >> > Express
> >> >> >> > to
> >> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> >> > enhance
> >> >> >> > them using the full Visual Studio version. Or, take a report done
> >> >> >> > in
> >> >> >> > the
> >> >> >> > full
> >> >> >> > version and allow he user to modify it in the Visual Studio
> >> >> >> > Express
> >> >> >> > version.
> >> >> >> >
> >> >> >> > I highly doubt this is possible but I need some outside opinions
> >> >> >> > on
> >> >> >> > this.
> >> >> >> >
> >> >> >> > Thanks for your time,
> >> >> >> >
> >> >> >> > Dave Sundell
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

command line parameters are invalid

I have a package that let me to import data from a excel book to a Sql server data base. When I try to run this package like a step into a SQL server Job it show me the next error.

"The command line parameters are invalid. The step failed."

the "command line" looks like this

/FILE "C:\Project\Package.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties=""EXCEL 8.0;HDR=YES"";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

and in my excel conexion is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="EXCEL 8.0;HDR=YES";

When i run the "Command Line" in the "Command window" the error is more expecific

"EXCEL 8.0;HDR=YES;" is not valid

So I chanded the "Command Line" in order to run it in de command window(look the double quote in the excel properties)

/FILE "C:\Project\Package.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties="EXCEL 8.0;HDR=YES";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

then the package RUN, but when i tried to do the same thing in the

sql wizzard, it just dont work and it lost the threat from de package and the errors says this time:

Couldn't find the package

Some one who knows the answer or has any idea to helpme please?

thanks

Use in the Import/Export wizard in SQL.

Adamus

|||According to current Books Online, the double quote is the correct method to escape the quotes inside the parameter. Are you running SP1? I believe they made some changes to the parsing of command lines in SP1, so perhaps that may help.|||

I have a windows 2003 server and the SP1 is only for windows vista, I have installed this version but, i don't know if it has some thing to do with that

|||

I have found the soluction,

I you have seen the command line, the excel connection doesn't have a Data Source because it change in a bucle, I modified connection string parameter in the package in oder to recive a variable with all the connection string, then when i programming my step in the job i don't need to especified the excel connection string.

Thanks Cesar for the aswer

Comma delimited file into SQL

Hello,
I have a comma delimited file where data for each field is in " ".
I use Bulk Insert to import the file into SQL table.
How do I get rid of " " ?
thank you.UPDATE MyTable SET MyCol = REPLACE(MyCol, '"', '')
I usually like to get rid of double-quotes or other legacy problems before a
BULK INSERT with a text editor or a script... Generally more efficient that
way.
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:57F89BBC-0268-439D-B55F-350617771BC5@.microsoft.com...
> Hello,
> I have a comma delimited file where data for each field is in " ".
> I use Bulk Insert to import the file into SQL table.
> How do I get rid of " " ?
> thank you.|||You can make a nice little format file to handle the quoted text identifier.
I found a great little thread for you here:
http://groups.google.com/groups?sel...2%40tkmsftngp07
Christopher Winn
Business Intelligence Engineer
Edugration Corp.
Books
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:57F89BBC-0268-439D-B55F-350617771BC5@.microsoft.com...
> Hello,
> I have a comma delimited file where data for each field is in " ".
> I use Bulk Insert to import the file into SQL table.
> How do I get rid of " " ?
> thank you.

Comma delimited errors

I need to import comma delimited text files into sql tables. in one of the column, there is a comma in the string itself. e.g.

Cust_ID Name Phone Address1 Address2

Date that I have:

001,juia, anderson,4694568855,,Cedar Spring

The data does not have double quote as text qualifiers. but as you see, on the Name column, there is a comma, which is not a delimiter. can anybody give any suggestions on how i can deal with that? i would appreciate it so much.

thanks

Jul wrote:

I need to import comma delimited text files into sql tables. in one of the column, there is a comma in the string itself. e.g.

Cust_ID Name Phone Address1 Address2

Date that I have:

001,juia, anderson,4694568855,,Cedar Spring

The data does not have double quote as text qualifiers. but as you see, on the Name column, there is a comma, which is not a delimiter. can anybody give any suggestions on how i can deal with that? i would appreciate it so much.

thanks

If the data has embedded commas, but does not have a text qualifier, I fail to see how you can clean this up. Sorry.

Either fix the format of the file by using text qualifiers, or chose a different delimiter. Tabs, semicolons, etc...|||

Phil,

Thanks for the reply. That's what I thought too..Was just wondering if anybody has ever dealt and solved this problem.

Thanks.