|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
im gonna tell u about my problem that concerning about ms sql 2000 and dts package that i created in it. i made several connection (dbase IV, ms access, sql server) and also some tasks/execute sql task(delete data source in ms acess, update sw_on & sw_off in ms access connection). 1st i want to delete data source in ms access and when its completed i wanna transfer data from dbase IV connection to ms access connection when its complete the data transfer i wanna update the sw_on & sw_off using the execute sql task. but i cant do it n its error raised everytime i wanna try to do so. as the attachment showed. and the result when the update to ms access completed i wanna transfer the data from ms access to sql server. can u guys help me how to avoid the error when i wanna update the sw_on & sw_off in ms access and what should i do to do so ? can u help me pls ???
thx in advance anyway.... ![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > help needed...dts package |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|