# Password property issue on DTSRun Action

**URL:** https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706
**Category:** Discussion
**Created:** [January 8, 2008, 2:41am UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706 "2008-01-08T02:41:35Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [January 8, 2008, 2:41am UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706/1 "2008-01-08T02:41:35Z")

</div>

Hi,

I was using the DTSRun Action to import a table into my database. And I want to specify the connection properties such as database username and password using existing variables in the project. Is this possible?

Thanks!

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [January 9, 2008, 12:35pm UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706/2 "2008-01-09T12:35:48Z")

</div>

Hi Liang,   
  
 Thanks for your post.   
  
 Variables are expanded for both the username and password on this action, so if you uncheck the “Use integrated security” checkbox and type %MyUserNameVar% for the username and %MyPasswordVar% for the password, this should work. You won’t be able to see what you type for the password, but you will get code completion for the variable name.   
  
 Regards,   
  
 Angus

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [January 9, 2008, 3:08am UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706/3 "2008-01-09T03:08:48Z")

</div>

Hi,

Thanks very much for the reply. But I still have a few questions on this action.

I have created a .dts file from a database table and I want to import the table to the target database using the .dts file. So in the DTSRun action where would you specify the destination database info? Should I enter the&nbsp;destination database name into the&nbsp;"Server 2000 instance"?

Also, since I have the dts page stored in a .dts file. Should I leave the "repository database" box empty?

I've tried the help file comes with the software and I didn't find much useful info on this action. Please help me with this.

&nbsp;

Thanks!

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [January 10, 2008, 4:19am UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706/4 "2008-01-10T04:19:27Z")

</div>

Hi Liang,   
  
As far as I understand it, the target database is part of the DTS package and cannot be changed when re-importing a package. This is different to the Repository Database property, which can be used to source the DTS package. This is a limitation of the DTSRun tool which we use to execute the DTS package.  
  
The "Server 2000 Instance" is for the name of the SQL Server instance, when connecting to a server with multiple running instances (I'll change the label so it's more up to date.)   
  
Regards,   
  
Angus

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [January 10, 2008, 12:59pm UTC](https://www.finalbuilder.com/forums/t/password-property-issue-on-dtsrun-action/706/5 "2008-01-10T12:59:33Z")

</div>

I have&nbsp;now decided to use&nbsp;the bcp command util to import the table because with this way I can specify what database the data goes to.   
  
Thanks for the help!