Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dynamic:How to insert tablename (SSIS) Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 4:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:04 AM
Points: 113, Visits: 190
Hi Guys,

I want to perform a task.
I want to insert the table name of the destination tables to the another table
My Source : Excel
My Destination : Sql Server (OLEDB)

how to do this..

Like i have inserted the rowcount of the inserted data of the destination table to the another table...

plzz help me on this..
Post #1381913
Posted Thursday, November 8, 2012 12:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
How do you configure the destination table? Is it fixed in the package or dynamic?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382307
Posted Thursday, November 8, 2012 5:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:04 AM
Points: 113, Visits: 190
Dyanmic...
If it was fixed then i wud have hardcore the table name and insert but it is dynamic
Post #1382434
Posted Thursday, November 8, 2012 5:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
farooq.hbs (11/8/2012)
Dyanmic...
If it was fixed then i wud have hardcore the table name and insert but it is dynamic


OK, and how do you configure the tablename?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382437
Posted Thursday, November 8, 2012 5:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:04 AM
Points: 113, Visits: 190
It is something like this...

In the Execute SQL task, Should configure this..

Name of the table of the data flow task and row_count of the insertion took place for everytable into another name..

I done with the destination rowcount insertion to another table but same like need to configure the table name of the destiantion
Post #1382440
Posted Thursday, November 8, 2012 6:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
I'll ask it again. You said you configure your destination in the dataflow dynamically.
My question was: how?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382446
Posted Thursday, November 8, 2012 7:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:20 AM
Points: 5,180, Visits: 12,033
farooq.hbs (11/8/2012)
Dyanmic...
If it was fixed then i wud have hardcore the table name and insert but it is dynamic


Hardcore table names? I'm thinking your mind isn't 100% focused on ETL ...



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1382511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse