Recent content by Machiaveli

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi p27br, Thanks for the tip, but it's a little bit to much to understand to get it worked. Can you help me with my code?

Hi, I have some files in different directies which i want to rename because they have the same names. The new name has a date then a "_" and then it's original name. E.g. 20041119_test1.txt. The root folder is "c:\results\" and the subdirectories are like "20041119-123456". Can someone help me...

Hi, I've a testpackage which i'm trying to adjust. What i would like is to import multiple textfiles (because there are files with the same name) and archive them. The package is from sqldts.com so i'll paste the activex scripts: Script 1 - Defining the Global Variables: Option Explicit...

Hi, Anyone can tell me which accespoint/router is better? I'm thinking to buy the usr805450 (with all turbo related devices )or the linksys new wrt54g speedbooster. I ditched my old wrt54g, because i think usr805450 is better. When i get me one of those models, i also will buy the same brand...

Hi Edwin, Thanks for replying. To answer your questions in your order: 1. Yes, it going to occur on a daily basis. 2. No, because the records should be normalised in the 2 tables which i've created. (e.g.) first table: reference | scandate | scantime | resultnr second table: resultnr |...

Hi Edwin, I tried to do what you said, but i'm having a little bit trouble. I need the columns with the indexnr from the first table to identify the columns in the second and than parse. Can you help me?

Hi Edwin, I did what you suggested. I've two tables where i import the raw data. The first table is structured and contains the columnnames. The second table is the rawdata table with only two columns, one with the form_id (see first message) and second the rawdata. What should i do next? In...

Hello, Can somebody help me with importing directories with their subfolders and files into tables. I would like to query some files with a particular extension and their size to make a capacity calculation.

Hi Edwin, I tried to do what you suggested, but i'm having some trouble with it. I normalized some columns into another table, the rest of the columns needs to be normalized also (like you said by grouping them). In the descriptionfile where the columname is, has also an index. I was thinking...

Hi EdwinGene, I'll try to do what you suggest. Can i return to you if i'm running into problems?

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi, How can i merge data from a database with a postscript? I would like to use a number from the database which in postscript should be formatted as a barcode on a specific location. Now i know it is a programming language, so if it requires some skill then i would like to know what the best...

Hello, How can i schedule to take sql server offline so i can ran defragmentation multiple times at night? I would be very greatful if i know to do this.

Hi Ely, Yes that's basically it. But the fieldnames must be under the field Q Num, like: Q Num Question 1 Question 2 etc.. However fieldnames may vary, so it is not always question1, question2, etc. Can you help me with this?