Ssis/sql Gurus Itu Vacheyyandi....oka Doubt

[cool_dude]

Nenu SSIS nundi dynamic ga table create cheyyali ani anukuntunna .

The intended process is:[list]
[*]Execute SQL Task object creates new table based on today's date (i.e. Table1_20121119)
[*]Data Flow task moves data from table "Table1" to "Table1_20121119".
[/list]
So hw can I do this?


Kastha help seyyandi babulu...2 hrs nundi kinda meedha padtunna.....

[ghazni]

asalu artam kaley mama.......

[cool_dude]

[quote name='ghazni' timestamp='1353370670' post='1302826103']
asalu artam kaley mama.......
[/quote]


Simple ga cheppali ante


SQL lo manam

Select * into newTable from oldtable antam kadha...

SO how to automate the above one in SSIS process where table name changes dynamically everytime
so newTable should be Destination table ....with table name in dynamic form

Ivvala pkg run chesthe aa table name should be created in DB as newtable_todaydate


Ippdu kuda ardham avvaledhu ante ika nenu waste baa story cheppadam lo.....

[ghazni]

mama idi actual ga aitey flat file ki ivochu kani tables ki ela ivalo tliyadu...... asalu oka project kuda cheyaledu ssis mida wait somebody might help u.....

[cool_dude]

[quote name='ghazni' timestamp='1353370670' post='1302826103']
asalu artam kaley mama.......
[/quote]

Inka clear ga cheppali ante similar to this ghajini bhaiyya....

[url="http://stackoverflow.com/questions/7763072/using-dynamically-named-table-in-ssis-data-flow-task"]http://stackoverflow.com/questions/7763072/using-dynamically-named-table-in-ssis-data-flow-task[/url]

[ghazni]

[quote name='cool_dude' timestamp='1353371466' post='1302826166']

Inka clear ga cheppali ante similar to this ghajini bhaiyya....

[url="http://stackoverflow.com/questions/7763072/using-dynamically-named-table-in-ssis-data-flow-task"]http://stackoverflow...-data-flow-task[/url]
[/quote]
mari cheseyi inkenti doubt mari.....

[chelsea]

Help

[cool_dude]

[quote name='ghazni' timestamp='1353371733' post='1302826180']
mari cheseyi inkenti doubt mari.....
[/quote]


Adhi summarized ga chepaledhu mama. Nenu aa flow follow ayyanu kani I am getting error in terms of mapping and etc. So looking for clear and betetr solution with detailed flow...

[chelsea]

execute sql task lo using SQL statement try cheyyi ba below example work out avthadi emo

declare @Tablename Varchar(45)

declare @Sql varchar(Max)
set @Tablename= CAST( getdate() as varchar(25))
select @Tablename


set @Sql='SELECT *
INTO ' + @Tablename +
'FROM existing_staging_table'
Exec (@sql)

[chelsea]

Execute Sql task lo use this code to create a table declare @Tablename Varchar(45)

declare @Sql varchar(Max)
set @Tablename= convert(varchar(8),getdate(),112)
--select @Tablename


set @Sql='Create table table' + @Tablename +
' ( id int, emp varchar(10) )'

if not exists (select 1 from sys.tables where name = '@Tablename')
exec (@sql)

Package lo okka variable create cheyyi table name

example e output variable value ga pass cheyyi
Declare @Tablename varchar(30) set @Tablename= convert(varchar(8),getdate(),112)
--select @Tablename

Data flow task add cheyyi OLED destination use tablename or viewname variable

[Darling999]

Time untey repu morning appiice ki ellaganey cheptaa

[cool_dude]

[quote name='DARLING...' timestamp='1353377121' post='1302826577']
Time untey repu morning appiice ki ellaganey cheptaa
[/quote]


Tnq darling bhaiyya...

[cool_dude]

[quote name='chelsea' timestamp='1353374884' post='1302826391']
Execute Sql task lo use this code to create a table declare @Tablename Varchar(45)

declare @Sql varchar(Max)
set @Tablename= convert(varchar(8),getdate(),112)
--select @Tablename


set @Sql='Create table table' + @Tablename +
' ( id int, emp varchar(10) )'

if not exists (select 1 from sys.tables where name = '@Tablename')
exec (@sql)

Package lo okka variable create cheyyi table name

example e output variable value ga pass cheyyi
Declare @Tablename varchar(30) set @Tablename= convert(varchar(8),getdate(),112)
--select @Tablename

Data flow task add cheyyi OLED destination use tablename or viewname variable
[/quote]

Tnq Chelsea bhaiyya..Will try to implement this one 2marrow....once again whole hearted thnkz...