problem with Transfer SQL Server Objects Task

Hot Topic

Setup of sql server
Installing databases to different hard drives.
Using WebService Task
getting data from Sharepoint lists
Template Packages and Wizards
Newbie: Exception Occured while accessing package from C#
VSI Templates install failed
GUID
Bug in Flat File Connection Object: Risky!!!!
how to get rid of old records

SQL Server

New Login with Trusted Connection
Strange bug with stored procedures.
save unicode data into MSDE SQL
Query Empty node
Is there any chance to execute or call PL/SQL SP in SQl Server 2000 T-sql
SQL Update statement
sql server 2005 RS multi-value params june ctp
What are the settings to enable any memeber of an AD group to logon to SQL2005
Update part of a string
sql problem in stored procedure

problem with Transfer SQL Server Objects Task

I have the following problem:

All Sp's and UDF's in one base database have to be compiled into five identical databases located in the same SQL Server in order to keep all those five db's stored procedures synchronized.

I made a simple SSIS package which content one "Transfer SQL Server Objects Task" component.

Hardcoded connection/Source db/Destination db and setup properties as

"Drop object first" = True

"Copy All Stored procedures" = True

"Copy All UDF" = True

Then I executed the Package right from Visual Studio environment and after the substantial thinking finally it show me a green light.

But when I verified the result no Sp's in the destination database were re-compiled/copied from the source database.

Is it kind of bug or I did something wrong

Any advice will be appreciated.




Answer this question

problem with Transfer SQL Server Objects Task

  • Janice Lam

    Set CopySchema=True.


  • RacingJack

    I had this same problem and set the CopySchema to True. Upon doing so, when I reran the task, I then get an error with executig the query "CREATE LOGIN XXXX". The problem is, I have CopySQLServerLogins set to False, and the particular login that it is flagging is not a login for the database that I am copying from or to for that matter.

    Now what


  • BarrySumpter

    May I know the status of this thread I have encountered similar problem. The debug log says "Transferred successfully" but none have been copied. Thanks.


  • Mausi

    Hi,

    I am doing the same SSIS package as you described and have the same problems as you had. Did you get your problem fix, and how

    Thanks,

    Jenny



  • problem with Transfer SQL Server Objects Task
Answer this question