Search results for query: *

Hi think I am having a slightly different problem. I beleive that the sql statement part is working fine. I was running the whole package and I beleive that there is something else in the package that does not like the fact that my variable is an object. What I would like to do is test that...

Hi all, I have been working through my variable problem with some success with your help. I can get my sql statement to store the result to a variable. However my SQL statement is a select statement returning multiple rows. From what I have read on the MS help I have to set my result set...

Thanks, I have tried putting an sql task within the foreach loop but i am still having problems. First I called the variable within the sql code and it wanted me to declare that variable first in the code so I take it that it is not seeing the variable from within the code? I take I am...

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...

yep, lol my thought i did not have the variable length set with enough Characters. Thanks all, it is returning what i need. Cheers

Thanks for that, certainly has helped. Think I have found my problem, looks like there SQL only lets you have a certain amount of characters in a dynamic statement. When I did a print I found that it was cutting my statement in half. Not sure if there is a way of increasing this limit.

yeah Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'SE'. SE is not in the code but is part of a field name?????

both varchar 50

This is my code, keeps coming up with an error no matter how i change it around so maybe it is not possible what i am trying to do here? set @dynamicstate='INSERT INTO tests ([field_name], [data_type], [RESULT]) SELECT ' + @Column_name1 + '...

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 thanks for this, I will probably use the spss route. I can create and save the SPSS file but how do i execute it from the SP? Thanks for the help.

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?

I was doing a select, testing before i do an update. I have changed the field to varchar now and it works ok with the zero's but i don't understand why it never liked the cast i used.

can you tell me why Right('0000000000'+field,10) does not work, it is not adding the zero's, it is just ignoring them. I have also tried cast(Right('0000000000'+hosp,10) as varchar(36)) still no zero's

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

ok thanks that has helped on some of the fields. 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...

Just SISS, taking the data from a view. We have checked the view and all seems ok with it. Also we have run queries on the data it looks at but we can not see anything wrong with that either.