Data Flow Question

#1

Does anyone know how to use the OLE DB Source/OLE DB Destination components
in SSIS to carry out a load of data from a table whose name is determined at
runtime? i.e. a variable which is assigned during the iterations of a loop

I am trying to do load of several tables and dont fancy writing a package
for each

Thanks
Gerard

#2

Has anyone managed to get this to work?

"Gerard" wrote:

Quote:

Does anyone know how to use the OLE DB Source/OLE DB Destination components
in SSIS to carry out a load of data from a table whose name is determined at
runtime? i.e. a variable which is assigned during the iterations of a loop

I am trying to do load of several tables and dont fancy writing a package
for each

Thanks
Gerard

#3

Never mind... found another thread that says it is not possible.

"Al" wrote:

Quote:

Has anyone managed to get this to work?

"Gerard" wrote:

Does anyone know how to use the OLE DB Source/OLE DB Destination components
in SSIS to carry out a load of data from a table whose name is determined at
runtime? i.e. a variable which is assigned during the iterations of a loop

I am trying to do load of several tables and dont fancy writing a package
for each

Thanks
Gerard

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data Flow Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Data Flow Question - 03-27-2006 , 05:44 AM

RE: Data Flow Question - 05-05-2006 , 04:55 AM

RE: Data Flow Question - 05-05-2006 , 05:31 AM