Dynamic Table Name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Dynamic Table Name

Author

Topic

rauof_thameem
Starting Member

31 Posts

Posted - 2007-05-16 : 01:55:52

Hi..,

I want to know how to create a DTS for dynamic tables..,
Details:
1)I have some tables which created every month(Like [Name][2 char of month][2 char of year] eg: name0206 this table is for feburary 2006),i want to create dts for those tables

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-16 : 02:34:37

refer www.sommarskog.se/dynamic_sql.html

Madhivanan

Failing to plan is Planning to fail

rauof_thameem
Starting Member

31 Posts

Posted - 2007-05-16 : 04:11:10

thanks madhi..,

the article was nice but..,that one is for creating sql queries..
i want to know how i can implement that one in DTS.. there i have Data flow tasks.., how i can associate this sql query with that task..,

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-16 : 10:45:24

Not sure about your requirements
See if you are able to find some scripts here
www.sqldts.com

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources