No, the work around was to write script that extracts the attachment and saves the file to a folder, its a bit clunky and doesn't always work, I have looked...

I had to design a package very similar to the one demonstrated but I had the problem that the COU had to be done in sequence so unfortunately Rbar was...

When running check point do I omit the checkpoint_duration or set to a specific value:-)

I think i have found the problem but not sure how to solve it, I am using SQL 2005 and when I insert a row with a null value it...

Thanks for your reply, but I am still having problems inserting NULL into field15 when field15 is 0, is it because i am tying to insert it into a smalldate...

I will explain a bit further.

SET @INSERT_QUERY = @INSERT_QUERY +'[New_RECORD]'+ @INSERT_COLS1 +

...

thanks for your reply but i can't seem to fet the Nullif to work

' SELECT '''+ @FIELD1+''', ''' +@FIELD2+''', ' +CAST(@FIELD3 AS VARCHAR)+', ''' +@FIELD4+''', ''' +nullif(@FIELD5,'0')+''', ''' +@FIELD6+''', '''...

HI thanks for your reply

I have added an attachment to this post.

The text file i am trying to import is a single line csv, so as you can see in...

Could you please expand on this as iam new to ssis

Being relatively new to SSIS 2008 could anybody help with transforming a text field to geography field, I have read the articles above and I still not sure (its also...

Thanks for your replies , but I am still not sure on how I am going to tackle this problem, when you mention run in batches of 1000 I am...

i have tried to use the below code but it errors

,ORGANISATION= '''+@FIELD18.replace("'","''")& ''' ,

hi

i am having trouble getting the below statement to work

IF @FIELD2 = 'I' and @FIELD1='24'

BEGIN

SET @INSERT_QUERY = @INSERT_QUERY +...

Your right the row beginning with 10 is different but that can be excluded because i can deal with that, i have tried to see the unprintable character using a...