I'm fairly new to using SSIS, but I have learned how to download the
contents of a custom database to a local development server (both with SQL
2005). Now I am trying to learn how to download a copy of the membership
(all the tables related to applications, logins, roles, profiles).

At first I tried using the wizard to transfer these tables, but it resulted
in an error related to foreign keys:
[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE
[aspnetdb].[dbo].[aspnet_Roles] " failed with the following error: "Cannot
truncate table 'aspnetdb.dbo.aspnet_Roles' because it is being referenced by
a FOREIGN KEY constraint.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly,
or connection not established correctly.

So then I tried using the tranfer logins task. I thought it might transfer
the login accounts, but after setting it up and running it (successfully), I
notice that there are no data flow items, and the results are [Transfer
Logins Task] Information: "There are no logins transferred.".

I would like to completely overwrite my local aspnetdb database with all the
membership data that has been collected on a webserver.

Can you give me a procedure for this, or a link to instructions?

(SSIS is using VS2005. If coding is involved, my preferred environment is
VS2008 and C#).

Many thanks for any help or instruction you can offer.

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi jrl,
I understand that you would like to transfer your custom database and its
related objects to your aspnetdb database on your local development server
via a SSIS package, however you encountered the error regarding FOREIGN KEY
constraint. Also your SQL transfer login task did not transfer any logins.
If I have misunderstood, please let me know.

Regarding your requirement, I think that you can simply use "Transfer SQL
Server Objects Task" to do this. Regarding the options, you may first refer
to this article:
Transfer SQL Server Objects Task
http://technet.microsoft.com/en-us/l.../ms142159.aspx

For the FOREIGN KEY constraint error you encountered, I think that you may
not set the destination property "IncludeDependentObjects" to true. By
default, it is false.

In addition, if SQL Server 2005 SP2 has not been installed on your server,
I recommend that you install SQL Server 2005 SP2 first since there are some
important hotfixes regarding SSIS. You can download SQL Server 2005 SP2
from the following link:
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

It might be easier to just backup the server db and restore it on your
local machine

Good luck!
J