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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Data feeds

Author  Topic 

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2012-07-10 : 01:53:39
Hi Guys,

I need you suggestions.
I'm implementing a plan to automate data feeds from US to asia. so, the data automatically uploaded into my database here in Asia. Right now I'm manually process the pullout of records w/c i used the cyrstal report then exported to data only (XLS). then use the bulk insert to dump into my table here in Asia. what is the best way to create an automated solution?

Thank you.

jov

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2012-07-10 : 01:59:32
SSIS
Go to Top of Page
   

- Advertisement -