Recent content by grayt26

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.