MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 8th, 2004, 08:47 PM
rt_hide rt_hide is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 7 rt_hide User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question help needed...dts package

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....
Attached Images
File Type: jpg sql_package.jpg (39.7 KB, 221 views)

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > help needed...dts package


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT