SSIS start proces - SQL Server Forums

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 2005 Forums

SSIS and Import/Export (2005)

SSIS start proces

Author

Topic

pvds
Starting Member

2 Posts

Posted - 2009-07-06 : 07:03:03

I want to start a vb.net application from SSIS. I am desperate for it's not giving the result I suspect.
What happens ;
vb.net application : make a connection with an oracle db on server A
make a connection with an SQL server db on server B
Create a Table and bulkcopying data to SQL.When running in vb.net then it is working correctly.
Start with SSIS proces and this is not giving the expected result. (result expected--> new table with data in SQL server B)
I can't figure out what the problem is.. I am a newbie to SSIS : in the properties of SSIS proces I directed to the executable path.

Gr. pvds

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-07-06 : 10:05:11

I dont think you need a VB application for doing this. You can accomplish this in SSIS itself.

You need a Data FLow Task with OLEDB source (Oracle DB) and a OLE DB destination (SQL server).

pvds
Starting Member

2 Posts

Posted - 2009-07-07 : 05:22:30

Ah, now I understand.. i made a project now and it is working.. BUT only one table is possible. Do i have to repeat the same things again. so, new data flow etc. ? or is it possible to copy some tables in one dataflow ?

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-07-07 : 10:13:31

It can be achieved in a single data flow task.

I found this for reference.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/80b80533-cc88-4e50-96d3-bdc9d3cb72dd

Narendranath
Starting Member

2 Posts

Posted - 2009-07-15 : 06:55:24

You can achieve multiple flow of tables from source to destination in a single DFT task.Inside this DFT task define the number of transfers you required by adding the proper number of OLEDB Source and Destinations tasks..Ensure to have connections managers set to all this sub-tasks.

Thanks,
Naren

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources