Dynamic:How to insert tablename (SSIS)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Dynamic:How to insert tablename (SSIS)

Dynamic:How to insert tablename (SSIS)

Rate Topic

Display Mode

Topic Options

Author

Message

farooq.hbs

Posted Wednesday, November 07, 2012 4:56 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:44 AM
Points: 99, Visits: 160

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

Koen Verbeeck

Posted Thursday, November 08, 2012 12:59 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376, Visits: 6,472

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

farooq.hbs

Posted Thursday, November 08, 2012 5:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:44 AM
Points: 99, Visits: 160

Dyanmic...
If it was fixed then i wud have hardcore the table name and insert but it is dynamic

Post #1382434

Koen Verbeeck

Posted Thursday, November 08, 2012 5:43 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376, Visits: 6,472

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

farooq.hbs

Posted Thursday, November 08, 2012 5:49 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:44 AM
Points: 99, Visits: 160

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

Koen Verbeeck

Posted Thursday, November 08, 2012 6:07 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376, Visits: 6,472

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

Phil Parkin

Posted Thursday, November 08, 2012 7:59 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 4,242, Visits: 9,494

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 ... Smile

____________________________________________________________________________________________

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

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1382511

« Prev Topic | Next Topic »

Permissions