October 18, 2005 at 8:17 am
Hi,
As we know to change the Server Name and the DataBase Name we need
to open the DTS . Is there any other user friendly way to change these
values , say by running some SQL scripts .
If there is please let me know,
Regards,
Vikram
October 18, 2005 at 8:41 am
This article will show you exactly what you need to do.
http://www.databasejournal.com/features/mssql/article.php/3073161
October 19, 2005 at 7:52 am
Thanks Jonathan, article was of much help.
At one thing i am still stuck , is that when i join Source Text File and Destination Server by Transform Data Task , it gets deleted when i close the
DTS package .Similar problem occurs when adding Dynamic Property Task .
Could you help me in this regard .
Vikram
October 19, 2005 at 7:58 am
Unless the transformation is the same, it's unlikely that the transformation mappings will work.
For example, if you have a spreadsheet with 5 columns as source and a table with 5 columns as destination, unless you change the connection to the source to be the SAME structure as the excel file and the destination Connection to be the SAME structure as the table, the mappings will disappear.
This article does not let you change to differently structured source and destinations. If you want to do that, you will have change the transformation tasks at runtime through an activex script which is very difficult to do and is better handled by dynamic sql.
October 19, 2005 at 8:23 am
Jonathan , could you let me know how to do it by Dynamic SQL.
October 20, 2005 at 9:49 am
I'm afraid I have never tried to do this. Perhaps someone else out there has attempted to do this and can help you out.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply