Search results for query: *

i posted this in the microsoft forums and i was told that this task is not able to pick up the file name for use in a variable there is a file watcher task (third party - www.sqlis.com) but it only looks once for a file then stops instead of continously looking in folder

thanks !

hello is it possible to use an ADP without a local installation of sql server ?

hello i would like to have a package that would detect new files in a directory and import them automatically. i have managed to configure a WMI Event Watcher Task, all i need is to get the new file name, so that i can assign it to the flat file connection object for importing, which is...

Aargh ! I forgot to set the "text delimiter", it's working fine now ! thanks anyway :) but I must say those error messages aren't very helpful

hello i am attempting to import a CSV file into SQL Server 2005. A record looks like this : "sometext","moretext","moretext","WEEK 200614","4.50000","19.32400" I want the 2 last fields to be imported into decimal fields, but SQL throws an error : Copying to [bla].[dbo].[mytable] (Error)...

ouch ! thanks :)

Hello I am new to visual studio development and i am having trouble with the following : I have a form with a combobox : this.cboCivilite.DataSource = DataRepository.CiviliteProvider.GetAll(); cboCivilite.DisplayMember = CiviliteColumn.Description.ToString()...

Hi, I am thinking of subsribing to either one of these video courses, from Joe Grip or LearnVisualStudioNet, but I'd like to have some opinions beforehand. I am interested in the C# tutorials, as I plan to develop database applications. Has anyone tried them ? thanks

the foundfiles collection is zero indexed so use .foundfiles(0) you don't need all those variables for this routine. also maybe you need to use Me.DRUKCODE.Text or .Value ?

hello, i hope this is the correct forum. i am trying to open port 80 on my firewall, as I'm running an http server. could somebody explain the process to achieve this on this particular firewall ? thanks paul

i think I have found the problem : BigInt values are returned as Strings ! Apparently, this should have been corected by Microsoft, but was not. :/ if I cast my bigint to string, it works. but then i'll have to cast back to do divisions in my script task.

i'm sorry, i must have been unclear. I don't set the autoincrement id with code. i just put all the fields on the form, then filled out all the fields (except the id field) then tried to save, or go to next record, but an error occurs : id field does not accept Nulls

hello i am new to Visual Studio 2005. I am trying to develop a Winforms applications based on an Sql Server database. I created a Dataset and I "drag & dropped" the dataset fields to my form. But when i add a record, the autoincrement ID field doesn't get set, so the record is not saved. i did...

can't you set a validation rule at database level ? or are these boundaries likely to change ?

this is the error message : Error: The type of the value being assigned to variable "User::rank" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

hello i have a query in SQL Server 2005, that uses the DENSE_RANK() function which returns a bigint. in my SSIS package, I have a recordset object which detects the field as [DT_I8]. I am trying to map a package variable to this field values in a loop but I keep getting a conversion error. The...

i also found that if i forced the conversion to float in the SQL statement , then the type will be correct in the package. is there no "edit post" functionality ? is there an SSIS forum ?

ok i have found that if i open the advanced editor for the OLE DB source, I can change the DT_NUMERIC type to float in the output columns node it seems to work now, but I don't know if it may have unforeseen consequences. i still don't understand why it detects float values as DT_NUMERIC in the...

hello, i am getting the following errors in my SSIS Package : Error: ForEach Varaible Mapping 3 to variable "myVariable" cannot be applied. and Error: The type of the value being assigned to variable "myvariable" differs from the current variable type. Varaibles may not change during...