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 |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-05-25 : 16:06:35
|
| Hi, First Question is can we use Stored Procesdures in SSIS..if yes where i mean by useing which transformation how..?Secondly i am stuck up here..:SELECT JAM_ID = a.JAMGCD, JAM_NM = a.JVDQVN, JAM_DESC = CONVERT(varchar(50),SUBSTRING(a.JAMATX,1,CHARINDEX('..',a.JAMATX )-1)), JAM_CODE = ?from table1...I am using this Query in the OlEDB Data flow task to retrieve the columns which i need and do some transformations..on them...now i get JAM_CODE by using JAM_DESC can i use it...i think i cant ....can anyone suggest how to deal with this.?thanksraviNothing much that i can do..!! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-29 : 10:13:57
|
| You can make a stored procedure a datasource.You can use a drived table if you don't want to repeat the code to derive JAM_DESC SELECT JAM_ID ,JAM_NM ,JAM_DESC ,JAM_CODE = fn(JAM_DESC)from(SELECT JAM_ID = a.JAMGCD, JAM_NM = a.JVDQVN, JAM_DESC = CONVERT(varchar(50),SUBSTRING(a.JAMATX,1,CHARINDEX('..',a.JAMATX )-1))from table1...) a==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Ravi0435
Starting Member
47 Posts |
Posted - 2007-05-30 : 12:19:51
|
| Know what I did the same but just a bit different way i mean worked on completely diffferent function...but the thinking was same , i saw your reply very late..thanks though..!!Nothing much that i can do..!! |
|
|
|
|
|
|
|
|
can we use stored procedures in SSIS..?