Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integration Services Project Data Flow relation
Message
From
26/02/2008 17:27:45
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Integration Services Project Data Flow relation
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01296616
Message ID:
01296616
Views:
53
I have created an Integration Services Project. It's been a while since the last time I had to deal with that. There is something I cannot remember how to do. In the package, in the Data Flow window, I have drop an OLE DB for the source and another one for the destination. I have defined the one for the source. But, for the destination one, there is something I am trying to do. I have created an empty database on SQL Server. There is no table in it. But, when I have to define the data flow for the destination, I have to select a table. But, if I recall correctly, I didn't have to do that when I did it about 18 months ago. Everytime I was running the package, I was removing all tables from the SQL Server database. So, the only thing remaining for the database itself. I also didn't have to define everything for all tables of my VFP directory in the package. I did something that was doing it by itself. So, I have about 120 tables. What is the simplest way to create a data flow object for each 120 tables as the source linked to their related 120 data flow objects of the destination?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform