Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to: Use Data Source Object and Data Source View Object?

 
   Database Help (Home) -> Programming RSS
Next:  UPDATE..FROM doesn't work in SQL 2005!!!!  
Author Message
Axel Dahmen

External


Since: Dec 20, 2007
Posts: 60



(Msg. 1) Posted: Fri May 16, 2008 11:41 am
Post subject: How to: Use Data Source Object and Data Source View Object?
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi,

I can't possibly find any information of actually how to use a data source object or a data source view object in a package.

After I've added a SQL Server data source object and a data source view object to my project I can't use any of them in almost any of the source or destination data flow component.

I've created an entry for the Data Source in the Connection Manager pane, but the only connection where I can see the Data Source object listed is in the DataReader source component. It lists the Data Source object amongst all available connections to use. Is this all? What am I doing wrong?

Moreover, I can't find any option to add a Data Source VIEW object to anything. How am I supposed to use this kind of object in SSIS?

Thanks for enlightening me!

Axel Dahmen

 >> Stay informed about: How to: Use Data Source Object and Data Source View Object? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Data Type > Save various object types - Hello, I am working on a .NET project and I would like to save some LOCALIZED content in an SQL 2005 database. This content might be a string, a number or even a class with its properties values defined so I can retrieve it later. I will not need..

Fucntion/View field source - Hi guys, I'll try to explain the problem. I have a function/view with returning fields A, B, C, D. A and B token from Table1. C and D token from Table2. Is it any way to check from wich table the function/view gets value of the result field? I can get..

"Verticalize" data in a view ? - /* How do you "verticalize" data in a view ? Thanks ! I would like the output to look like this.. 2 columns... Cust Grp A AA A CC A DD B DD B AA B NN C CC */ CREATE TABLE [dbo].[tblCust] ( [Cust] [char] (10) NO...

Source Safe - Hi, We desperately need to have some Source Control for version maintaining and to enable quick replication of chenges done to development server to say staging server or QA server... or a production server Any tools, that can plug in to sql server,....

Export DB source help - Hello, i am looking to make a full scripted backup of my sql server 2000 database using various free tools, i can easily export the table structures and stored procs into my script, but i have not found anything to help with: - indexes - users/logins -..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]