Extremely Urgent


I am trying to copy a table from one sql server to another sql server through a DTS Package. I have to pass part of table name as a parameter(s). I have to develop the package such that it will accept these parameters and create table name and copy that table.
Ex: I have to copy a table named as Dev12test3. I will pass the parameter 12 and 3. The package should take these parameters and build the table name as Dev12test3 and copy table

Thanks in Advance

I'm new to sql server and very naive, but I'll take a chance.

I've read about the Dynamic Properties Task and an initialization file (.ini). Will they do what you need? I'm guessing they're discussed in other books but I found them in Microsoft SQL Server 2000 DTS Step By Step, by Carl Rabeler, page 215+. Good luck.

Use a dynamic properties task, to assign a values at runtime. this makes ur package completely configurable. U can use INI files, global variables, constants and many others for this.