Search results for query: *

Hi, I am fairly new to the SSIS thing here but I am having trouble calling a variable that I have created. My package looks in a directory to import multiple excel files and to do this I use a FOREACH LOOP Container. I have put in that foreach loop a variable name and in the connection...

Hi I was hoping from some help with a SISS package I have created. In the control flow I have a foreach loop container and I have that loop storing file names to a variable. In my events handlers box I have an execute a sql statement so that the goal is that it can write the contents of that...

Hi all, I am struggling with a dynamic statement. I have a insert into table command using two variables which have been declared eariler and a select statement. This all works find however once I put this into a dynamic statement it wants me to declare the variable again and lose everything...

Hi All, I have a lengthy procedure that i run that usually takes a few hours but at the end of that procedure I would like it to be able to export a table out to a File File format preferable comma delimited. Is there a way of putting code into the procedure that will do this for me so I don't...

Hi all, I have a table with about 100 fields in thier with mixed case. Is there a simple way of putting the whole table into upper case without running an upper command on each field?

Hi, I have a field of numeric values of different lengths, example 20 200 20000 I need these all to be padded out so that 00020 00200 02000 I thought that there was a command that could do this but i can not find it. Thanks

Hi all, I have a table and dotted within multiple rows of that tables are strings of text that seem to have blanks at the end of them, so.... 'abc ' instead of 'abc' This is causing me to have duplicates when i export out of sql. Is there an easy way of sweeping the whole table and...

Hi All, I am exporting a SQL table to a text file, comma delimited. The text file is approx 4.5g in size. After several attempts i am noticing that there is a record each time that is being merged with another record. A better way of explaining that is one record looks like it has been...

Hi all, I have been given the task of taking 100 excel sheets and importing them into one table in sql. Due to the size of each sheet excel really doesn't like it when you try to put it into one sheet then import. The only solution i can think of at the moment is to import them one by one then...

Hi all, I have a table and i need to insert a field which contains the row number of that record. I know this is possible in FoxPro but in SQL I have no idea. Thanks for reading.