question

artistlover avatar image
artistlover asked

SSIS and translating one field from table.

I have to create ssis. It needs to take stuff from sql to access. Then i have to do reverse. My big question. It is one table ..so if stuff is entered via web that is sql and taken to access. Items entered in house are on access. one field has to be translated from access to sql and sql to access. How can i do this?
ssis-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

artistlover avatar image
artistlover answered
got it with case statement
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

artistlover avatar image
artistlover answered
here is translations. I have no clue how to actually code this. Access SQL Server 0-Non-Pay Audit 4-Audit 1-Check Payment 1-Check Payment 2-Cancel 4-Audit 3-Fulfillment 6-Fulfillment 4-Re-Issue 1-Check Payment 5-Submitted 4-Audit 6-Debit Card 2-Debit Card 9-Void 4-Audit 10-Pending 4-Audit 11-Valid Supporting Record 5-Non-Cash/Prize
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.