Hi,
I'm not much exp. in DTS programing.I want to transfer Excel Data to SQL
Server.
Now my SQLDatabase and Excel file path are dynamic.(user will enter during
runtime).
I've created the DTS package in which i've specify the transformation task
for Excel Source to SQL Server Destination.
When i set the transformation property it asks source file and destination
table and transformation info.It will create the table during design time to
map the columns.
Now i'm able to set the excel file during runtime but could not able to set
Database name dynamically.
When i run the package for the specific database which is
set in the transformation it works fine, but when i change the
database name it refers the same old database name which i've mentioned during
design time.
Is there any way to change this database name ?
--
Thanks & Regards
Malkesh

Change the Data Flow task's DestinationObjectName as well.

An example of using script to do this-

Changing the DataPump Source and Destination Tables
(http://www.sqldts.com/default.aspx?213)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Malkesh" <Malkesh (AT) discussions (DOT) microsoft.com> wrote