SSIS using BIDS 2005 - 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 using BIDS 2005

Author

Topic

pradeep_21
Starting Member

9 Posts

Posted - 2012-04-25 : 08:29:59

HI folks,

I'm totally new in SSIS, how can i configure multiple database in single SSIS package.

I'm using Data flow task,OLEDB Source,OLEDB Destination.

If i add more than one OLEDB source and destination its getting error

scenario:

If i run this package in first time there is no issues. It was insert both destination tables. But if i did any modification in source tables after that i run the package it was appended in first destination table but not appended in 2nd destination table.

My requirement: To run single SSIS package to update multiple database's table.

Please help me i have to implement this ASAP in live.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-25 : 14:53:56

duplicate

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173969

please dont crosspost

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

pradeep_21
Starting Member

9 Posts

Posted - 2012-04-26 : 00:35:25

Hi Visakh,

Thanks for your reply....

Previous issue has been fixed.

thanks.

pradeep_21
Starting Member

9 Posts

Posted - 2012-04-26 : 00:51:14

Hi Visakh,

Now i am trying to connect destination database in different server while connecting its getting error:

"Test connection failed because of an error in initializing provider.[DBNETLIB]ConnectionOpen (connect()
). SQL Server does not exist or access denied."

I'm using provide (Native OLE DB\Microsoft OLE DB provider for SQL Server)

Source server: SQL Server 2005 / SP2 / 32bit
Destination server : SQL Server 2005 / SP2 / 32bit

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-26 : 12:32:25

are you giving correct values in connection? the error suggests either server/db name is wrong or you dont have access to it using current credentials you use for running the package

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources