copying tables in SQL Server

Hi,
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.did you hear "=?Utf-8?B?c2hhcm1hbg==?="
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY if
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easiest
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > Hi,
> >
> > I am a newbie. I want to copy a table from the production database and
> > paste
> > it in the test database thus replacing the old copy in the test database.
> > What's the best way to do it? Thanks in advance.
>
>|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
> > Sharman,
> >
> > Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> > SQL Books Online for more information.
> >
> > HTH
> >
> > Jerry
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > > Hi,
> > >
> > > I am a newbie. I want to copy a table from the production database and
> > > paste
> > > it in the test database thus replacing the old copy in the test database.
> > > What's the best way to do it? Thanks in advance.
> >
> >
> >

Copying subreports

I have a subreport inside of a report that I want to copy and paste in another part of the report (two identical subreports in the same report).
What is the easiest way to accomplish this?
Thanks,
MichaelSave the subreport as a report in its own right.

copying stored procedures?

Hi all, is there a way I can simply copy the stored procedures in one DB, and "paste" them over into another DB that is identical? Thanks!You can script out any database object (right click and select Generate SQL from the menu), or you can import/export data and objects between databases (right click on the database and select import/export data in the menu).|||If the tables and views (and other objects) referenced in the stored procedure are same in both the database, then you can simply copy the Stored procedure and paste it in the other DB and use it.

You can view the stroed procdure in the Enterprise Manager by just double clicking on the procudure name or you can view the stored procedure in Query Analyser by using the stored procure sp_help <your sp name>

Copying my existing database to another server

Hi

I am running my sql 2000 database server and I just want to copy that database and paste or put on another server which has also run same version of sql 2000 database. I tried to copy and paste the ldf & mdf extensioned files which are located in "C:\Program Files\Microsoft SQL Server\MSSQL\Data" into my 2 server, but when I open up the enterprise manager, I cant see the new database. So this way dont work, I tried to do something with export and import wizard but it just creates another database and copies the data in that database in the same server. I want to copy that data and put onto another system, please guide me. I'm confused, Thanks a lot

Use the copy database wizard-http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp|||

That's it,

Thanks thanks thanks :)

|||One thing to keep in mind: Copy Database Wizard is only available in SQL2005, and the destination data source must be SQL2005. For SQL2000 you can use Backup/Restore to move databases. You may take a look at:Copying Databases to Other Servers|||Actually, it's available in SQL Server 2000 as well, see the link in my first post.|||Thanks Mudface, you teach me a lotsql

Copying grid results with column headers

Is there any way to copy grid query results with the column headers? When I
copy and paste the results into Excel now I have to manually type the
headers so I know what I'm looking at.
David,
if you are referring to Query Analyser, you can change the output format to
"Results to File...". On Tools, Options, Results, you can select to take the
column headers and select csv, column aligned etc formats. If this is a
regular process, you might like to do this in a DTS package.
HTH,
Paul Ibison
|||Do you know if there's a way to enable copying the column headers from the
grid results though? I may want to actually see the results visually before
deciding I want to copy it, making the Resuts to File a less appealing
option. If it's a long running query, running to grid first then again to
file would double the time. I'll paste the results into Excel.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OaanEGlSEHA.3768@.TK2MSFTNGP11.phx.gbl...
> David,
> if you are referring to Query Analyser, you can change the output format
to
> "Results to File...". On Tools, Options, Results, you can select to take
the
> column headers and select csv, column aligned etc formats. If this is a
> regular process, you might like to do this in a DTS package.
> HTH,
> Paul Ibison
>
|||David,
not directly as far as I know. 'Results to text' will give you visual output
with column headers, but it usually won'y format correctly in Excel.
Regards,
Paul Ibison
|||Why not go into EXCEL and IMPORT DATA - use a NEW SQL CONNECTION and get to your DATABASE.
Then from in there you can load a table, execute a query, etc.
It will load right into the EXCEL grids - headings and all - and if you like what you see, save as XLS or CSV or TDF or whatever you want - EXCEL does them all.

Copying grid results with column headers

Is there any way to copy grid query results with the column headers? When I
copy and paste the results into Excel now I have to manually type the
headers so I know what I'm looking at.David,
if you are referring to Query Analyser, you can change the output format to
"Results to File...". On Tools, Options, Results, you can select to take the
column headers and select csv, column aligned etc formats. If this is a
regular process, you might like to do this in a DTS package.
HTH,
Paul Ibison|||Do you know if there's a way to enable copying the column headers from the
grid results though? I may want to actually see the results visually before
deciding I want to copy it, making the Resuts to File a less appealing
option. If it's a long running query, running to grid first then again to
file would double the time. I'll paste the results into Excel.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OaanEGlSEHA.3768@.TK2MSFTNGP11.phx.gbl...
> David,
> if you are referring to Query Analyser, you can change the output format
to
> "Results to File...". On Tools, Options, Results, you can select to take
the
> column headers and select csv, column aligned etc formats. If this is a
> regular process, you might like to do this in a DTS package.
> HTH,
> Paul Ibison
>|||David,
not directly as far as I know. 'Results to text' will give you visual output
with column headers, but it usually won'y format correctly in Excel.
Regards,
Paul Ibison|||Why not go into EXCEL and IMPORT DATA - use a NEW SQL CONNECTION and get to
your DATABASE.
Then from in there you can load a table, execute a query, etc.
It will load right into the EXCEL grids - headings and all - and if you like
what you see, save as XLS or CSV or TDF or whatever you want - EXCEL does t
hem all.

Copying grid results with column headers

Is there any way to copy grid query results with the column headers? When I
copy and paste the results into Excel now I have to manually type the
headers so I know what I'm looking at.David,
if you are referring to Query Analyser, you can change the output format to
"Results to File...". On Tools, Options, Results, you can select to take the
column headers and select csv, column aligned etc formats. If this is a
regular process, you might like to do this in a DTS package.
HTH,
Paul Ibison|||Do you know if there's a way to enable copying the column headers from the
grid results though? I may want to actually see the results visually before
deciding I want to copy it, making the Resuts to File a less appealing
option. If it's a long running query, running to grid first then again to
file would double the time. I'll paste the results into Excel.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OaanEGlSEHA.3768@.TK2MSFTNGP11.phx.gbl...
> David,
> if you are referring to Query Analyser, you can change the output format
to
> "Results to File...". On Tools, Options, Results, you can select to take
the
> column headers and select csv, column aligned etc formats. If this is a
> regular process, you might like to do this in a DTS package.
> HTH,
> Paul Ibison
>|||David,
not directly as far as I know. 'Results to text' will give you visual output
with column headers, but it usually won'y format correctly in Excel.
Regards,
Paul Ibison|||Why not go into EXCEL and IMPORT DATA - use a NEW SQL CONNECTION and get to your DATABASE
Then from in there you can load a table, execute a query, etc
It will load right into the EXCEL grids - headings and all - and if you like what you see, save as XLS or CSV or TDF or whatever you want - EXCEL does them all.

copying a table

I am assuming there is some functionality to copy and paste a table in sql server..however I am not seeing where I can do this what I want to do is this:

create table1 as select * from table 2;

Please let me know how I can create a new table as a replica of an existing table. Thanks so much!Sounds like Oracle syntax there. There is an analog in SQL Server, though

Select * into copytable
from sourcetable

This won't bring over indexes, primary keys, foreign keys, or identity columns, but it does bring the bare table structure, and the data.|||thanks. Yep I am having a big of a syntax issue here. I am more of an Oracle person! Thanks again.

Copy/Paste text into a field

I've encountered a strange problem with the Microsoft SQL Server Management Studio.

When I manually edit a record in a table and want to insert text with more lines, only the first line is copied into the field.

The field type I use is nvarchar(max) but it doesn't really matter what type it is.

The problem only exists in the Management studio. When I perform the same task in the "old" Entreprise Manager it works fine.

Am I doing something wrong or does anybody have a key to whats wrong?

Thanks!

Ken

I don't think you are doing anything wrong. I suspect the edit control in the grid just doesn't support multi-line text.

Please report this issue here: http://lab.msdn.microsoft.com/productfeedback/Default.aspx

We use defect reports and feature requests filed at the feedback center to make decisions about future versions and service packs of SQL Server.

As a work around, you could write a T-SQL update statement to make the change you want. That's how the grid control updates the table behind the scenes.

Thanks,
Steve

|||It's been some time since this was originally posted; I wonder if there's been any action taken on this?
I'm also having a similar problem. I often copy/paste text between database tables (usually a development table and later a production table).
This works fine in Enterprise Manager, but Management Stuido(2005), cells that contain multi-lines are not copied (it seems to be "blowing up" on the crlf; it dosen't seem to be an issue with the length of the text copied).

Its possible that there is a setting somewhere to change the behavior of the Results grid to allow this, but thus far I haven't found anything.
I followed the link provided above, but eventually decided it would be easier to write my own interface than to follow all the trails now necessary submit feedback. :)
At least I can complain here. :)|||

I just did a quick search on Microsoft Connect for any bug that was reported by customers, but did not find anything.

https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=copy+paste

Could you this suggestion on http://connect.microsoft.com/SQLServer/?

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Copy/Paste text into a field

I've encountered a strange problem with the Microsoft SQL Server Management Studio.

When I manually edit a record in a table and want to insert text with more lines, only the first line is copied into the field.

The field type I use is nvarchar(max) but it doesn't really matter what type it is.

The problem only exists in the Management studio. When I perform the same task in the "old" Entreprise Manager it works fine.

Am I doing something wrong or does anybody have a key to whats wrong?

Thanks!

Ken

I don't think you are doing anything wrong. I suspect the edit control in the grid just doesn't support multi-line text.

Please report this issue here: http://lab.msdn.microsoft.com/productfeedback/Default.aspx

We use defect reports and feature requests filed at the feedback center to make decisions about future versions and service packs of SQL Server.

As a work around, you could write a T-SQL update statement to make the change you want. That's how the grid control updates the table behind the scenes.

Thanks,
Steve

|||It's been some time since this was originally posted; I wonder if there's been any action taken on this?
I'm also having a similar problem. I often copy/paste text between database tables (usually a development table and later a production table).
This works fine in Enterprise Manager, but Management Stuido(2005), cells that contain multi-lines are not copied (it seems to be "blowing up" on the crlf; it dosen't seem to be an issue with the length of the text copied).

Its possible that there is a setting somewhere to change the behavior of the Results grid to allow this, but thus far I haven't found anything.
I followed the link provided above, but eventually decided it would be easier to write my own interface than to follow all the trails now necessary submit feedback. :)
At least I can complain here. :)|||

I just did a quick search on Microsoft Connect for any bug that was reported by customers, but did not find anything.

https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=copy+paste

Could you this suggestion on http://connect.microsoft.com/SQLServer/?

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

copy/paste grid from QA - no field names!

for debug purposes i tried to copy paste some Query Analyser output into Excel... the data pastes fine, but i can't get the field-names to copy/paste.

is there a trick?

izyNot by itself...

YOu could save it as text...you get the column names that way...

Or you can Go

SELECT 'Col1', 'Col2', 'Ect'
UNION ALL
SELECT Col1, Col2, Ect
FROM your Table|||text! stupidly simple really.
thanks for the help,

izy|||Try results to Text & Tab delimited.
Under Tools --> Options --> Results.

It works OK for me.

Tim S

Copy/Paste fails in SQL Server Management Studio

Has anyone experience the much frustrated situation of having the copy/paste
functionality fail within the Management Studio query editor environment?
I will be working fine, doing copy/paste within the query editor and then
for some reason the "copy" quits. I can copy from an outside source, e.g.
NotePad or Word and paste within Studio, but it seems like the "copy"
function stops working.
Like-wise, the ability to generate a script into a new window also stops
working.
Any ideas?
Thanks,
DaveDave
You are probably have SQL Server 2005 installed as a named instance, right?
It consumes memory as well
Close SSMS and open again ,see what is going on
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> Has anyone experience the much frustrated situation of having the
> copy/paste
> functionality fail within the Management Studio query editor environment?
> I will be working fine, doing copy/paste within the query editor and then
> for some reason the "copy" quits. I can copy from an outside source, e.g.
> NotePad or Word and paste within Studio, but it seems like the "copy"
> function stops working.
> Like-wise, the ability to generate a script into a new window also stops
> working.
> Any ideas?
> Thanks,
> Dave|||Thanks for the response.
I did close and reopen and it then works fine. I also had a whole day wwhere
I never experienced any problems.
So, you think it is a memry issue? I was watching my client (PC) memory and
it did not change much when running a series of tests. I really don't think
it is a memory issue but I also haven't beable to figure out any sequence o
r
pattern to the problem.
Dave
"Uri Dimant" wrote:

> Dave
> You are probably have SQL Server 2005 installed as a named instance, right
?
> It consumes memory as well
> Close SSMS and open again ,see what is going on
>
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
>
>|||Dave
Each instance you have on your computer will counsume memory for its needs,
how much memory do you have?
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> I did close and reopen and it then works fine. I also had a whole day
> wwhere
> I never experienced any problems.
> So, you think it is a memry issue? I was watching my client (PC) memory
> and
> it did not change much when running a series of tests. I really don't
> think
> it is a memory issue but I also haven't beable to figure out any sequence
> or
> pattern to the problem.
> Dave
>
> "Uri Dimant" wrote:
>|||I have 1 gb of memory. I have monitored the memory usage while doing many
copy/paste scenarios and I haven't noticed any change in usage.
I will shut all my services down tomorrow and see if I run into any problems
.
This problem is very sparatic. Most of the early morning I was running into
this pretty frequently and quickly after shutting down management Studeo and
reopening it. And now for awhile I have been doing many times as many
copy/paste and have not run into the problem.
"Uri Dimant" wrote:

> Dave
> Each instance you have on your computer will counsume memory for its needs
,
> how much memory do you have?
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
>
>|||I've experienced similar with terminal services. Just reconnect/recreate the
session seems to help.
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...[vbcol=seagreen]
>I have 1 gb of memory. I have monitored the memory usage while doing many
> copy/paste scenarios and I haven't noticed any change in usage.
> I will shut all my services down tomorrow and see if I run into any
> problems.
> This problem is very sparatic. Most of the early morning I was running
> into
> this pretty frequently and quickly after shutting down management Studeo
> and
> reopening it. And now for awhile I have been doing many times as many
> copy/paste and have not run into the problem.
> "Uri Dimant" wrote:
>|||I don't beleive this has anything to do with memory. I stopped all SQL
services locally on my PC that I am not using as I am doing my work against
a
differetn sql server on a different server using Managementb Studio.
So, after stopping a bunch of services that freed up
200+ MB of memory, and just after a dozen or so copy/paste, the ability to
do a copy stops.
I didn't think it had to do with memory since I was watching it usage and it
didn't jump when doing a sweries of copies.
I guess it is time to engage a Microsoft support call.
"oj" wrote:

> I've experienced similar with terminal services. Just reconnect/recreate t
he
> session seems to help.
> --
> -oj
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
>
>|||Hi Dave,
I wasn't suggesting it's a memory problem. I've seen similar behavior
through remote desktop ( I do it quite a bit to access the office). Simply
reconnecting helps.
If you contact PSS and have a definite answer, I would love to know for
reference.
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:276C89F0-67EA-416F-AC70-94C95D8A3CF5@.microsoft.com...[vbcol=seagreen]
>I don't beleive this has anything to do with memory. I stopped all SQL
> services locally on my PC that I am not using as I am doing my work
> against a
> differetn sql server on a different server using Managementb Studio.
> So, after stopping a bunch of services that freed up
> 200+ MB of memory, and just after a dozen or so copy/paste, the ability to
> do a copy stops.
> I didn't think it had to do with memory since I was watching it usage and
> it
> didn't jump when doing a sweries of copies.
> I guess it is time to engage a Microsoft support call.
>
> "oj" wrote:
>

Copy/Paste fails in SQL Server Management Studio

Has anyone experience the much frustrated situation of having the copy/paste
functionality fail within the Management Studio query editor environment?
I will be working fine, doing copy/paste within the query editor and then
for some reason the "copy" quits. I can copy from an outside source, e.g.
NotePad or Word and paste within Studio, but it seems like the "copy"
function stops working.
Like-wise, the ability to generate a script into a new window also stops
working.
Any ideas?
Thanks,
DaveDave
You are probably have SQL Server 2005 installed as a named instance, right?
It consumes memory as well
Close SSMS and open again ,see what is going on
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> Has anyone experience the much frustrated situation of having the
> copy/paste
> functionality fail within the Management Studio query editor environment?
> I will be working fine, doing copy/paste within the query editor and then
> for some reason the "copy" quits. I can copy from an outside source, e.g.
> NotePad or Word and paste within Studio, but it seems like the "copy"
> function stops working.
> Like-wise, the ability to generate a script into a new window also stops
> working.
> Any ideas?
> Thanks,
> Dave|||Thanks for the response.
I did close and reopen and it then works fine. I also had a whole day wwhere
I never experienced any problems.
So, you think it is a memry issue? I was watching my client (PC) memory and
it did not change much when running a series of tests. I really don't think
it is a memory issue but I also haven't beable to figure out any sequence or
pattern to the problem.
Dave
"Uri Dimant" wrote:
> Dave
> You are probably have SQL Server 2005 installed as a named instance, right?
> It consumes memory as well
> Close SSMS and open again ,see what is going on
>
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> > Has anyone experience the much frustrated situation of having the
> > copy/paste
> > functionality fail within the Management Studio query editor environment?
> >
> > I will be working fine, doing copy/paste within the query editor and then
> > for some reason the "copy" quits. I can copy from an outside source, e.g.
> > NotePad or Word and paste within Studio, but it seems like the "copy"
> > function stops working.
> >
> > Like-wise, the ability to generate a script into a new window also stops
> > working.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Dave
>
>|||Dave
Each instance you have on your computer will counsume memory for its needs,
how much memory do you have?
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
> Thanks for the response.
> I did close and reopen and it then works fine. I also had a whole day
> wwhere
> I never experienced any problems.
> So, you think it is a memry issue? I was watching my client (PC) memory
> and
> it did not change much when running a series of tests. I really don't
> think
> it is a memory issue but I also haven't beable to figure out any sequence
> or
> pattern to the problem.
> Dave
>
> "Uri Dimant" wrote:
>> Dave
>> You are probably have SQL Server 2005 installed as a named instance,
>> right?
>> It consumes memory as well
>> Close SSMS and open again ,see what is going on
>>
>>
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
>> > Has anyone experience the much frustrated situation of having the
>> > copy/paste
>> > functionality fail within the Management Studio query editor
>> > environment?
>> >
>> > I will be working fine, doing copy/paste within the query editor and
>> > then
>> > for some reason the "copy" quits. I can copy from an outside source,
>> > e.g.
>> > NotePad or Word and paste within Studio, but it seems like the "copy"
>> > function stops working.
>> >
>> > Like-wise, the ability to generate a script into a new window also
>> > stops
>> > working.
>> >
>> > Any ideas?
>> >
>> > Thanks,
>> >
>> > Dave
>>|||I have 1 gb of memory. I have monitored the memory usage while doing many
copy/paste scenarios and I haven't noticed any change in usage.
I will shut all my services down tomorrow and see if I run into any problems.
This problem is very sparatic. Most of the early morning I was running into
this pretty frequently and quickly after shutting down management Studeo and
reopening it. And now for awhile I have been doing many times as many
copy/paste and have not run into the problem.
"Uri Dimant" wrote:
> Dave
> Each instance you have on your computer will counsume memory for its needs,
> how much memory do you have?
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
> > Thanks for the response.
> >
> > I did close and reopen and it then works fine. I also had a whole day
> > wwhere
> > I never experienced any problems.
> >
> > So, you think it is a memry issue? I was watching my client (PC) memory
> > and
> > it did not change much when running a series of tests. I really don't
> > think
> > it is a memory issue but I also haven't beable to figure out any sequence
> > or
> > pattern to the problem.
> >
> > Dave
> >
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Dave
> >> You are probably have SQL Server 2005 installed as a named instance,
> >> right?
> >> It consumes memory as well
> >> Close SSMS and open again ,see what is going on
> >>
> >>
> >>
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> >> > Has anyone experience the much frustrated situation of having the
> >> > copy/paste
> >> > functionality fail within the Management Studio query editor
> >> > environment?
> >> >
> >> > I will be working fine, doing copy/paste within the query editor and
> >> > then
> >> > for some reason the "copy" quits. I can copy from an outside source,
> >> > e.g.
> >> > NotePad or Word and paste within Studio, but it seems like the "copy"
> >> > function stops working.
> >> >
> >> > Like-wise, the ability to generate a script into a new window also
> >> > stops
> >> > working.
> >> >
> >> > Any ideas?
> >> >
> >> > Thanks,
> >> >
> >> > Dave
> >>
> >>
> >>
>
>|||I've experienced similar with terminal services. Just reconnect/recreate the
session seems to help.
--
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
>I have 1 gb of memory. I have monitored the memory usage while doing many
> copy/paste scenarios and I haven't noticed any change in usage.
> I will shut all my services down tomorrow and see if I run into any
> problems.
> This problem is very sparatic. Most of the early morning I was running
> into
> this pretty frequently and quickly after shutting down management Studeo
> and
> reopening it. And now for awhile I have been doing many times as many
> copy/paste and have not run into the problem.
> "Uri Dimant" wrote:
>> Dave
>> Each instance you have on your computer will counsume memory for its
>> needs,
>> how much memory do you have?
>>
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
>> > Thanks for the response.
>> >
>> > I did close and reopen and it then works fine. I also had a whole day
>> > wwhere
>> > I never experienced any problems.
>> >
>> > So, you think it is a memry issue? I was watching my client (PC) memory
>> > and
>> > it did not change much when running a series of tests. I really don't
>> > think
>> > it is a memory issue but I also haven't beable to figure out any
>> > sequence
>> > or
>> > pattern to the problem.
>> >
>> > Dave
>> >
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Dave
>> >> You are probably have SQL Server 2005 installed as a named instance,
>> >> right?
>> >> It consumes memory as well
>> >> Close SSMS and open again ,see what is going on
>> >>
>> >>
>> >>
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
>> >> > Has anyone experience the much frustrated situation of having the
>> >> > copy/paste
>> >> > functionality fail within the Management Studio query editor
>> >> > environment?
>> >> >
>> >> > I will be working fine, doing copy/paste within the query editor and
>> >> > then
>> >> > for some reason the "copy" quits. I can copy from an outside source,
>> >> > e.g.
>> >> > NotePad or Word and paste within Studio, but it seems like the
>> >> > "copy"
>> >> > function stops working.
>> >> >
>> >> > Like-wise, the ability to generate a script into a new window also
>> >> > stops
>> >> > working.
>> >> >
>> >> > Any ideas?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Dave
>> >>
>> >>
>> >>
>>|||I don't beleive this has anything to do with memory. I stopped all SQL
services locally on my PC that I am not using as I am doing my work against a
differetn sql server on a different server using Managementb Studio.
So, after stopping a bunch of services that freed up
200+ MB of memory, and just after a dozen or so copy/paste, the ability to
do a copy stops.
I didn't think it had to do with memory since I was watching it usage and it
didn't jump when doing a sweries of copies.
I guess it is time to engage a Microsoft support call.
"oj" wrote:
> I've experienced similar with terminal services. Just reconnect/recreate the
> session seems to help.
> --
> -oj
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
> >I have 1 gb of memory. I have monitored the memory usage while doing many
> > copy/paste scenarios and I haven't noticed any change in usage.
> >
> > I will shut all my services down tomorrow and see if I run into any
> > problems.
> >
> > This problem is very sparatic. Most of the early morning I was running
> > into
> > this pretty frequently and quickly after shutting down management Studeo
> > and
> > reopening it. And now for awhile I have been doing many times as many
> > copy/paste and have not run into the problem.
> >
> > "Uri Dimant" wrote:
> >
> >> Dave
> >>
> >> Each instance you have on your computer will counsume memory for its
> >> needs,
> >> how much memory do you have?
> >>
> >>
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
> >> > Thanks for the response.
> >> >
> >> > I did close and reopen and it then works fine. I also had a whole day
> >> > wwhere
> >> > I never experienced any problems.
> >> >
> >> > So, you think it is a memry issue? I was watching my client (PC) memory
> >> > and
> >> > it did not change much when running a series of tests. I really don't
> >> > think
> >> > it is a memory issue but I also haven't beable to figure out any
> >> > sequence
> >> > or
> >> > pattern to the problem.
> >> >
> >> > Dave
> >> >
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Dave
> >> >> You are probably have SQL Server 2005 installed as a named instance,
> >> >> right?
> >> >> It consumes memory as well
> >> >> Close SSMS and open again ,see what is going on
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> >> >> > Has anyone experience the much frustrated situation of having the
> >> >> > copy/paste
> >> >> > functionality fail within the Management Studio query editor
> >> >> > environment?
> >> >> >
> >> >> > I will be working fine, doing copy/paste within the query editor and
> >> >> > then
> >> >> > for some reason the "copy" quits. I can copy from an outside source,
> >> >> > e.g.
> >> >> > NotePad or Word and paste within Studio, but it seems like the
> >> >> > "copy"
> >> >> > function stops working.
> >> >> >
> >> >> > Like-wise, the ability to generate a script into a new window also
> >> >> > stops
> >> >> > working.
> >> >> >
> >> >> > Any ideas?
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Dave
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi Dave,
I wasn't suggesting it's a memory problem. I've seen similar behavior
through remote desktop ( I do it quite a bit to access the office). Simply
reconnecting helps.
If you contact PSS and have a definite answer, I would love to know for
reference.
--
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:276C89F0-67EA-416F-AC70-94C95D8A3CF5@.microsoft.com...
>I don't beleive this has anything to do with memory. I stopped all SQL
> services locally on my PC that I am not using as I am doing my work
> against a
> differetn sql server on a different server using Managementb Studio.
> So, after stopping a bunch of services that freed up
> 200+ MB of memory, and just after a dozen or so copy/paste, the ability to
> do a copy stops.
> I didn't think it had to do with memory since I was watching it usage and
> it
> didn't jump when doing a sweries of copies.
> I guess it is time to engage a Microsoft support call.
>
> "oj" wrote:
>> I've experienced similar with terminal services. Just reconnect/recreate
>> the
>> session seems to help.
>> --
>> -oj
>>
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
>> >I have 1 gb of memory. I have monitored the memory usage while doing
>> >many
>> > copy/paste scenarios and I haven't noticed any change in usage.
>> >
>> > I will shut all my services down tomorrow and see if I run into any
>> > problems.
>> >
>> > This problem is very sparatic. Most of the early morning I was running
>> > into
>> > this pretty frequently and quickly after shutting down management
>> > Studeo
>> > and
>> > reopening it. And now for awhile I have been doing many times as many
>> > copy/paste and have not run into the problem.
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Dave
>> >>
>> >> Each instance you have on your computer will counsume memory for its
>> >> needs,
>> >> how much memory do you have?
>> >>
>> >>
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
>> >> > Thanks for the response.
>> >> >
>> >> > I did close and reopen and it then works fine. I also had a whole
>> >> > day
>> >> > wwhere
>> >> > I never experienced any problems.
>> >> >
>> >> > So, you think it is a memry issue? I was watching my client (PC)
>> >> > memory
>> >> > and
>> >> > it did not change much when running a series of tests. I really
>> >> > don't
>> >> > think
>> >> > it is a memory issue but I also haven't beable to figure out any
>> >> > sequence
>> >> > or
>> >> > pattern to the problem.
>> >> >
>> >> > Dave
>> >> >
>> >> >
>> >> >
>> >> > "Uri Dimant" wrote:
>> >> >
>> >> >> Dave
>> >> >> You are probably have SQL Server 2005 installed as a named
>> >> >> instance,
>> >> >> right?
>> >> >> It consumes memory as well
>> >> >> Close SSMS and open again ,see what is going on
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
>> >> >> > Has anyone experience the much frustrated situation of having the
>> >> >> > copy/paste
>> >> >> > functionality fail within the Management Studio query editor
>> >> >> > environment?
>> >> >> >
>> >> >> > I will be working fine, doing copy/paste within the query editor
>> >> >> > and
>> >> >> > then
>> >> >> > for some reason the "copy" quits. I can copy from an outside
>> >> >> > source,
>> >> >> > e.g.
>> >> >> > NotePad or Word and paste within Studio, but it seems like the
>> >> >> > "copy"
>> >> >> > function stops working.
>> >> >> >
>> >> >> > Like-wise, the ability to generate a script into a new window
>> >> >> > also
>> >> >> > stops
>> >> >> > working.
>> >> >> >
>> >> >> > Any ideas?
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > Dave
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Copy/Paste Fails in Management Studio

After opening Management Studio and doing some editing it is possible to copy/paste things in the query editor. After a while (working in another app) I come back to Management Studio and I can't copy/paste anything anymore. If I try to copy from the results window I get an error message that the clipboard operation did not succeed. If I try to copy from the query editor window it just doesn't copy. I can copy/paste in other apps without a problem.

I have seen this problem described in other forums so I'm not alone but I have 3 other computers where this problem does not occur. The one machine with the problem is hyper-threading. I wonder ....

Any other ideas? It is not the clipboard getting full but I can't rule out much else.

What is the configuration of those machines?

I believe the copy/paste cache is depend upon the operating system and resource usage, I don't see any problem with SSMS here. If it is a normal text then based on the memory usage that shouldn't be a problem.

|||

You are not alone, I had this happen to me also where the copy paste functionality quit working but under slightly different circumstances. I am running Windows XP Professional SQL Server 2005 Standard Edition SP2. I started working in SSMS yesterday and copy paste functionality was working fine. I did not shut down the program or my machine over night and when I logged onto my machine this morning to continue working in SSMS the copy paste functionality was not longer working. I have never had a problem with this functionality until today. I see that someone else reported it as a bug. I suggest that you also log onto the but report and validate that this is an issue. The link is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126743

Maybe if everyone who has this issue reports it then someone will do more research to determine the cause of the problem.

GN

copy/paste bugs

try copying a connection manager from one package to another

it does not work

e.g. excel connection manager

it loses the name of the connection manager and also the file you are pointing to

so it is basically no different to 'add new connection manager'

also

try copying the name of the connection manager to another connection

select connection, hit F2 (edit) ctrl C,

try pasting!

in order to paste you have to right click on the selected text and select copy from the context menu

this is not a bug

this sloppy, poorly tested software

So get busy posting these bugs over at http://connect.microsoft.com/sqlserver/feedback.

Copy/Paste behavior in SSMS

I realize that this seems odd, but I want to change the copy paste
behavior in SSMS.
Right now if you have no text selected in SSMS and do a control-c the
entire line is copied, but I want the copy to be null. Basicly I'm
automating some repetive functions and need to move only the selected
text to the clipboard. If no text is selected then want nothing.
Any ideas?
Thanks
William
wgbrown_nospam_@.gmail.com
How are you automating the tasks?
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
<wgbrown@.gmail.com> wrote in message
news:1164146398.788232.175850@.k70g2000cwa.googlegr oups.com...
>I realize that this seems odd, but I want to change the copy paste
> behavior in SSMS.
> Right now if you have no text selected in SSMS and do a control-c the
> entire line is copied, but I want the copy to be null. Basicly I'm
> automating some repetive functions and need to move only the selected
> text to the clipboard. If no text is selected then want nothing.
> Any ideas?
> Thanks
> William
> wgbrown_nospam_@.gmail.com
>
|||Using Autohotkey - www.autohotkey.com. Its a scripting language to
automate tasks. Right now I've had problems pulling selected text
using its tools - some editors don't get along with it so I've resorted
to using the clipboard but the SSMS behavior is different that other
tools.
Thanks
William
Paul A. Mestemaker II [MSFT] wrote:[vbcol=seagreen]
> How are you automating the tasks?
> Paul A. Mestemaker II
> Program Manager
> Microsoft SQL Server Manageability
> http://blogs.msdn.com/sqlrem/
> <wgbrown@.gmail.com> wrote in message
> news:1164146398.788232.175850@.k70g2000cwa.googlegr oups.com...
|||I'm not famliar with this utility at all. Can you give us an example of the
task you'd like to automate? Maybe we can find you a way to complete your
task using SQLCMD Mode in SSMS.
-Paul
<wgbrown@.gmail.com> wrote in message
news:1164179204.938292.85990@.k70g2000cwa.googlegro ups.com...
> Using Autohotkey - www.autohotkey.com. Its a scripting language to
> automate tasks. Right now I've had problems pulling selected text
> using its tools - some editors don't get along with it so I've resorted
> to using the clipboard but the SSMS behavior is different that other
> tools.
> Thanks
> William
>
> Paul A. Mestemaker II [MSFT] wrote:
>
|||Good Morning Paul.
There isn't one function but a bunch of little ones. Currently I'm
closing off certain characters like { [ ( " so I get {}, [], (), "" (I
work a lot in mdx). But I'd like to be able to reformat highlighted
text. Proper case words or such.
I was surprised about the copy behavior - I'd never noticed it.
Thanks
William
Paul A. Mestemaker II [MSFT] wrote:[vbcol=seagreen]
> I'm not famliar with this utility at all. Can you give us an example of the
> task you'd like to automate? Maybe we can find you a way to complete your
> task using SQLCMD Mode in SSMS.
> -Paul
> <wgbrown@.gmail.com> wrote in message
> news:1164179204.938292.85990@.k70g2000cwa.googlegro ups.com...
|||See if this helps with what you want?
http://www.red-gate.com/products/SQL_Refactor/index.htm
Andrew J. Kelly SQL MVP
<wgbrown@.gmail.com> wrote in message
news:1164215484.851461.150040@.h54g2000cwb.googlegr oups.com...
> Good Morning Paul.
> There isn't one function but a bunch of little ones. Currently I'm
> closing off certain characters like { [ ( " so I get {}, [], (), "" (I
> work a lot in mdx). But I'd like to be able to reformat highlighted
> text. Proper case words or such.
> I was surprised about the copy behavior - I'd never noticed it.
> Thanks
> William
>
> Paul A. Mestemaker II [MSFT] wrote:
>
|||I've looked at that and it looks really nice. As soon as I have time I
want to try it out. Much of my work is around MDX however, and the
tools are more limited. For good reason, for every person who does MDX
there must be 1000 (or more) sql programmers.
Thanks for the tip.
William
Andrew J. Kelly wrote:[vbcol=seagreen]
> See if this helps with what you want?
> http://www.red-gate.com/products/SQL_Refactor/index.htm
> --
> Andrew J. Kelly SQL MVP
> <wgbrown@.gmail.com> wrote in message
> news:1164215484.851461.150040@.h54g2000cwb.googlegr oups.com...

Copy(paste) ''serialize'' error always occurs with task, never with components

Some more insight into the error I am getting.

It always occurs at the task (control flow) level and never at the component (data flow) level

It always occurs on the 'copy' action.

I have tried all the msxml/registry recommendations to no avail.

once again here are the error details

===================================

An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)

===================================

Could not copy object 'SQT Drop Create RAWMigDeal RAWBarrier table' to the clipboard.
(Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=SerializeComponentsFailed&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)
at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.InternalMenuCopy(MenuCommand sender, CommandHandlingArgs args)

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.PersistImpl.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)Does that copy to clipboard error occur each time an attempt is made to copy any Execute SQL task from any SSIS package?|||brand new ssis solution
add a data flow task
right click copy
BANG! same error

here is the package..... (after receiving the error, so not sure what state it is in)
<?xml version="1.0"?><DTS:Executable xmlnsTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSroperty DTS:Name="PackageFormatVersion">2</DTSroperty><DTSroperty DTS:Name="VersionComments"></DTSroperty><DTSroperty DTS:Name="CreatorName">CSFB\npearse</DTSroperty><DTSroperty DTS:Name="CreatorComputerName">XXXXXXXXXXXXX</DTSroperty><DTSroperty DTS:Name="CreationDate" DTSataType="7">8/20/2007 9:52:03 AM</DTSroperty><DTSroperty DTS:Name="PackageType">5</DTSroperty><DTSroperty DTS:Name="ProtectionLevel">1</DTSroperty><DTSroperty DTS:Name="MaxConcurrentExecutables">-1</DTSroperty><DTSroperty DTS:Name="PackagePriorityClass">0</DTSroperty><DTSroperty DTS:Name="VersionMajor">1</DTSroperty><DTSroperty DTS:Name="VersionMinor">0</DTSroperty><DTSroperty DTS:Name="VersionBuild">1</DTSroperty><DTSroperty DTS:Name="VersionGUID">{557D24A8-D190-486E-BD86-A836815DE6DA}</DTSroperty><DTSroperty DTS:Name="EnableConfig">0</DTSroperty><DTSroperty DTS:Name="CheckpointFileName"></DTSroperty><DTSroperty DTS:Name="SaveCheckpoints">0</DTSroperty><DTSroperty DTS:Name="CheckpointUsage">0</DTSroperty><DTSroperty DTS:Name="SuppressConfigurationWarnings">0</DTSroperty>
<DTSackageVariable><DTSroperty DTS:Name="PackageVariableValue" DTSataType="8">&lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsdl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlnswd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwdtsDataFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="8467" y="7620" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwdtsDataFlowDiagram&gt;&lt;/TaskHost&gt;</DTSroperty><DTSroperty DTS:Name="Namespace">dts-designer-1.0</DTSroperty><DTSroperty DTS:Name="ObjectName">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTSroperty><DTSroperty DTS:Name="DTSID">{90FA5082-2489-4857-AA8B-B7CC0A62D7C7}</DTSroperty><DTSroperty DTS:Name="Description"></DTSroperty><DTSroperty DTS:Name="CreationName"></DTSroperty></DTSackageVariable>
<DTSackageVariable><DTSroperty DTS:Name="PackageVariableValue" DTSataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsdl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlnswd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwdtsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;4128&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="33179" y="18283" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="11695" top="4128" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwdtsControlFlowDiagram&gt;&lt;/Package&gt;</DTSroperty><DTSroperty DTS:Name="Namespace">dts-designer-1.0</DTSroperty><DTSroperty DTS:Name="ObjectName">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTSroperty><DTSroperty DTS:Name="DTSID">{B505F61E-B095-4522-9FA2-8145F92E7976}</DTSroperty><DTSroperty DTS:Name="Description"></DTSroperty><DTSroperty DTS:Name="CreationName"></DTSroperty></DTSackageVariable><DTSroperty DTS:Name="ForceExecValue">0</DTSroperty><DTSroperty DTS:Name="ExecValue" DTSataType="3">0</DTSroperty><DTSroperty DTS:Name="ForceExecutionResult">-1</DTSroperty><DTSroperty DTS:Name="Disabled">0</DTSroperty><DTSroperty DTS:Name="FailPackageOnFailure">0</DTSroperty><DTSroperty DTS:Name="FailParentOnFailure">0</DTSroperty><DTSroperty DTS:Name="MaxErrorCount">1</DTSroperty><DTSroperty DTS:Name="ISOLevel">1048576</DTSroperty><DTSroperty DTS:Name="LocaleID">2057</DTSroperty><DTSroperty DTS:Name="TransactionOption">1</DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty>
<DTS:LoggingOptions><DTSroperty DTS:Name="LoggingMode">0</DTSroperty><DTSroperty DTS:Name="FilterKind">1</DTSroperty><DTSroperty DTS:Name="EventFilter" DTSataType="8"></DTSroperty></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTSroperty DTS:Name="ExecutionLocation">0</DTSroperty><DTSroperty DTS:Name="ExecutionAddress"></DTSroperty><DTSroperty DTS:Name="TaskContact">Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTSroperty><DTSroperty DTS:Name="ForceExecValue">0</DTSroperty><DTSroperty DTS:Name="ExecValue" DTSataType="3">0</DTSroperty><DTSroperty DTS:Name="ForceExecutionResult">-1</DTSroperty><DTSroperty DTS:Name="Disabled">0</DTSroperty><DTSroperty DTS:Name="FailPackageOnFailure">0</DTSroperty><DTSroperty DTS:Name="FailParentOnFailure">0</DTSroperty><DTSroperty DTS:Name="MaxErrorCount">1</DTSroperty><DTSroperty DTS:Name="ISOLevel">1048576</DTSroperty><DTSroperty DTS:Name="LocaleID">-1</DTSroperty><DTSroperty DTS:Name="TransactionOption">1</DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty>
<DTS:LoggingOptions><DTSroperty DTS:Name="LoggingMode">0</DTSroperty><DTSroperty DTS:Name="FilterKind">1</DTSroperty><DTSroperty DTS:Name="EventFilter" DTSataType="8"></DTSroperty></DTS:LoggingOptions><DTSroperty DTS:Name="ObjectName">Data Flow Task</DTSroperty><DTSroperty DTS:Name="DTSID">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTSroperty><DTSroperty DTS:Name="Description">Data Flow Task</DTSroperty><DTSroperty DTS:Name="CreationName">DTS.Pipeline.1</DTSroperty><DTSroperty DTS:Name="DisableEventHandlers">0</DTSroperty><DTSbjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true"/></DTSbjectData></DTS:Executable><DTSroperty DTS:Name="ObjectName">Package</DTSroperty><DTSroperty DTS:Name="DTSID">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTSroperty><DTSroperty DTS:Name="Description"></DTSroperty><DTSroperty DTS:Name="CreationName">MSDTS.Package.1</DTSroperty><DTSroperty DTS:Name="DisableEventHandlers">0</DTSroperty></DTS:Executable>|||Paste the package xml in a code block, via the Mark Code block button, and you will not get the smilies all over the place.|||

Code Snippet

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">CSFB\npearse</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">XXXXXXXXXXXXX</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">8/20/2007 9:52:03 AM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">1</DTS:Property><DTS:Property DTS:Name="VersionGUID">{557D24A8-D190-486E-BD86-A836815DE6DA}</DTS:Property><DTS:Property DTS:Name="EnableConfig">0</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsDataFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="8467" y="7620" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsDataFlowDiagram&gt;&lt;/TaskHost&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTS:Property><DTS:Property DTS:Name="DTSID">{90FA5082-2489-4857-AA8B-B7CC0A62D7C7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;4128&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="33179" y="18283" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="11695" top="4128" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTS:Property><DTS:Property DTS:Name="DTSID">{B505F61E-B095-4522-9FA2-8145F92E7976}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">2057</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Data Flow Task</DTS:Property><DTS:Property DTS:Name="DTSID">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true"/></DTS:ObjectData></DTS:Executable><DTS:Property DTS:Name="ObjectName">Package</DTS:Property><DTS:Property DTS:Name="DTSID">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable>

|||

At this point, if you've re-installed and this basic operation (clipboard cut/copy) continues to occur, I would see if you can get SSIS working in a VPC (virtual PC 2007 is a free download) with undo disks set to on, so you can just get back to a clean slate if need be.

Now, using the SSIS package xml provided, cut/copy and paste from a Windows Vista x64 OS work fine. There was not, nor has their ever been (on that machine) or any of the approximately 15 different SSIS installs (some Vista, some XP, some Win2k3, some 32 bit, some 64 bit, some VPC), that error. So, all that means the package xml is not the issue.

Now, looking at the dlls and assemblies being pulled in, the following below 2 are prominently used, which you've already re-registered.

msxml3.dll

msxml6.dll