sql server data warehouse: Hi
I am new to this area, please be nice to me.
BTW, am I in the right group?
I am very new to SSIS, but tons of experience in SQL programming. I
would like to do an SSIS package, a simple one. can I do it in SSIS
with something like this in SQL or I have to use SQL.

SELECT TABLE1.col1, TABLE1.COL2, NULL as COL3
INTO myNewTable
FROM TABLE1

Thanks

Yes you can do this in SSIS

In the control flow view (which controls the flow of the whole package) you
can use the Execute SQL task to just run any SQL statement.

However depending on what you are doing it might be worth looking in the
Data Flow Task,

This will allow you to add complex workflow syntax which will be applied row
by row to your source data which you then can add conditional transformation
before bulk loading into your new table.

Regards

Simon

[quoted text, click to view]