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 - 2002-09-10 : 09:26:43
|
| Jyoti writes "Hello Everybody I am using SQL 7. I am running DTS package from Visual Basic 6.This works properly.Now In the table where i am importing the text file has one more column.I want this column to have a run time value which i will be passing from my vb. What i have done is I have a globalvariable with hard coded value and in the activex script for that column i am assigning that global variable.But it is not taking that value. Also i want to assign the value to this global variable at run time.Reply me asapThanksbyeJyoti" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-10 : 09:44:01
|
| Set objDTSPackage = New DTS.PackageobjDTSPackage.LoadFromSQLServer strServerName, , , DTSSQLStgFlag_UseTrustedConnection, , , , strDTSPackageNameobjDTSPackage.GlobalVariables("var1") = "value"objDTSPackage.GlobalVariables("var2") = "value"objDTSPackage.Execute==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Pass parameters from the vb to DTS package