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)
 insertion-one DB table to another DB table

Author  Topic 

abbikhan
Starting Member

26 Posts

Posted - 2011-07-07 : 13:57:08
I wan to insert data from DB1.table1 to DB2.table2 after performing some TSQL 'CASE' and string functions
how can i do in SSIS

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-07-07 : 14:01:51
in sql task?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

abbikhan
Starting Member

26 Posts

Posted - 2011-07-07 : 14:12:11
yes using SQL databases,tables and visual studio integration project.
Go to Top of Page

lightsql
Starting Member

17 Posts

Posted - 2011-07-20 : 05:31:02
You can use a Derived Column if you want to perform some transformation on the data and Conditional Split for filtering function.
Go to Top of Page
   

- Advertisement -