Viewing 15 posts - 3,361 through 3,375 (of 3,738 total)
I Forgot to mention that I have a hotmail account & I'm using my Account in the From & To...
I sending myself an e-mail in this case.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 21, 2010 at 4:00 pm
Thank you for the information.
I got the information on the outgoing & incoming sites from the following link:
http://www.emailaddressmanager.com/tips/mail-settings.html
However I had to use Port 110 for the incoming.
You are supposed...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 21, 2010 at 3:57 pm
I have been able to do this from a corporate environment using their SMTP Server.
However in this case I'm trying to do this from home running XP Pro with the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 21, 2010 at 3:21 pm
Grant,
Unfortunately I do not have your 2008 book but I have an older one written by Sajal Dam. 😎
Regards..
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 1:15 am
Thanks everyone!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 1:10 am
I believe that you would want to store the UNC Path in a Package variable.
You could the select @@servername statement and store it in a Package variable.
Then create an additional...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 1:00 am
Re: Move data to DB2 on AS400 with SSIS
Try this thread from BJ Custard.
The configuration steps are as follows...
1.Create a Data Source for the AS/400, using provider NATIVE OLE...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 12:51 am
Does your code reside in Foreach Loop Container?
Create Package Level Variables that capture the Newest File for each directory. THen compare the two variables and store the Folder & File...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 12:27 am
Why not use OLEDB for UniData connection?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 12:06 am
I believe the merge join will provide you with the parallell capability that you are looking for.
The Database has to be sorted in the same Order on the Fields that...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 12, 2010 at 12:01 am
Why don't you use the OLEDB Provider for the connection to the Database on your AS400?
I have used the OLEDB for DB2, not on an AS400 platform...
As far as...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 11, 2010 at 11:46 pm
I have written SSIS Packages using named instances and it worked.
In the connection Manager Server Dropdown are you specifying the Server Name and the Instance?
YourServerName\TheInstanceName?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 11, 2010 at 11:22 pm
Is this for an SSIS Package?
Why not use VB.Net in the Script task?
There are numerous examples on the File System Object that can be found on Goggle.
I think I know...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 11, 2010 at 11:13 pm
There is an article at the following URL that list the deployment options.
It also describes the process for each method:
http://msdn.microsoft.com/en-us/library/cc966389.aspx
You can deploy SSIS packages in one of four ways:
•Use the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 11, 2010 at 11:05 pm
Please check out Jonathan Kehayias While Loop Solution at the following URL:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5cb4004-02fb-4b41-a321-5197f8105941%5B/URL%5D
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 11, 2010 at 10:58 pm
Viewing 15 posts - 3,361 through 3,375 (of 3,738 total)