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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2008-11-10 : 16:06:55
|
| 2.i still dont know how to add a log to my package ,and how to see the log after runnig.3.i want to merg join with execl and table in my sql-this i know,but if i want so constant field?for examplefield1-from execlfield2-from table in sqlfield3-'aaa'field4-100thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-10 : 23:44:58
|
| are you asking about package logging?didnt understand what you mean by execl? did you mean sp? |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-11 : 01:21:43
|
| 1.yes,i asked od package log.2.i want to make join in ssis. i have 2 information source (execl-data in execl,and table in sql) so i do it with meg join. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-11 : 01:26:13
|
| my problem,that i do not know how to write fields constant.like my previous example.field1-field that come from execlfield2-from table in sqlfield3-'aaa' (constant)field4-100 (constant)like sql query:select execl.field1 table.field2 'aaa' as field3 100 as field 4from table join execl on table.field5=execl.field5how i do it in ssis? (field3 and field4)thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 01:57:34
|
| just hardcode value as 'aaa' in command window of execute sql task or oledb command task. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-11 : 12:56:29
|
| what is oledb command task?in sql task,do you mean that i need to write query or just 'aaaa'?example:select 'aaa' from tableOR'aaa'and if i want to mak statment of "case when then" where i write that? |
|
|
|
|
|
|
log,merg join