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.
| Author |
Topic |
|
sridharg
Starting Member
7 Posts |
 Posted - 2008-04-15 : 05:07:03
|
| i am transfering the table from one database to csv file format..i did it.. again i want to shift that csv files to another databse as tables. how to do this task.. pls help me.. its very urgent..out TL had given me the dead line.. send reply soon.... |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-04-15 : 07:42:37
|
| Why not directly dump the data to the other databases? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-15 : 12:04:52
|
| why are you converting it to csv for table to table transfer? just use a dataflow task with source and destination tasks |
|
|
|
sridharg
Starting Member
7 Posts |
Posted - 2008-04-16 : 02:51:25
|
quote:
Originally posted by rgombina
Why not directly dump the data to the other databases?
as per our client requirement.. we have to convert all the database tables into csv formats and we have to mail that csv files to them..then there they will again load that csv files into their database... |
|
|
|
sridharg
Starting Member
7 Posts |
Posted - 2008-04-16 : 02:51:51
|
quote:
Originally posted by visakh16
why are you converting it to csv for table to table transfer? just use a dataflow task with source and destination tasks
as per our client requirement.. we have to convert all the database tables into csv formats and we have to mail that csv files to them..then there they will again load that csv files into their database... |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-04-17 : 10:34:15
|
| Can you give more information what the problem you are having?Where in the loading are you having problem with?Does the destination database already have the table to import to?Do you currently have a package you are working on which you are getting an error? |
|
|
|
|
|
|
changing dynamically the destination name in ssis