Post reply

SSIS Variable to SQL Table

  • March 13, 2009 at 9:13 am

    #128968

    Hello

    I am trying to write the value of a variable to a SQL Table, (is there a best way for this ?)

    At Present I have tried the following.

    I have a for next loop that loops through a set of databases, reads values and writes them to a single cental database. the for each loop uses a connection string and i exited the connection so that the Connection string expression is set to that variable, the loop works just fine. Now i want write the value to the connection string to the central database. I used a Derived column but I get truncation error (even though the dest column is nvarchar(MAX)

    However when I use a system variable like machine name this write just fine with no errors. What could I be doing wrong ? is there a better way of writing the values of a variable to a SQL table ?

    any Help would be great

    Thanks

  • March 13, 2009 at 9:17 am

    #959228

    Hello Again,

    I Found the error in my ways, in the Derived Column the lenght for the user variable was set to '0' (this is I guess since it does not aheva default value) I changed this to 255, and then it sorted it all out

    I hope this helps someone else.

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply