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
 SSIS and Import/Export (2008)
 Simple Update Statement using Script Task

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2011-08-01 : 14:39:08
I spent pretty much all of today trying to read a text file, parse the rows, and write those rows to SQL using a SCRIPT task.

Can someone please point me to a simple example on how to do this using C#? Better yet, does anyone have any sample code I can use as a real world example?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-02 : 01:16:45
why should you use script task for this? If you want a quick and easy solution why not go with export import wizard which does this for you by building package using wizard.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -