Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-12 : 07:35:45
|
| nirmalya writes "HiI am using SqlServer 2000 and I am writing a script which will load the data of AccessDB tables into corresponding SqlServerDB tables without any user interaction .For this purpose a DTS package was created and it can be called from command line by dtsrun command and hence it can be executed without any more user interaction .But since we have ~300 tables how we can have a common DTS package which will accept the table name at run time and do the needful .How it can be done in the simplest way ? I think I need a global variable .Then what type of Task is needed - 'Dynamic Properties Task' or 'ActiveX Script Task' or 'Execute Sql Task' ? How I can define the global variable and access it within the Task ? Also I want that before the data is loaded the script will delete the table data already present in the SqlServerDB ? How I can write that script within the Task ?Actually I have been searching for the answer for a long time and couldn't get it - and hence posting the question here ; hope you will be kind enough to reply me back .ThanksNirmalya " |
|
|
|
|
|
How we can pass the table name at runtime to the DTS package