45 Archived Topics
Remove Filter  | Hi All, I have a simple form that I want to send me an email when the button is clicked. I have two questions, 1. How can I make the fields Name and Email mandatory? 2. It does not send an email to me when used with my smartphone, which … |
| | Hi All, I have recently viewed something that I have never seen before with regards to a computer. I saw a window close and open really fast, at least 10 times upon startup. It looked like the cmd.exe window but I only saw a video of it happening and it …  |
| | Hi All, I'm working on a script which has a primary function to look for jpg files. I can get it to work if the folder path is just my desktop but if I try the start of the path to be C:\ it errors out. Right now the error … |
| | Hi All, I have two issues that I cannot seem to resolve using Google. 1. My windows account, the only one I have, is the Admin account. However, I cannot save files on my desktop and get prompted that only the admin can save there and that I should contact … |
| | Hi All, I have a Dell PC for which I am attempting to install Windows 7 onto a new HDD I bought. However, I am having issues with not being able to Boot the disk that has the Windows 7 iso. What I've done: 1. Seated the new HDD 2. … |
| | On my Facebooks there are a lot of posts from people that are really worried about WW3 popping off because of the Russian takeover of Ukraine. I've read some interesting articles from different countries that denounce Russia's actions and there's talk of economic sanctions from the US and other countries …  |
| | Not sure if this is the right spot for this question but I'm here! I'm trying to make a vb script that opens large text files, one at time, searches each line for Null values (there can be many) and then replaces them with a space. My coworker put the … |
| | Hi all, I'm going nuts with my laptop. I installed gparted, backed up my fil, and then let gparted do its thing. I then went to reinstall Ubuntu with a disc but I keep getting the following messages: "xhecking media [fail]. No boot device found. Press any key to continue". … |
| | Hi All, I've been helping a friend with a site that he's been designing with godaddy.com. It's pretty cool and easy to do with their templates and all but their like buttons are troublesome and I was hoping to get some knowledge about this from here. Lets say there are … |
| | Hi All, I've had Ubuntu for a couple of months now and I'm having problems with the boot drive/partition. I have a total of 500 GB to work with but for some reason that I didn't notice Ubuntu installed using only a (very) small portion of my 500 GB and … |
| | Hi All, THis is just a basic question about Wine. How many use it on Linux and how many are happy with it? I've seen mixed reviews about Wine on the internets so I thought I would ask the only tech community that matters. I just installed it because I … |
| | Hi All, I'm attempting to install Jre7 on my newly installed Ubunto OS. I've been looking [here](http://askubuntu.com/questions/56104/how-can-i-install-sun-oracles-proprietary-java-6-7-jre-or-jdk) and it is telling me to move the unzipped folder to /usr/lib but where is that? In the Terminal I tried finding it by changing directories but to no avail and I'm getting …  |
| | Hi all, I'm trying to get Ubuntu to work but at boot up I get issues. I took a picture and I don't know how to procede. |
| | Hi All, I'm trying to loop through and open PDFs in a folder using Java. I have the following code: import java.awt.Desktop; import java.io.File; import java.io.IOException; public class OpenPDFs { public static void main(String[] args) throws IOException { // TODO code application logic here String fp; fp ="S:\\Economic Forecasts\\Fcst13\\SourceForecasts\\"; File … |
| | Hi All, I am creating a simple query with a not so simple twist, at least it's not simple to me. First, the query: select distinct b.Bank_Mnemonic as [Bank],bd.Demo_Name as [Demography],ei.BEFI_Description[Economic Indicator],bsd.BSD_Year as [Year],bsd.BSD_Data_Value as [Value] from dbo.tblBank_Source_Data as bsd inner join dbo.tblBankDemographics as bd on bsd.Demo_ID=bd.Demo_ID inner join dbo.tblBanks … |
| | Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task … |
| | Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in … |
| | Hi All, This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line: where a.IPI_Ref_Date between '2012' and GETDATE() and the output … |
| | Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections … |
| | Hi All, There's a gentleman in my department that is retiring this Friday. He's asked me if there is a way to copy all links in his "Favorites" menu in his web browser. He's got a lot of links and to do it 1 by 1 will take him a … |
| | Hi All, I'm a little stuck with one table's design. I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design: `CB_ID int (PK)` `CB_Mnemonic_ID int (FK)` `CB_Value decimal (18,10)` `CB_Year int` `CB_Quarter int` This table is loaded …  |
| | Hi All, I have a table that holds monthly data in it. I need to average that data into Quarterly and Annual data but I'm not sure how to go about that. For annual I tried something like: SELECT TOP (100) PERCENT b.vSeries_Type as [Description],b.vSeries_Number as [CANSIM], Year(a.IPI_Ref_Date)as [Year], avg(a.IPI_Value) … |
| | Hi All, I created a small executable that runs an SSIS project. It works on my system but when I tried using it on a colleagues system nothing happens. I'm not overly familiar with with part of Java so any suggestions will be most appreciated. |
| | Hi All, I sort of want to get a "best practices" perspective regarding numeric values. First, I'll give my scenario: In my SSIS package, a CSV file is used for data extraction. Once extracted, a staging table is loaded with all the values from the CSV. One column, called "IPI_Value" … |
| | Hi All, I'm working on filling a user variable called "EmailString" via a db connection with SSIS. I've created a script task to do this (the only way I can see how) and in it I have the following code: Public Sub Main() ' ' Add your code here ' … |
| | Hi All, I am attempting to execute a dtsx package using Java and I have the following line Process executionProcess = Runtime.getRuntime().exec("dtexec/f\"C:\\Projects\\EconAnalysisConferenceBoard\\EconAnalysisConferenceBoard\\EconAnalysisConferenceBoard\\ConferenceBoardETL.dtsx\""); I keep getting an error saying the file cannot be found but if I run the dtexec in command prompt with the exact same paths and file name … |
| | Hi All, Forgive me if this doesn't come accross clearly. I have a specific data set to get from a website. Most of the data sets that I get from this site have publication dates that I have been able to successfully use for our SSIS ETL processes. However, one … |
| | Hi All, I have the following statement which is intended to have a Year over Year Percentage change: select CurrYear.Variable_Date,CurrYear.Variable_Value,cast(100*(CurrYear.Variable_Value-PrevYear.Variable_Value)/PrevYear.Variable_Value) AS Percentage_Change from dbo.tblCPISC as CurrYear left outer join dbo.tblCPISC as PrevYear on year(PrevYear.Variable_Date) = (select MAX(Variable_Value) from tblCPISC where year(Variable_Date) < year(CurrYear.Variable_Date)) order by year(CurrYear.Variable_Date) For some reason, I … |
| | Hi All, I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value' but the output still has the 2 decimal places which are 0s and pointless in …  |
| | Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …  |
| | Hi all, I am attempting to rename a file using the File System Task Editor in SSIS. In the Expression Builder, I have @[User::fileName]+(DT_WSTR,2)DATEPART("mm",GETDATE())+(DT_WSTR,4)DATEPART("yyyy",GETDATE())+".zip" but it returns the following error: > TITLE: Expression Builder >------------------------------ >Expression cannot be evaluated. >------------------------------ >ADDITIONAL INFORMATION: >The data types "DT_I4" and "DT_WSTR" are incompatible … |
| | Hi all, This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year: Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, … |
| | Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at …  |
| | Hi all, My laptop is running Windows 7 64. I need to get into my run it in safe mode but when I press F8 upon startup but I am not given the option. I get Start Windows Normally or a prompt to fix the startup process because apparently my … |
| | Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to … |
| | Hi all, This is going to be difficult for me to describe but I'm going to give it a go! I have tables called tblCPI, tblCPI_Staging, & tblVSeriesList. Please see the diagram.  Right now I am using SSIS 2008 to get data from Statistics Canada and load the … |
| | Hi all, With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure … |
| | Hi all, I have a procedure that compares release dates to file download dates. I have a download folder that is added to a string Dim strFilePath = "\EconomicDBTemp\DownloadedCSVs\" I've removed the directory but the folder DownloadedCSVs is where I need to search each csv file. However, I am unsure … |
| | Hi all, I'm about to get a little long winded here and I'm sorry for that but I have a couple of issues that I need guidance with. I have assembled a procedure that basically performs a bunch of web browser clicks to query Statistics Canada (SC). The query itself … |
| | Hi all, I have the following procedure that connects to my database. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim stmt As String SQLConn.ConnectionString = ConnString SQLConn.Open() stmt = "select Table_Numbers From tblRelease_Dates Where (Release_Date Between '" + fileCreatedDate + "' And GETDATE())" SQLCmd.Connection = SQLConn SQLCmd.CommandText … |
| | Hi all, I have the following VB.NET code where I am attempting to connect to a SQL Server table, query it to find out if a date in the table is between a derived date called "fileCreateDate" and now/today. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim … |
| | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
| | Hi all, I have a form that is supposed to query a website. I have the following code that first looks at and uses data from an SQL Server db connection: ConnString = "Data Source=SQL2008T1;Initial Catalog=EconAnalysis;Integrated Security=True" SCqryStr = "" SQLConn.ConnectionString = ConnString SQLConn.Open() SQLStr = "SELECT vSeries_Number FROM tblVSeriesList" … |
| | Hi all, I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax … |
| | I would like to invoke a click on a link from a link that is generated by an HTML query. I am attempting to program an application that queries a website and am getting hung up where I download the .csv that is loaded by the website. Here is the … |
The End.