April 8, 2008 at 2:27 am
Is there any other options available other than the Merge join merge and union all?
I have to take the data from three tables aND UPDATE ONE TABLE BASED ON SOME CONDIOTIONS?
Please help me.
April 8, 2008 at 4:13 am
Please give us an example of the data from each of the tables and the conditions you're trying to pull the data together with. It's hard to answer your question without knowing exactly what you're attempting to accomplish.
April 8, 2008 at 4:32 am
I have 3 tables named Business_segment_Data,OneWeekData and DimTime.
update Business_Segment_Data
set Business_Segment_Data.lastweekdatedata = b.amount
from oneweekdata a,oneweekdata b,DimTime c,Business_Segment_Data
where a.branch_alt_key = b.branch_alt_key
and a.schemecode = b.schemecode
and a.weekdate = dateadd(week,1,b.weekdate)
and dateadd(week,1,b.weekdate) = c.pkdate
and Business_Segment_Data.timekey = c.dimtimekey
and Business_Segment_Data.branch_alt_code = a.branch_alt_key
and Business_Segment_Data.branch_alt_code = b.branch_alt_key
and Business_Segment_Data.scheme_code = a.schemecode
and Business_Segment_Data.scheme_code = b.schemecode
The above is my SQL Query..
I want to create a SSIS Package for the above query.
April 8, 2008 at 4:40 am
FYI, Microsoft is threatening to discontinue the version of JOINing that you just posted, so you might want to update it to the format most people use these days. (Look up JOIN in Books Online if you don't know the common format).
Could you post each table's structure and an example of the data from each table? It doesn't have to be real data. Sanitize it as necessary, but giving us this information will help determine the best way to do what you're wanting.
April 8, 2008 at 4:42 am
Oh, and it just occurs to me. Don't import the data. Use an Execute SQL Task on the Control Flow. Easiest and simpliest way to do what you're asking. @=) All you have to do is paste your query into the command window of the task and you're done.
April 9, 2008 at 12:09 am
I want to have a user be able to launch a DTS package that I've written. Their client machine (whether it's a local workstation or the Citrix box) doesn't and can't have SQL Tools loaded on it.
Will it be possible for me to have the user launch the DTS package? If so, how?
April 9, 2008 at 3:46 am
Look up DTUtil & DTExec in Books Online. It gives you details on how to run the package at the command prompt.
The caveat is that the user in question will need permissions on the server to run the package plus possible windows permissions to either log into the server directly or remotely using the command prompt.
The last option is to develop a little .Net program (using SMO) which takes advantage of the DTExec command to run the package and all you need to do is give the user the ability to run the program.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply