65 Discussion / Question Topics
Remove Filter  | 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, can someone tell me where the path is for the images used in folders. I'm making an interface right now and I need access to the images like the "Open file" image (or an image of a file). I know that I can use the interwebs to find … |
| | 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 … |
| | Just curious as to how to report spam here or if it should be reported at all. I received an email from babyl which reads: > Hello >My name is amaram I am tall ,good looking, perfect body figure and sexy.I saw your profile and was delighted to contact you, …  |
| | 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 … |
| | Greetings all. I am a 38 year student and will be starting my last year of studies at a local university this fall. My field of study is Information Systems and I work as a student for my local utilities as an IS support for the company's Economic Analysis Department. … |
The End.