Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts

Wednesday, March 7, 2012

Copy Column in SSIS

What is the use of the Copy Column in SSIS please help me

give me the example

regards

koti

Hi ya,

Copy column is only there to create new copies of the existing columns. Later you can do some transformation or do some aggregations for the new copies. You can create multiple copies of a column.

Hope this helps.


Cheers

Rizwan

Friday, February 24, 2012

Coping logins from one server to other

Hello All,
How Can I copy logins from one server to another?
Any help will be appreciated.
Regards,
Miguel.You should check out xp_help_revlogin. Here is an article that should help
you out: http://databasejournal.com/features/mssql/article.php/2228611
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Miguel Ramirez" <miguel.ramirez@.valycontrol.com.mx> wrote in message
news:ekiGfgOSEHA.3944@.tk2msftngp13.phx.gbl...
> Hello All,
> How Can I copy logins from one server to another?
> Any help will be appreciated.
> Regards,
> Miguel.
>

Sunday, February 12, 2012

converting reports

Hello.
Any one know of a utility to convert reports from Access and Crystal into
SRS?
Thanks in advance for any input
Regards
HSYou can import Access reports directly in the dev environment... Crystal you
will have to do manually... However I think HItachi has developed a
conversion tool ( not for sale ) , but one their consultants use on their
gigs...It might be cheaper to hire them...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"HSalim[MVP]" wrote:
> Hello.
> Any one know of a utility to convert reports from Access and Crystal into
> SRS?
> Thanks in advance for any input
> Regards
> HS
>
>