I have switched from blogger to word press. here is my blogger site;
Category: Uncategorized
Anything unrelated to defined categories
How to run SSIS Packages from Web
This is all about running SSIS Web packages;
DTExec /ISSERVER “\SSISDB\fm\fmimports\ALL_STG_Main_Run.dtsx” /SERVER “172.16.20.13” /Envreference 3
Resources
https://stevestedman.com/2016/05/is-enabling-xp_cmdshell-a-security-risk/
this link is helpful
https://www.timmitchell.net/post/2016/11/28/a-better-way-to-execute-ssis-packages-with-t-sql/
How to script out packages
http://tomaslind.net/2015/12/07/ssisdb-catalog-create_execution/
ErrorDescription
Error 0xC0012050 while executing package from project reference package “STG_SETO_MilestonesImport.dtsx”. Package failed validation from the ExecutePackage task. The package cannot run. .
32 bit and 64 bit office side by side
Download this;
https://www.microsoft.com/en-us/download/details.aspx?id=54920
Open command prompt, navigate to exe and run this;
accessdatabaseengine.exe /quiet
This will help you to install 32 bit office driver along 64 bit.
To validate, try running SQL Agent job in 32 bit. If there is no error, your installation of 32 bit is successful. SQL Agent SSIS jobs by default run in 64 bit.
Installing on SQL Server
Install 64-bit version on SQL Server.
Reference
Introduction to stocks, housing market
Check this web site;
use any stock symbol, aal, ual, aal, msft, amd, mu, spce, astr, mnts, arkx and see whether its available for sale or on hold. do a research on google and see last 5 years history. see Mkt capital and P/E (< 30). Example of overpriced stocks, Tesla.
Check Business and Science & Technology News (Google, Facebook). Dr. Shahid Massod is another resource for international stocks.
Apple, Microsoft stocks are safe. TX deals in precious metal and they are new but risky. Other options are 401K, IRA. Age over 50 can contribute more. Check fidelity also.
Check housing market. when fed interest rate increases, housing price fell. it’s time to invest. when fed interest decrease, refinance helps.
Create kids brokerage accounts in Charles Schwab or Fidelity. Buy big companies share. Big company is at least more than 50B. Look at last 5 years stock price. for example, if share price were $100 5 years ago and now it’s $500 then it’s 500% growth. Good company to invest.
Student Loan’s cost about 4-6%. grab load and invest in stocks that yield about 15%. Offset loan amount with invested amount and keep the gain.
Try to do job on 1099 or Corp-to-corp. Employer do not need to worry about social security and Medicare. The rate difference is around $8-10. This can help to save for old age.