Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts

Thursday, March 22, 2012

Download DTS Designer?

Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express?Ellen,
No. SSIS is not provided with Express.

-Jamie|||

Jamie,

Is there a download available for SSIS that will run on Express? If so, where can I find it?

Thanks!

|||SSIS is not included with Express, but you can use an Express database as a source or destination for an SSIS package. SSIS comes with the Standard, Enterprise, and Developer Editions of SQL Server.

Download DTS Designer?

Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express?Ellen,
No. SSIS is not provided with Express.

-Jamie

Sunday, March 11, 2012

Double Line border turn to be single in Reporting Service

I tried to set double in bottom border of text file. But it turned out to be single line either Previewing in Designer or Printing or Exporting to PDF. Does anyone have any idea?Try to increase width to at least 3pt|||

Thank you for your post, Lev. I just tried that. But it seems not working even I set borderwidth to 5pt. I found double line is OK only when exporting to excel. Does anyone else have the same issue with me?

|||

What version of RS are you using? Are you viewing the PDF at 100% zoom? It should work with a width of >3pt.

Thank you.

|||

Dear Donovan,

I tried again after your reply. It did work this time. There must be somewhere wrong while I did my test yesterday.

Thank both of you, Lev & Donovan!

Cheers!

|||I am having the exact same problem. I am using RS2005. I set the bottom border to double. I have tried changing the border width and this just makes the single line that is displayed thicker. If I export to Excel, I can see the double line, otherwise in preview, pdf, etc, I only see the single line. Any other ideas?|||

Could this be the result of border clipping? Is the report item you placed the double border on inside of another item? A border starts at the edge of a report item and extends out half the width on each side of this edge. If the item with a border is contained inside another item, any of the border that extends beyond the bounds of that container will be clipped. In this way, a double border will appear to show only a single border if half of it is clipped.

If that's not the case, would you please either post a simple demonstration RDL to this thread or open a bug on http://connect.microsoft.com so I can take a look?

Thank you.

|||It looks like the border is being "clipped off". I am using a matrix to display the data. The very last row of the matrix is where I am attempting to set the bottom border as double. If I add another row below this one, the double border is displayed correctly.

Double Line border turn to be single in Reporting Service

I tried to set double in bottom border of text file. But it turned out to be single line either Previewing in Designer or Printing or Exporting to PDF. Does anyone have any idea?Try to increase width to at least 3pt|||

Thank you for your post, Lev. I just tried that. But it seems not working even I set borderwidth to 5pt. I found double line is OK only when exporting to excel. Does anyone else have the same issue with me?

|||

What version of RS are you using? Are you viewing the PDF at 100% zoom? It should work with a width of >3pt.

Thank you.

|||

Dear Donovan,

I tried again after your reply. It did work this time. There must be somewhere wrong while I did my test yesterday.

Thank both of you, Lev & Donovan!

Cheers!

|||I am having the exact same problem. I am using RS2005. I set the bottom border to double. I have tried changing the border width and this just makes the single line that is displayed thicker. If I export to Excel, I can see the double line, otherwise in preview, pdf, etc, I only see the single line. Any other ideas?|||

Could this be the result of border clipping? Is the report item you placed the double border on inside of another item? A border starts at the edge of a report item and extends out half the width on each side of this edge. If the item with a border is contained inside another item, any of the border that extends beyond the bounds of that container will be clipped. In this way, a double border will appear to show only a single border if half of it is clipped.

If that's not the case, would you please either post a simple demonstration RDL to this thread or open a bug on http://connect.microsoft.com so I can take a look?

Thank you.

|||It looks like the border is being "clipped off". I am using a matrix to display the data. The very last row of the matrix is where I am attempting to set the bottom border as double. If I add another row below this one, the double border is displayed correctly.

Friday, February 17, 2012

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?
Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?
|||I've installed Visio for VS2005 Beta? but I can't found where is that command
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.
|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||I've installed visio for VS2005 Beta? but I can't found where is that comman
d
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Tuesday, February 14, 2012

Does the Undo operation work ?

Hi ,

I was working in the SSIS designer and when I found that the DataFlow task I deleted was indeed something I needed, I tried to Undo the operation but Alas the option is not enabled :(

Is there a way we can undo the operations?

as such I guess there is no way u can undo any changes. best possible way, work in Foundation server and keep checking in whenever you feel you are completed.

Does the Undo operation work ?

Hi ,

I was working in the SSIS designer and when I found that the DataFlow task I deleted was indeed something I needed, I tried to Undo the operation but Alas the option is not enabled :(

Is there a way we can undo the operations?

as such I guess there is no way u can undo any changes. best possible way, work in Foundation server and keep checking in whenever you feel you are completed.