saw your presentation a sql saturday in omaha at mammal hall AND in lincoln, at avery hall, oct 6. been going to sql user groups in lincoln and omaha for several years. i am trying to config an ssis package to send emails. getting error: [Send Mail Task] Error: An error occurred with the following error message: “Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:25″. is there any way to force ssis to use port 80?
can you give me any guidance regarding HOW to debug this?
THANKS!!!
thanks alot for the wonderful and useful posts about ssis, i use ssis alot to develop ETLs,
i am facing a serious problem with sybase.
i managed to get data from every where accept sybase, sybase used to work with DTS, but now it doesn’t work with ssis
the normal sybase driver 12 and 15 didn’t work me, luckily i found a very nice third-party driver by Datadirect, which works perfect, but its very expensive
i was just thinking if you have faced such a problem before it will be great to share your experience
Hi Phil,
I have one column in sql server DB having nvarchar data type and i want to put this table data to excel file,but it showing text data in the excel file.my requirement is to convert the sql server nvarchar column to numeric data type in ssis so that correct format(number format) can be insert into the destination excel file.Please let me know how i can do this.i tried with this approach use data conversion transformation and select eight byte signed ineteger data type ,but its not working.Thanks in advance…
I have two database from two different servers need to synchronization of database using ssis.which controls use for synchronization of database using ssis.Condition is that
from server A what ever new data inserted should be updated on server B & inserted if not exists.but not versa
saw your presentation a sql saturday in omaha at mammal hall AND in lincoln, at avery hall, oct 6. been going to sql user groups in lincoln and omaha for several years. i am trying to config an ssis package to send emails. getting error: [Send Mail Task] Error: An error occurred with the following error message: “Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:25″. is there any way to force ssis to use port 80?
can you give me any guidance regarding HOW to debug this?
THANKS!!!
hi phil
thanks alot for the wonderful and useful posts about ssis, i use ssis alot to develop ETLs,
i am facing a serious problem with sybase.
i managed to get data from every where accept sybase, sybase used to work with DTS, but now it doesn’t work with ssis
the normal sybase driver 12 and 15 didn’t work me, luckily i found a very nice third-party driver by Datadirect, which works perfect, but its very expensive
i was just thinking if you have faced such a problem before it will be great to share your experience
thanks allot
Regards
Hi Phil,
I have one column in sql server DB having nvarchar data type and i want to put this table data to excel file,but it showing text data in the excel file.my requirement is to convert the sql server nvarchar column to numeric data type in ssis so that correct format(number format) can be insert into the destination excel file.Please let me know how i can do this.i tried with this approach use data conversion transformation and select eight byte signed ineteger data type ,but its not working.Thanks in advance…
I have two database from two different servers need to synchronization of database using ssis.which controls use for synchronization of database using ssis.Condition is that
from server A what ever new data inserted should be updated on server B & inserted if not exists.but not versa