SSIS Question

FAQ

Profile

SSIS Question

Database Forums (Home) -> Data Warehouse

Next: Can't join tables from two databases using linked..

Author

Message

Kris

External

Since: Mar 31, 2006
Posts: 24

(Msg. 1) Posted: Mon Feb 11, 2008 3:09 pm
Post subject: SSIS Question
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

Hi,

Is there any way I can copy multiple tables using any controls in SSIS ?

Thanks.

>> Stay informed about: SSIS Question

Jeje

External

Since: Apr 17, 2006
Posts: 184

(Msg. 2) Posted: Wed Feb 13, 2008 8:01 pm Post subject: Re: SSIS Question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

can you explain what you want to do? "Kris" wrote in message > Hi, > > Is there any way I can copy multiple tables using any controls in SSIS ? > > Thanks. >> Stay informed about: SSIS Question

Kris

External

Since: Mar 31, 2006
Posts: 24

(Msg. 3) Posted: Thu Feb 14, 2008 9:29 am Post subject: Re: SSIS Question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Sure, Thanks Jeje. I would like to copy 30 tables from Source system to WH every day. At present I have used Data Flow talk for each table to copy. Is ther any Way, I can copy all the tables using one Task ? Like in SQL 2000 I have used Copy SQL Server Object task ..any help pls. Thanks. "Jeje" wrote: > can you explain what you want to do? > > > "Kris" wrote in message > > > Hi, > > > > Is there any way I can copy multiple tables using any controls in SSIS ? > > > > Thanks. > >> Stay informed about: SSIS Question

Knowledgy

External

Since: Jan 03, 2008
Posts: 56

(Msg. 4) Posted: Thu Feb 14, 2008 6:23 pm Post subject: Re: SSIS Question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

You can put the SELECT....INTO syntax for all your tables into sql script and run that as a task. You can put object verification functionality and action before this. This could be put into a single task. -- Sincerely, John K Knowledgy Consulting www.knowledgy.org Atlanta's Business Intelligence and Data Warehouse Experts "Kris" wrote in message > Hi, > > Is there any way I can copy multiple tables using any controls in SSIS ? > > Thanks. >> Stay informed about: SSIS Question

Jack Vamvas

External

Since: Aug 13, 2007
Posts: 60

(Msg. 5) Posted: Sat Feb 16, 2008 3:00 pm Post subject: Re: SSIS Question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

1)Set up the 2 connections 2)Create a Preparation SQL Task - (include all your CREATE TABLE processes) 3)Set up your Data Flow Task -- Jack Vamvas ___________________________________ Search IT jobs from multiple sources- http://www.ITjobfeed.com "Kris" wrote in message > Hi, > > Is there any way I can copy multiple tables using any controls in SSIS ? > > Thanks. >> Stay informed about: SSIS Question

Display posts from previous:

Related Topics:

Basic SSIS question - All, I'm new to SSIS and really need you guys’ help. Here is my problem. I need to copy data from number of tables to the staging tables in a DB, These are just direct copy and doesn’t need any changes during the extraction. The process basically...

New question re: SSIS Slowly Changing Dimension transforma.. - Hi, I'm just getting my feet wet with SSIS, and I'm having some trouble with the Slowly Changing Dimension transformation. I'm processing Type 2 SCDs, and in addition to creating a new current dimension record/setting the old dimension record to expired...

MDX resultset in SSIS - Hi, I'm trying to write a MDX query resultset from a cube to a database table via an SSIS package. I create an OLE DB source in a data flow and choose OLE DB Provider for Analysis Services 9.0 as the connection manager. Then I run it through some node...

SSIS Non-Equijoin Lookups - When do a fact table load...I have to perform lookups against the dimension tables. The dimensions tables I have support slow changes, however, and thus have multiple rows for a single legacy key under different effective start and end dates. In..

SSIS multiple databases - Hi all I'm trying to find something smart :) but let me first explain situation I've couple databases with the some structure Is there any way to run the same SSIS packages parallel against those databases . Ideally the packages should be controlled....

	Database Forums (Home) -> Data Warehouse	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