December 27, 2005 at 10:00 am
I am in the process of building a SQL Server 2005 SSIS package that uses the TransferSqlServerObjectsTask... but there is a problem.
When I create the object I can use expressions to set almost everything I need to set at run time with a notable exception.
As in 2000, the TransferSqlServerObjectsTask does NOT allow you to set the tables to be copied at run time. They must be set at design time and cannot be changed. But I have a need to copy tables where I'm not aware of the table name in advance of run time.
I know that I am going to have to use the Script object to execute a VB script... which in-turn dynamically creates a TransferSqlServerObjectsTask and then uses expressions to set each of the objects properties via code.
The problem is I'm not familiar with VB.net. Does anyone have examples, suggestions or other ideas about how I can do this?
Thanks
December 28, 2005 at 6:59 am
try looking here: http://www.sqlis.com
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply