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.
Author |
Topic |
richardps
Starting Member
33 Posts |
Posted - 2007-11-22 : 09:03:13
|
Is it possible to create a Create Table or similar script in SSIS for an object?Thanks in advance,Richard. |
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-11-22 : 15:27:14
|
You can use the Execute SQL Task to execute any Transact SQL including CREATE TABLE statements. |
|
|
pritika.vats
Starting Member
3 Posts |
Posted - 2007-11-29 : 08:18:49
|
yes their is one other way that is in ssis sourse tool we havw one option that is command and write the sql query like create table tablename which can create the table but that is work only once.when it ill executed 2nd time than it show the error object already existtry this Pritika vatsB+ |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-01-16 : 10:30:43
|
quote: Originally posted by pritika.vats yes their is one other way that is in ssis sourse tool we havw one option that is command and write the sql query like create table tablename which can create the table but that is work only once.when it ill executed 2nd time than it show the error object already existtry this Pritika vatsB+
Add If Exists object (DROP table) on top of CREATE table then you won't have to worry about already exist. JUST be careful with this or you end up dropping tables very quickly. |
|
|
|
|
|