425 Posted Topics
 | 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. |
 | It will be in my rec-room when it comes out!  |
| | I think someone must have been bored and started spamming the downvotes because I got hit too. As pyTony stated, it didn't affect my points in anyway but dang, seeing those red numbers can get to ya! |
| | I'm not saying this because I want to push people away from this site but this can more than likely be solved at an Excel site. You'll be able to post a workbook where people can work with what you have. Am I able to provide a link to a … |
| | 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" … |
 | Re: help I'm just saying, this is a help forum where people help other people with their tech problems. You haven't even asked a question for anyone to help with. |
| | I've never had of that type of title before (not to say it doesn't exist). What is in the job description? You should be able to formulate answers accordingly I would think. Also, knowing as much as you can about the company hiring you is a really good idea too. |
| | Lmao, I just had a post voted down (I'm guessing) because it wasn't right as far as the code went. That's fine with me but a post that was "more correct" didn't get a vote up. Finicky people on forums. Anyways, it's my first since joining 10 months ago. |
| | 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 NardCake, perhaps I'm not up to par with terminology but what's a Git and what does it mean to "fork"? |
| | I think that's definitely a good idea if you are having power issues. The type you buy will depend on how many pc's and laptops you'll need to protect. I like [Dell products](http://www.dell.com/us/business/p/dell-ups) and they have many UPSs depending on the number of terminals that are used. If only a … |
 | In the last 2 or 3 years my wife has become more savvy on a computer but that's only because she doesn't have to wait for programs to run or webpages to load. She used to hate getting on the computer and she would always say something like: "I can't …  |
| | Saturday December 15, 1973. Ahh, I remember that like it was yesterday! Oh wait, I'm only remembering yesterday. |
 | |
| | Hi, that's sort of a vague question. If you you have elements in the array then it already has a size. You can find the size of the array by using its length property. For instance: int[] ary = new int[10]; int j=0; for (int i=0;i<ary.length;i++) { j++; ary[i]= j; …  |
 | Welcome to this great forum Neon Tetras. Stick around and you definitely will get better and better. |
| | Hi All, I started this general discussion because I want to know what kind of standards you all work by with regards to documenting your projects. I've been steadily working on a system at work since last spring that is automating (extracting, transforming, & loading) data flows within my department. …  |
 | Personally, I don't think you should be referencing a book where you already need a website, especially if you are just starting out with learning about it. A good book will have you create your own webpages and you don't need an actual website to do that.  |
| | Print "Who?" once? I can't see it looping because i will never be < 2 when it starts at 5. That being said, the only print should be "Who?".  |
 | Re: 101 Dalmatians Well, since forums like this contain either retired people or workers that run puppy mills (dog f^^^ers), there's probably a few puppies around. LoL, kidding all, just kidding. :) |
| | You need a full system built for this which is no small task and requires much more details than what you provided. Perhaps your dentist should hire a team to build this. Just my opinion. |
| | Hi, You need to watch your indexing with arrays. At one point you index with a double type and at other points you indexed movies with just a 0. I've clean up your code a bit and made a couple alterations and I think it works the way you need … |
| | 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 … |
 | Welcome, this site is seconde to none, I'm sure you'll learn everything you need to know here when problems arise. |
| | I don't know where this can go or even if there is someone here that can help so bear with me. I am creating a PDF document for my manager that's a combination of PDF files as well as Excel files. The Excel files contain data sets and all I … |
 | I wouldn't know how to rate my learning in the past year. I went from knowing basically nothing about SSIS and writing SQL statements (other than basic select statements) to creating a database that uses SSIS to perform ETL processes that load millions of records into the db each month. …  |
 | Re: Old xbox value? I checked Ebay and they're selling for about $45 Cdn. You'll have to convert that based on where you're from if not in Canada. As for the games, I can't see you getting more than $10 for old Xbox games but that's just an opinion. |
| | 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 … |
 | When my own brother shot and tried to kill me. For real!  |
| | I just wanted to say that the menu bar at the bottom of the page is great. Nice job Dani and whomever else worked on this idea. My only problem that I can not is with regards to the cursor being hovered over any link in IE8 because when I … |
 | Just as a side note in case this happens again and trim doesn't work. Example, yesterday I was dealing with what looked like white spaces at the end of each string in on of my tables. Therewere two spaces and the table accepted them as white spaces but in fact … |
 | I agree with IIM, Notepad++ is an excellent text editor for a wide range of code writing (Java, HTML, SQL). In saying that, when I work with Java I prefer to use Netbeans but the learning curve of the software was difficult in the beginning. I like they way you …  |
 | |
| | 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 …  |
| | I don't get scared by movie characters and never have, I thoroughly enjoy horror movies and am usually quite entertained by "scary" movies. That being said, Pinhead from Hellraiser is quite the evil character. |
| | Google can be your best friend for this too. Query "Android Developement" and you'll find out what you need on your computer to start.  |
| | 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 … |
 | Skyrim on the Xbox has been my crutch when I have time between work, university, my kids, and my wife. I love that game. I'm also looking forward to getting Black Ops 2 at Christmas time. In saying that, I think the best game I've played (enjoyment wise) was Earthbound …  |
| | 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 …  |
| | I love movies but I am not particularily inspired by them. Magnolia was a very interesting movie to me and so was Inception. Neither would be in my top 5 movies though but I appreciated the thought that was put into them. |
| | Can someone please help with [this thread](http://www.daniweb.com/software-development/vbnet/threads/436922/how-can-i-create-a-fees-reminder-working-with-access-as-db-and-prompting)? I was thinking that the answer should be in the form of SQL but the op wants a .NET solution. |
| | I'm not sure and can be completely off my rocker here (someone will correct me if I'm wrong) but wouldn't the easiest solution be to have a field in your database called Balance_Owing or something like that and then have an if statement that is checking each Balance_Owing value to …  |
| | 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 … |
The End.