Problem with a select in a stored procedure

Does anybody know what is wrong with this code from a stored procedure:
DECLARE tables_cursor CURSOR FOR
SELECT tf_change_out_id, destination, re_table, date_in
FROM tf_change_out_table
WHERE date_out = NULL
ORDER BY tf_change_out_id

Here is the error I'm getting:
Error 107: The column prefix 'tf_change_out_table' does not match with a table name or alias name used in the query.Perhaps there's something before the cursor declaration that results in the error below. If you'd select the cursor-declaration, and parse it, is there an error message?|||Silly me! The error was further down the code. Why can't they give line numbers with all the errors?|||That woud make it too easy, and then everyone would think they could write SQL :D


Besides ... if it was hard to write, it should be hard to read ;)

Problem while exporting in MAPI

Hi,

I am using crystal report v8.5.
I click on the export icon & select Acrobat Format (PDF) as Format and MAPI as Destination.
But nothing appeared and i couldn't export report whereas i can succesfully save the same report when select Acrobat Format (PDF) as Format and "disk file" as Destination.
Please help me out?

Thanks,
JasIs this on you development machine or the Client machine? Did you make sure you had the correct MAPI dll installed on the computer?|||this is on my developing m/c. i use outlook express for mailing purpose, which works fine. how to check whether correct mapi dll is intalled?

thanks

jas|||I also use CR 8.5. On my computer (Win2k), all the Export dlls are located in C:\WINNT\Crystal. The MAPI one has the name u2dmapi.dll. If you can't find the right dll, maybe it wasn't installed when you installed Crystal Reports. You may be able to reinstall it or pull the dll from the installation CD.|||i use win xp professional, u2dmapi.dll is present in my C:\WINDOWS\Crystal folder but still i couldn't mail. when i click "ok" after selecting format as Acrobat and destination as MAPI, one window appeared titled as "Export options" which allows to enter page range. But after that nothing happened.|||Do you have Outlook or something setup on your computer? I'm not familiar with MAPI, but while researching one of my exporting problems, I read a post where someone was having trouble exporting with MAPI and it was because Outlook wasn't set up with a user profile.|||yaa, i m using outlook express to send n receive mails and it is working perfectly.|||Outlook express is not connected through MAPI, while Microsoft Outlook uses MAPI, to configure a profile follow these steps

1. Open Mail Control Panel
2. Configure Message Store and Internet mail account
3. then use Microsoft Outlook to send & receive mail, if it works then ur Export will also work.|||Thanx for ur help. I m off from work for 2-3 weeks, got chicken pox :( , will try later.
Thanks again
Jas|||Get well soon

Problem When From Sequence file insert into Oracle Destination table in SSIS Package

Hi ,

i was used the Follwing DataFlow for my Package.using Oracle 8i

FalteFile Source -> Data Conversion >OLEDB Destination (Oracle Data table)

using above control flow to map the Source file to Destination . When i run the SSIS Package teh Folwing Error i got

"Truncation Occur maydue to inserting data from data flow column "columnName " with a length of 50 "

regarding this Error i i understood its for happening Data Length . so that i was changed the Source Column Length Exactly Match with the The Destination table.

still i am getting this Error. pls any one give me a solution . SHould i Change the DataType also?

pls give your suggestion

Thanks & Regards

Jeyakumar.M

chennai

At some point of your flow it is still defined as greater than 50. Check all outputs of all components and check external columns of your source as well.

-Jamie

|||

Hi Jamie

Thanks for your reply. all the Source column (Sequence file) and Destination Column (oracle Table ) length are same. But i didn't give Data type match for source and Destination .. Is it Required for Data Type to define in the Source column in Dataconversion control. pls Let me know.

Thanks For Your reply

Jeyakumar.M

chennai

|||

Data types in teh source are by and large determined by the OLE DB Provider. If you need them to be something else then drop a Data Conversion component into your flow.

-Jamie

Problem using merge join transformation in Sql server 2005(SSIS)

Hi,

I am pretty new to SSIS. I am transferring some rows from 2 source tables to 1 destination table.

The 2 source tables have 1000 rows.They act as the 2 inputs to a merge join transformation where i perform the join between the 2 tables based on a couple of fields. But for some reason the output of the merge join gives me about 1018 rows .Shouldnt the destination also have only 1000 rows?

How do i solve tis problem?

Thanks in advance

Sat

Satishr23:

But for some reason the output of the merge join gives me about 1018 rows .Shouldnt the destination also have only 1000 rows?

Not exactly. It depends on the logical operation of the merge join, for example "full outer join" may lead to such issue. You can refer to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_5alv.asp